Appendix 3A) Jenson Manufacturing is developing cost formula for future planning and cost control. Utilities is one of the mixed costs associated with production. The cost analyst has suggested that units produced be used as the activity base to determine the fixed and variable costs and the cost formula for utility costs. The controller feels the most appropriate cost base is direct labour hours. Below is information collected over the past 8 months: MonthUnits ProducedDirect Labour HoursUtilities Cost 11,100500$7,200 29003006,500 31,3004007,100 41,5006007,500 51,7201,00010,800 61,70090010,000 71,7008009,200 81,6701,10012,000

Required:

Use the least squares regression method to determine the cost formula for utilities cost assuming units produced is the independent variable. Calculate the R-squared. Use the same method to determine the cost formula and R-squared assuming direct labour hours is the independent variable. Use a spreadsheet or calculator to determine the slope and intercept. Do you recommend the company use units produced or direct labour hours as a cost base? Explain.