File Home Insert Draw Page Layout Formulas Dala Review View Help Liberation Sans 12 ' ' = Wrap Text Custom Paste BIUV h A Merge & Center $ % 0.00 000 Clipboard Font Alignment 19 Number H10 B AB D E F G H | J K 1 Function: SUM; Formula: Subtract, Cell Referencing 2 3 Using Excel To Prepare a Cost of Goods Manufactured Schedule and a 4 Partial Income Statement 5 PROBLEM 6 The following is available for Alkman Company. Comments AutoSum O Fill F Conditional Format as Cell Formatting Table Styles Styles Insert Delete Format Sort & Find & Analyze Clear Filter Select Data Cells Editing Analysis Student Work Area M P R S Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem or work area as indicated. Use the SUM function with cell references to add amounts as indicated. 7 8 January 1, 9 2022 During the December 31. Year 2022 2022 a. 10 Raw materials inventory S 21,000 S 30,000 11 Work in process inventory 13,500 17,200 12 13 14 15 16 17 18 19 Finished goods inventory Materials purchased Direct labor Manufacturing overhead Sales revenue a. Compute cost of goods manufactured. b. Prepare an income statement through gross profit. 27,000 21,000 $ 150,000 220,000 180,000 910,000 20 21 22 Enter Answer Ready Accessibility: Investigate Share + 90%