create the profit model

Donut Information Based on the below data, create the profit model for Donuts to Go. 2 3 Assume that each customer will buy one donut and one cup of coffee Sales estimate range from 200-5000 per week 5 16 Time period $4.00 $3.50 $0.60 7 Revenue: Cup of Coffee Revenue: Donut 10 9 Donut ingredients per donunt) paper products: napkins, plates etc per donut 11 12 Insurance $200.00 month 13 Maintenance & Repairs to equipment month 15 Marketing & Promotion: Advertising month Coffee Coffee cups Payroll: Wages (Owner? Manager) Payroll: Wages (per Employees) 20 Donut and Coffee equipment rent Professional Fees: Accounting 22 Professional Fees: Legal 23 Powdered and Liquid Beverages 14 $0.00 $50.00 $0.25 $0.10 $2,500.00 $1000.00 $500 00 $50.00 $25.00 $0.00 $1,000.00 16 per cup 17 per cup 18 month 19 month month 21 month month 24 Rent month Previous research expense for 25 Donuts advancements $1,500.00 $25.00 26 Supplies: Office month 27 Utilities month $200.00 29 Muffins to Go 30 Assume that each customer will buy one muffin and one cup of coffee 31 Sales estimate range from 200-5000 per week 32 33 34 Muffin Financial Information 35 36 Revenue: Cup of Coffee 37 Revenue: Muffin 38 Muffin ingredients (per muffin) 39 paper products: napkins, plates etc insurance Time period $4.00 $5.50 $1.20 per donut 40 $500.00 month 41 42 Maintenance & Repairs to equipment month 43 Marketing & Promotion: Advertising month $0.00 $250.00 $0.25 $0.10 $2,500.00 $1,000.00 $2,500.00 $50.00 $25.00 $0.00 $2,000.00 53 Previous research expense for Muffin aduancemen $2,000.00 Coffee 45 Coffee cups 46 Payroll: Wages (Owner? Manager) 47 Payroll: Wages (per Employees) 48 Muffin and Coffee equipment rent 49 Professional Fees: Accounting 50 Professional Fees: Legal Powdered and Liquid Beverages 44 per cup per cup month month month month month 51 52 Rent month 54 Supplies: Office $25.00 month 55 Utilities month $500.00 56 DTG Quantity sold 500 1000 1500 3000 2000 2500 3500 4000 4500 5000 Revenue 7 coffee donut Total Revenue 9 10 Fixed Expenses Total Fixed Expense 11 12 13 Variable Expenses Coffee Variable expense 14 15 Donut Variable expense Total VariableExpenses Total Expenses 16 17 18 19 Profit Donuts and Coffee 20 21 22. MTG Quantity sold 500 1000 2000 1500 3000 2500 3500 4000 s000 4500 Revenue coffee Muffins Total Revenue Fixed Expenses Total Fixed Expense Variable Expenses Coffee Variable expense Muffin Variable expense Total VariableExpenses Total Expenses Profit Muffin and Coffee