Question: please i need the solution for problem iii thus, 11 through 14. thank you PROBLEM III. The quarterly sales data for a gift item over

please i need the solution for problem iii
PROBLEM III. The quarterly sales data for a gift item over the past three years are as follows. year 1 year 2 year 3 3 Quarter 1 Quarter 2 Quarter 3 Quarter 4 1690 940 2625 2500 1800 900 2900 2360 1850 1100 2930 2615 Calculate the four-quarter centered moving average and the seasonal indexes for the four quarters. (11) The Average Seasonal Index for Quarter 1 is (round-off to 3 decimal places): (a) 1.586 (b) 0.784 (c) 0.254 (d) 0.902 (e) none of the above (12) The Average Seasonal Index for Quarter 2 is (round-off to 3 decimal places): (a) 0.514 (b) 1.828 (c) 0.487 (d) 1.542 (13) The Average Seasonal Index for Quarter 3 is (round-off to 3 decimal places): (e) none of the above (a) 0.232 (b) 1.399 (c) 1.354 (d) 0.892 (e) none of the above (14) The Average Seasonal Index for Quarter 4 is (round-off to 3 decimal places): (a) 1.219 (b) 0.484 (c) 1.759 (d) 0.422 (e) none of the above PROBLEM IV. The number of items sold over a six-month period are: month: 1 2 3 4 5 6 sales: 4410 4540 4520 4480 4390 4530 Calculate the forecast for the 4th, 5th, 6th and 7th months using 3-month simple moving average, and 3-month weighted moving average with weights of 0.5 for the most recent month and 0.3 for the month preceding the most recent month. (15) Under the 3-month Simple Moving Average Method, the forecast for the 5th month is: (a) 4490 (b) 4513.33 (c) 4543.33 (d) 4556.18 (e) none of the above (16) Under the 3-month Simple Moving Average Method, the forecast for the 7 month is: (a) 4458 (b) 4525 (c) 4484.24 (d) 4466.67 (e) none of the above (17) Under the 3-month Weighted Moving Average Method, the forecast for the 6th month is: (a) 4443 (b) 4512 (c) 4563 (d) 4457 (e) none of the above (18) Under the 3-month Weighted Moving Average Method, the forecast for the 7" month is: (a) 4497 (b) 4532 (c) 4478 (d) 4576 (e) none of the above
thus, 11 through 14. thank you
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
