23 Jul In this exercise, you will compile summary data based on an inventory listing for Educational Endeavors. Then you w
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-A1-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: In this cell:
Use a function to display the:
Cell J5 Cell K5 Cell L5 Cell M5
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 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:I63 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.
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: • Country of Manufacture in the Rows area • Product Category in the Columns area • A filter that excludes all but the Active product department
18. Add a slicer that limits the data to product categories that earned at least a 3 of 5 online rating.
19. Create a 3-D Clustered Column PivotChart and display the Online Rating category in the legend.
20. Position the PivotChart and slicer in a logical manner.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteEdu. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
Do you need help with this question?
Get assignment help from WriteEdu.com Paper Writing Website and forget about your problems.
WriteEdu provides custom & cheap essay writing 100% original, plagiarism free essays, assignments & dissertations.
With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Chat with us today! We are always waiting to answer all your questions.