The Mario's Case study continues... Pauline wants to have an analysis of store sales and product waste. Yoshi has provided transactional data from the April store sales from the financial system for your analysis. 1. Data Analysis a. Download the spreadsheet provided. Examine the data. b. Create a Sales Data Pivot Table. Product Category by Location. (I have modified the table to make this easier). Insert the table in the slides, or create a Pivot Chart that shows the same data. c. The table should provide: (This can be done in one pivot table) i. Total Revenue ii. Revenue per location iii. Revenue per Product Category 2. Evaluate and explain (You will need to update the appropriate tables) a. Which location is not meeting targets? b. Demonstrate how product waste impact location revenue figures? Submit a 2-page memo explaining your analysis.