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.
| Month | Manufacturing overhead costs | Number of machine hours |
| April | $22,000 | 12,250 |
| May | $22,860 | 12,510 |
| June | $21,600 | 11,280 |
| July | $21,800 | 11,410 |
| August | $21,250 | 10,980 |
| September | $21,930 | 11,670 |
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:
| 1. | What is the cost equation if the high-low method is used to estimate costs? |
| 2. | Using the high-low method, predict total manufacturing overhead costs if Maxwell |
Corporation uses 12,000 hours.
| 3 | What is the cost equation if regression analysis is used to estimate costs (use the results from |
the regression analysis provided)?
| 4. | Using regression analysis, predict total manufacturing overhead costs if Maxwell Corporation |
uses 12,000 hours.
| 5. | Which method is generally the best predictor of costs? Justify your answer. |
History of the number of observed sunspots during the last 250 years, which shows the ~11-year solar
Increasing Costs of Natural Disasters
A 5,000-year-old Egyptian garment
Should We Prolong Life at all Costs?
You deposit $2000 each year into an account earning 4% interest compounded annually. How much ...
Find the proceeds of the following promissory note. A five-year, $4500.00 note bearing interest ...