Cateories	Supplier	YTD spend
8+1/2x11 paper	Domtar	$ 1,110
advertising	commercial eyes	$ 265,000
appliances	maytag	$ 4,200
ballpoint pens	grand & toy	$ 315
batteries	grand & toy	$ 235
boxes	staples	$ 864
cartons	staples	$ 4,850
cartons	Domtar	$ 2,316
coffee service	coffee guys	$ 16,800
electricity	enersource	$ 1,440
janitorial	we clean 4 u	$ 13,200
marketing supplies	Adverteazers	$ 15,000
pens	staples	$ 115
phones	Bell Canada	$ 11,400
photocopiers	xerox	$ 9,504
photocopy paper	grand & toy	$ 1,760
photocopy supplies	xerox	$ 3,420
printer paper	staples	$ 4,400
printer supplies	pitney bowes	$ 1,028
printers	pitney bowes	$ 13,836
Security	guardex	$ 65,380
shipping containers	grand & toy	$ 1,823
water	peel wastewater	$ 1,800

Using the above table;

1. To find all of the opportunities to re-name categories for simplified spend analysis.

2. To Identify where and how money may be saved for the next year.

3. To Sort the categories by highest to lowest dollar spend.

4. Pareto Analysis a. Based on the data provided, to do a pareto analysis using standard ABC categories to classify the suppliers.

Wilfredo Pareto (1848-1923) studied sociology, engineering, economics and philosophy, among other disciplines. He discovered that 80% of the land in Italy was owned by 20% of the population. It was Joseph Juran, a business consultant, who named the 80/20 rule after Pareto - the Pareto principle. This same distribution has been accurately applied to multiple areas: 80% of your sales come from 20% of your customers, etc. For the purpose of this exercise, please use 3 categories for the Pareto analysis