FIN615 week 10 homework

You are presented with a data file that includes sales to date by product, customer type etc. You have actuals to date as well as the yearly forecast. You have to develop a dashboard that indicates whether they will hit their year end target, and provide sufficient analysis and visual presentation for the sales executives to be able to understand why, or why not.

You must use at least 3 of the functions we have used this semester.

Present results by quarter.

The dashboard file should be created in Excel should include the following on separate worksheets: the raw data (formatted to remove all irrelevant fields), the analyses performed on the raw data (via pivot tables and other Excel functions), and graphs to display the results of the analyses performed. The arrangement of these graphs within a single worksheet forms the actual dashboard.