habe Editing AT fr Determine Spider's ending inventory and cost of goods sold under the FIFO perpetual basis. B D E 1 Determine Spider's ending inventory and cost of goods sold under the FIFO perpetual basis. (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.) G 4 Cost of goods sold 5 Ending inventory (Most recent cost) ND SOM 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 73 24 26 30 31 2 Short-Term Operating Assets: Inventory D Short-Term Operating Assets: Inventory 2 FIFO, Perpetual Basis 4 Spider Incorporated provided the following information regarding its inventory for the current year. Units 3,500 Sales in Units Unit Cost $50 Total Cost $175.000 D Transaction Beginning inventory 1/1 Purchases March 30 July 15 September 1 Total available for sale Units sold September 1 Ending inventory 5,000 1,000 65 72 325.000 72.000 1 6.100 2 $572.000 9,500 (6,100) 3,400 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 Determine Spider's ending inventory and cost of goods sold under the FIFO perpetual basis