E F G H I J K L M N o P AB D Function: SUM; Formula: Subtract, Cell Referencing C Using Excel To Prepare a Cost of Goods Manufactured Schedule and a Partial Income Statement PROBLEM The following is available for Aikman Company. Student Work Area 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. OAN 000 OCAWww a. 10 During the January 1, 2022 Year 2022 $21,000 13,500 27,000 $150,000 220,000 180,000 910,000 December 31, 2022 $30,000 17,200 21,000 Raw materials inventory Work in process inventory 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. b. Aikman Company Income Statement (Partial) For the Year Ended December 31, 2022