I am looking for assistance on questions 1-8. Please provide formulas or use cell referencing so that I can build it out within excel correctly.
0 Q R W Z AA AB AC AD AE AF AG AH At the beginning of September the company had the following jobs in work-in-process inventories: 1. Develop the predetermined overhead rate. Job 1 $19,000 Job 2 15,000 2. Complete the job cost sheets provided below: Job 3 16,000 Total $50,000 Job 1 Job 2 Job 3 Job 4 Job 5 Job 6 Job 7 Beginning Balance During September, the following activities took place: Current costs: . Started jobs 4, 5,6, and 7. 2. Ordered and received the following raw materials for specified jobs Direct materials Direct Labor Motors Chassis Wheels Total Applied overhead Job 2 0 $700 $700 Total Job 3 0 0 1, 100 1, 100 Job 4 1,500 2,000 1,600 5.100 Job 5 1,000 4.000 3. Determine the ending Work-In-Process Inventory at the end of September and provide the number of the Jobs still in Work-in-Process at the end of September. 1.000 6.000 Job 6 8,000 3,500 900 2,400 4. Determine the Cost of Goods Sold for September and provide the number of the Jobs in Cost of Goods Sold for September. Job 7 7,500 3,800 11,300 Total $36,600 5. Prepare a statement of cost of goods manufactured for September below. Use Manufacturing Overhead applied in your statement. 3. Incurred September manufacturing payroll: Grass Mower Company Direct Labor Statement of Cost of Goods Manufactured Job 1 $500 For Month ending September 30, 2019 ob 2 3,100 Current manufacturing costs: Job 3 3,000 Cost of material placed in production Job 4 4,000 Direct Labor Job 5 1,500 Manufacturing overhead Applied Job 6 2,500 Work-in-process September 1, 2019 Job 7 2,000 Total costs in process Total Direct Labor 16,600 Work-in-process September 30, 2019 Cost of goods manufactured Indirect Labor 4,000 6. Prepare an Income Statement for September below. The company does not close the over or underapplied overhead until the end of the year, so no adjustment is needed to Cost of Goods Sold. 4. Incurred additional manufacturing overhead costs for September: Grass Mower Company Manufacturing supplies purchased and used 2,000 Depreciation on factory fixed assets 6,000 Income Statement For Month ending September 30, 2019 Factory utilities 4,900 Sales 5. Applied manufacturing overhead using a predetermined rate based on predicted annual overhead Cost of goods sold and predicted annual direct labor cost as follows Gross Profit Predicted Annual Overhead $185,250 Predicted Annual Direct Labor cost $195,000 Selling and Administrative expenses Net income 6. Completed and shipped jobs 1 and 6. The following is what was charged to these customers: Job 1 28,000 7. Determine the underapplied or overapplied manufacturing for September. Job 6 26,000 Total 54,000 8. Prepare a pie chart below showing the balance of the jobs that are in work-in-process at the end of September. 7. Selling and Administrative costs incurred in September are the following: $3,900 Required: You need to use cell references to provide answers and calculations
