Part 1: Below is the company Information that you will use in completing Part 1. The requirements are listed after this company information and you should provide your solution below each of the requirements. 6. Completed jobs 25 and 27 in January. 7. Customer for Job 25 picked up completed job and was billed the following: Sheds, Inc. designs and builds sheds 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: Job 25 10,000 $500 8. The company had the following period costs that they incurred: $2,000 $1,000 Sales commissions At the beginning of January the company had the following work-in-process inventories: $1,000 $3,000 Administrative salaries Job 21 Job 25 Required: You need to use cell references to complete Part 1 in your response and calculations. Also show written calculations separately for questions 1-10 below (EXCEL format only) During January, the following activities took place: 1. Develop the predetermined overhead rate. 1. Started jobs 26 and 27. 2. Complete the job cost sheets provided below for the month of January: 2. Purchased raw materials in January: $13,000 Job 21 Job 25 Job 26 Job 27 Requisitioned (or used) the following raw materials to the specific jobs: Beginning Balance $4,000 $1,000 $2,000 $3,000 3. Incurred January manufacturing payroll: Job 21 Job 25 Current costs: Job 26 Direct materials Job 27 Direct labor Applied Overhead Direct Labor $700 $2,000 $900 $1,600 Indirect labor $400 Job 21 Total Job 25 Job 26 Job 27 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 determine total cost of ending work in process for January. 4. Incurred additional manufacturing overhead costs for January: $700 $500 4. Determine the Ending Finished Goods for January and provide the Job number(s) in Finished Goods at the Production equipment rent end of January and determine the total cost of ending finished goods for January. Manufacturing supplies purchased and used Factory utilities 5. Determine the Cost of Goods Sold for January and provide the Job number(s) in Cost of Goods Sold for $300 January and determine the total cost of goods sold for January. 5. Applied manufacturing overhead using a predetermined rate based on predicted annual overhead and predicted annual direct material cost as follows: 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. Predicted Annual Overhead $30,000 $150,000 Predicted Annual Direct Material cost 7. Prepare a statement of cost of goods manufactured for January below. Use Manufacturing Overhead applied in your statement. Shed Inc. Statement of Cost of Goods Manufactured For Month ending January 31, 20XX Shed Inc. Cost of material placed in production Raw materials, 1/1/XX Purchases Total available Raw materials, 1/31/XX Direct Labor Manufacturing overhead Applied Work-in-process January 1, 20XX Total costs in process Work-in-process January 31, 20XX Cost of goods manufactured 8. Prepare an Income Statement for January below. The company does not close the over or under applied overhead until the end of the year, so no adjustment is needed to Cost of Goods Sold. Shed Inc. Income Statement For Month ending January 31, 20xx Sales Cost of goods sold Gross Profit Selling and Administrative expenses Net income 9. Determine the under applied or over applied manufacturing for January. 10. Prepare a Column chart below showing the 3 products that were added to the jobs in January