Essay on spend analysis
Company N to perform this function. In addition, the two systems i.e. Unifier and JDE reporting don’t interface. Therefore, the spend data needs to be consolidated and sorted out manually. Data fields will be determined, whether to be items, category, suppliers, and annual total spend, etc.
Step 4: Normalize, calculate and analyze the data.
From the sorted data, the total spend by category can be calculated and exported with the help of Excel functions e.g. pivot table functions.
A chart of top 10