Donuts to Go: 1. What is the breakeven point for Donuts to Go (assume each customer buys one donut and one coffee)? Solve using the equation and by graph 847 /pr sol 2. Using Goal seek, if you want to achieve profit of $2000, how many donuts and coffee do you need to sell? 3. What is the contribution margin of each sale of a Coffee and Donut? 4. What is the Profit at the break even? Solve by equation and by graph 0 1 prder = 1 coffee + 1 doughnut Time period $4.00 $3.50 $0.60 Fixed Cost Revenue: Cup of Coffee Revenue: Donut Donut ingredients per donunt) paper products: napkins, plates etc Insurance $5,550.00 per donut Revenue per Order $7.50 month $200.00 Variable Cost per Order $0.95 month month Contribution margin per Ord $6.55 Doughnut Variable Exp. Coffee Variable Exp. $0.60 $0.35 per cup per cup month month month month month Maintenance & Repairs to equipment Marketing & Promotion: Advertising Coffee Coffee cups Payroll: Wages (Owner/ Manager) Payroll: Wages (per Employees) Donut and Coffee equipment rent Professional Fees: Accounting Professional Fees: Legal Powdered and Liquid Beverages Rent Previous research expense for Donuts advancements Supplies: Office Utilities $0.00 $50.00 $0.251 $0.10 $2,500.00 $1,000.00 $500.00 $50.00 $25.00 $0.00 $1,000.00 Break-even Point $847.33 month SUNK month month $1,500.00 $25.00 $200.00 Donuts to Go: 1. What is the breakeven point for Donuts to Go (assume each customer buys one donut and one coffee)? Solve using the equation and by graph 847 /pr sol 2. Using Goal seek, if you want to achieve profit of $2000, how many donuts and coffee do you need to sell? 3. What is the contribution margin of each sale of a Coffee and Donut? 4. What is the Profit at the break even? Solve by equation and by graph 0 1 prder = 1 coffee + 1 doughnut Time period $4.00 $3.50 $0.60 Fixed Cost Revenue: Cup of Coffee Revenue: Donut Donut ingredients per donunt) paper products: napkins, plates etc Insurance $5,550.00 per donut Revenue per Order $7.50 month $200.00 Variable Cost per Order $0.95 month month Contribution margin per Ord $6.55 Doughnut Variable Exp. Coffee Variable Exp. $0.60 $0.35 per cup per cup month month month month month Maintenance & Repairs to equipment Marketing & Promotion: Advertising Coffee Coffee cups Payroll: Wages (Owner/ Manager) Payroll: Wages (per Employees) Donut and Coffee equipment rent Professional Fees: Accounting Professional Fees: Legal Powdered and Liquid Beverages Rent Previous research expense for Donuts advancements Supplies: Office Utilities $0.00 $50.00 $0.251 $0.10 $2,500.00 $1,000.00 $500.00 $50.00 $25.00 $0.00 $1,000.00 Break-even Point $847.33 month SUNK month month $1,500.00 $25.00 $200.00
