A B C 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 F H K L M N P R S T U 5 6 Enter totals Time period Fixed Costs $5,800.00 7 Revenue: Cup of Coffee 8 Revenue: Donut $2.99 $2.50 Varible Costs 9 Donut ingredients per donunt) per donut $0.60 Coffee Donut $0.50 $0.60 10 paper products: napkins, plates etc 11 Insurance month $300.00 12 13 Maintenance & Repairs to equipment 14 Marketing & Promotion: Advertising 15 Coffee 16 Coffee cups 17 Payroll: Wages (Owner/Manager) month month $0.00 $100.00 per cup $0.35 per cup $0.15 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 $0.00 23 Rent month $1,000.00 Previous research expense for Donuts 24 advancements $1,500.00 25 Supplies: Office month 26 Utilities month $25.00 $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 Exp 28 29 A B C F H J K L M N P Q R S T U 30 Additional Data 31 Operations 32 Monthly Production 33 Lost Sales 34 Day old revenue 35 High demand, % above Average 36 Low Demand, % below average 37 Franchise Operations 38 Monthly Fixed Expense increase 39 Monthly Production Increase 40 Monthly demand increase 41 States of Natures 42 High demand 43 Average demand 44 Low demand 45 46 47 48 49 50 51 52 53 54 55 56 57 50 Financial information SI and regression Pt 1 Current operations Pt2 & Pt3 Franchise operations Pt2 & Pt3 Exp