# Question

Berg Industries is in the process of analyzing its manufacturing overhead costs. Berg Industries is not sure if the number of units produced or number of direct labour hours is the best cost driver to use for predicting manufacturing overhead costs. The following information is available:

Requirements

1. Are manufacturing overhead costs fixed, variable, or mixed? Explain.

2. Graph Berg Industries’ MOH costs against DL hours. Use Excel or graph by hand.

3. Graph Berg Industries’ MOH costs against units produced. Use Excel or graph by hand.

4. Do the data appear to be sound, or do you see any potential data problems? Explain.

5. Use the high-low method to determine Berg Industries’ MOH cost equation using DL hours as the cost driver. Assume that management believes that all data are accurate and wants to include all of it in the analysis.

6. Estimate MOH costs if Berg Industries incurs 24,000 DL hours in January.

Requirements

1. Are manufacturing overhead costs fixed, variable, or mixed? Explain.

2. Graph Berg Industries’ MOH costs against DL hours. Use Excel or graph by hand.

3. Graph Berg Industries’ MOH costs against units produced. Use Excel or graph by hand.

4. Do the data appear to be sound, or do you see any potential data problems? Explain.

5. Use the high-low method to determine Berg Industries’ MOH cost equation using DL hours as the cost driver. Assume that management believes that all data are accurate and wants to include all of it in the analysis.

6. Estimate MOH costs if Berg Industries incurs 24,000 DL hours in January.

## Answer to relevant Questions

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 ...Refer to Cherestal Industries in P6-66B. Requirements 1. Use Excel regression analysis to determine Cherestal Industries’ manufacturing overhead cost equation using DL hours as the cost driver. Comment on the R-square. ...Refer to the Lube-for-Less data in S6-8. Use the high-low method to determine the variable and fixed cost components of Lube-for-Less’s operating costs. Use this information to project the monthly operating costs for a ...Now decide how much you would like to make in before-tax operating income (target profit) in each of the upcoming five years. Calculate how many units you would need to sell in each of the upcoming years to meet these target ...Why is it necessary to calculate a weighted-average contribution margin ratio for a multiproduct company when calculating the break-even point for that company? Why can’t all of the products’ contribution margin ratios ...Post your question

0