Management of MRC Enterprises has provided the following output from Excel^®: $\begin{array}{lr}\hline {\text { Statistics }} \\\hline \text { Multiple R } & 0.8939072 \\\text { R Square } & 0.7990702 \\\text { Adjusted R2 } & 0.7488377 \\\text { Standard Error } & 10744.516 \\\text { Observations } & 6 \\\hline\end{array}$

$\begin{array}{lrrrrr}\hline &&&&&\text { Signticance }\\\text { ANOVA }&df&SS&MS&F&F\\\hline \text { Regression } & 1 & 1836429 & 1836429 & 15.90745 & 0.0162864 \\\text { Residual } & 4 & 46177852 & 11544463 & & \\\text { Total } & 5 & 2298208 & & & \\\hline\end{array}$

$\begin{array}{lrrrrrrrr}\hline&&&&&&\text { Upper } & \text { Lower } & \text {upper } \\&\text { Coefficients}&\text { Std Error}&\text { t stat }&\text { P vlalue}&\text { Lower } 95 \%&95 \% & 95 \% & 95 \%\\\hline \text { Intercept } & 47757.05 & 34958.30 & 1.36611 & 0.24366 & -49302.764 & 144816.88 & 49302 . & 144816.8 \\\text { XVariable 1 } & 6.364 & 1.595798 & 3.98841 & 0.01628 & 1.9340590 & 10.795352 & 1.9340 & 10.79535 \\\hline\end{array}$ What is the estimated cost for a production level of 1,200 units?

Question

Management of MRC Enterprises has provided the following output from Excel^®:

\begin{array}{lr}\hline {\text { Statistics }} \\\hline \text { Multiple R } & 0.8939072 \\\text { R Square } & 0.7990702 \\\text { Adjusted R2 } & 0.7488377 \\\text { Standard Error } & 10744.516 \\\text { Observations } & 6 \\\hline\end{array}

\begin{array}{lrrrrr}\hline &&&&&\text { Signticance }\\\text { ANOVA }&df&SS&MS&F&F\\\hline \text { Regression } & 1 & 1836429 & 1836429 & 15.90745 & 0.0162864 \\\text { Residual } & 4 & 46177852 & 11544463 & & \\\text { Total } & 5 & 2298208 & & & \\\hline\end{array}

\begin{array}{lrrrrrrrr}\hline&&&&&&\text { Upper } & \text { Lower } & \text {upper } \\&\text { Coefficients}&\text { Std Error}&\text { t stat }&\text { P vlalue}&\text { Lower } 95 \%&95 \% & 95 \% & 95 \%\\\hline \text { Intercept } & 47757.05 & 34958.30 & 1.36611 & 0.24366 & -49302.764 & 144816.88 & 49302 . & 144816.8 \\\text { XVariable 1 } & 6.364 & 1.595798 & 3.98841 & 0.01628 & 1.9340590 & 10.795352 & 1.9340 & 10.79535 \\\hline\end{array}

What is the estimated cost for a production level of 1,200 units?

Quizplus · Accepted Answer

The estimated cost for a production level of 1,200 units can be calculated using the regression equation $Y = a + bX$, where $a$ is the intercept, $b$ is the coefficient for the variable, and $X$ is the value of the variable. Here, $a = 47757.05$ and $b = 6.364$. For $X = 1,200$, the calculation is $47757.05 + 6.364 \times 1,200 = 55394$.

Management of MRC Enterprises Has Provided the Following Output from Excel®

Management of MRC Enterprises Has Provided the Following Output from Excel^®