How do I upload the Microsoft excel in chegg there wasn't any option.
EA4-A2 Edit an Inventory Listing and Create a PivotTable for Electronic Worl Then you will determine the inventory balance for a product category using three methods. Last, you will create a PivotTable and a PivotChart. 1. Open EA4-A2-Inventory from your Chapter 04 folder and save it as: EA4-A2-Inventory-[YourName] 2. Use a function to display the total number of product categories in cell B2. 3. Populate the cells as described for the 4K Ultra HD TVs product category: In this cell: Cell J5 Cell K5 Cell L5 Cell M5 Use a function to display the: Number of years for which an inventory balance is displayed Average inventory balance for the five years shown Maximum inventory balance for the five years shown Minimum inventory balance for the five years shown Hint: Make sure the formula in cell J5 will update properly if ary currently blank cells are later filled irn. 4. Copy the formulas in the range J5:M5 and paste them such that the calculations will be performed for all product categories Enter formulas in the range E76:176 to add all inventory balances for each year. 5. Use Inventory Costing Methods 6. Switch to the 4K Ultra HD TVs tab. 7. Use the CONCATENATE function to enter LIFO Inventory Balance in cell A17. 8. Enter a formula in cell B17 to calculate the ending inventory balance for 4K ultra HD TVs under the LIFO method. 9. In cell A18, use the CONCATENATE function to enter PIFO Inventory Balance. 10. Enter a formula in cell B18 to calculate the ending inventory balance for 4K ultra HD TVs 11. In cell A19, use the CONCATENATE function to enter WA Inventory Balance. 12. Enter a formula in cell B19 to calculate the ending inventory balance for 4K ultra HD TVs under the FIFO method. under the weighted average method. 13. E nter a formula in the appropriate location on the Inventory Listing tab to display the fifth-year LIFO inventory balance for 4K ultra HD TVs. 14. Apply the Red Gradient Fill data bars and Green - White color scale to the range K5:K75. Insert a PivotTable and a PivotChart 15. Create a PivotTable on the Inventory Listing tab based on the inventory balances displayed for all five years. 16. Rename the new worksheet tab containing the PivotTable 17. Display the Year 5 Inventory Balances within the PivotTable with . Department in the Rows area Product Category in the Columns area A filter that excludes the Northeast shipping region 18. Add a slicer that limits the data to product categories with an internal classification of at least Level 6 19. Create a Clustered Bar PivotChart and display the Internal Classification category in the legend. 20. Position the PivotChart and slicer in a logical manner 21. Save and close your file. 1 Electronic World -Inventory Listing internal Ending Inventory Ending Inventory Balance-Year 2 Bavance-Yeav3 Balance-Year4 Balance-Year5 afYears Ending Inventary Ending Inwentory Ending Inwentory Number Aweroge Inventory Maximum Iventory Minlmum Inventory Product Category Department shipping Region Classiication Balance-Year i 11 Home Theatre Systems 15 Wireless&Multiroom Audio Lavdl 2 MoclaPlayors 25 Remate TVStrpamin 2 VComponent Shelvine 30 Hame Thestre Seating Level 3 S 3,877 1,459 40 TV& Media Ceaning& Care Level 2 Level 8 Lavel 6S Level 2 Love 3 Level 2 Level 3 evel 3 Level 6 Lave 2 Level 9S Level 95 Love 3 Level 9 S Level 6 Leve 3 Level 3 evel 8 Level 8 S 0 1 Sanding Accessories 2 Inventory Costing Method Comparison 4 Methods to be used 5 Last-In, First-Out 6 First-In, First-Out 7 Weighted Average Units in Ending Inventory: 23 Cost per Unit Total 10 Beginning Inventory 11 Purchase #1 12 Purchase #2 13 Purchase#3 14 Purchase #4 15 Units 18 21 19 34 12 104 475$8,550 477 10,017 $478 $ 9,082 480 16,320 $ 482 $ 5,784 49,753
