Smeyer Industries is a large firm with more than 40 departments, each employing 35 to 100 persons. Recent experience suggests that the cost function used to estimate overhead in Department IP-14 is no longer appropriate. The current function was developed three years ago. Since then, a number of changes occurred in the facilities and processes used in Department IP-14. The changes happened one at a time. Each time a change was made, the cost accountant felt the change was not major enough to justify calculating a new overhead cost function. Now it is clear that the cumulative effect of the changes has been large. You have been assigned the task to develop a new cost function for overhead in Department IP14. Initial analysis suggests that the number of direct labor hours is an appropriate cost driver. Departmental records are available for nine months. The records reveal the following information Actual Direct Labor Month Overhead Hours $68,200 March 8,812 April May 71,250 8,538 68,150 8,740 73,500 9,176 June July August September 38,310 2,123 9,218 8,943 70,790 80,350 October 68,750 8,821 November 68,200 8,794 An assistant has analyzed the data for March through July and made the appropriate adjustments except for the following items (for which the assistant was unsure of the proper treatment). 1. The semiannual property tax bill for Department IP-14 was paid on June 30. The entire amount, $3,000 was charged to overhead for June. 2. The costs to install a new piece of equipment with a life of 10 years in the department were charged to overhead in April. The installation costs were $4,300. 3. Factory depreciation is allocated to Department IP-14 every month. The department's share, $8,000, is included in overhead. 4. A strike closed the plant for three weeks in July. Several nonunion employees were kept on payroll during the strike. Their duties were general housekeeping and "busy work." These costs were charged to overhead. You also have the details for the overhead account for the months of August and September. They are presented in the following table. You were hired on October 1 and have been keeping the department accounts since then. Therefore, you know that the data for October and November are correct, except for any adjustments needed for the preceding items Department IP-14 Overhead Control August Explanation Miscellaneous supplies Payroll for indirect labor Power costs: Department IP-14 Payroll for indirect labor Overtime premium Factory depreciation Miscellaneous supplies Total for August Date Amount Aug. 4 Aug. 5 Aug. 15 Aug. 19 Aug. 19 Aug. 24 Aug. 26 $10,450 5,500 12,250 6,000 890 8,000 27,700 $70,790 Department IP-14 Overhead Control September Explanation Payroll for indirect labor Miscellaneous supplies Power costs: Department IP-14 Power costs: Department IB-4 Payroll for indirect labor Overtime premium Miscellaneous supplies Factory depreciation Payroll for indirect labor Date Amount Sept. 2 Sept. 7 Sept. 15 Sept. 15 Sept. 16 Sept. 16 Sept. 21 Sept. 28 Sept. 30 6,000 12,100 11,100 10,850 6,500 950 19,350 8,000 5,500 Total for September $80,350 August has 31 days and September has 30 days REQUIRED A. Using the information provided, adjust the monthly cost data to more accurately reflect the overhead costs incurred during each month. B. Discuss whether the data for July should be included in the estimate of future costs. Use a scatter plot to help you answer this question. C. Develop a cost function by regressing overhead costs in Department IP-14 on direct labor hours. Discuss whether your cost function would be reasonable for estimating future overhead costs. Ignore any items you will discuss in part (D) D. Identify and discuss any additional adjustments that might be needed to more accurately measure overhead costs for the regression in part (C) E. Explain why adjustments probably need to be made to information from accounting records when estimating a cost function. Smeyer Industries is a large firm with more than 40 departments, each employing 35 to 100 persons. Recent experience suggests that the cost function used to estimate overhead in Department IP-14 is no longer appropriate. The current function was developed three years ago. Since then, a number of changes occurred in the facilities and processes used in Department IP-14. The changes happened one at a time. Each time a change was made, the cost accountant felt the change was not major enough to justify calculating a new overhead cost function. Now it is clear that the cumulative effect of the changes has been large. You have been assigned the task to develop a new cost function for overhead in Department IP14. Initial analysis suggests that the number of direct labor hours is an appropriate cost driver. Departmental records are available for nine months. The records reveal the following information Actual Direct Labor Month Overhead Hours $68,200 March 8,812 April May 71,250 8,538 68,150 8,740 73,500 9,176 June July August September 38,310 2,123 9,218 8,943 70,790 80,350 October 68,750 8,821 November 68,200 8,794 An assistant has analyzed the data for March through July and made the appropriate adjustments except for the following items (for which the assistant was unsure of the proper treatment). 1. The semiannual property tax bill for Department IP-14 was paid on June 30. The entire amount, $3,000 was charged to overhead for June. 2. The costs to install a new piece of equipment with a life of 10 years in the department were charged to overhead in April. The installation costs were $4,300. 3. Factory depreciation is allocated to Department IP-14 every month. The department's share, $8,000, is included in overhead. 4. A strike closed the plant for three weeks in July. Several nonunion employees were kept on payroll during the strike. Their duties were general housekeeping and "busy work." These costs were charged to overhead. You also have the details for the overhead account for the months of August and September. They are presented in the following table. You were hired on October 1 and have been keeping the department accounts since then. Therefore, you know that the data for October and November are correct, except for any adjustments needed for the preceding items Department IP-14 Overhead Control August Explanation Miscellaneous supplies Payroll for indirect labor Power costs: Department IP-14 Payroll for indirect labor Overtime premium Factory depreciation Miscellaneous supplies Total for August Date Amount Aug. 4 Aug. 5 Aug. 15 Aug. 19 Aug. 19 Aug. 24 Aug. 26 $10,450 5,500 12,250 6,000 890 8,000 27,700 $70,790 Department IP-14 Overhead Control September Explanation Payroll for indirect labor Miscellaneous supplies Power costs: Department IP-14 Power costs: Department IB-4 Payroll for indirect labor Overtime premium Miscellaneous supplies Factory depreciation Payroll for indirect labor Date Amount Sept. 2 Sept. 7 Sept. 15 Sept. 15 Sept. 16 Sept. 16 Sept. 21 Sept. 28 Sept. 30 6,000 12,100 11,100 10,850 6,500 950 19,350 8,000 5,500 Total for September $80,350 August has 31 days and September has 30 days REQUIRED A. Using the information provided, adjust the monthly cost data to more accurately reflect the overhead costs incurred during each month. B. Discuss whether the data for July should be included in the estimate of future costs. Use a scatter plot to help you answer this question. C. Develop a cost function by regressing overhead costs in Department IP-14 on direct labor hours. Discuss whether your cost function would be reasonable for estimating future overhead costs. Ignore any items you will discuss in part (D) D. Identify and discuss any additional adjustments that might be needed to more accurately measure overhead costs for the regression in part (C) E. Explain why adjustments probably need to be made to information from accounting records when estimating a cost function