AutoSave OF AA 2 O... Chapter Four Exercises - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) v 12 X G ~ A Wrap Text General Insert v AY 0 v Delete v Paste B I U :- - Merge & Center Conditional Format Cell Formatting as Table Styles Sort & Filter # Format Find & Select Analyze Data Sensitivity V B33 fx Actual overhead costs A B C D E H J K L M N O P a B S T Call highlighted in grear contain a drop-down arrow, select information from list. In the cells highlighted in grey, enter the appropiate amount in those cells When the correct amount is entered the cell will change color. Textra Plastics produes parts for a variety of small machine manufacturers. Most products go through two operations, molding and trimming, before they are ready for packaging. Fxpected costs and activities for the molding and trimming departments for 2017 are as follows: Direct laber hours Machine hours Overhead costs Molding 26,000 DLH 61,000 MH $365,000 Trimming 24,000 DLH 7,200 MH $295,000 16 17 Data for two special order parts to be manufactured by the company in 2017 follow. Part A27C 9,800 units Part 820 54 500 units Nurnber of units Machine hours Molding Trimming Direct labor hours Molding Trimmine 5,100 MH 2,600 MH 1,020 MH 650 MH 5,500 DLH 700 DEH 2,150 DLH 3,500 DIH Required: 1. Compute the plantwide overhead rate using direct labor hours as the base. 2. Determine the overtread cost assigned to each product line using the plantwide rate computed in requirement 1 1. Artual overhead costs 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 2. Activity Driver Plantwice OH rate Total Overhead Cost Part A27C YAZR Exercise 4-2 Exercise 4.4 QS 4-2 QS 4-5 QS 4-7 + Ready + 100%