Question: 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

 Please attach the spreadsheet to show the work! Thanks PS.52 The

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

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 General Management Questions!