# Question: Refer to Cherestal Industries in P6 66B Requirements 1 Use Excel regression analysis

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. Estimate MOH costs if Cherestal Industries incurs 25,500 DL hours in January.

2. Use Excel regression analysis to determine Cherestal’s MOH cost equation using number of units produced as the cost driver. Use all of the data provided. Project total MOH costs if

Cherestal Industries produces 5,200 units. Which cost equation is better—this one or the one from Question 1? Why?

3. Use Excel regression analysis to determine Cherestal 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,200 units are produced.

4. In which cost equation do you have the most confidence? Why?

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. Estimate MOH costs if Cherestal Industries incurs 25,500 DL hours in January.

2. Use Excel regression analysis to determine Cherestal’s MOH cost equation using number of units produced as the cost driver. Use all of the data provided. Project total MOH costs if

Cherestal Industries produces 5,200 units. Which cost equation is better—this one or the one from Question 1? Why?

3. Use Excel regression analysis to determine Cherestal 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,200 units are produced.

4. In which cost equation do you have the most confidence? Why?

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

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 ...Lube-for-Less is a car-care centre specializing in ten-minute oil changes. Lube-for-Less has two service bays, which limits its capacity to 3,600 oil changes per month. The following information was collected over the past ...Calculate how many units of your product you will need to sell to break even in each of the five years you have projected. Describe three ways that cost-volume-profit concepts could be used by a service organization. Use the information from the Northern Cruiseline Data Set. a. Compute the operating leverage factor when Northern Cruiseline sells 12,000 dinner cruises. b. If volume increases by 10%, by what percentage will operating ...Post your question