W4 Chapter 07 Homework 1. EX.07.01 2. EX.07.02 3. EX 07.03 ALGO 4. EX.07.07 EXCEL ALGO 5. EX.07.08 6. EX.07.12 ALGO eflock Show Me How Office3 FIFO and LIFO costs under perpetual inventory system The following units of an item were available for sale during the year Beginning inventory Sale 1,600 unit at $100 5,700 units at $310 First purchase 15,100 units at $160 Sale 12,600 $310 Second purchase 15,600 units at $172 13.100 units at 5310 The femuses the perpetual inventory systems, and there are 7,000 units of the item on hand at the end of the year This formation has been callesteit in the Microsoft Excel Online file Open the serealsheet, perform the required analysis, and put your answers the be 7. EX.07.13 ALGO 8 EX.07.14 9. EX.07.15 ALGO 10. EX07.17 ALGO Open spreadsheet 11. EX.07.20 ALGO 12 EX.07.21 ALGO 13. PR.07.01.BLANKSHEETA..... What is the total cost of the ending inventory according to FIFO? Round your answer to the nearest doc $ h. What is the total cost of the ending inventory acarding to LIFO? Round your answer to the nearest dolar 14. PR.07.02 ALGO