Question: 1. Demonstrate the data analytical skills you learned in this class (ACCESS or EXCEL) to perform the following analysis: a. Report Sales, Cost of Sales,
1. Demonstrate the data analytical skills you learned in this class (ACCESS or EXCEL) to perform the following analysis: a. Report Sales, Cost of Sales, and the Gross Margin by stores for Q1, 2022 (20 points) b. List the top 5 flower names and rank by their actual gross margin contribution across all stores for Q1, 2022. (20 points) c. Rank the top 5 customers with the most outstanding balance at the end of 2021? (20 points) d. Create a dashboard, including a chart and table, that allows your CFO to dynamically see the revenue, cost of sales, and gross margin by Store, individually or collectively. (40 points) e. BONUS: Provide additional reporting/dashboard features that would be helpful to your
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
