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

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.

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!