# Question: Kenny Wolff the production manager of Gould Construction Components is

Kenny Wolff, the production manager of Gould Construction Components, is trying to figure out the cost behavior of his factory supplies cost. The company uses machine hours as the cost driver. Henry Foote, the assistant manager, collected the following cost data for the last 32 weeks:

Required

a. The company uses the number of machine hours as the cost driver for factory supplies costs. Use an algebraic equation to describe how total factory supplies costs can be estimated.

b. Use a spreadsheet program to perform a regression analysis. Use factory supplies costs as the dependent variable (Y) and the machine hours as the independent variable (X). Determine the total fixed cost per week and variable cost per machine hour.

c. Identify the R2 statistic provided by the Excel program and explain what it means.

d. Identify a potential weakness of regression analysis and explain what can be done to minimize it.

e. Determine the estimated total cost of factory supplies if machine-hour usage amounts to 100 hours for the next week. What portion of the total cost is fixed and what portion isvariable?

Required

a. The company uses the number of machine hours as the cost driver for factory supplies costs. Use an algebraic equation to describe how total factory supplies costs can be estimated.

b. Use a spreadsheet program to perform a regression analysis. Use factory supplies costs as the dependent variable (Y) and the machine hours as the independent variable (X). Determine the total fixed cost per week and variable cost per machine hour.

c. Identify the R2 statistic provided by the Excel program and explain what it means.

d. Identify a potential weakness of regression analysis and explain what can be done to minimize it.

e. Determine the estimated total cost of factory supplies if machine-hour usage amounts to 100 hours for the next week. What portion of the total cost is fixed and what portion isvariable?

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

Merck & Co., Inc., is a global health care company that delivers innovative health solutions through its prescription medicines, vaccines, biologic therapies, animal health, and consumer care products, which it markets ...Agassi Corporation sells products for $90 each that have variable costs of $60 per unit. Agassi’s annual fixed cost is $450,000.RequiredUse the per-unit contribution margin approach to determine the break-even point in ...Toledo Enterprises produces a product with fixed costs of $160,000 and variable cost of $7.50 per unit. The company desires to earn a $80,000 profit and believes it can sell 20,000 units of the product.\Requireda. Based on ...Volodya Company reported the following data regarding the product it sells:Sales price ............ $20Contribution margin ratio ...... 40%Fixed costs ............ $900,000RequiredUse the contribution margin ratio ...Lorenza Corporation manufactures products that have variable costs of $32 per unit. Its fixed cost amounts to $360,000. It sells the products for $80 each.RequiredUse the per-unit contribution margin approach to determine ...Post your question