Refer to Berg Industries in P6-61A.

Requirements
1. Use Excel regression analysis to determine Berg Industries€™ manufacturing overhead cost
equation using DL hours as the cost driver. Comment on the R-square. Estimate MOH costs
if Berg Industries incurs 24,000 DL hours in January.
2. Use Excel regression analysis to determine Berg€™s MOH cost equation using number of units produced as the cost driver. Use all of the data provided. Project total MOH costs if Berg Industries produces 5,000 units. Which cost equation is better€”this one or the one from Question 1? Why?
3. Use Excel regression analysis to determine Berg Industries€™ MOH cost equation using number of units produced as the cost driver. This time, remove any potential outliers before performing the regression. How does this affect the R-square? Project total MOH costs if 5,000 units are produced.
4. In which cost equation do you have the most confidence? Why?

Transcribed Image Text:

MOH Manufacturing Direct МОН Cost Overhead Labour Units Cost per per Unit Month July August. September Hours Produced DL Hour Produced $460,000 23,000 3,600 $20.00 $127.78 515,000 26,400 4,320 19.51 119.21 425,000 19,000 4,200 22.37 101.19 448,000 21,600 3,400 20.74 131.76 91.65 19,400 3,250 22.53 134.46 Costs 527,000 27,000 5,750 437,000 ...5 19.52 December.