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?

Sales1
Views223