Archive: Excel dash board development

Budget By arrangement

Posted: 5 years ago

Closed

Description: 1. Buy = Sell comparison – what products on the months invoice did we buy from Supply Chain last year and what have we saved on those in the month
2. What products on the invoice are new spend with supply chain and what are we saving on those – total price reduction including the buy=sell reduction
3. What products do we currently not buy via supply chain – we can then work with them on how we can most effectively move what items over to maximise the benefits.

For lines 1 and 2 I would expect us to be able to build a self-populating analysis that just pulls in a new data set at monthly intervals.
Working conditions:
1-5 days
1-10 Hours/wk
Rate: not specified
Skills:
analytics,supply chain management,microsoft excel