Same Day Delivery wants to determine the cost behavior pattern of maintenance costs for its delivery vehicles. The company has decided to use linear regression to examine the costs. The prior year’s data regarding maintenance hours and costs are as follows:

Required
A. Perform a regression analysis on the above data. What maintenance costs should be budgeted for a month in which 420 maintenance hours will be worked?
B. What is the percentage of the total variance that can be explained by your analysis?
C. Use the high/low method to estimate a cost formula for Same Day. How similar is your high/low solution to the regressionsolution?

Transcribed Image Text:

Maintenance Costs $4,200 3,000 3,600 2,820 4,350 2,960 3,030 4,470 4,260 4,050 3,300 3,160 January February March Hours of Activity 480 320 May June July August September 300 500 310 320 520 490 470 350 340 November December