Objectives: 1. To improve your quantitative literacy skills by completing a problem on job costing with multiple jobs using Excel 2. To improve your understanding of job costing by prorating over/under-applied overhead cost to inventory and completing the related journal entry Davy Systems manufactures automated testing equipment. The company uses a job-order costing system and applies overhead on the basis of machine-hours. At the beginning of the year, estimated manufacturing overhead costs were $3,200,000 and the estimated machine-hours were 80,000. Data regarding several jobs at Davy are presented below. WIP Total Machine Hours anual WIP - January MOA Cost Job Number XJ107 ST211 SD108 SL 205 RX115 Total Beginning Balance 123.000 120,000 20.000 30,000 WIP - January Direct Materials 4,000 3,000 80,000 60,000 20,000 $167,000 WIP - January Direct Labor 8.000 10,000 34.000 30.000 20.000 $102,000 900 1.150 2.000 1.000 1,200 6.250 $293,000 By the end of the first month (January), all jobs but RX-115 were completed, and all completed jobs had been delivered to customers except for SL-205. The balance in Finished Goods inventory at the start of January is $0. At the end of January, the actual manufacturing overhead cost is $150,000. The company prorates over/under- applied overhead cost at the end of each month using the amounts of applied manufacturing overhead cost in work-in-process control, finished goods control, and cost of goods sold as the basis for proration. Required (show your work in Excel): Complete the table above to answer the following questions: Item Answer a. What is the predetermined manufacturing overhead rate? What are the amounts of manufacturing overhead allocated to the five jobs in January? What is the balance in work-in-process inventory (Job RX115) at the end of January after proration? What was the balance in finished goods inventory (Job SL205) at the end of January after proration? What was the balance of cost of goods sold at the end of January after proration? f. Show the compound journal entry to move the over/under-applied manufacturing overhead cost to the three accounts