Question: please solve it using Excel. needed ASAP. Forecasting Computer Services assembles customized personal computer s from generic parts. Formed and operated by part-time UMass Lowell

please solve it using Excel. needed ASAP.

please solve it using Excel. needed ASAP.

Forecasting Computer Services assembles customized personal computer s from generic parts. Formed and operated by part-time UMass Lowell students Paulette Tyler and Maureen Becker, the company has had steady growth since it started. The company assembles computers mostly at night, using part- time students. Paulette and Maureen purchase generic computer parts in volume at a discount from a variety of sources whenever they see a good deal. Thus, they need a good forecast of demand for their computers so that they will know how many parts to purchase and stock. They have compiled demand data for the last 12 months as reported below Period 1 2 3 4 5 6 7 8 9 10 11 12 Month Jan Feb Mar Apr Jun Jul Oct Noy Dec May 45 Aug 47 Sep 56 Demand 37 40 41 37 50 43 52 55 54 a) Use exponential smoothing with smoothing parameter a= 0.3 to compute the demand forecast for January (Period 13). b) Use exponential smoothing with smoothing parameter a=0.5 to compute the demand forecast for January (Period 13) compute the mean squared error for each of the methods used

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!