Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need help ASAP please 9 10 11 13 34 15 3 16 17 18 19 20 21 22 23 24 25 26 27 28

i need help ASAP please
image text in transcribed
image text in transcribed
image text in transcribed
9 10 11 13 34 15 3 16 17 18 19 20 21 22 23 24 25 26 27 28 1 Month 61 OF #1 L44 10/19 2/1/19 3/2/20 4/2/20 61/0/5 6/12/19 SUVE 3/1/29 9/12/19 10/1/19 11/1/19 12/01/09 1/7/20 2/1/20 3/1/20 4/1/20 5/1/20 6/1/20 7/1/20 8/1/20 1/1/20 10/1/20 11/1/20 120/20 1/1/1 2/1/21 3/1/21 4/2/221 5/1/21 4/1/21 20/01 8/1/21 12 3 4 5 10/1/21 11/1/21 12/1/21 1/1/22 2/2/22 12/1/6 3/02/22 4002 Demand: 2218 2335 2780 3145 3078 3346 2534 2203 2394 3366 2682 4589 2425 2678 2686 3040 3512 3601 2706 3180 3081 3728 4351 4992 2535 2700 2813 3524 3741 4101 3051 3473 3394 4343 4758 5707 C Yearly average Financial information 2880.17 3331926647 Seasonal indes 3678.33 07677 03082 09622 10085 10454 11581 08771 07625 08286 11650 0928) 15883 Average St 0.7287 03037 0.8061 09124 10540 1.0808 08121 09544 09247 1.1189 1.3059 14982 0.6892 0.7340 0.7647 0.9580 10170 13149 0.8295 09442 0.9227 11807 1.2935 15515 SI and regression Pt 1 9.7285 0.7820 0.8444 0983 10455 11179 Deseasonalzed 0.3390 0820 04920 1.1549 11759 15460 03285 07820 03444 0.3863 10455 11179 08396 08470 08920 1.1549 11759 15460 0.7285 0.7820 03444 0.9063 10455 11179 0.8396 0.8870 0.8920 11549 13759 15460 304451 2015.04 3292 40 318860 2944.30 2993.04 Time period 301826 248357 2483.85 291451 228082 2968.24 3332.76 342461 318107 308214 3319.22 3221.34 3223.33 3585.00 3454.0) 3228.06 3700.38 3228.91 347963 3452.74 313148 357285 3578 26 366839 363407 3915.32 3806.92 3760.59 4045.30 3692.38 Current operations Pt2 & P13 3 P. 6 5 30 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Deseasonalized forecast 37 38 CLICK CELL I output call for re 39 3825.77 145743 3866.07 3914.72 Franchise operations Pt2 & Pt3 Expectes Highest yearly average Total 3 year demand Average 3 year demand 3678.33 Highest Average SI 1.5460 Total 3 year deseasonalized demand Average 3 year deseasonalized demand 22 m m m m m m 28 29 30 31 32 23 33 34 15 35 36 Deseasonalized forecast 37 38 39 40 41 42 43 44 45 46 47 48 3828.77 3857.42 3886.07 3914.72 3943.37 3972.03 4000.68 4029.33 4057.98 4086.63 4115.28 4143.93 Use the average seasonal Index in the column for 2019 Seasonalized forecast 2789.36 3016.45 3281.28 3861.20 4122.72 4440.44 3358.79 3574.13 3619.73 4719.53 4839.12 6406.66 Put yearly average in cell 150 When you move your forecast to the profit models, you must use an equation, not just copy the values 9 10 11 13 34 15 3 16 17 18 19 20 21 22 23 24 25 26 27 28 1 Month 61 OF #1 L44 10/19 2/1/19 3/2/20 4/2/20 61/0/5 6/12/19 SUVE 3/1/29 9/12/19 10/1/19 11/1/19 12/01/09 1/7/20 2/1/20 3/1/20 4/1/20 5/1/20 6/1/20 7/1/20 8/1/20 1/1/20 10/1/20 11/1/20 120/20 1/1/1 2/1/21 3/1/21 4/2/221 5/1/21 4/1/21 20/01 8/1/21 12 3 4 5 10/1/21 11/1/21 12/1/21 1/1/22 2/2/22 12/1/6 3/02/22 4002 Demand: 2218 2335 2780 3145 3078 3346 2534 2203 2394 3366 2682 4589 2425 2678 2686 3040 3512 3601 2706 3180 3081 3728 4351 4992 2535 2700 2813 3524 3741 4101 3051 3473 3394 4343 4758 5707 C Yearly average Financial information 2880.17 3331926647 Seasonal indes 3678.33 07677 03082 09622 10085 10454 11581 08771 07625 08286 11650 0928) 15883 Average St 0.7287 03037 0.8061 09124 10540 1.0808 08121 09544 09247 1.1189 1.3059 14982 0.6892 0.7340 0.7647 0.9580 10170 13149 0.8295 09442 0.9227 11807 1.2935 15515 SI and regression Pt 1 9.7285 0.7820 0.8444 0983 10455 11179 Deseasonalzed 0.3390 0820 04920 1.1549 11759 15460 03285 07820 03444 0.3863 10455 11179 08396 08470 08920 1.1549 11759 15460 0.7285 0.7820 03444 0.9063 10455 11179 0.8396 0.8870 0.8920 11549 13759 15460 304451 2015.04 3292 40 318860 2944.30 2993.04 Time period 301826 248357 2483.85 291451 228082 2968.24 3332.76 342461 318107 308214 3319.22 3221.34 3223.33 3585.00 3454.0) 3228.06 3700.38 3228.91 347963 3452.74 313148 357285 3578 26 366839 363407 3915.32 3806.92 3760.59 4045.30 3692.38 Current operations Pt2 & P13 3 P. 6 5 30 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Deseasonalized forecast 37 38 CLICK CELL I output call for re 39 3825.77 145743 3866.07 3914.72 Franchise operations Pt2 & Pt3 Expectes Highest yearly average Total 3 year demand Average 3 year demand 3678.33 Highest Average SI 1.5460 Total 3 year deseasonalized demand Average 3 year deseasonalized demand 22 m m m m m m 28 29 30 31 32 23 33 34 15 35 36 Deseasonalized forecast 37 38 39 40 41 42 43 44 45 46 47 48 3828.77 3857.42 3886.07 3914.72 3943.37 3972.03 4000.68 4029.33 4057.98 4086.63 4115.28 4143.93 Use the average seasonal Index in the column for 2019 Seasonalized forecast 2789.36 3016.45 3281.28 3861.20 4122.72 4440.44 3358.79 3574.13 3619.73 4719.53 4839.12 6406.66 Put yearly average in cell 150 When you move your forecast to the profit models, you must use an equation, not just copy the values

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The New CFO Financial Leadership Manual

Authors: Steven M. Bragg

3rd Edition

0470882565, 978-0470882566

More Books

Students also viewed these Finance questions

Question

15.14 Repeat the instructions of Exercise 15.13 for Ha p 0.5.

Answered: 1 week ago