Required information

Problem $5$A$-6($Algo$)$ Least$-$Squares Regresslon; Scattergraph; Comparison of Actlvity Bases $[$LO$5-11]$

The Hard Rock. Mining Compony ls developing cost farmuls: for mansgement planning and declaion$-$making purposes.

The compsny's cost enslyat has concluded thst utilties cost la o mixed cost, end he is stte mpting to find $s$ bsse thest

carrelates with the cost. The controller has suggested thst tons mined might be o good bose to use in deve oping o cost

formuls. The praduct on superintendent dissgress; she thinks thst direct abor$-$hours would be s better bose. The cost

anglyst has decided to try both bsses snd hss sasembled the following Infarmstan:

Problem $5$A$-6$ Part $2($Algo$)$

$2-$s$.$ Ualing drect labar$-$haurs $5s$ the Independent variable, prepsre $3$ scstergreph that plots direct lsbar$-$haurs on the horizantal sxis

and utiltes cost on the vertical sxis.

Instructions:

On the graph below, use the polnt tool $($Year $1-1$st quarter$)$ to plot direct labor$-$hours on the harizontal axis and uttilities cost on

the Vertical sxis.

$2$ Repeat the some process for the plotter tools $($Yesr $1-2$ nd querter to Year $2-4$th querter$).$

To enter exact coordinstes, click on the point and enter the values of $x$ and $y.$

To remove a point from the graph, click on the polnt and select delete optlon.

$2-$b$.$ Uaing the lesst$-$squore: regresslon method, estimete the voriable utilutes cost per direct labor$-$hour and the total fixed utilties cost

per quarter. Express these est mates in the form $Y=+b($Round the Variable cost to $2$ decimel places and Fixed Cost to the

nearest whale dollsr e mount.$)$