Activity rates and product costs using activity-based cost Idris Inc. manufactures entry and dining room lighting fixtures. Five activities are used in manufacturing the fixtures. These activities and their associated budgeted activity costs and activity bases are as felews Budgeted Activity Casting Assembly Activity Cost Activity Base . $319,900 Machine hours 145,880 Direct labor hours Inspecting 19,470 Number of inspections Setup Materials handing 40,200 42,510 Number of setups Number of loads Corporate reconds were obtained to estimate the amount of activity to be used by the two products. The estimated activity-base usage quantities and units produced follow Activity Base Entry Dining Total Machine hour 4,840 4,300 9,140 Direct labor hours i 4,170 10,420 Number of inspections 1,350 420 1,770 Number of setups 240 60 300 Number of loads Units produced 660 9.600 230 4,000 1,090 14,400 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below Open spreadsheet a. Determine the activity rate for each activity. If required, round the rate to the nearest dollar. Check My Work Previous Open spreadsheet a. Determine the activity rate for each activity. If required, round the rate to the nearest dollar. Activity Casting Assembly Inspecting Setup Materials handling Activity Rate 31 X per machine hour 17X per direct labor hour 14 X per inspection per setup per load . Use the activity rates in (a) to determine the total and per-unit activity costs associated with each product. Round the per unit amounts to the nearest cent Total Activity Cost Activity Cost Per Unit Product Entry Lighting Fixtures Dining Room Lighting Fixtures F ChMy Work a. Budgeted Activity Cost Total Activity-Base Usage Activity Rate for each activity b. Calculate for each product Activity-Base Usage x Activity Rate from Rea (a) Activity cost for each activity. Sum all activity costs to obtain the total cost per product. Divide total costs by number of units to obtain activity cost per unit Previous 18-5, EX 18-11 BBook Multiple production department factory overhead rate method Spielman Leather Inc., produces three sizes of sports gloves: small, medium, and large. A glove pattern is first stencied onto leather in the Pattern Department. The stenciled patterns are then sent to the Cut and Sew Department, where the glove is cut and sewed together Spielman Leather uses the multiple production department factory overhead rate method of allocating factory everhead costs. Its factory overhead costs were budgeted as follows: Pattern Department overhead Cut and Sew Department overhead Tetal $145,200 246,400 $391,600 The direct labor estimated for each production department was as follows Pattern Department Cut and Sew Department Total 2.200 direct labor hours 2,000 5,000 direct labor hours Direct labor hours are used to allocate the production department overhead to the products. The direct labor hours per unit for each product for each production department were obtained from the engineering records as follows Production Departments Small Glove Medium Glove Large Glove Pattern Department 0.05 0.06 0.07 Cut and Sew Department 0.08 0.10 0.12 Direct labor hours per unit 0.13 0.16 0.19 This information has been culected in the Microsoft Excel Online fie. Open the spreadsheet, perform the required analysis, and input your answers in the question below Open spreadsheet If required, round all per unit answers to the nearest cent. a. Determine the two production department factory overhead rates Check My Work Next mentradi e Direct labor hours are used to allocate the production department overhead to the products. The direct labor hours per unit for each product for each production department were obtained from the engineering records as follows Production Departments Small Glove Medium Glove Large Glove Pattern Department Cut and Sew Department Direct labor hours per unit 0.05 01.06 0.07 0.00 013 0.10 0.18 0.12 0.19 This information has been colected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below Open spreadsheet If required, round all per unit answers to the nearest cent a. Determine the twe pisaction department factory overhead Pattern department Cut and Sew department X per d b. Use the twe production department factory overhead rates to determine the factory overhead per unit for each product Small glove Medum glove Large glove 485 X per unit 6.70 X per unit a. Calculate production department factory overhead rate for each department Total Factory Overhead Direct Labor Hours Production Department Factory Overhead Rate Check My Work Assignment Seon 2.0% Nest Save and Submit for Grading