Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2 pages to this question: Excel information Apply Your Skis 121 Apply Your Skills EA4-A1 Edit an Inventory Listing and Create a PivotTable for Educational

2 pages to this question: image text in transcribed
image text in transcribed
Excel information image text in transcribed 
 
image text in transcribed
 
image text in transcribed
 
image text in transcribed

Apply Your Skis 121 Apply Your Skills EA4-A1 Edit an Inventory Listing and Create a PivotTable for Educational Endeavors In this exercise, you will compile summary data based on an inventory listing for Educational Endeavors. 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-A1-Inventory from your Chapter 04 folder and save it as EA4-Al-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 Construction Paper product category: Use a function to display the: In this cell: Number of years for which an inventory balance is displayed Average inventory balance for the five years shown Cell 15 Cell K5 Cell L5 Maximum inventory balance for the five years shown Cell M5 Minimum inventory balance for the five years shown Hint: Make sure the formula in cell J5 will update properly if any currently blank cells are later filled in. 4. Copy the formulas in the range J5:M5 and paste them such that the calculations will be performed for all product categories. 5. Enter formulas in the range E63:163 to add the inventory balances for each year. Use Inventory Costing Methods 6. Switch to the Construction Paper 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 construction paper under the LIFO method. 9. In cell A18, use the CONCATENATE function to enter FIFO Inventory Balance. 10. Enter a formula in cell B18 to calculate the ending inventory balance for construction paper under the FIFO method. 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 construction paper under the weighted average method. 13. Enter a formula in the appropriate location on the Inventory Listing tab to display the fifth-year LIFO inventory balance for construction paper. 14. Apply the 3 Symbols (Uncircled) icon set and Red - White - Green color scale to the range K5:K62

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Heres a detailed stepbystep solution for the tasks described in your question Steps for Editing Inventory Listing Step 1 Open the given file 1 Open EA4A1Inventory from your Chapter 04 folder and save ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Reporting, Analysis And Decision Making

Authors: Shirley Carlon

6th Edition

0730363279, 9780730363279

More Books

Students also viewed these Accounting questions