ollowing tools and concepts:

a$.$ Spend Analysis

b$.$ ABC analysis

c$.$ Pareto Analysis

This assignment consists of $3$ separate parts $$ see below!

PART $1$: Candidates will be provided with an Excel spreadsheet that

includes data from a small Canadian company's annual spend.

Conduct a Spend Analysis

a$)$ Based on the data provided, re$-$name and$/$or create new spend

categories to prepare a simplified spend analysis.

b$)$ Sort the categories by highest to lowest dollar spend using a Pareto

Analysis, Also, based on the data provided, prepare a pareto analysis

using standard ABC categories to classify the suppliers.

c$)$ Identify where and how much money may be saved for the next year. For the purpose of this exercise, please use $3$ categories for the

ABC $+$ Pareto analysis A $=80\%$; B$=15\%$; C$=5\%$