ABOVE IS THE COMPLETED MILESTONE 1. BELOW IS WHAT I NEED HELP WITH :) INSTRUCTIO

Question

ABOVE IS THE COMPLETED MILESTONE 1.

BELOW IS WHAT I NEED HELP WITH :)

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): GENERAL Use data from Milestone 1 in your analysis CONTRIBUTION MARGIN ANALYSIS Select a price for each service (grooming, day care, boarding) Determine the variable cost from the Variable_Fixed tab for each service 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

Explanation / Answer

Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you. Milestone-2 Contribution Margin Assuming following prices: Dog Day Care $          18 Overnight Boarding $          25 Basic Groom $          25 Dog Day Care Overnight Boarding Basic Groom Sales Price $                  18 $                                25 $                 25 Variable cost per unit $               4.74 $                            7.36 $             9.97 Contribution Margin $            13.26 $                          17.64 $           15.03 Contribution Margin Ratio CM/SP 73.67% 70.56% 60.12% Milestone-2 Break Even Dog Day Care Overnight Boarding Basic Groom Sales Price A $                  18 $                                25 $                 25 Fixed Cost B 858.44 1378.99 2367.92 Contribution Margin C $            13.26 $                          17.64 $           15.03 Break Even Units B/C $                  65 $                                79 $              158 Target Profit D $                417 $                              583 $           1,000 Break Even Units (B+D)/C $                  97 $                              112 $              224 Target Profit E $                667 $                              909 $           1,500 Break Even Units (B+E)/C $                115 $                              130 $              258

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.