Thane Company Is Interested in Establishing the Relationship Between Electricity

question 22

Multiple Choice

Thane Company is interested in establishing the relationship between electricity costs and machine hours. Data have been collected and a regression analysis prepared using Excel. The monthly data and the regression output follow:
$\begin{array}{lll}\text {Month}&\text {Machine Hours}&\text {Electricity Costs}\\\text { January } & 2,500 & \$ 18,400 \\\text { February } & 2,900 & 21,000 \\\text { March } & 1,900& 13,500 \\\text { April } & 3,100 & 23,000 \\\text { May } & 3,800& 28,250 \\\text { June } & 3,300& 22,000 \\\text { July } & 4,100 & 24,750\\\text { August } & 3,500 & 22,750 \\\text { September } & 2,000 & 15,500 \\\text { October } & 3,700 & 26,000 \\\text { November } & 4,700 & 31,000 \\\text { December } & 4,200 & 27,750\end{array}$



$$\begin{array}{c} { \text { Summary Output } } \\ { \text { Regression Statistics } } \\\begin{array}{ | l | c | } \hline \text { Multiple R } & 0.965 \\\hline \text { R Squuare } & 0.932 \\\hline \text { Adjusted R } ^2 & 0.925 \\\hline \text { Standard Error } & 1,425.18 \\\hline \text { Observations } & 12.00 \\\hline\end{array}\end{array}$$
$\begin{array}{|l|r|r|r|r|r|r|}\hline && \text { Standard } & && \text { Lower } & \text { Upper } \\&\text { Coefficients } & \text { Error } & \text { t Stat } & \text { P-value } & 95 \% & 95 \% \\ \hline \text { Intercept } & 3,726.88 & 1,682.82 & 2.21 & 0.05 & (22.69) & 7,476.45 \\\hline \text { Machine } & 5.77 & 0.49 & 11.7 & 0.00 & 4.67 & 6.87 \\\text { Hours } & & & & & \\\hline\end{array}$



-
The percent of the total variance that can be explained by the regression is:

• A) 96.5%.
• B) 93.2%.
• C) 92.5%.
• D) 98.2%.

---

Definitions:

Flexible Budget Amounts

Budgeted figures that can adjust based on changes in activity levels or other factors, unlike a static budget.

Variable Costs

Expenses that change in proportion to the volume of production or sales, including components like raw materials and direct labor costs.

Fixed Costs

Expenses that do not change with the level of goods or services produced within a certain time span.

Operating Income

The profit realized from a business's core operations, excluding deductions of interest and taxes.