*Please help me with 9 and 10*

4. What is the Profit at the break even? Solve by equation and by graph 0 Muffins to Go: 5. What is the breakeven point for Muffins to Go (assume each customer buys one muffins and one coffee)? Solve by equation and by graph 9.50x-1.55x-9350=0 1176 6. What is the contribution margin of each sale of a Coffee and Muffins? 7.95 7. What is the Profit at the break even? Solve by Graph 0 8. Using Goal seek, if you want to achieve profit of $4000, how many muffins and coffee do you need to sell? Data>What if Analysis>set cell: N20 > To Value: 2000 By changing : N5. Anwser is 1679 Kiana also was wondering if instead of donuts she should sell muffins. She thought that selling the muffins for a higher price, however it has more upfront costs. Using this information create a graph of the crossover point for the two alternatives. Using this spreadsheet answer the following questions. (assume each customer buys one muffin and 9. What is the cross over point for the two alternatives? (solve by equation and confirm on graph). Enter quantity in cell below round to two decimal places 10. What is the Profit at the cross over point?(solve by equation and confirm on graph) Enter profit in cell below round to two decimal places Assume that each customer will buy one muffin and one cup of coffee Sales estimate range from 200-5000 per week Muffin Financial Information Time period Revenue: Cup of Coffee Revenue: Muffin Muffin ingredients (per muffin) paper products: napkins, plates etc Insurance $4.00 $5.50 $1.201 per donut Price Coffee Muffin month $500.000 $4.00 $5.50 $9.50 Cost Coffee Muffin $0.35 $1.20 $1.55 Fixed exp $9,350.00 Maintenance & Repairs to equipment month $0.001 Marketing & Promotion: Advertising month $250.00 Coffee per cup $0.25) Coffee cups per cup $0.10 Payroll: Wages (Owner/ Manager) month $2,500.00 Payroll: Wages (per Employees) month $1,000.00 Muffin and Coffee equipment rent month $2,500.00 Professional Fees: Accounting month $50.00 Professional Fees: Legal month $25.00 Powdered and Liquid Beverages $0.00 Rent month $2,000.00 Previous research expense for Muffin advancemen $2,000.00 Supplies: Office month $25.00 Utilities month $500.000 CM $7.95 1000 1500 Goal seek 5000 1679.25 2000 2500 3000 3500 4000 4500 Quantity sold o 500 Revenue coffee 0 2000 Muffins 0 2750 Total Revenue 0 4750 12000 14000 16000 4000 5500 9500 6000 8250 14250 8000 11000 19000 10000 13750 23750 16500 19250 22000 18000 24750 42750 20000 6716.98 27500 9235.85 47500 15952.8 28500 33250 38000 Fixed Expenses Total Fixed Expense 9350 9350 9350 9350 9350 9350 9350 9350 9350 9350 9350 9350 0 175 350 525 700 875 1050 1225 1400 1750 587.736 Variable Expenses Coffee Variable expense Muffin Variable expense Total VariableExpenses Total Expenses 0 600 1200 1800 2400 3000 3600 4200 4800 1575 5400 6975 16325 0 775 1550 2325 3100 3875 4650 5425 6200 6000 2015.09 7750 2602.83 17100 11952.8 9350 10125 10900 11675 12450 13225 14000 14775 15550 Profit Muffin and Coffee -9350 -5375 -1400 2575 6550 10525 14500 18475 22450 26425 30400 4000 4. What is the Profit at the break even? Solve by equation and by graph 0 Muffins to Go: 5. What is the breakeven point for Muffins to Go (assume each customer buys one muffins and one coffee)? Solve by equation and by graph 9.50x-1.55x-9350=0 1176 6. What is the contribution margin of each sale of a Coffee and Muffins? 7.95 7. What is the Profit at the break even? Solve by Graph 0 8. Using Goal seek, if you want to achieve profit of $4000, how many muffins and coffee do you need to sell? Data>What if Analysis>set cell: N20 > To Value: 2000 By changing : N5. Anwser is 1679 Kiana also was wondering if instead of donuts she should sell muffins. She thought that selling the muffins for a higher price, however it has more upfront costs. Using this information create a graph of the crossover point for the two alternatives. Using this spreadsheet answer the following questions. (assume each customer buys one muffin and 9. What is the cross over point for the two alternatives? (solve by equation and confirm on graph). Enter quantity in cell below round to two decimal places 10. What is the Profit at the cross over point?(solve by equation and confirm on graph) Enter profit in cell below round to two decimal places Assume that each customer will buy one muffin and one cup of coffee Sales estimate range from 200-5000 per week Muffin Financial Information Time period Revenue: Cup of Coffee Revenue: Muffin Muffin ingredients (per muffin) paper products: napkins, plates etc Insurance $4.00 $5.50 $1.201 per donut Price Coffee Muffin month $500.000 $4.00 $5.50 $9.50 Cost Coffee Muffin $0.35 $1.20 $1.55 Fixed exp $9,350.00 Maintenance & Repairs to equipment month $0.001 Marketing & Promotion: Advertising month $250.00 Coffee per cup $0.25) Coffee cups per cup $0.10 Payroll: Wages (Owner/ Manager) month $2,500.00 Payroll: Wages (per Employees) month $1,000.00 Muffin and Coffee equipment rent month $2,500.00 Professional Fees: Accounting month $50.00 Professional Fees: Legal month $25.00 Powdered and Liquid Beverages $0.00 Rent month $2,000.00 Previous research expense for Muffin advancemen $2,000.00 Supplies: Office month $25.00 Utilities month $500.000 CM $7.95 1000 1500 Goal seek 5000 1679.25 2000 2500 3000 3500 4000 4500 Quantity sold o 500 Revenue coffee 0 2000 Muffins 0 2750 Total Revenue 0 4750 12000 14000 16000 4000 5500 9500 6000 8250 14250 8000 11000 19000 10000 13750 23750 16500 19250 22000 18000 24750 42750 20000 6716.98 27500 9235.85 47500 15952.8 28500 33250 38000 Fixed Expenses Total Fixed Expense 9350 9350 9350 9350 9350 9350 9350 9350 9350 9350 9350 9350 0 175 350 525 700 875 1050 1225 1400 1750 587.736 Variable Expenses Coffee Variable expense Muffin Variable expense Total VariableExpenses Total Expenses 0 600 1200 1800 2400 3000 3600 4200 4800 1575 5400 6975 16325 0 775 1550 2325 3100 3875 4650 5425 6200 6000 2015.09 7750 2602.83 17100 11952.8 9350 10125 10900 11675 12450 13225 14000 14775 15550 Profit Muffin and Coffee -9350 -5375 -1400 2575 6550 10525 14500 18475 22450 26425 30400 4000