# Question: Refer to Berg Industries in P6 61A Requirements 1 Use Excel regression analysis

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?

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?

**View Solution:**## Answer to relevant Questions

Kelsey’s Ice Cream Shoppe sold 9,000 servings of ice cream during June for $3 per serving. Kelsey purchases the ice cream in large tubs from the BlueBell Ice Cream Company. Each tub costs Kelsey $15 and has enough ice ...Mary’s Ice Cream Shoppe sold 9,100 servings of ice cream during June for $4 per serving. Mary purchases the ice cream in large tubs from the Organic Ice Cream Company. Each tub costs Mary $14 and has enough ice cream to ...Describe your product. What market are you targeting this product for? What price will you sell your product for? Make projections of your sales in units over each of the upcoming five years. How realistic is your potential venture? Do you think you would be able to break even in each of the projected five years? How risky is your venture (use the margin of safety to help answer this question). Do you think your ...Is the contribution margin ratio of a grocery store likely to be higher or lower than that of a plastics manufacturer? Explain the difference in cost structure between a grocery store and a plastics manufacturer. How does ...Post your question