Hedgepeth TTHi2e $6 4 Start [Read-Only]- Microsoft Excel Home Insert Page Layout Formulas Data Review View Cut a Copy 12A Wrap General Calibri B 1 .IB' i a-. litf ! Merge & Ce Paste Clipboard Font Alignment Number Prepare Carson's income statement for the current year ended December 31 using the ave B20 AB 1 Inventory and Cost of Goods Sold 2 Apply the average-cost, FIFO, and LIFO methods 4 Carson Print Supplies, Inc., sells laser printers and supplies. The following data is given for the current year Description Units Beginning inventory 100 800 Average Cost Per Unit $8.90 FIFO Cost LIFO Cost Per UnitPer Unit 9.00 7.80 Purchases Sales 600 9.80 Cost per unit 21.50 Sales price per unit 10 12 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the instruction tab you will be marked wrong Requirement arson's income statement for the current year ended December 31 using the average-c a. Check your spelling carefully and do not abbreviate b Ente er all amounts as posi itive values. Do not use a minus sign or parentheses for any values to be subtracted 2 Hedgepeth TTHZe $6 4 Start [Read-Only] Microsoft Excel n Home Insert Page LayoutFormulas Data Review View cut Copy Format Painter Calibri General Paste B 1 .,Jr..! Merge a center. Alignment yal Conde Formatti S. % , Clipboard E11 11. Begin by calculating the average cost per unit to be used in the Average-cost income statement. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the 2 Instruction tab you will be marked wrong.) 4 Average cost per unit 2 Prepare Carson's income statement for the eurrent year ended December 31 using the average-cost, FIFO, and LIFO methods. Include a complete statement heading Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will be marked wrong. Use cell references from prior calculations, if applicable.) Carson Print Supplies, Inc Income Statement Year Ended December 31, Current Year Average-cost 5 12.900 S 12.900 S 12.900 FIFO LIFO Sales Revenue Cost of goods sold 14 7 Net income ENTERANSw