In class lab chapter 6 part 1 - Excel Tell me what you want to do File Sign in Share Good Bad : Autosum. 47 A Home Insert Page Layout Formulas Data Review View ACROBAI X Cut Calib - 11 - SPA Wrap Text E E Copy - Formal Painter BIU---A === Merge r Center Clipboard fon Alignment Paste - General Normal $ -% Conditional format as Neutral Formatting Table Number Calculation Check Cell Insert Delete commal Clear Surl & Find & Filter Select Styles 111 f J K L M N 0 P R S B D E F G H 1 In Class Lab - Chapter 6 2 3 The following is inventory information for Spartan Co. 4 5 Dale Vol Units Cost/unit Total Cost Beginning 6 1-Mar Inventory 100 $ 3.00 7 7 Mar 50 $ 4.000 $ 200 8 10-Mar 100 $ 5.00 $ 500 9 18-Ma 100 S 6.00 $ 600 10 20-Mar 50 $ 7.00 $ 350 400 $ 1,650 12 13 Spartan Co. sells 225 of the units 14 15 Question 1: What is the cost of ending inventory using the LIFO method of inventory valuation? 16 17 ANSWER: 18 19 20 22 Questiuri 2: What is the cost of ending inventory using the FIFO method of inventory valuation? 23 24 ANSWER: 25 26 27 28 30 Sheet1 + Featy 100% 3 9 W X! 101:46 AM 2/25/2021