Repeat parts (1) and (2) of Exercise 61 using least-squares regression (you may use a spreadsheet to

Question:

Repeat parts (1) and (2) of Exercise 6–1 using least-squares regression (you may use a spreadsheet to compute the fixed and variable costs). Comment on the reliability of using occupancy-days as an allocation base.

Custodial Supplies Expense Month Occupancy-Days March 18,000 $2,500 April 12,500 19,250 May 15,000 20,900 June 28,500 28,850 July 24,000 27,100 August 19,000 22,750 September 14,500 20,750