Question: P3.37 (appendix) Multiple regression analysis: service firm LO 3.11 CopyFast operates a chain of photocopy centres near several major tuiiversities . The firm's accountant is

P3.37 (appendix) Multiple regression analysis:
P3.37 (appendix) Multiple regression analysis: service firm LO 3.11 CopyFast operates a chain of photocopy centres near several major tuiiversities . The firm's accountant is accumulating data to be used in preparing its annual budget for the coming year. The cost behaviour pattern of the firm's equipment maintenance costs must be determined. Data regarding number of photocopies , maintenance hours and costs for last year are as follows: Month January February March April May June July August September October November D ecember Total Average Required: Number of photocopies 480 000 408 000 414 000 384 000 540 000 510 000 330 000 510I 000 372 000 492 000 360 000 420 000 5 220 000 435 000 Hours of maintenance service 1 575 1 515 930 1 485 945 1 455 945 1 215 1 425 1 035 1 050 1 005 14 580 1 215 1. Use Excel and multiple regression analysis to estimate the behaviour of CopyFast's maintenance costs. 2. Calculate R42 and interpret this statistic. 3. Calculate the total variable cost and the fixed cost per maintenance hour at 1 300 hours of maintenance and 420 000 photocopies . Explain the problems that might occur when using fixed cost per hour in decisions

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!