AutoSave Manufacturing Cost Flows.xlsx File Home Insert Page Layout Formulas Data Review View Developer Help Arial 11 VA A General DI TA Norm X Cut [ Copy Format Painter === DO ab Wrap Text Es - Merge & Center w Paste BI U A $ % ) -.. Conditional Format as Formatting Table Chech Clipboard Font Alignment Number F34 X fc G BI ................. ................. .............. A B D E F 1 Name: lan Gentry 2 Your score: 31% The T-accounts for the lan Gentry Company below summarize its production activity for the year. REQUIRED: Calculate the ending T-account balances for each account, then compute 3 the amount for each of the manufacturing cost flows. Every yellow cell must include a valid 4 formula, even if the result is $0. 5 6 7 Raw Materials Inventory Factory Wages Payable 8 49.000 28.500 132,500 85.500 12.... 9 47,0 10 11 9,100 0 12 13 Work in Process Inventory Factory Overhead 14 28,500 180,000 11.400 111,150 15 85,500 47,000 16 111,150 55,350 17 45,150 2,600 18 19 Finished Goods Inventory 20 180.000 144.000 21 22 23 36.000 24 25 26 Required: Enter a valid formula to compute the amount for each of the following. 27 28 a. Direct materials used 29 b. Indirect materials used 30 C. Direct labor used 31 d. Indirect labor used 32 e. Cost of goods manufactured 33 f. Cost of goods sold (before closing over-or underapplied overhead) 34 g. Actual overhead incurred 35 h. Overhead applied 36 i. The amount of over-or underapplied overhead 37 j. Use dropdown button to indicate whether overhead is over- or underapplied. 38 k. Cost of goods sold (after closing over-or underapplied overhead) 39 40 41 42