Exercise 2 Student Revised (1).xlsx - Donut Information Based on the below data create the profit model for Donuts to Go Assume that each customer will

Donut Information Assume that each customer will buy one donut and one cup of coffee Sales estimate range from 200-1000 per week Time period Revenue: Cup of Coffee $4.00 Revenue: Donut $3.50 Donut ingredients per donunt) per donut $0.75 paper products: napkins, plates etc Insurance month $50.00 Maintenance & Repairs to equipment month $0.00 Marketing & Promotion: Advertising month $25.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 $750.00 Donut and Coffee equipment rent month $200.00 Professional Fees: Accounting month $50.00 Professional Fees: Legal month $25.00 Powdered and Liquid Beverages $0.00 Rent month $1,000.00 $1,500.00 Supplies: Office month $25.00 Utilities month $200.00 Muffin Financial Information Revenue per unit is Time period Revenue: Cup of Coffee $4.00 Revenue: Muffin $4.50 Muffin ingredients (per muffin) per donut $1.10 paper products: napkins, plates etc Insurance month $50.00 Maintenance & Repairs to equipment month $0.00 Marketing & Promotion: Advertising month $25.00 Coffee per cup $0.25 Based on the below data, create the profit model for