Month	Number of photocopies	Hours of maintenance service	Maintenance costs
January	480,000	1,575	28,260
February	408,000	1,515	25,860
March	414,000	1200	17,940
April	384,000	1,485	25,200
May	540,000	1000	18,000
June	510,000	1,455	25,290
July	330,000	945	17,700
August	510,000	1,215	22,080
September	372,000	1,425	24,600
October	492,000	850	19,500
November	360,000	1,050	19,560
December	420,000	950	18,090
Total	5,220,000	14,665	262,080
Average	435,000	1,222	21,840

Assume the number of photocopies and hours of maintenance service as cost drivers of maintenance cost. Use Excel and multiple regression analysis to estimate the behaviour of maintenance costs and enter the value of R-square below: (which i believe to be 0.86 to 2 decimal points)

I am stuck with this part, can someone please give me a step by step?

Calculate the total maintenance cost for the above question at 1,300 hours of maintenance and 420,000 photocopies.

Answer rating: 100% (QA)

Answer To solve this problem well use multiple regression analysis in Excel to estimate the behavior ... View the full answer