Required #$1$:

Construct an Excel spreadsheet and use the Excel commands to perform a least$-$squares regression. Estimate the variable$-$ and fixed$-$cost components in the company$$s material$-$handling department costs.

Note: Round the Variable$-$cost component to $2$ decimal places and the Fixed$-$cost component to the nearest whole dollar amount.

Required #$2$:

Complete the least$-$squares regression equation for the department$$s costs.

Note: Round variable cost per unit to $2$ decimal places and other answer to the nearest whole dollar amount.

Required #$3$:

Predict the firm$$s material$-$handling department$$s costs for a month when $2,150$ units of activity are recorded.

Note: Round variable cost per unit to $2$ decimal places and final answer to the nearest whole dollar amount.