AutoSave OFF 101 #4 Assignment Home Insert Draw Page Layout Formulas Datal Review View Tell me Calibri (Body) v 11 ' ' Wras Text v Poste B I U v G A v Merge & Center F35 : x fx B D E F G H A 3 1 5 G 7 8 9 10 11 12 13 14 15 16 Kelly O's Sporting Goods reported the following January 2022 transactions with respect to inventory item KO-13, aLAM punch dummy used as a training aid: Units Unit Cost Beginning inventory Jan 1 8 $ 48.50 5-Jan Purchase 20 $ 49.00 7-Jan Sale 18 10-Jan Purchase 17 $ 51.25 15-Jan Sale 7 20-Jan 25-Jan Purchase Sale 6 $ 52.65 12 17 Use the above information to calculate the following: 18 1 Cost of goods available for sale if the perioic system is used 19 2 Ending Inventory Value using FIFO periodic 20 3 Cost of goods sold using FIFO periodic 21 4 Ending Inventory Value using LIFO periodic 22 5 Cost of goods sold using LIFO periodic 23 6 Ending Inventory Value using Average Cost periodic (round unit cost to the penny) 24 7 Cost of goods sold using Average Cost periodic 25 8 Cost of goods available for sale if the perpetual system is used 26 9 Ending Inventory Value using FIFO PERPETUAL 27 10 28 11 29 12 Cost of goods sold using FIFO PERPETUAL Ending Inventory Value using LIFO PERPETUAL Cost of goods sold using LIFO PERPETUAL 30 13 31 Gross Profit the KO-13 units (37) are sold at $70 each and LIFO PERPETUAL is used. 32 33 34 INDICATE THE 35 36 37 14 38 Account debited when merchandise is acquired and the Perpetual Inventory System is used. 39 40 15 41 Account debited when merchandise is acquired and the Periodic Inventory System is used. 42 Problem 8 Problem 9 Problem 10 Problem 11 Ready + Share Comments General v $%9 00 Cell Conditional Format Formatting as Table Styles Insert Delete Format v Sort & Filter Find & Select Analyze Data J K Answers 1 2 3 4 5 6 7 8 9 10 11 12 13 B 5-Jan-22 7-Jan-22 14 10-Jan-22 15 15-Jan-22 M N 0 P a Perpetual Charts Purchases Units U/C T/C Units Sales U/C 100%