Question: We will use the Coffee Chain.xlsx data file for this assignment. Use Microsoft Excel to create three charts in order to answer the questions below.

We will use the Coffee Chain.xlsx data file for this assignment. Use Microsoft Excel to create three charts in order to answer the questions below. Each chart should provide complete answer to all questions listed on each one. Chart 1-- Which Product Type generated the highest Sales? What was the Sales figure? Which Product Line does it belong to? Chart 2-- What is the trend of Monthly Profits for all Products combined in 2012? Which month had the highest profit and what was the profit figure? Chart 3-- What is the trend of Monthly Profits for Herbal Tea in 2012 compared to 2013? Did it follow the same pattern as in 2012?

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 General Management Questions!