Question: Question 6 Cell E11. Enter F1 error for August 2020, must be a whole number. Question 7 Cell F10. Enter F1 absolute error for July

Question 6 Cell E11. Enter F1 error for August 2020, must be a whole number. Question 7 Cell F10. Enter F1 absolute error for July 2020, must be a whole number. Question 8 Cell F17. Enter F1 MAD, must be a whole number. Homework - Moving Average Forecasts Forecast 1 (F1) Absolute Error F1 Absolute * Error Forecast 2 Absolute Absolute F1 (F2) Error F2 X Error F2 Error F1 ud dem desmi ROUND R4 Rand dum dem UAB Radio KUD AU A function TIL Actual Year Month Demand 2020 Jan 500 2020 Feb 450 2020 Mar 475 2020 Apr 575 2020 May 460 2020 Jun 480 2020 Jul 500 2020 Aug 510 2020 Sep 600 2020 Oct 515 2020 Nov 465 2020 Dec SOS 2021 Jan 495 1 H WENN Enter Means above, round Entert to decimal above Enter MAD above, odec Enter MAPE Enter Sum above wbove Enter MAD bove, dec Enter MAPE above You want to compare accuracy of two types of 3-month moving average forecasts of sales for a machine part. Based on the above data, calculate a simple 3-month moving average forecast 1). Then calculate a weighted 3-month moving average (forecast 2). In forecast 2, the sales of the most recent month, Le "one month ago," have double the weight of any of the two preceding months, ie. two months ago and three months ago Tip: you will need to flex your analytical abilities by creating and solving an equation for weights first, keeping in mind that all weights must add up to 1. Calculate forecast errors and make a conclusion about the relative accuracy of one method over the other for this data set based on MAD and mean absolute percentage error (MAPE). Use formulas in all cells, including the ROUND formula to round to integer number of units and the ABS formula for absolute numbers where applicable. Color legend: Test your answers in these cells in the Help Tool, unlimited attempts Enter final answers in these cells in the final quiz when ready Note on rounding of values expressed in percent, such as MAPE: If your formula looks like a/b and then you click on the icon in the menu to display the value in round to 4 decimals. If you use the formula a/b*100, then round to 2 decimals

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Question 7 1 pt Enter forecast F3 for July 2020; must be a whole number. a Question 8 1 pts Enter forecast F3 absolute % error for July 2020; round to 2 decimals. Do not use the % sign. puran moving...

Question 12 1 pts Cell H8. Enter F2 forecast for May 2020, must be a whole number. Question 13 1 pts Cell H12. Enter F2 forecast for September 2020, must be a whole number. Question 14 1 pts Cell...

Question 9 1 pts Cell G7. Enter F1 absolute % error for April 2020, must be a number with two decimals, e.g., 15.23. Do not enter the % sign. Question 10 1 pts Cell G9. Enter F1 absolute % error for...

the yellow and green boxes are what I'm looking to fill in Enter actual demand for July 2020; must be a whole number. Question 2 Enter mean actual demand for the period of Januacy 2020 through...

Enter forecast F1 for July 2020; must be a whole number. Question 4 Enter forecast F1 absolute \% error for July 2020; round to 2 decimals. Do not use the \% sign. Fuitivi Time Serien Forecast...

3 Enter forecast F1 for July 2020; must be a whole number. Question 4 1 pts 1 pts Enter forecast F1 absolute % error for July 2020; round to 2 decimals. Do not use the % sign. S-month weighted porent...

Question 1 2 pts Cell D17. Enter mean monthly forecast F1 for the period from April 2020 through January 2021, must be a whole number. Question 2 2 pts Cell E17. Enter cumulative F1 forecast error...

Question 15 1 pts Cell 110. Enter F2 absolute error for July 2020, must be a whole number. Question 16 1 pts Cell 18. Enter F2 absolute % error for May 2020, must be a number with two decimals, e.g....

Cell 117. Enter mean absolute deviation (MAD) for F2 forecast for the period from April 2020 through January 2021, must be a whole number. 2 pts Question 5 Cell J17. Enter mean absolute percent error...

QUESTION 1 Using lab 1 part 1, what is the formula that should be in cell G14 using all the proper absolute and relative referencing? a =(C3/E3)+G$7+(G$8*$C14) O b. =(C3/E3)+G7+(G8*C14) OC....

*Hom Anywhere vemulapallivinay kumar201gvitstudent ac.in LogoutU Consider a passive low pass filter with resistance R and inductance L as shown in the Fig. 1. IN OUT Fig. 1 A random process X(t)...

5 people can claim joint ownership of an item and intend to divide it by the Method of Sealed Bids. The winner offers a bid of $8,000, how much will that bidder need to put into a kitty for the other...

Please use this adjusted trial balance to create an income statement in multiple step format. I am unsure if tax amount is right. The tax rate for the company is 4 0 % . The income tax expense listed...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...