To fill out this problem I need excel formulas for each box I can not input answers in the box . For each box give me a formula for example (b58-c60)

please base the formula off this excel sheet horizontal and vertical numbers horizontal (A,B,C,D) vertical (1-63)

ED: Homework Chapter 6 Inventory i Saved Help Save & 1. Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO, and Weighted Average Cost methods. ? x BB5. FILE HOME Inventory costing methods - Excel FORMULAS DATA REVIEW - 6 Sign In INSERT PAGE LAYOUT VIEW Calibri Paste B I U- - -A Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styles Clipboard Font . Better Bottles, Inc., uses a periodic inventory system and has the following nces 1 Better Bottles, Inc., uses a periodic inventory system and has the following information available: of Units $ 3 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 $ 20.00 27 33 22.00 Total Cost 400.00 594.00 990.00 1,984.00 12 Required: Formatting Styles Table Styles Clipboard Font B17 1 Better Bottles, Inc., uses a periodic inventory system and has the following information available: 26.53 points 18 # of Units $ 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 $ 20.00 27 22.00 33 30.00 Total Cost 400.00 594.00 990.00 1.984.00 eBoo To References 12 Required: 13 ) Calculate both the Ending Inventory and Cost of Goods Sold using Periodic FIFO. FIFO Ending Inventory of Units Cost per Unit T otal Cost 16 Description 17 Jan. 20 Purchase 18 Jan. 15 Purchase FIFO Cost of Goods Sold of Units Cost per Unit Total Cost Description 23 Beginning Inventory an Too 16. Dunabnne ... Sheet1 ... READY Formatting Styles Clipboard Table Styles B23 B 18 Jan. 15 Purchase 26.53 points FIFO Cost of Goods Sold # of Units Cost per Unit T otal Cost Description 23 Beginning Inventory 24 Jan. 15 Purchase eBook 36 References 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 Description T otal Cost Jan. 20 Purchase 38 Jan. 15 Purchase 36 Sheet1 ... + READY 1009 Attempt(s) 3/3 Help sa Formatting Styles Table Styles Clipboard Font B31 D . 18 Jan. 15 Purchase 26.53 points FIFO Cost of Goods Sold # of Units Cost per Unit T otal Cost Description 23 Beginning Inventory 24 Jan. 15 Purchase eBook References 2) Calculate both the Ending Inventory and Cost of Goods Sold using Periodic LIFO. LIFO Ending Inventory # of Units Cost per Unit T otal Cost Description Beginning Inventory Jan. 15 Purchase LIFO Cost of Goods Sold of Units Cost per Unit Total Cost Description 37 Jan. 20 Purchase 38 Jan. 15 Purchase ... Sheeti . READY Attempt(s) 3/3 hep Save & E Formatting Styles Table Styles Clipboard Font B37 18 Jan. 15 Purchase 26.53 points FIFO Cost of Goods Sold of Units Cost per Unit T otal Cost Description 23 Beginning Inventory 24 Jan. 15 Purchase eBook 36 References 27 2) Calculate both the Ending Inventory and Cost of Goods Sold using Periodic LIFO. LIFO Ending Inventory # of Units Cost per Unit T otal Cost Description 31 Beginning Inventory 32 Jan. 15 Purchase LIFO Cost of Goods Sold # of Units Cost per Unit Total Cost Description Jan. 20 Purchase 38 Jan. 15 Purchase 36 40 Sheet1 ... + READY Attempt(s) 3/3 Formatting Styles Table Styles Clipboard Font E46 36 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. Book Weighted Average Cost = Cost of Goods Available for Sale Number of Units Available for Sale per unit erences Weighted Average Ending Inventory # of Units Cost per Unit T otal Cost Weighted Average Cost of Goods Sold # of Units Cost per Unit T otal Cost 56 4) 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 L IFO Wtd. Avg. 59 Beginning Inventory 60 Add: Purchases 61 Goods Available for Sale UIRED: Homework Cildpler olivenly Formatting Styles Table Styles Clipboard Font B59 D Weighted Average Cost of Goods Sold # of Units Cost per Unit Total Cost 58 56 4) 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 Goods Available for Sale 62 Less: Ending Inventory 63 Cost of Goods Sold