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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!