AutoSave OF AAP 2G ... Chapter Four Exercises - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) v 12 v A A X G 25 Wrap Text General Insert v Y, v v Paste YA = = = Y Merge & Center v $ % ) Delete Format Conditional Format Cell Formatting as Table Styles Sensitivity Sort & Filter v Find & Select Analyze Data V E32 fx A D E F G H I I J K L M N 0 P a R S B Name: : Section: Cells highlighted in green contain a drap-down arrow select information from list. In the cells highlighted in grey, enter the appropiate amount in those cells. When the correct arnaunt is entered, the cell will change color. Rafner Manufacturing identified the following budgeted data in its two production departments. Manufacturing overhead costs Direct labor hours Machine hours Assembly $1,200,000 12,000 DUH 6,000 MH Finishing $600,000 20,000 DU 16,000 MH Required: What are the company's departmental overhead rates if the assembly department assigns overhead based on direct labor hours and the finishing department assigns overhead based on machine hours? per direct labor hour 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 The departmental overhead rate for Assembly Estimated overhead costs Estimated direct labor hours The departmental overhead rate for Finishing Estimated overhead costs Estimated machine hours per machine haur Exercise 4-2 Exercise 4-4 OS 4-2 OS 4-5 QS 4-7 + Ready + 109% 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%