B26 12345678=23 v A Calibri 11 B X fx B D E ab Merge v Curr F G A company that uses job order costing reports the costs incurred below. Overhead is applied at the rate of 60% of direct materials cost. The company has no beginning Work in Process or Finished Goods inventories. Jobs 1 and 3 are not finished by the end of the month, and Job 2 is finished but not sold by month-end Job 1 Direct materials used 8 Direct labor used 9 10 Required: 11 $5,000 $9,000 Job 2 Job 3 $7,000 $1,500 $4,000 $3,000 Overhead rate 60% 1. Prepare job cost sheets that have direct materials, direct labor, and overhead applied for each of the three jobs for the month. 13 (Use cells A2 to G8 from the given information to complete this question.) 14 15 16 17 Direct materials 18 Direct labor 19 Overhead 20 Total 21 JOB COST SHEET Job 1 Job 2 Job 3 $5,000 $7,000 $1,500 9,000 4,000 3,000 10,400 9,400 3,300 $24,400 $20,400 $7,800 22 2. Determine the total dollar amount of Work in Process Inventory at the end of the month. 23 24 (Use cells A2 to G8 from the given information to complete this question.) 25 26 Work in process inventory 27 28 3. Determine the total dollar amount of Finished Goods Inventory at the end of the month. 29 30 (Use cells A2 to G8 from the given information to complete this question.) 31 32 Finished goods inventory 33