Excel McGraw Hill Excel Questio Saved File Home Insert Draw F32 A Calibri fx Formulas Data Review View Help Editing v 11 v B A *** ab v B 1 2 The following information is available for a custom manufacturer. 4 Inventories 234565 Raw materials, beginning Work in process, beginning Finished goods, beginning $38,000 12,400 8,750 8 Cost of goods manufactured 95,290 Cost of goods sold (not considering 9 over- or underapplied overhead) 83,200 10 Sales 100,000 Predetermined overhead rate based on 11 direct materials used 80% 12 Costs incurred for the period 13 Raw materials purchases $18,460 14 Direct materials used 43,250 15 Direct labor used 22,800 16 Factory overhead (actual) 17 Indirect materials used 9,300 18 Indirect labor used 16,400 19 Other overhead costs 4,300 20 D E 21 Required: 22 1. Complete the T-accounts for each of the three inventory accounts using the data provided in the above table. 23 24 (Use cells A4 to B19, as well as any yellow input cells, to complete this question.) 25 26 20 21 Required: 22 1. Complete the T-accounts for each of the three inventory accounts using the data provided in the above table. 23 24 (Use cells A4 to B19, as well as any yellow input cells, to complete this question.) 25 26 27 Beginning 28 Cost of goods manufactured 29 30 Ending 31 32 33 Beginning 34 35 36 37 Ending 38 39 Raw Materials Inventory 38,000 95,290 Work in Process Inventory Finished Goods Inventory 40 Beginning 41 42 Ending 43 44 2. Compute overapplied or underapplied overhead.. 45 46 (Use cells A4 to B19, as well as any yellow input cells, to complete this question.) 47 =Graded Worksheet Calculation Mode: Automatic Workbook Statistics + B A 35 36 37 Ending 38 39 40 Beginning 41 42 Ending 43 Finished Goods Inventory 44 2. Compute overapplied or underapplied overhead. 45 46 (Use cells A4 to B19, as well as any yellow input cells, to complete this question. 47 48 49 50 51