please attach an excel sheet with the answer:

1. Create a Pareto chart in order to determine who are the major competitors and what is needed in order to compete with these companies. You will analyze the results in order to create a summary report. In your summary, consider the following five points:
   • the frequency of imports
   • the total dollar amount spent per import
   • the cumulative dollar amount spent per year
   • the percentage of each importers annual expenditure versus the total amount of expenditure in Ontario
   • and calculate the cumulative expenditure of all companies in Ontario
2. 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
3. Include your full name in Sheet1 cell A1 and center text
4. Format data table with theme cell style 40% Accent1
5. Add currency format where needed
6. Customize chart title
7. Autofit data info so it is fully visible in each cell
8. Use the frequency amounts and change it to numeric in the data table
9. In summary, indicate and describe the largest importers in the industry

MATERIALS AND RESOURCES

• Publisher Materials: Information Systems: A Managers Guide to Harnessing Technology. John Gallaugher. Flatworld Edition, 2018.
• Software: Microsoft Excel

Item Description Annual Usage Frequency Harry's Foods MM Agro Trios Wholesale Sault Imports Toronto Foods ABC Imports Fine Foods William and Jane Trading Lentils and Foods imports Dr. Sweets and Chocolates Premium Foods Carmelo's Goods Mutton Trading Chic Distributors Amazing Fulfillment XYZ Distribution Mike's Imports and Logistics Foods & Lotions Imports Rice and Grains Imports Nickel and Dime Imports Coco Trading Unit Price CAD 400000 89000 325000 125000 80000 120000 300000 50000 25000 12000 25000 500000 55000 12000 90000 75000 25000 113000 13000 150000 25000 Monthly Monthly Weekly Weekly Weekly Weekly Monthly Weekly Weekly Weekly Monthly Quarterly Bi-Weekly Weekly Monthly Monthly Bi-Weekly Monthly Weekly Weekly Weekly