Graw Hill Excel Question Saved Search (Option + Q) Home Insert Draw Formulas Data Review View Help Calibri 11 B Av Editing v General 4.0 00 00 0 Commer A fx Accessibility tab summary: Financial information for Better Bottles, Incorporated, is presented in cells A4 to D10. A statement for requirement 1 is presented in rows 12 to 15. The FIFO Ending Inventory tal F H I B C D E G J K McGraw Hill Bottles, Inc., uses a periodic inventory system and has the following information available: Description ming Inventory 5 Purchase O Purchase s Available for Sale January Sales ng Inventory # of Units Cost per Unit Total Cost 20 $20.00 $400.00 27 22.00 594.00 33 30.00 990.00 80 $1,984.00 36 44 uired: alculate both the Ending Inventory and Cost of Goods Sold using Periodic FIFO. e cells A4 to D10 from the given information to complete this question.) FIFO Ending Inventory Description .20 Purchase . 15 Purchase # of Units 44 Cost per Unit Total Cost Cost per Unit Total Cost Description eginning Inventory an. 15 Purchase FIFO Cost of Goods Sold # of Units A Graded Worksheet lation Mode: Automatic Workbook Statistics + 36 Legend Graded cell: Leave blank If no answer is needed. Scratchpad: Use as a non-graded workspace Save and Return to Assignment Give Feedback to Microsoft 100% +