- +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 : Variance for the data

Providing excellent customer service is essential in any business. A bank samples 7 tellers and monitors the time to complete a transaction. The times ( in whole minutes) are 2,4,2,5,2,3, and 10. The variance for the data calculated is 4.33. Given