1. The historical demand for the Panasonic Model 304 Pencil Sharpener is: January, 160; February, 280; March, 175; April, 295; and May, 190 units.
a. Using a 2-month moving average, what is the forecast for June? If June experienced a demand of 100, what is the forecast for July?
a. Using single exponential smoothing with α = 0.5, if the forecast for January had been 70, compute what the exponential forecast would have been for the remaining months through June.
a. Develop a linear regression model and compute a forecast for June, July, and August.
(You may use any software package of your choice to solve this problem, including Excel or QM, or…….)