# Question: The controller for Beckham Company believes that the number of

The controller for Beckham Company believes that the number of direct labor hours is associated with overhead cost. He collected the following data on the number of direct labor hours and associated factory overhead cost for the months of January through August.

Required:

1. Using a computer spreadsheet program such as Excel, run a regression on these data. Print out your results.

2. Using your results from Requirement 1, write the cost formula for overhead cost.

3. What is R2 based on your results? Do you think that the number of direct labor hours is a good predictor of factory overhead cost?

4. Assuming that expected September direct labor hours are 700, what is expected factory overhead cost using the cost formula in Requirement 2?

Required:

1. Using a computer spreadsheet program such as Excel, run a regression on these data. Print out your results.

2. Using your results from Requirement 1, write the cost formula for overhead cost.

3. What is R2 based on your results? Do you think that the number of direct labor hours is a good predictor of factory overhead cost?

4. Assuming that expected September direct labor hours are 700, what is expected factory overhead cost using the cost formula in Requirement 2?

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

Program Susan Lewis, owner of a florist shop, is interested in predicting the cost of delivering floral arrangements. She collected monthly data on the number of deliveries and the total monthly delivery cost (depreciation ...Time Period from the One Used to Develop a Cost Formula Refer the information for Farnsworth Company above. Required: 1. Prepare a scattergraph based on the 10 months of data. Does the relationship appear to be linear? 2. ...The management of Wheeler Company has decided to develop cost formulas for its major overhead activities. Wheeler uses a highly automated manufacturing process, and power costs are a significant manufacturing cost. Cost ...Explain why contribution margin per unit becomes profit per unit above the break-even point. Suppose that Head-First Company now sells both bicycle helmets and motorcycle helmets. The bicycle helmets are priced at $75 and have variable costs of $45 each. The motorcycle helmets are priced at $220 and have variable ...Post your question