A bakery sells its pies for $6.00 each
Question # 00549144
Posted By:
Updated on: 06/20/2017 12:44 AM Due on: 06/20/2017
EXCEL BREAKEVEN PROBLEM
1. A bakery sells its pies for $6.00 each. The bakery incurs a daily fixed cost of $500 which includes salaries and rental. The variable cost per pie is $2.50. The bakery sells 50 pies per day.
A. How many additional pies per day do the bakery need to break-even?
B. Using Goal Seek what is the new selling price per unit to achieve a Profit = $100?
Please provide a spreadsheet with the show formula page with all the calculations and the actual results page.
-
Rating:
/5
Solution: A bakery sells its pies for $6.00 each