UNIT $3-$ Chapter Review

Started: Mar $21$ at $11$:$45$pm

Quiz Instructions

Rock salt is often used to melt snow. This salt is produced by a firm called Tahoe Salt. In the past, Tahoe Salt relied on estimates of demand from a sample of its retailers. However, the company noticed that these retailers often overestimate their purchases, leaving Tahoe stuck with inventory. Tahoe wants to produce a collaborative forecast using actual retail data of their sales of salt. Quarterly retail data for the last three years is given in the spreadsheet tahoe.xlsx Download tahoe.xlsx

Flag question: Question $1$

Question $13$ pts

Perform a three point moving average and forecast demand, in pounds, for salt for the first quarter of year $4.$ Please round to the nearest whole number.

$19000$

Flag question: Question $2$

Question $23$ pts

Write down the MAD for the three point moving average. Please round to two decimal points.

$19000$

Flag question: Question $3$

Question $34$ pts

Perform exponential smoothing with alpha$=0\mathrm{.}2$; Round to $3$ decimal places.

$10000$

Flag question: Question $4$

Question $43$ pts

Write down the MAD for exponential smoothing. Please round your answer to two decimal points.

$13$

Flag question: Question $5$

Question $55$ pts

Identify an optimal value for alpha $-$ round to $3$ decimal places.

Flag question: Question $6$

Question $63$ pts

Develop the trend projection equation $($simple linear regression$)$ slope. Please round to the nearest whole number.

Flag question: Question $7$

Question $73$ pts

Develop the trend projection equation $($simple linear regression$)$ intercept. Please round to the nearest whole number.

Flag question: Question $8$

Question $83$ pts

Question

Flag question: Question $9$

Question $94$ pts

What is the forecast for year $4$ with Trend Projection for the first quarter? Please round your answer to the nearest whole number.

Flag question: Question $10$

Question $104$ pts

What is the forecast for year $4$ with Trend Projection for the second quarter? Please round your answer to the nearest whole number.

Flag question: Question $11$

Question $114$ pts

What is the forecast for year $4$ with Trend Projection for the third quarter? Please round your answer to the nearest whole number.

Flag question: Question $12$

Question $124$ pts

What is the forecast for year $4$ with Trend Projection for the fourth quarter? Please round your answer to the nearest whole number.

Flag question: Question $13$

Question $134$ pts

Write down the MAD projection. Please round your answer to two decimal places.

Flag question: Question $14$

Question $144$ pts

Perform a Trend and Seasonal analyses for this data. Indicate the scaled seasonal indices for the first quarter. Please round your answer to three decimal places.

Flag question: Question $15$

Question $154$ pts

Perform a Trend and Seasonal analyses for this data. Indicate the scaled seasonal indices for the second quarter. Please round your answer to three decimal places.

Flag question: Question $16$

Question $164$ pts

Perform a Trend and Seasonal analyses for this data. Indicate the scaled seasonal indices for the third quarter. Please round your answer to three decimal places.

Flag question: Question $17$

Question $174$ pts

Perform a Trend and Seasonal analyses for this data. Indicate the scaled seasonal indices for the fourth quarter. Please round your answer to three decimal places.

Flag question: Question $18$

Question $182$ pts

When is the busiest period $($quarter$)?$

Flag question: Question $19$

Question $194$ pts

Develop the linear regression equation after de$-$seasonalizing the data. Please indicate the slope, rounding your answer to two decimal places.

Flag question: Question $20$

Question $202$ pts

Develop the linear regression equation after de$-$seasonalizing the data. Please indicate the intercept, rounding your answer to the nearest whole number

Flag question: Question $21$

Question $212$ pts

Question

Flag question: Question $22$

Question $222$ pts

What is the forecast for year $4$ with the Trend and Seasonal Method for the first quarter? Please round your answer to the nearest whole number.

Flag question: Question $23$

Question $232$ pts

What is the forecast for year $4$ with the Trend and Seasonal Method for the second quarter? Please round your answer to the nearest whole number.

Flag question: Question $24$

Question $242$ pts

What is the forecast for year $4$ with the Trend and Seasonal Method for the third quarter? Please round your answer to the nearest whole number.

Flag question: Question $25$

Question $252$ pts

What is the forecast for year $4$ with the Trend and Seasonal Method for the fourth quarter? Please round your answer to the nearest whole number.

Flag question: Question $26$

Question $262$ pts

Of all the forecasts, which do you prefer?

Group of answer choices

Trend Projection

Trend and Seasonal

Exponential Smoothing

Moving Average

Flag question: Question $27$

Question $272$ pts

Why do you prefer that forecast?

Group of answer choices

MAD is the lowest

MAD is the highest

t