The job is to create analysis, calculation & excel module for our Supply Chain, logistics & inventory management.
It is for an FMCG product (Potato Chips). The need is to be able to create an excel model & a presentation for the Supply Chain, logistics & inventory management of our production.
You need to align it to the following:
1. Production cycle (between production lines)
2. Production hours per shift per line
3. Production shifts per day
4. Inbond logistics constrains
5. Minimum order per item from the raw material
6. Capacity of each item (raw material & product) per container
7. Duration of shipments ( for both, raw material & product).
8. Alignment of the raw material movement & product to the financial module (basically will need to identify the point in time a payment is due.
9. inventory capacity for the different raw material items & finished product.
In addition to the above, I rely on your experience to advice on the changes or additions that can get us the most out of this exercise.
If the price is not suitable, kindly propose the one that you think is fair.
Looking forward to seeing your proposal.
August 22, 2018
I am looking for a mix of experience and value