Note: Fill in formulas for all of the highlighted cells. Single Serving Dual Serving $ 15,000 Family Size Total Total 20

[answerhappygod]

Note Fill In Formulas For All Of The Highlighted Cells Single Serving Dual Serving 15 000 Family Size Total Total 20 1 (77.32 KiB) Viewed 46 times

Note: Fill in formulas for all of the highlighted cells. Single Serving Dual Serving $ 15,000 Family Size Total Total 20,000 100% Input Values: Number of Customer Meals Sales mix (% of customer meals) Number of Servings per Meal Number of Servings Number of Customer Orders Number of Donated Meals Number of Donated Deliveries Single Serving Dual Serving Family Size 3,000 5,000 12,000 15% 25% 60% 1 2 4 3,000 10,000 48,000 750 1,250 3,000 3,000 5,000 12,000 6 10 24 61,000 5,000 20,000 40 $ 5.00 per customer serving Total Sales Revenue ($5 per serving) Less: Variable costs: Customer Meals: Direct Materials ($1 per customer serving) Direct Labor ($0.75 per customer meal) Variable Manufacturing Overhead (60% of Direct labor) Customer Delivery Expenses ($2 per customer order) Total Variable Cost Per Customer Meal Donated Meals: Variable Manufacturing Cost ($1.25 per donated meal) Donation Delivery Expense ($125 per delivery) Total Variable Cost per Donated Meal Total Variable Costs Total Contribution Margin Less: Fixed Costs Allocated Based on Sales Revenue Fixed Manufacturing Expenses Fixed Selling Expenses Fixed Administrative Expenses Total Fixed Expenses Net Operating Profit $ $ 1.00 per customer serving 0.75 per customer meal 60% of direct labor cost 2.00 per customer order $ #NAME? $ $ $ 75,000 29,000 40,000 144,000 (144,000) Price Per Serving Variable Costs: Customer Meals Direct Materials ($1 per serving) Direct Labor ($0.75 per customer meal) Variable Manufacturing Overhead 60% of DL Variable delivery expenses (customer meals) Donated Meals: Variable Manufacturing cost of donated meals Variable delivery expenses (donated meals) Fixed costs: Fixed manufacturing costs Fixed selling expenses Fixed administrative expenses Total Fixed costs $ $ 1.25 per donated meal 125.00 per delivery $ Weighted Average Contribution Margin Average Contribution Margin Ratio Degree of Operating Leverage $ $ $ $ $ 75,000 29,000 40,000 144,000 $ $ #DIV/0! Single Family Serving Dual Serving Size Total Break-even point (customer meals sold) Margin of Safety