With the numbers and information provided could you please solve for the margin analysis and break even analysis.
OPERATIONAL \& COST INFORMATION: For simplicity, base all calculations using 30 days in each month OPERATIONAL DA Grooming: The Groomer can groom 5 dogs a day, 5 days Each grooming takes 1.5 labor hol Day The Day Care can house 10 large dogs and 12 small dogs Day Care is offered 6 days a week Boarding: There are 12 kennels (single dog 0 Boarding (kennel services) is offered every do Faci The Grooming facility is 200 squar The Boarding facility is 2,500 squa The Day Care facility is 1,500 squa Ger Loan for start-up costs - monthly payment of $420; in effect immediately; limited cash and loan funding - used angel invest Modest monthly draw of $600 a month for first year; should be divided evenly amoung the services (grooming, day care, b SALARY \& HIRING DATA Groomer (Allison) - $12.00 an hour, 40 hours a u Day Care Attendant (Beverly) - $9.00 per hour, based on ner Receptionist (Cathie) - $8.50 per hour, 30 hours a week Kennel Attendant (Ben) - $11.50 per hour, based on need ACC202 - Managerial Accounting INSTRUCTIONS FOR MILESTONE 2 (Due Week 4) IMPORTANT NOTE: Make sure to completely review the Rubric for Milestone 2 Use the data from this Milestone and begin working on your final presentation due in Milestone 4 (Week 7) ITEMS TO COMPLETE FOR THIS MILESTONE (Green Tabs): GENER Use data from Milestone 1 in your an CONTRIBUTION MARGIN ANALYSIS Select a price for each service (grooming, day care, boardin; Determine the variable cost from the Variable_Fixed tab for each servi Calculate the contribution margin for each service based on your sales price and the variable cost for that service BREAK-EVEN ANALYSIS Determine the fixed cost from the Variable_Fixed tab for each service Fixed \& Variable cost designation is provided Calculate the break-even units (round up) for each service Calculate the break-even units (round up) for suggested target profit levels for each service Milestone Two - Contribution Margin Analysis Sales Price per Unit Variable Cost per Unit Contribution Margin Milestone Two - Break-Even Analysis Sales Price $COLLARS LEASHES HARNESSES \$ - \$ - Fixed Costs Contribution Margin Break-Even Units (round up) Target Profit $300.00$400.00$500.00 Break-Even Units (round up) Target Profit $500.00 $600.00 $650.00 Break-Even Units (round up) OPERATIONAL \& COST INFORMATION: For simplicity, base all calculations using 30 days in each month OPERATIONAL DA Grooming: The Groomer can groom 5 dogs a day, 5 days Each grooming takes 1.5 labor hol Day The Day Care can house 10 large dogs and 12 small dogs Day Care is offered 6 days a week Boarding: There are 12 kennels (single dog 0 Boarding (kennel services) is offered every do Faci The Grooming facility is 200 squar The Boarding facility is 2,500 squa The Day Care facility is 1,500 squa Ger Loan for start-up costs - monthly payment of $420; in effect immediately; limited cash and loan funding - used angel invest Modest monthly draw of $600 a month for first year; should be divided evenly amoung the services (grooming, day care, b SALARY \& HIRING DATA Groomer (Allison) - $12.00 an hour, 40 hours a u Day Care Attendant (Beverly) - $9.00 per hour, based on ner Receptionist (Cathie) - $8.50 per hour, 30 hours a week Kennel Attendant (Ben) - $11.50 per hour, based on need ACC202 - Managerial Accounting INSTRUCTIONS FOR MILESTONE 2 (Due Week 4) IMPORTANT NOTE: Make sure to completely review the Rubric for Milestone 2 Use the data from this Milestone and begin working on your final presentation due in Milestone 4 (Week 7) ITEMS TO COMPLETE FOR THIS MILESTONE (Green Tabs): GENER Use data from Milestone 1 in your an CONTRIBUTION MARGIN ANALYSIS Select a price for each service (grooming, day care, boardin; Determine the variable cost from the Variable_Fixed tab for each servi Calculate the contribution margin for each service based on your sales price and the variable cost for that service BREAK-EVEN ANALYSIS Determine the fixed cost from the Variable_Fixed tab for each service Fixed \& Variable cost designation is provided Calculate the break-even units (round up) for each service Calculate the break-even units (round up) for suggested target profit levels for each service Milestone Two - Contribution Margin Analysis Sales Price per Unit Variable Cost per Unit Contribution Margin Milestone Two - Break-Even Analysis Sales Price $COLLARS LEASHES HARNESSES \$ - \$ - Fixed Costs Contribution Margin Break-Even Units (round up) Target Profit $300.00$400.00$500.00 Break-Even Units (round up) Target Profit $500.00 $600.00 $650.00 Break-Even Units (round up)
