Better Bottles, Incorporated uses a periodic inventory system and has provid The Controller has asked you to prepare a comparison of the Ending Inventory and Cost of Goods Sold totals for 2 three different inventory costing methods: Periodic FIFO, LIFO, and Weighted-Average. 3 4 Description # of Units Cost per Unit Total Cost 5 Beginning Inventory 20 $ 20.00 $ 400.00 6 January 15 Purchase 27 22.00 594.00 7 January 20 Purchase 33 30.00 990.00 8 Goods Available for Sale 80 $ 1,984.00 9 Less: January Sales 36 44 10 Ending Inventory 11 12 Here are some tips for using Excel: 13 14 15 Cell Reference: Basic Math Functions: SUM Function: Allows you to refer to data from another cell in the worksheet. If you entered "B5" into a blank cell, the formula would output the value from cell B5. Allow you to use the basic math symbols to perform mathematical functions. You can use the following keys:+ (plus sign to add), - (minus sign to subtract), * (asterisk sign to multiply), and/ (forward slash to divide). For example, if you entered "=B4+85" in a blank cell, the formula would add the values from those cells and output the result. cell references or ranges. If you entered "-SUM(C4,CS,C6)" into a blank cell, the formula would output the result of adding those three separate cells. Similarly, if you entered "=SUM(C4:C6)", the formula would output the same result of adding those cells.