- +1-530-264-8006
- info@tutorsglobe.com

Average method to forecast sales price

HP uses X63 chip in their computers and prices for these chips for last 12 months are:

Month |
Jan |
Feb |
Mar |
Apr |
May |
Jun |
July |
Aug |
Sep |
Oct |
Nov |
Dec |

Price ($) |
1.80 |
1.67 |
1.70 |
1.85 |
1.90 |
1.87 |
1.80 |
1.83 |
1.70 |
1.65 |
1.70 |
1.75 |

Forecast next month (i.e. next Jan) sales price using each of the following:

- First use 2-month and then 3-month moving average method to forecast sales price. Using MAD approach, which average is better?
- If the initial Jan forecasts were also $1.80; in an exponential smoothing method, first use a = 0.1 and then a = 0.5; Using MSE approach, which value of a is better to predict sales price?
- In practice, both MAD and MSE can be used to find forecast accuracy giving the same decisions. Why would you choose one over the other? ( Can you explain how to do it by solving, not excel)

Expected delivery within 24 Hoursrs

18,76,764

Questions

Asked

21,311

Experts

9,67,568

Questions

Answered

Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!

Submit Assignment2015 © Tutors Globe. All rights reserved.

## Q : Redesign an ejection seat for an airplane

An engineer is going to redesign an ejection seat for an airplane. The seat was designed for pilots weighing between 130 lb and 191 lb. The new population of pilots has normally distributed weights with a mean of 136 lb and a standard deviation of