Please help answer the four questions below:

7-33. Calculating activity cost Pool Rates

Handy Fabricators is exploring adoption of an activity-based costing system. In a first step towards implementation the company identified four cost pools - fabricating, assembly, quality control, and paten development. Employees classified as indirect labor were asked to estimate the percentage of their time spent on activities in each of the four pools. If they spent time on activities outside of these pools, that time was identified as organization sustaining and assigned to a fifth pool. You have been asked to calculate the total costs in each pool and to calculate an activity rate using the following activity cost drivers.

Activity Cost PoolActivity DriverAnnual Activity Driver VolumeFabricatingMachine hours500,000 machine hoursAssemblyDirect labor hours275,000 direct labor hoursQuality ControlBatches48,000 batchesPatent DevelopmentNumber of patents200 patents

Required:

• 1. Calculate the total indirect labor cost included in each of the five pools - fabricating, assembly, quality control, paten development, and organization sustaining.
  2. Using the activity drivers identified above, calculate the indirect labor activity rate for each activity cost pool. Round your answers to two decimal places.
  3. Manufacturing details for one of Handy's products is presented below. Using the activity rates you developed in part B, calculate the total indirect labor cost and indirect labor cost per unit incurred to produce the product.

Activity Driver Usage8,000 machine hours12,000 direct labor hours300 batches2 patents2,000 units produced

4. The production manager has suggested that the manufacturing processes would run more smoothly if several small batches could be combined into one larger batch. He believes that with careful production planning the number of batched could be reduced to 40,000 per year. What effect will this have on the activity rate for the quality control activity cost pool?

EmployeeSalaryFabricatingFinishingQuality ControlPatent DevelopmentOrganization sustaining1004$ 65,8003%43%25%29%0%1006$ 88,30051%27%4%18%0%1023$ 54,50037%20%4%39%0%1025$ 77,50037%33%23%7%0%1036$ 67,00039%16%43%2%0%1037$ 70,50091%0%2%7%0%1045$ 67,70040%37%23%0%0%1056$ 70,9002%23%18%57%0%1086$ 76,70055%22%19%4%0%1091$ 55,20059%19%12%10%0%1133$ 46,60067%32%0%1%0%1135$ 98,60014%29%26%7%24%1145$ 79,80015%0%5%11%69%1151$ 40,6000%4%27%1%68%1155$ 60,5004%17%64%15%0%1158$ 49,20025%42%25%5%3%1172$ 90,3008%39%15%14%24%1204$ 56,50035%9%49%7%0%1210$ 43,10016%2%72%10%0%1216$ 40,4006%0%2%1%91%1222$ 97,7000%64%24%12%0%1224$ 44,2002%18%0%4%76%1228$ 68,50029%8%24%7%32%1230$ 73,8006%10%28%56%0%1235$ 66,60056%43%0%1%0%1250$ 97,10044%22%26%8%0%1259$ 94,90019%24%20%37%0%1260$ 59,20016%36%37%11%0%1278$ 78,20025%29%28%18%0%1282$ 43,10015%43%30%12%0%1284$ 45,6002%72%18%8%0%1291$ 99,30012%63%19%6%0%1315$ 53,3002%71%18%9%0%1325$ 57,60023%30%35%12%0%1339$ 87,60033%10%38%19%0%1342$ 99,30063%3%15%19%0%1354$ 50,00031%19%15%2%33%1381$ 85,30034%25%4%17%20%1387$ 70,1000%18%10%0%72%1397$ 72,50027%27%6%8%32%