1. Read the assignment scenario.
2. Create a pareto chart in order to determine who the major competitors are and what is needed in order to compete with these companies. You will analyze the results to create a summary report.

• In your summary, consider the following five points:
• The frequency of imports
• Total dollar amount spent per import
• Cumulative dollar amount spent per year
• The percentage of each importers annual expenditure versus the total amount of expenditure in Ontario
• Calculate the cumulative expenditure of all companies in Ontario.

1. Create a series line chart with 2 separate sheets.

• Sheet1: Add the data table here, rename Sheet1 as Data.
• Sheet2: Add the chart here, Rename Sheet2 as Pareto Chart.

1. Include your full name in Sheet1 cell A1 and center text.
2. Format data table with theme cell style 40% Accent1.
3. Add currency format where needed.
4. Customize chart title.
5. Autofit data info so it is fully visible in each cell.
6. Use the frequency amounts and change it to numeric in the data table.
7. In summary, indicate and describe the largest importers in the industry.

ASSIGNMENT SCENARIO

You operate in the domestic food market and youre looking to expand your supply chain and import foodstuff internationally. Before you decide to import, you need to review the current importers in Ontario and assess which competitors are the market leaders.

Below is the allocation of imports for every competitor operating in Ontario: