Use information from Milestone One and the providedMilestone Two Market Research Data Appendixto...

Question

Use information from Milestone One and the providedMilestone Two Market Research Data Appendixto conduct a cost-volume profit analysis. Complete the “Contribution Margin Analysis” and “Break-Even Analysis” tabs in theProject Workbookthat you used for completing the Milestone One assignment.

Specifically, you must address the following rubric criteria:

Contribution Margin.Determine your contribution margin per unit in the “Contribution Margin Analysis” tab.
- Choose asales pricefor each product.
- Calculate thecontribution marginfor each product based on your sales price and the variable cost for that product. Show your work using calculations to the side of the table or using appropriate formulas in the table.

Break-Even Analysis.Use cost-volume-profit (CVP) analysis to determine your break-even points for achieving your target profits in the “Break-Even Analysis” tab.
- Determine thebreak-even pointsfor each product. Show your work using calculations to the side of the table or using appropriate formulas in the table.
- Determine break-even units for the suggestedtarget profitsfor each product. Show your work using calculations to the side of the table or using appropriate formulas in the table.

Guidelines for Submission

Submit the Project Workbook with the “Contribution Margin Analysis” and “Break-Even Analysis” tabs completed. This file should be completed and submitted using Microsoft Excel.

Use information from Milestone One and the providedMilestone Two Market Research Data Appendixto conduct a cost-volume profit analysis. Complete the “Contribution Margin Analysis” and “Break-Even Analysis” tabs in theProject Workbookthat you used for completing the Milestone One assignment.

Specifically, you must address the following rubric criteria:

Contribution Margin.Determine your contribution margin per unit in the “Contribution Margin Analysis” tab.
- Choose asales pricefor each product.
- Calculate thecontribution marginfor each product based on your sales price and the variable cost for that product. Show your work using calculations to the side of the table or using appropriate formulas in the table.

Break-Even Analysis.Use cost-volume-profit (CVP) analysis to determine your break-even points for achieving your target profits in the “Break-Even Analysis” tab.
- Determine thebreak-even pointsfor each product. Show your work using calculations to the side of the table or using appropriate formulas in the table.
- Determine break-even units for the suggestedtarget profitsfor each product. Show your work using calculations to the side of the table or using appropriate formulas in the table.

Guidelines for Submission

Submit the Project Workbook with the “Contribution Margin Analysis” and “Break-Even Analysis” tabs completed. This file should be completed and submitted using Microsoft Excel.

acc-202-milestone-two-market-research-data-appendix-copy-lr5ivarr.docx

Bhavani · Accepted Answer

Instructions
	Southern New Hampshire University
	College of Continuing Education (COCE)
	ACC202 - Managerial Accounting
	MILESTONE 1 (Due in Module 2)				MILESTONE 2 (Due in Module 4)					MILESTONE 3 (Due in Module 5)
	1.					1.					1.
		Name					Choose a price range and calculate:					Create a Cost of Goods Manufactured Schedule
		Location					Grooming
		Vision					Day Care
		Mission					Boarding
	2.					2.					2.
		Identify the following:					Calculate the break-even units					Create an Income Statement
		Direct Materials					Grooming					Revenue will be provided end of week 4
		Diret Labor					Day Care
		Manufacturing Overhead					Boarding
		Period Costs					Calculate the break-even for target profits
	3.						Grooming				3.
							Day Care
		Calculate the Variable & Fixed Costs for:					Boarding					Calculate for the Grooming line:
		Grooming										Direct Labor Time Variance
		Day Care										Direct Labor Rate Variance
		Boarding										Direct Materials Efficiency Variance
												Direct Materials Price Variance
ACC202 - MANAGERIAL ACCOUNTING	
Company Profile
/xl/drawings/drawing1.xml#CompanyProfileVariable & Fixed Costs
/xl/drawings/drawing1.xml#VariableFixedCostsCost Classification
/xl/drawings/drawing1.xml#CostClassificationContribution Margin
/xl/drawings/drawing1.xml#ContributionMarginBreak-Even Analysis
/xl/drawings/drawing1.xml#BreakevenAnalysisCOGM Schedule
/xl/drawings/drawing1.xml#COGMScheduleIncome Statement
/xl/drawings/drawing1.xml#COGMScheduleVariances
/xl/drawings/drawing1.xml#VariancesInstructions Milestone 1
/xl/drawings/drawing1.xml#InstructionsMilestone1Instructions Milestone 2
/xl/drawings/drawing1.xml#'Instructions%20-%20Milestone%202'!InstructionsMilestone2Instructions Milestone  3
/xl/drawings/drawing1.xml#'Instructions%20-%20Milestone%203'!InstructionsMilestone3
Instructions - Milestone 1
	Southern New Hampshire University
	College of Continuing Education (COCE)
	ACC202 - Managerial Accounting
	INSTRUCTIONS FOR MILESTONE 1 (Due Week 2)
	IMPORTANT NOTE:
	Make sure to completely review the Rubric for Milestone 1
	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 (Blue Tabs):
	GENERAL
	You plan to open a pet services business that will offer dog grooming, day care and boarding
	COST CLASSIFICATION
	Accurately classify all of your costs (direct material, direct labor, manufacturing overhead, period costs)
	Fixed & Variable cost designation is provided
	VARIABLE & FIXED COSTS
	Determine your per unit cost per dog for grooming, day care and boarding
	OPERATIONAL & COST INFORMATION:
	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,

Use information from Milestone One and the providedMilestone Two Market Research Data Appendixto conduct a cost-volume profit analysis. Complete the “Contribution Margin Analysis” and “Break-Even...

Guidelines for Submission

Guidelines for Submission

Answer To: Use information from Milestone One and the providedMilestone Two Market Research Data Appendixto...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment