Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What calculation in excel would I use to figure out the Target profit Break--even units (round up)? INSTRUCTIONS: Show all steps and calculations to determine
What calculation in excel would I use to figure out the Target profit Break--even units (round up)?
INSTRUCTIONS: Show all steps and calculations to determine the break-even. Determine the break-even for the target profit levels as outlined in the instructions. Break-even = Fixed Costs / Contribution Margin BOARDING DAY CARE 18.00 GROOMING $ 25.00 Sales Price $ 25.00 Fixed Costs $ 858 1,379 $ 2,368 Contribution Margin $ 293.70 $ 211.80 $ 75.15 Break-even Units (round up) 64.30 78.13 157.55 Target Profit $ $ $ 1,000.00 417.00 4.34 583.00 9.26 Break-even Units (round up) 44.82 Target Profit $ 667.00 $ 909.00 $ 1,500.00 Break-even Units (round up) 5.19 10.80 51.47 |Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started