Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Chapters 4-7 In this project, you will use skills and procedures presented in Chapters 4-7 together as you complete accounting- related tasks for Craft World.
Chapters 4-7 In this project, you will use skills and procedures presented in Chapters 4-7 together as you complete accounting- related tasks for Craft World. Follow all instructions and use the approaches presented in the chapters to complete the requirements in good form. Submit your work per your instructor's directions. Robert Rosenberg has been a fixture at Craft World in Syosset, NY, where he has worked (and often painted, much to the delight of customers) for more than ten years. He was recently selected as a contestant on the nationally syndicated reality competition So You Think You Can Paint! and abruptly quit his job at Craft World to move to Los Angeles, CA, and pursue his dream. Arnold Norris, owner of Craft World (and your boss), has asked you to assume some of Robert's previous responsibilities. To begin, as of January 31, 2020, Arnold would like you to perform an inventory analysis and complete a bank reconciliation, a depreciation schedule, and a payroll register. Unfortunately, because Arnold is unable to locate most of Robert's files, you will have to complete much of this work from scratch. Project Requirements Requirement #1 Use the EA-MCP-Inventory file to perform an inventory analysis. (Chapter 4) Use a function to enter the total number of product categories in the appropriate location. For each product category, use functions to enter the total number of years for which an inventory balance is displayed (include zero balances) and the average, maximum, and minimum inventory balances in appropriate locations. Then, use a function to enter the total inventory for each of the five years in the appropriate locations. Determine the fifth-year inventory balance for Artist Canvas using the LIFO, FIFO, and weighted average methods (use formulas to create the names of each of the three methods in appropriate locations). Use formulas to determine the inventory balance under each method. Ensure the calculations are entered in appropriate locations on the Artist Canvas tab; label each calculation. Use a formula to enter the LIFO inventory balance from the Artist Canvas tab on the Inventory Listing tab where it is missing. Create a PivotTable that displays the total Year 4 inventory balances (on a per-popularity level basis) for products in store location Section A with a customer popularity level of 3 or higher. Include the same for Section D within the PivotTable as well. Label the new worksheet tab appropriately and use slicers to create the PivotTable. Create a PivotChart displaying the results of the PivotTable, using appropriate labeling and formatting throughout. Position the PivotChart and slicers in a logical manner
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started