Question: Need help adding the ice cream cakes to my existing spreadsheet. Will need to adjust my numbers due to addition of ice cream cakes. Please
Need help adding the ice cream cakes to my existing spreadsheet. Will need to adjust my numbers due to addition of ice cream cakes. Please help, thank you!
- 1st photo is my what if scenario, 2nd photo is my forma, 3rd photo is my assumptions.

----

----

Scenario Two: "What if" Analysis Your client would like to consider adding ice cream cakes to the list of items available for sale. She is wanting to offer cakes with customized cake, ice cream decorations. She thinks she can sell 20 small cakes a week and 25 large cakes a week. It seems to be lucrative because the small cake is $18.95 and the large cake is $28.95. Costs are $6.45 per small cake and $9.40 per large cake. It will cost her $3,500 to purchase the equipment and insurance costs would rise by another $375 per month due to the hot equipment needed to make the cakes. What is your recommendation? Would it be profitable to sell the cakes? Scenario Two: "What if" Analysis Your client would like to consider adding ice cream cakes to the list of items available for sale. She is wanting to offer cakes with customized cake, ice cream decorations. She thinks she can sell 20 small cakes a week and 25 large cakes a week. It seems to be lucrative because the small cake is $18.95 and the large cake is $28.95. Costs are $6.45 per small cake and $9.40 per large cake. It will cost her $3,500 to purchase the equipment and insurance costs would rise by another $375 per month due to the hot equipment needed to make the cakes. What is your recommendation? Would it be profitable to sell the cakes
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
