Below is the actual demand for electrical boxes for Abco Electric for the last nine periods along with a forecast. A) Complete the Mean Absolute Deviation for this forecast. B) Complete an additional forecast for periods 4-12 using a weighted moving average of your choice. Change the title to describe your method. C) Calculate the MAD for your forecast. D) In the text box below put your comment comparing the accuracy of your forecast versus the one given in A. Was your method more accurate? Why or why not? Use whole numbers for all forecasts. Use ONE decimal place for the MAD calculations.

 

DRAWING TOOLS 2227Assignment10PM400VerE (1) Excel (Product Activation Failed) ? Sign in FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW FORMAT Cut Calibri (Body) 12 ' ' AutoSum- A Wrap Text Number Paste Copy Clipboard TextBox 6 BIU- Merge & Center $ % % 000 Format Painter 000 Conditional Format as Cell Formatting Table Styles- Insert Delete Format Fill- Clear Sort & Find & Filter -Select- 22 Font 17 Alignment E Number 5 Styles Cells Editing . X fx B J K L M A D 60 A. E B. F C. G H 61 Period Demand Nave Method MAD Your title here Your MAD 62 1 925 Abs e Abs e 63 2 910 64 3 864 65 4 825 864 66 5 955 825 67 6 980 955 68 7 1020 980 69 8 950 1020 70 9 905 950 71 10 825 905 72 11 795 825 73 12 730 795 74 MAD 75 76 D. Your comment on Forecast Accuracy: 77 70 Assignment 1 READY AVERAGE: 3630 COUNT: 11 SUM: 39927 + 106%