Complete the inventory costing schedules documenting details in the calculation of ending inventory and cost of goods sold for each of the THREE costing methods.

Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO and Weighted Average Cost methods. Make use of Excel/Sheets capabilities by using as many formulas and functions as possible. BBC2, Inc. uses a periodic inventory system and has the following information available: REQ. A MASTER INVENTORY RECORD Description (Shelves) # of Units Cost per unit Total cost Beginning inventory Jan 15 purchase 20 $ 20.00 25 $ 25.00 35 $ 33.00 Jan 20 purchase Total Inventory January Sales Ending Inventory 42 answer will be on each schedule below REOB INVENTORY COSTING SCHEDULES Link or reference back to the description, units and cost on the master reco Calculate the Ending Inventory and cost of Goods Sold using Periodic FIFO FIFO Ending Inventory # of Units Cost per unit Total cost Description Jan 15 purchase Jan 20 purchase Total FIFO Cost of Goods Sold # of Units Cost per unit Description Total cost Calculate the Ending Inventory and Cost of Goods Sold using Periodic LIFO LIFO Ending Inventory # of Units Cost per unit Description Total cost LIFO Cost of Goods Sold # of Units Cost per unit Description Total cost Calculate the Ending Inventory and cost of Goods Sold using Periodic LIFO Description LIFO Ending Inventory # of Units Cost per unit Total cost LIFO Cost of Goods Sold # of Units Cost per unit Description Total cost Calculate the Ending Inventory and cost of Goods Sold using Periodic Weighted Average WEIGHTED AVERAGE Ending Inventory WEIGHTED AVERAGE Cost of Goods Sold + Sheet1