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)

Hi. i only need help with the second one. I'm not sure

YEAR ONE

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!