Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed

----

image text in transcribed

----

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Accounting And Auditing Theory And Practice

Authors: Prof. R.B. Patel

1st Edition

8188730882, 978-8188730889

More Books

Students also viewed these Accounting questions