com/ed/map/index.html?con=contexternal browser=0&launchUid=http%253A%252F%252Fm.mheducation.com%252Fmaglumickiew it Excel Sims Sowed Help Sa 1 Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO and Weighted Average Cost method 7 5 X H. LE HOME X Inventory costing methods - Excel FORMULAS DATA REVIEW INSERT PAGE LAYOUT VIEW BIU. - 96 A Alignment Number Conditional Formats Cell Cells rating Formatting Table Styles She Metter Bottles, Inc., uses a periodic inventory system and as the following Fort A1 B Better Bottles, Inc., uses periodicnventory system and has the following information table 2 1 Description cout per un Total Cost + Beginning triventory 2015 0.00 20.00 San. 15 Purchase 22 2200 550.00 6 20 Purchase 33 30.00 900.00 Gods for Sale BO 1 DO Endantry 10 o E 8 P R. acation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fms.me a Credit Excel Sims i Savod 11 12 Required: 13. 1) Calculate both the Ending Inventory and Cost of Goods Sold using Periodic FIFO. 14 15 16 Description of Units 17 Jan. 20 Purchase 18 Jan. 15 Purchase 19 44 20 21 FIFO Cost of Goods Sold 22 Description I of Units Cost per Unit Total Cost 23 Beginning Inventory 24 Jan. 15 Purchase 25 36 26 27 2) Calculate both the Ending Inventory and cost of Goods Sold using Periodic LIFO. 28 29 LIFO Ending Inventory 30 Description of Units Cost per Unit Total Cost 51 Beginning Inventory 32 Jan. 15 Purchase 33 14 3 Sheet READY EE Prev 1 of 1 Score answer arch X Question 1 - MO3 Ch 05 Extra Ch x C Game 10-12 restament Notex google cale Google San X ation.com/ext/map/index.html?_con=con external browser=0&launchUrl=http%253A%252F%252Films.meducation.com Credit Excel Sims Saved 44 35 30 31 Beginning Inventory 32 lan. 15 Purchase 33 34 LIFO Cont of Goods Sold Description of Units Cost per Unit Total Cost 37 Jan. 20 Purchase 38 Jan. 15 Purchase 39 36 40 41 3) Using Periodic Weighted Average, first calculate the cost per unit using the formula below. 42 Next, apply that same cost per unit to calculate both the Ending Inventory and cost of Goods Sold. 36 Weighted Average Cost Cost of Goods Available for Sale Number of Units Available for Sale perum 45 45 47 45 49 50 52 Welighted Average Ending inventory #of Units Cost per Unit Total Cost Sheet READY Prov 1 of 1 Score answer > o arch =https%253A%252F%252Fims.meducation.com edit Excel Sims * Weighted Average Cost = Cost of Goods Available for Sale Number of Units Available for Sale per unit Weighted Average cost of Goods Sold It of Unit Cost per Unit Total Cost 4) Use the given information and your calculated numbers to complete the cost of Goods Sold Equation below for all three inventory methods. (All numbers should be positive.) FITO LIFO wid. Avg Beginning Inventory Add: Purchases 1 Goods Available for Sale 2. Less: Ending Inventory Cost of Goods Sold 14 5 56 Sheet1 REAL Prey 1 of Score answer > o . com/ed/map/index.html?con=contexternal browser=0&launchUid=http%253A%252F%252Fm.mheducation.com%252Fmaglumickiew it Excel Sims Sowed Help Sa 1 Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO and Weighted Average Cost method 7 5 X H. LE HOME X Inventory costing methods - Excel FORMULAS DATA REVIEW INSERT PAGE LAYOUT VIEW BIU. - 96 A Alignment Number Conditional Formats Cell Cells rating Formatting Table Styles She Metter Bottles, Inc., uses a periodic inventory system and as the following Fort A1 B Better Bottles, Inc., uses periodicnventory system and has the following information table 2 1 Description cout per un Total Cost + Beginning triventory 2015 0.00 20.00 San. 15 Purchase 22 2200 550.00 6 20 Purchase 33 30.00 900.00 Gods for Sale BO 1 DO Endantry 10 o E 8 P R. acation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Fms.me a Credit Excel Sims i Savod 11 12 Required: 13. 1) Calculate both the Ending Inventory and Cost of Goods Sold using Periodic FIFO. 14 15 16 Description of Units 17 Jan. 20 Purchase 18 Jan. 15 Purchase 19 44 20 21 FIFO Cost of Goods Sold 22 Description I of Units Cost per Unit Total Cost 23 Beginning Inventory 24 Jan. 15 Purchase 25 36 26 27 2) Calculate both the Ending Inventory and cost of Goods Sold using Periodic LIFO. 28 29 LIFO Ending Inventory 30 Description of Units Cost per Unit Total Cost 51 Beginning Inventory 32 Jan. 15 Purchase 33 14 3 Sheet READY EE Prev 1 of 1 Score answer arch X Question 1 - MO3 Ch 05 Extra Ch x C Game 10-12 restament Notex google cale Google San X ation.com/ext/map/index.html?_con=con external browser=0&launchUrl=http%253A%252F%252Films.meducation.com Credit Excel Sims Saved 44 35 30 31 Beginning Inventory 32 lan. 15 Purchase 33 34 LIFO Cont of Goods Sold Description of Units Cost per Unit Total Cost 37 Jan. 20 Purchase 38 Jan. 15 Purchase 39 36 40 41 3) Using Periodic Weighted Average, first calculate the cost per unit using the formula below. 42 Next, apply that same cost per unit to calculate both the Ending Inventory and cost of Goods Sold. 36 Weighted Average Cost Cost of Goods Available for Sale Number of Units Available for Sale perum 45 45 47 45 49 50 52 Welighted Average Ending inventory #of Units Cost per Unit Total Cost Sheet READY Prov 1 of 1 Score answer > o arch =https%253A%252F%252Fims.meducation.com edit Excel Sims * Weighted Average Cost = Cost of Goods Available for Sale Number of Units Available for Sale per unit Weighted Average cost of Goods Sold It of Unit Cost per Unit Total Cost 4) Use the given information and your calculated numbers to complete the cost of Goods Sold Equation below for all three inventory methods. (All numbers should be positive.) FITO LIFO wid. Avg Beginning Inventory Add: Purchases 1 Goods Available for Sale 2. Less: Ending Inventory Cost of Goods Sold 14 5 56 Sheet1 REAL Prey 1 of Score answer > o