ACCT00.00 Cow The Short Sheo Hd The omheducation comestimap/index.html?con concernal browser-anchor-253A%252P%252Fm meducation.com%252mg umiddlewa ark 5 A 1. Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO, and weighted Average Cost methods tirting methods - Excel FORMAS DATA REVIEW VIEW FILE HO PAGE LAYOUT X KA Cells to TW Algement Conditional For Call Forming Table Styles C Better Bottles, Inc., uses a periodic inventory system and has the following E TO Description Test Cat 2015 Beginning av 20.00 S 400.00 27 5 m. 15 Purchase 22.00 59000 6 Jan 20 Purchase 30 30.00 91.00 30 $ 198400 7 Goods Available for Sale Les January Sales 9 Ending leven 44 30 11 12 Required: 13 ) Calculate both the Ending Inventory and cost of Goods Sold using Periodic FIFO. 14 FIFO Ending Inventory Description of Units Tital Cost 17 Jan 20 Purchase 18 l. 15 Purchase 19 20 FIFO Cost of Goods Sold of Units Cost per Unit Total Cost 21 Description 23 Beginning Inventory 24 Jan. 15 Purchase . Sheet1 die Puth X FACT400-001 > Connect The Shin Shopa The Fox + omheducation.com/map/index.html?con contexternal browserAlaunchurtha253A%252F%252Fims.meducation.com252Fmghmid or 5A 1. Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO, and Weighted Average Cost methods X D. FILE HOME INSERT Cat 11 TV- merry costing model 70 PAGE LAYOUT FORMULAS DATA REVIEW VIEW RA Alle Number Conditional format el idong Formatting Table Styles S Better Bodies, Inc., uses a periodic inventory system and has the following C. D E LIFO Yading Inventory of Unit Cod per Total Cost AI 29 10 Description 1. Beginning Inventory 12 Jun. 15 Parchase 33 44 LIFO Cotal Goods Sold 36 Dewrite of Units Cester Unit Total Cos Jun 20 Purchase 38 Jan. 15 Purchase 36 43 413) Using Periodic Weighted Average, incalculate the cost per unit using the form below Next, apply that same couper unit to calculate both the landing Inventory and Cont of Goods Sold 44 Weighted Average Cost = Cost of Goods Available for Sale Number of Units Available for Sale 45 per unit Wilhed Average Ending Tentary For Unit Cod por Unit Total 3 12 BALI Sheets die Puth X FACT400-001 > Connect The Shin Shopa The Fox + omheducation.com/map/index.html?con contexternal browserAlaunchurtha253A%252F%252Fims.meducation.com252Fmghmid or 5A 1. Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO, and Weighted Average Cost methods X D. FILE HOME INSERT Cat 11 TV- merry costing model 70 PAGE LAYOUT FORMULAS DATA REVIEW VIEW RA Alle Number Conditional format el idong Formatting Table Styles S Better Bodies, Inc., uses a periodic inventory system and has the following C. D E LIFO Yading Inventory of Unit Cod per Total Cost AI 29 10 Description 1. Beginning Inventory 12 Jun. 15 Parchase 33 44 LIFO Cotal Goods Sold 36 Dewrite of Units Cester Unit Total Cos Jun 20 Purchase 38 Jan. 15 Purchase 36 43 413) Using Periodic Weighted Average, incalculate the cost per unit using the form below Next, apply that same couper unit to calculate both the landing Inventory and Cont of Goods Sold 44 Weighted Average Cost = Cost of Goods Available for Sale Number of Units Available for Sale 45 per unit Wilhed Average Ending Tentary For Unit Cod por Unit Total 3 12 BALI Sheets