XYZ Company has been using Units Produced to allocate Maintenance Costs. Cal Q. Lator, the accounting manager, has been noticing wild shifts in the amount of maintenance being charged, so he wants you to look into it Data has been gathered for several possible cost drivers along with total maintenance. Using regression, determine which of units produced, batches processed, machine hours, or direct labor is the best cost driver for maintenance costs. Prepare a memo to Cal to choose the best cost driver and predict what September maintenance costs will be based on the selected cost driver Data Produced Processed Hours DL Hours Costs Sep 13 864 1.737 23400 45.468 38.159 May 14 26,000 43,540 38,955 Dec 14 888 1.612 23.205 43.467 37.237 Feb-15 Jun 15 960 1.785 35.399 83.1622 46.656 30.498 63.007 43488 29,302 70,367 44,454 Estimated Activity XYZ Company has been using Units Produced to allocate Maintenance Costs. Cal Q. Lator, the accounting manager, has been noticing wild shifts in the amount of maintenance being charged, so he wants you to look into it Data has been gathered for several possible cost drivers along with total maintenance. Using regression, determine which of units produced, batches processed, machine hours, or direct labor is the best cost driver for maintenance costs. Prepare a memo to Cal to choose the best cost driver and predict what September maintenance costs will be based on the selected cost driver Data Produced Processed Hours DL Hours Costs Sep 13 864 1.737 23400 45.468 38.159 May 14 26,000 43,540 38,955 Dec 14 888 1.612 23.205 43.467 37.237 Feb-15 Jun 15 960 1.785 35.399 83.1622 46.656 30.498 63.007 43488 29,302 70,367 44,454 Estimated Activity