AutoSave OF AAP 2G ... ACC 215 - Week One Serial Problem Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments v 12 ~ A Calibri (Body) Insert v X G General 2 Wrap Text v 3X Delete Paste I U AYA = = - Y Merge & Center v $ - % Conditional Format Cell Formatting as Table Styles Sort & Filter Sensitivity - Format v Find & Select Analyze Data V J11 X fy D E F G H When the amount or percentage for the cells) highlighted in gray is correct, the cell Will change to yellow. ) T L M N 4 The computer workstation furniture manufacturing that Santana Rey started in January is progressing well. As of the end of June, Business Solutions's job cost sheets show the following total costs accumulated on three furniture jobs. Job 602 Job 603 Job 604 Direct materials Direct labor Overhead 1,500 800 400 3,300 1,420 7101 2,700 2,100 1,050 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Job 602 was started in production in May, and these costs were assigned to it in May: direct materials, $600; direct labor, $180; and overhead, $90. Jobs 603 and 604 were started in June. Overhead cost is applied with a predetermined rate based on direct labor costs. Jobs 602 and 603 are finished in June, and Job 604 is expected to be finished in July. No raw materials are used indirectly in June. (Assume this company's predetermined overhead rate did not change over these months.) Required: 1. What is the cost of the raw materials used in June for each of the three jobs and in total? 2. How much total direct labor cost is incurred in June? 3. What predetermined overhead rate is used in June? 4. How much cost is transferred to finished goods inventory in June? Job 602 Job 603 Job 604 Total May costs June costs Total 27 28 29 30 31 Job 602 Job 603 Job 604 Total 2 May costs June costs Total 32 33 34 35 3 Predetermined overhead rate 36 Serial Problem + Ready + 131% AutoSave OF AAP 2G ... ACC 215 - Week One Serial Problem Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (body) v 12 v A X G Insert v General 2 Wrap Text Ayu v Delete Paste 7 Y Y = = $ %) Merge & Center v Conditional Format Cell Formatting as Table Styles Y 8 Sort & Filter Format v Find & Select Analyze Data Sensitivity V J11 C E G . J K L M N 18 19 20 21 fx B D Required: 1. What is the cost of the raw materials used in June for each of the three jobs and in total? 2. How much total direct labor cost is incurred in June? 3. What predetermined overhead rate is used in June? 4. How much cost is transferred to finished goods inventory in June? 22 23 Jab 602 Jab 603 Job 604 Total May costs June costs Total 24 25 26 27 28 29 30 31 Jab 602 Jab 603 Job 604 Total May costs June costs Total 32 3 Predetermined overhead rate 33 34 35 36 4 37 Job Raw Materials Direct Labor Overhead Applied Total Cost Cost transferred to finished goods Costs of Ending WIP 38 39 40 41 42 43 44 45 46 602 603 604 Total 47 48 49 50 Serial Problem + + Ready + 131% %
