Question

please help with COS schedule, income statement, and variances. everything is completed and added for reference.

View Help i SUBSCRIPTION EXPIRED To keep using Excel without interruption, please reactivate now. Reactivate H32 X : B for D A C E F G H I J K L M N O P Q 43 For simplicity, base all calculations using 30 days in each month OPERATIONAL DATA Grooming: The Groomer can groom 5 dogs a day, 5 days a week Each grooming takes 1.5 labor hours Day Care: The Day Care can house 10 large dogs and 12 small dogs daily. Day Care is offered 6 days a week Boarding: There are 12 kennels (single dog only). Boarding (kennel services) is offered every day Facilities: The Grooming facility is 200 square feet The Boarding facility is 2,500 square feet The Day Care facility is 1,500 square feet General: Loan for start up costs - monthly payment of $420; in effect immediately; limited cash and loan funding - used angel investors Modest monthly draw of $600 a month for first year; should be divided evenly amoung the services (grooming, day care, boarding) SALARY & HIRING DATA Groomer (Allison) - $12.00 an hour, 40 hours a week Day Care Attendant (Beverly) - $9.00 per hour, based on need Receptionist (Cathie) - $8.50 per hour, 30 hours a week Kennel Attendant (Ben) - $11.50 per hour, based on need Variable Fixed Instructions Milestone Cost Classification Company Profile Instructions Instructions - Milestone 1 O Type here to search

please complete the last 3 sections

Answer 1

	Dippin and Clipping Dog Grooming
	Statement of Cost of Services
	For the Month Ended Jan 31,xxxxx
Beginning Work in Progress		0
Direct Material:
Materials-Beginning	0
Add: Purchases	5000
Material Available for use	5000
Deduct ending Materilas	3000
Materials Used		2000
Direct Labor		6240
Overhead		2800
Total Service Cost		11040
Deduct Ending Work in Process *		0
Cost of Services		11040
* In the absence of any express information, it is assumed that there is no closing work in process
Variance Favorable/Unfavorable Grooming Direct Labor Time Variance (Actual Hours- Std Hours) * Std Rate (180-150) *12 360 Unfavorable Grooming Direct Labor Rate Variance (Actual Rate- Std Rate) * Actual Hours (11.50-12)*180 90 Favorable Direct Material Quantity Variance (Actual Quantity- Std Quantity) * Std Price (1200-1000)*2 400 Unfavorable Direct Material Price Variance (Actual Price- Std Price) * Actual Qty (3-2)*1200 1200 Unfavorable