Scatter Diagrams and High$-$Low Cost Estimation

Assume the local Pearle Vision has the following information on the number of sales orders received and order$-$processing costs.

NOTE: Round variable cost per unit answers to two decimal places, if appropriate.

$($a$.)$ Use information from the high$-$ and low$-$volume months to develop a cost$-$estimating equation for monthly order$-$processing costs.

$

$($b$.)$ Plot the data on a scatter diagram. Hint: In Excel, highlight the data to be included in the chart. Open the insert tab and select the Scatter chart in the Charts group. Using the information from representative

high$-$ and low$-$volume months, develop a cost$-$estimating equation for monthly order$-$processing costs.

$+$$

$x$