- J K L M N O a R S T U V A B D E F G H 1 Donut Information 2 Based on the below data, create the profit model for Donuts to Go. 3 Assume that each customer will buy one donut and one cup of coffee 4 5 Enter totals 6 6 Time period Fixed Costs $5,800.00 7 Revenue: Cup of Coffee $2.99 Varible Costs 8 Revenue: Donut $2.50 Coffee $0.50 9 Donut ingredients per donunt) Iper donut $0.60 Donut $0.60 10 paper products: napkins, plates etc 11 Insurance month $300.00 12 13 Maintenance & Repairs to equipment month $0.00 14 Marketing & Promotion: Advertising month $100.00 15 Coffee per cup $0.35 16 Coffee cups per cup $0.15 17 Payroll: Wages (Owner/ Manager) month $2,400.00 18 Payroll: Wages (per Employees) month $1,200.00 19 Donut and Coffee equipment rent month $500.00 20 Professional Fees: Accounting month $50.00 21 Professional Fees: Legal month $25.00 22 Powdered and Liquid Beverages 23 Rent month $1,000.00 Previous research expense for Donuts 24 advancements $1,500.00 25 Supplies: Office month $25.001 26 Utilities month $200.00 27 28 29 30 Additional Data 31 Operations Financial information SI and regression Pt 1 Current operations Pt2 & Pt3 Franchise operations Pt2 & Pt3 $0.00 Exp... + 4100 3 5.49 Additional Data Operations Monthly Production Lost Sales Day old revenue High demand, % above Average Low Demand, % below average Franchise Operations Monthly Fixed Expense increase Monthly Production Increase Monthly demand increase States of Natures High demand Average demand Low demand - J K L M N O a R S T U V A B D E F G H 1 Donut Information 2 Based on the below data, create the profit model for Donuts to Go. 3 Assume that each customer will buy one donut and one cup of coffee 4 5 Enter totals 6 6 Time period Fixed Costs $5,800.00 7 Revenue: Cup of Coffee $2.99 Varible Costs 8 Revenue: Donut $2.50 Coffee $0.50 9 Donut ingredients per donunt) Iper donut $0.60 Donut $0.60 10 paper products: napkins, plates etc 11 Insurance month $300.00 12 13 Maintenance & Repairs to equipment month $0.00 14 Marketing & Promotion: Advertising month $100.00 15 Coffee per cup $0.35 16 Coffee cups per cup $0.15 17 Payroll: Wages (Owner/ Manager) month $2,400.00 18 Payroll: Wages (per Employees) month $1,200.00 19 Donut and Coffee equipment rent month $500.00 20 Professional Fees: Accounting month $50.00 21 Professional Fees: Legal month $25.00 22 Powdered and Liquid Beverages 23 Rent month $1,000.00 Previous research expense for Donuts 24 advancements $1,500.00 25 Supplies: Office month $25.001 26 Utilities month $200.00 27 28 29 30 Additional Data 31 Operations Financial information SI and regression Pt 1 Current operations Pt2 & Pt3 Franchise operations Pt2 & Pt3 $0.00 Exp... + 4100 3 5.49 Additional Data Operations Monthly Production Lost Sales Day old revenue High demand, % above Average Low Demand, % below average Franchise Operations Monthly Fixed Expense increase Monthly Production Increase Monthly demand increase States of Natures High demand Average demand Low demand