Create the Supply Chain Dashboard

Background

Here’s an overview of your individual project. The instructions below will assist you in completing Assignment 3, which will be submitted this week.

· Week 3 Assignment 2: Create the Supply Chain Dashboard, after you have completed each tab of the Excel template. Use formulas where needed in your Excel doc.

Instructions

For this part of the assignment, you will be creating a dashboard using the data from the “Final Project – Excel Template.”

You will submit two items for this report:

1. Upload your written report (Word Doc)

a. Descriptive paragraph explaining each dashboard element (1 paragraph per table element). There should be at least six dashboards. They can be line graphs, bar charts, Pivot tables etc.

2. Upload your created Dashboard (Excel Doc)

Additional Resources

Please see the following additional resources to assist you.

· Linked-In Learning: Excel: Dashboards for Beginners

· https://www.youtube.com/watch?v=MTlQvyNQ3PM (Kevin on YouTube: How to build dashboards)

· Final Project – Excel Template

· Business Case Study Recommendations

Grading

This assignment is worth 30 points