Ken Howard, financial analyst at JVR Corporation, a manufacturer of precision parts, is examining the behaviour of quarterly maintenance costs for budgeting purposes. Ken collects data on machine-hours worked and maintenance costs for the past 26 quarters. The data are as follows:

Required
1. a. Using Excel, do a regression analysis to estimate and plot the quarterly data underlying the cost function: Maintenance costs y = a + bX + e (where X = 100,000 Direct machine-hours).
b. Estimate the cost function for the data represented by the plots in requirement la using the high-low method.
c. How well does each cost function fit the data?
2. a. After considering the accounting cycle, Ken realizes that maintenance costs are not even invoiced to the company until the month following the completion of the work. Work done at the end of March will not be invoiced and paid until April. This delays payment of the cost of maintenance completed in quarter 1 into quarter 2, when the payment is recorded in the maintenance cost pool. Ken then uses Excel to complete an OLS regression to estimate and plot the quarterly data relating machine-hours in a quarter (such as t) to maintenance costs in the following quarter (t + 1). That is, plot machine-hours in quarter 1 against maintenance costs in quarter 2, machine-hours in quarter 2 against maintenance costs in quarter 3, and so on.
b. Estimate the cost function for the data represented by the plots in requirement 2a using the high-low method.
c. How well does each cost function fit the data?

Transcribed Image Text:

0 55.8 84, 2 8063, 1 7 5 7 7 7 3 4 1 3 4 9 93 5300 2 7 1 8 2 6 3 8 0 5 3 8 2 6271-7 2 555-5 33571-2 102㏄1-2 17 2 055555555 19200 091 1234,5 6 7 8 9 0 1 2 3 4 5 6 7 9 0 1 2 3 4 5 6 111-11-11222222