Need excel shreadsheet with forecast setup. Your boss has asked you to figure out how many aircraft
Question:
Need excel shreadsheet with forecast setup.
Your boss has asked you to figure out how many aircraft engines you need to plan on producing in January. Since engines are costly, your boss wants you to ensure that your forecast is as accurate as possible. He has provided you with the actual demand for the last year; review the following: Period ,Actual 1)155 2)160 3)160 4)158 5)162 6)156 7)160 8)158 9)159 10)163 11)165 12)166 Produce four forecasts (4-period moving average, 4-period weighted moving average, exponential smoothing, and a simple linear regression) and determine which is the most accurate and should be used by our company. For the weighted moving average, use weights of 0.1, 0.2, 0.3, and 0.4, with 0.4 being the most recent period. For the Exponential Smoothing, use an Alpha of 0.3. You should end up with five tabs in your spreadsheetone for each of the four forecasts and a summary and analysis page.