de BPM A Bryanna Marie Hardy - X AC306 Unit 3 Assignment template - Excel Tell me what you want to do File Home Insert Page Layout Formulas Data Review View UPDATES AVAILABLE Updates for Office are ready to be installed, but fest we need to close some apps Update now MINO 1 Enter titles and accounts in the green cells 2 Enter Numbers in the blue cells 3 Enter your Calculations in the yellow cells 5 Unit 3 Job Order Costing 2. Cost Flows As of the end of October, the job cost sheets at Detroit Scooters, Inc., show the following total costs accumulated on three custom jobs. Job 91B Job 919 Job 920 11 12 13 Direct materials Direct labor Overhead applied 17.500 8.700 5.220 43,250 19,500 11.700 19.500 14200 8.520 Job 918 was started in production in September and the following costs were assigned to it in September: direct materials, 55,600; direct labor, $1,200; and overhead, 5/20. Jobs 919 and 920 were started in October. Overhead cost is applied with a predetermined rate based on direct labor cost. Jobs 918 and 919 were finished in October, and Job 920 is expected to be finished in November. No raw materials were used indirectly in October. Using this information, answer the following questions. The company's predetermined overhead rate was the same for the entire year. 17 Instructions: 1&2. Complete the table below to calculate the cost of the raw materials requisitioned and direct labor cost incurred during October for each of the three jobs? 20 Direct Materials 21 Job September October 229 18 23 91911 Total Problem 1 Problem 2 Problem 3 Problem 4 Ready OO 5- = WA @ AC306 Unit 3 Assignment template - Excel A Bryanna Marie Hardy File Home Insert Page Layout Formulas Data Review View Tell me what you want to do UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps Update now C41 G H I J K 182. Complete the table below to calculate the cost of the raw materials requisitioned and direct labor cost incurred during October for each of the three jobs?! L M Direct Materials September October 21 Job 919 920 de 25 Total 26 27 Direct Labor September October Total 28 Job 29 301 32 Total 3. Using the accumulated costs of the jobs, what predetermined overhead rate is used? Overhead Rate Job Numerator Denominator Overhead Rate 2 Problem 1 Problem 2 Problem 3 Problem 4 + Ready File Home Insert Page Layout Formulas Data Review View Tell me what you want to do i UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps. Update now F35 : x x A B C D E 1 3. Using the accumulated costs of the jobs, what predetermined overhead rate is used? Overhead Rate Job Numerator Denominator Overhead Rate Overhead September October Total 4. How much total cost is transferred to finished goods during June? Cost Direct Direct Labor Applied Overhead Total Cost Transferred Materials Finished Go Job . Problem 1 Problem 2 Problem 3 Problem 4 Ready AC3 Ung s File Home Insert Page Layout Formulas Data Review View Tell me what you want to do Update now UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps. F74 X 53 54 4. How much total cost is transferred to finished goods during June? Direct Materials Direct Labor Applied Overhead Cost Total Cost Transferred to Finished Goods 56 9 18- 57919- 58 9201 Total - . 1 . Problem 1 Problem 2 Problem 3 Problem 4 Ready