just show me how to work it

Enter totals Faced Costs Varible costs Coffee Donut 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 6 Time period 7 Revenue: Cup of Coffee $2.99 8 Revenue: Donut $2.50 9 Donut ingredients per donunt) per 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 (Ownerl 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 $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 Lost Sales High demand, % Low Demand, % below Day old revenue above Average average 1.25 22% 26% 4000 3 Monthly Production 31 52 -3 Franchise 4 Monthly Fixed Expense increase 5 Monthly Production Increase 6 Monthly demand increase 4,350.00 32% 22% States of Natures 3 High demand Average demand Low demand probabilities 20.00% 55.00% 25.00% Seasonal Index Average si Deseasonalued Time period Month Demand 1/1/19 2/1/19 3/1/19 4/1/19 S/1/19 6/1/19 772/19 8/1/19 9/1/19 10/1/19 11/1/19 12/1/19 1/1/20 2/1/20 3/1/20 4/1/20 5/1/20 6/1/20 7/1/20 8/1/20 9/1/20 10/1/20 11/1/20 12/1/20 1/1/21 2/1/21 3/1/21 4/1/21 5/1/21 6/1/21 7/1/21 8/1/21 9/1/21 10/1/21 11/1/21 12/1/21 Yearly average 22.10 2353 2835 2745 2350 3433 2550 2250 2263 2590 3428 Put yearly average in below cell 3998 2513 2344 2476 3055 3535 3365 2426 2788 2806 3397 4097 Put yearly average in below cell 5097 2629 2831 1802 3520 3620 3879 2891 3293 3394 5175 Put yearly average in below cell 6208 Highest yearly average Total 3 year deseasonalized demand Total 3 year demand Average 3 year deseasonalized demand Average 3 year demand Highest Average SI M N o Regression Output CLICK CEUL 12 as output cell for regression Deseasonalized forecast Use the average seasonal Index Seasonalized forecast When you move your forecast to the profit models, you must use an equation, not just copy the values ut yearly average in cells Enter totals Faced Costs Varible costs Coffee Donut 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 6 Time period 7 Revenue: Cup of Coffee $2.99 8 Revenue: Donut $2.50 9 Donut ingredients per donunt) per 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 (Ownerl 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 $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 Lost Sales High demand, % Low Demand, % below Day old revenue above Average average 1.25 22% 26% 4000 3 Monthly Production 31 52 -3 Franchise 4 Monthly Fixed Expense increase 5 Monthly Production Increase 6 Monthly demand increase 4,350.00 32% 22% States of Natures 3 High demand Average demand Low demand probabilities 20.00% 55.00% 25.00% Seasonal Index Average si Deseasonalued Time period Month Demand 1/1/19 2/1/19 3/1/19 4/1/19 S/1/19 6/1/19 772/19 8/1/19 9/1/19 10/1/19 11/1/19 12/1/19 1/1/20 2/1/20 3/1/20 4/1/20 5/1/20 6/1/20 7/1/20 8/1/20 9/1/20 10/1/20 11/1/20 12/1/20 1/1/21 2/1/21 3/1/21 4/1/21 5/1/21 6/1/21 7/1/21 8/1/21 9/1/21 10/1/21 11/1/21 12/1/21 Yearly average 22.10 2353 2835 2745 2350 3433 2550 2250 2263 2590 3428 Put yearly average in below cell 3998 2513 2344 2476 3055 3535 3365 2426 2788 2806 3397 4097 Put yearly average in below cell 5097 2629 2831 1802 3520 3620 3879 2891 3293 3394 5175 Put yearly average in below cell 6208 Highest yearly average Total 3 year deseasonalized demand Total 3 year demand Average 3 year deseasonalized demand Average 3 year demand Highest Average SI M N o Regression Output CLICK CEUL 12 as output cell for regression Deseasonalized forecast Use the average seasonal Index Seasonalized forecast When you move your forecast to the profit models, you must use an equation, not just copy the values ut yearly average in cells