Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please attach the spreadsheet to show the work! Thanks PS.52 The Station, a boutique cookie company, needs to create a production process for its new

image text in transcribed

Please attach the spreadsheet to show the work!

Thanks

PS.52 The Station, a boutique cookie company, needs to create a production process for its new cinnamon malt ball cookies. To help accomplish this, the company has put together some numbers for production costs (per dozen cookies for the variable costs). The Station estimates demand for the semester will be 855 dozen cinnamon malt ball cookies. Due to the cookies' expected popularity the selling price will be $4.15 per dozen. Based on the projected demand (volume) for the semester, which process type should they select? Speed Bake Pre-Bake Easy Bake Under this process type-the one selected in the previous question-what would be their profits for the semester? (Display your answer to the nearest whole number). What would be the break-even point (in unit volume or demand) between the process option you selected above and the "Speed Bake" process option? (Display your answer to the nearest whole number). For a unit volume (or demand level) that is EXACTLY equal to the UNROUNDED break-even point (derived in the previous question), what would be the total cost? (Display your answer to the nearest whole number). HINT: When using the break-even point derived in the previous question, be sure to NOT use it as a rounded number. Instead, be sure to include the exact break-even point, including any digits after the decimal, in order to get the correct total cost. If necessary, use direct cell referencing to ensure the correct break-even point is used. For a volume that is 3 units greater than the break-even point (derived in the previous two questions), which process option would be best? Speed Bake Pre-Bake Easy Bake

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

More Books

Students also viewed these General Management questions

Question

explain five important changes in the world of work;

Answered: 1 week ago