The aim of this report is to find out for a given date range (contract date), how much business (value and volume) was done with all vendors and the data should be presented in descending order (vendor with max volume goes on top)
Following columns will be available for this report
User will select a date range and for that date range the following will be shown
All contracts will be considered (not just open contracts)
Column name | Description |
Supplier name | Name of the supplier |
Total purchased volumes (MT) | All contracts for a given supplier that fall in the date range, add the volumes and show the volumes in MT |
Total purchased value USD | All contracts for a given supplier that fall in the date range, add the values 1- for priced contracts – contract price X volume 2- for unpriced contracts-- latest available price for the futures month X volume 3- for partially priced contracts- weighted average of priced futures and latest settlement price X volume |
% of total JDE spend | (Total purchased value of the supplier/ total purchased value of all suppliers) X 100 |