based on the below data, create the profit model for Donuts to Go
Donut Information Based on the below data, create the profit model for Donuts to Go. Assume that each customer will buy one donut and one cup of coffee Variable costs Fixed Costs Time period Revenue: Cup of Coffee $4.00 3 Revenue: Donut $3.50 e Donut Ingredients per donunt) per donut $0.50 20 paper products: napkins, plates etc 11 Insurance month $200.00 12 13 Maintenance & Repairs to equipment month $0.00 14 Marketing & Promotion: Advertising month $50.00 15 Coffee per cup $0.25 16 Coffee cups per cup $0.10 17 Payroll: Wages (Owner Manager) month $2,500.00 18 Payroll: Wages (per Employees) month $1,000.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 $25.00 26 Utilities month $200.00 27 28 29 30 Additional Data High demand, Day old above Low Demand, below 31 Monthly Production Lost Sales revenue Average average 32 4000 3 1.25 20% 25% 33 Franchise Monthly production increase 34 Franchise Expense 6,000.00 40% 35 Franchise demand increase 24% 36 States of Natures probabilities for Expected Values 37 High demand 20.00% 38 Average demand 55.00% 39 Low demand 25.00% 40 F Monthly Production Lost Sales Day old revenue L February March April May June July August September October November December CURRENT OPERATIONS 2 AVERAGE DEMAND 4 Month January 5. Demand 6 satisfied demand 7 Extra donuts over) 8 Unsatisfied customers (short) 9 Revenue 10 coffee 11 donut 12 Revenue from day old sales 13 Total Revenue Expenses 15 Fixed Expenses 16 Total Fixed Expense 17 18 Variable Expenses 19 Coffee Variable expense 20 Donut Variable expense 21 Total Variable Expenses 22 Expenses: due to lost sales 23 Total Expenses 24 25 Profit Donuts and Coffee 26 February March April May June July September October November December 27 28 HIGH DEMAND 29 Month January 30 Demand 31 satisfied demand 32 Extra donutsover) 33 Unsatisfied customers(short) 34 Revenue 35 coffee 36 donut 37 Revenue from day old sales 38 Total Revenue 39 Expenses 40 Fixed Bxpenses 41 Total Fixed Expense 42 43 Variable Expenses 44 Coffee Variable expense 45 Donut Variable expense 46 Total Variable Expenses 47 Expenses due to lost sales 48 Total Expenses 49 50 Profit Donuts and Coffee 51 February March April June July August September October November December 52 53 LOW DEMAND 54 Month January 55 Demand 56 satisfied demand 57 Extra donutsover) 58 Unsatisfied customers (short) 59 Revenue 60 coffee 61 donut 62 Revenue from day old sales 63 Total Revenue 64 Expenses 65 Fixed Expenses 66 Total Fixed Expense 68 Variable Expenses 69 Coffee Variable expense 70 Donut Variable expense 71 Total Variable Expenses 72 Expenses due to lost sales 73 Total Expenses 74 75 Profit Donuts and Coffee 76 77 Donut Information Based on the below data, create the profit model for Donuts to Go. Assume that each customer will buy one donut and one cup of coffee Variable costs Fixed Costs Time period Revenue: Cup of Coffee $4.00 3 Revenue: Donut $3.50 e Donut Ingredients per donunt) per donut $0.50 20 paper products: napkins, plates etc 11 Insurance month $200.00 12 13 Maintenance & Repairs to equipment month $0.00 14 Marketing & Promotion: Advertising month $50.00 15 Coffee per cup $0.25 16 Coffee cups per cup $0.10 17 Payroll: Wages (Owner Manager) month $2,500.00 18 Payroll: Wages (per Employees) month $1,000.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 $25.00 26 Utilities month $200.00 27 28 29 30 Additional Data High demand, Day old above Low Demand, below 31 Monthly Production Lost Sales revenue Average average 32 4000 3 1.25 20% 25% 33 Franchise Monthly production increase 34 Franchise Expense 6,000.00 40% 35 Franchise demand increase 24% 36 States of Natures probabilities for Expected Values 37 High demand 20.00% 38 Average demand 55.00% 39 Low demand 25.00% 40 F Monthly Production Lost Sales Day old revenue L February March April May June July August September October November December CURRENT OPERATIONS 2 AVERAGE DEMAND 4 Month January 5. Demand 6 satisfied demand 7 Extra donuts over) 8 Unsatisfied customers (short) 9 Revenue 10 coffee 11 donut 12 Revenue from day old sales 13 Total Revenue Expenses 15 Fixed Expenses 16 Total Fixed Expense 17 18 Variable Expenses 19 Coffee Variable expense 20 Donut Variable expense 21 Total Variable Expenses 22 Expenses: due to lost sales 23 Total Expenses 24 25 Profit Donuts and Coffee 26 February March April May June July September October November December 27 28 HIGH DEMAND 29 Month January 30 Demand 31 satisfied demand 32 Extra donutsover) 33 Unsatisfied customers(short) 34 Revenue 35 coffee 36 donut 37 Revenue from day old sales 38 Total Revenue 39 Expenses 40 Fixed Bxpenses 41 Total Fixed Expense 42 43 Variable Expenses 44 Coffee Variable expense 45 Donut Variable expense 46 Total Variable Expenses 47 Expenses due to lost sales 48 Total Expenses 49 50 Profit Donuts and Coffee 51 February March April June July August September October November December 52 53 LOW DEMAND 54 Month January 55 Demand 56 satisfied demand 57 Extra donutsover) 58 Unsatisfied customers (short) 59 Revenue 60 coffee 61 donut 62 Revenue from day old sales 63 Total Revenue 64 Expenses 65 Fixed Expenses 66 Total Fixed Expense 68 Variable Expenses 69 Coffee Variable expense 70 Donut Variable expense 71 Total Variable Expenses 72 Expenses due to lost sales 73 Total Expenses 74 75 Profit Donuts and Coffee 76 77
