Question
Hi. i only need help with the second one. I'm not sure how to do it. 1. How many cakes Lady M would need to
Hi. i only need help with the second one. I'm not sure how to do it.
1. How many cakes Lady M would need to sell in order to break even? Does this number seem feasible? (Hint: You need to solve for x in the following equation: x - 310,600-38,644-594,750 - x*0.5 = 0).
2. Assuming sales in the first year are break even, how quickly would sales need to grow to pay the start-up cost (i.e., $1 million) within 5 years? Is this growth rate feasible?
To answer this question, do the following steps: (1) Enter your answer to Q1 in cell B11 in the "Break-even" sheet. (2) The next step is like a trial and error. Try entering different sales growth rates that range between 5% and 15% in cell E13 until you see the amount close to zero in cell F28.
(Answer question and use excel sheet attached)
YEAR ONE
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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