PM Computer Services assembles customized personal computers from generic parts. The

company was formed and is operated by two part$-$time university students, Paul and Bryan. The

company has experienced steady growth since started. The computer parts are bought using

volume discounts when good deals can be found. As such it is important that they develop a good

model to forecast demand for their computers so that they will know how many computer

components parts to purchase and stock.

The company has accumulated computer demand data over a $12-$month period. The data are shown

in the worksheet named PM$.$

a$.(8$ Points$)$ Under the Excel Insert Tab, choose to create an appropriate line chart

displaying the time pattern of computer demand data. Please create a professional

appearing chart with labeling and titles. A legend is probably not needed. Move the

chart so that it starts in cell E$3$ and fits within the shaded area. Is the time pattern

stationary? Yes or No in cell I$15.$

b$.(6$ Points$)$ Using StatTools, create the Optimal Parameters Exponential Smoothing

$($Simple$)$ forecast incorporating only Forecast Overlay and Forecast Errors Charts.

Anchor the output in cell A$1$ of the StatTools PM Worksheet.

$4$

c$.(6$ Points$)$ Using StatTools, create the Optimal Parameters Exponential Smoothing

$($Holt$$s$)$ forecast incorporating only Forecast Overlay and Forecast Errors Charts.

Anchor the output in cell G$1$ of the StatTools PM Worksheet.

d$.(8$ Points$)$ In the text box located at A$19,$ provide a managerial analysis for Paul and

Bryan incorporating any patterns you have identified, recommending a forecasting

method $($with reasons$),$ and providing your best forecast for the upcoming month