WHAT TO USE.

NEED HELP

ENTER AS EQUATION LIKE ON EXCEL

E Better Bottles, Inc., uses a periodic inventory system and has the following information available: of Units T otal Cost 400.00 20 S $ Description 4 Beginning Inventory 5 Jan. 15 Purchase 6 Jan. 20 Purchase 7 Goods Available for Sale 8 Less: January Sales 9 Ending Inventory Cost per Unit 20.00 22.00 30.00 594.00 990.00 1,984.00 27 2) Calculate both the Ending Inventory and Cost of Goods Sold using Periodic LIFO. LIFO Ending Inventory of Units Cost per Unit Total Cost Description 31 Beginning Inventory 32 Jan. 15 Purchase 44 LIFO Cost of Goods Sold of Units Cost per Unit T otal Cost Description 37 Jan. 20 Purchase 38 Jan. 15 Purchase 41 3) Using Periodic Weighted Average, first calculate the cost per unit using the formula below. - Sheet1 ... 6 READY Attempt(s) - + 100% Hint Show Me ? S.S. HOME % Calibri Inventory costing methods - Excel FORMULAS DATA REVIEW - ex Sign In INSERT PAGE LAYOUT FILE A VIEW Paste B I U- Cells Editing 11 AA - -AAlignment Number Conditional Format as Cell Formatting Table Styles Styles fc =B25-323 Clipboard Font * B24 Weighted Average Cost - Cost of Goods Available for Sale Number of Units Available for Sale per unit Weighted Average Ending Inventory #of Units Cost per Unit Total Cost Weighted Average Cost of Goods Sold # of Units Cost per Unit T otal Cost 1) Use the given information and your calculated numbers to complete the cost of Goods Sold 57 Equation below for all three inventory methods. (All numbers should be positive.) FIFO LIFO Wtd. Avg. 59 Beginning Inventory 60 Add: Purchases 61 Boods Available for Sale I 62 .ess: Ending Inventory 63 Post of Goods Sold ... Sheet1 ... + @ -- READY Attempt(s) + 100% Show Me 0/3 Hint