Maxwell Corporation Is Trying to Predict Its Manufacturing Overhead CostsThe Company Performed a Regression Analysis Using the Above Data

The Answer of Maxwell Corporation Is Trying to Predict Its Manufacturing Overhead CostsThe Company Performed a Regression Analysis Using the Above Data

Maxwell Corporation Is Trying to Predict Its Manufacturing Overhead CostsThe Company Performed a Regression Analysis Using the Above Data

The Answer of Maxwell Corporation Is Trying to Predict Its Manufacturing Overhead CostsThe Company Performed a Regression Analysis Using the Above Data

Solved

Maxwell Corporation Is Trying to Predict Its Manufacturing Overhead Costs

question 36

Essay

Maxwell Corporation is trying to predict its manufacturing overhead costs for the upcoming year; they are debating the use of the high-low method versus the use of regression analysis.They have gathered information about their manufacturing overhead costs in each of the past six months.A table containing their cost data and the associated machine hours in each month (the cost driver)follows.
$\begin{array}{|c|c|c|c|}\hline \text { Month } & \text { Manufacturing } & \text { overhead costs } & \text { Number of machine hours } \\\hline \text { April } & \$ & 22,000 & 12,250 \\\hline \text { May } & \$ & 22,860 & 12,510 \\\hline \text { June } & \$ & 21,600 & 11,280 \\\hline \text { July } & \$ & 21,800 & 11,410 \\\hline \text { August } & \$ & 21,250 & 10,980 \\\hline \text { September } & \$ & 21,930 & 11,670 \\\hline\end{array}$
The company performed a regression analysis using the above data and had the following results.(Note: the results are excerpts so not all of the regression analysis results are presented.)
$Maxwell Corporation is trying to predict its manufacturing overhead costs for the upcoming year; they are debating the use of the high-low method versus the use of regression analysis.They have gathered information about their manufacturing overhead costs in each of the past six months.A table containing their cost data and the associated machine hours in each month (the cost driver)follows. \begin{array}{|c|c|c|c|} \hline \text { Month } & \text { Manufacturing } & \text { overhead costs } & \text { Number of machine hours } \\ \hline \text { April } & \$ & 22,000 & 12,250 \\ \hline \text { May } & \$ & 22,860 & 12,510 \\ \hline \text { June } & \$ & 21,600 & 11,280 \\ \hline \text { July } & \$ & 21,800 & 11,410 \\ \hline \text { August } & \$ & 21,250 & 10,980 \\ \hline \text { September } & \$ & 21,930 & 11,670 \\ \hline \end{array} The company performed a regression analysis using the above data and had the following results.(Note: the results are excerpts so not all of the regression analysis results are presented.) Required: a.What is the cost equation if the high-low method is used to estimate costs? b.Using the high-low method,predict total manufacturing overhead costs if Maxwell Corporation uses 12,000 hours. c.What is the cost equation if regression analysis is used to estimate costs (use the results from the regression analysis provided)? d.Using the results from the regression analysis provided,predict total manufacturing overhead costs if Maxwell Corporation uses 12,000 hours. e.Which method (high-low or regression analysis)is a better predictor of total manufacturing overhead costs? Why?$ Required:
a.What is the cost equation if the high-low method is used to estimate costs?
b.Using the high-low method,predict total manufacturing overhead costs if Maxwell Corporation uses 12,000 hours.
c.What is the cost equation if regression analysis is used to estimate costs (use the results from the regression analysis provided)?
d.Using the results from the regression analysis provided,predict total manufacturing overhead costs if Maxwell Corporation uses 12,000 hours.
e.Which method (high-low or regression analysis)is a better predictor of total manufacturing overhead costs? Why?

Definitions:

Educational Demands

The requirements, expectations, and workload placed on students by educational systems, often reflecting academic standards and goals.

Friendships

Mutual affectionate relationships between two or more individuals, characterized by trust, support, and communication.

Protection

Measures or actions taken to guard against harm, loss, or unwanted access, ensuring safety and security.

Stress

The body's response to any demand or challenge, which can be physical, mental, or emotional.