Sheds, Inc. designs and buildssheds and outbuildings for individual customers. The company uses a job cost system and treats each customer's order as a separate job. At the beginning of January the company had the following raw material inventory - $400 At the beginning of January the company had the following work-in-process inventories: Job 21 - $1,00 Job 24 - 53,000 During January, the following activities took place: Started jobs 26 and 27. Purchased raw materials in January - $10,000 Requisitioned (or used) the following raw materials to the specific jobs: Job 21 - $1,500 Job 24 - $3,000 Job 26 - 52,000 Job 27 - $1,000 Incurred January manufacturing payroll: Direct Labor Job 21 - $800 Job 24 - $2,000 Job 26 - 5900 Job 27 - $1,600 Indirect labor - $500 Incurred additional manufacturing overhead costs for January: Production equipment rent - $600 Manufacturing supplies purchased and used - $500 Factory utilities- $300 Applied manufacturing overhead using a predetermined rate based on predicted annual overhead and predicted annual direct material cost as follows: Predicted Annual Overhead - $25,000 Predicted Annual Direct Material cost - $ 100,000 Completed jobs 21 and 26 in January. Customer for Job 26 picked up completed job and was billed the following: Job 26 - 57,000 The company had the following period costs that they incurred: Sales commissions - $1,000 Administrative salaries - $1,200Required: 1. Develop the predetermined overhead rate. 2. Complete the job cost sheets provided below for the month of January: Job 21 Job 24 Job 26 Job 27 Beginning Balance Current costs direct materials direct labor applied overhead Total 3. Determine the ending Work-In-Process Inventory at the end of January and provide the Job number(s) still in Work-in-Process at the end of January and then determine total cost of ending work in process for January. 4. Determine the Ending Finished Goods for January and provide the Job number(s) in Finished Goods at the end of January and determine the total cost of ending finished goods for January. 5. Determine the Cost of Goods Sold for January and provide the Job number(s) in Cost of Goods Sold for January and determine the total cost of goods sold for January. 6. Determine the ending raw material balance for January, which you will need when preparing the Statement of Cost of Goods Manufacturing for the month ended. 7. Determine the underapplied or overapplied manufacturing overhead for January