Required:

1. Prepare answers to all 7 questions in the problem.
2. Use Excel to replicate the regression results for both regression 1 and regression 2.
3. Use Excel to calculate a multiple regression to estimate restated engineering support costs based on "machine hours" and "materials and parts: restated costs". Machine hours should be independent variable 1 and materials/parts should be independent variable 2.
4. Evaluate whether the multiple regression you calculated in requirement 3 is a better estimator of "engineering support costs: restated costs" than either regression 1 or regression 2 in the problem.
   Collaborative Learning Problem
   10-42. High-low method, alternative regression functions, accrual accounting adjustments, ethics . Trevor Kennedy, the cost analyst at a can manufacturing plant of United Packaging, is examining the relationship between total engineering support costs reported in the plant records and machine-hours. These costs have two components: (1) labor, which is paid monthly, and (2) materials and parts, which are purchased from an outside vendor every three months. After further discussion with the operating manager, Kennedy discovers that the materials and parts numbers reported in the monthly records are on an "as purchased" or cash accounting basis and not on an "as used" or accrual accounting basis. By examining materials and parts usage records, Kennedy is able to restate the materials and parts costs to an "as used" basis. (No restatement of the labor costs was necessary.) The reported and restated costs are as follows:

   Month	Labor: Reported Costs	Materials and Parts: Reported Costs (2)	Materials and Parts: Restated Costs (3)	Total Engineering Support: Reported Costs (4) = (1) + (2)	Total Engineering Support: Restated Costs (5) = (1)+(3)	Machine- Hours (6)
   March	347	847	182	1,194	529	30
   April	521	0	411	521	932	63
   May	398	0	268	398	666	49
   June	355	961	228	1,316	583	38
   July	473	0	348	473	821	57
   August	617	0	349	617	966	73
   September	245	821	125	1,066	370	19
   October	487	0	364	487	851	53
   November	431	0	290	431	721	42

   
   The regression results for total engineering support reported costs as the dependent variable are:
   Regression 1: Engineering support reported costs = a + (b x Machine-hours)

   Variable	Coefficient	Standard Error	t-Value
   Constant	1,393.20	305.68	4.56
   Independent variable 1: Machine-hours r 2 = 0.43; Durbin-Watson statistic = 2.26	-14.23	6.15	-2.31

   
   The regression results for total engineering support restated costs as the dependent variable are:
   Regression 2: Engineering support restated costs = a + (b x Machine-hours)

   Variable	Coefficient	Standard Error	t-Value
   Constant	176.38	53.99	3.27
   Independent variable 1: Machine-hours r 2 = 0.94; Durbin-Watson statistic = 1.31	11.44	1.08	10.59

   1. Plot the cost functions relating (i) the reported costs for total engineering support to machine-hours required and (ii) the restated costs for total engineering support to machine-hours. Comment on the plots.

2. Use the high-low method to compute estimates of the cost functions y = a + bX for (a) reported engineering support costs and machine-hours and (b) restated engineering support costs and machine-hours.

3. Contrast and evaluate the cost function estimated with regression analysis using restated data for materials and parts with the cost function estimated with regression analysis using the data reported in the plant records. Use the comparison format employed in Exhibit 10-18 (p. 369).

4. Of all the cost functions estimated in requirements 2 and 3, which one would you choose to best represent the relationship between engineering support costs and machine-hours? Explain briefly.

5. What problems might Kennedy encounter when restating the materials and parts costs recorded to an "as used" or accrual accounting basis?

6. Why is it important for Kennedy to choose the correct cost function? That is, illustrate two potential problems Kennedy could encounter by choosing a cost function other than the one you chose in requirement 4.

7. John Mason, the plant manager, is not pleased when he sees the restated numbers. He tells Kennedy, "I think the restated engineering support costs are too high. Please recheck your numbers. They ought to be lower." Kennedy is aware that lower costs will result in a higher bonus for Mason. He is also certain that his numbers are correct. What should Kennedy do?

Price: $13.23

Solution: The downloadable solution consists of 5 pages, 823 words and 1 charts.
Deliverable: Word Document