We carry circa 25 products.
Each product needs to be processed in 2-3 stages. circa 20 minutes/stage.
Raw materials come in several times a month. However for some products the raw materials are readily available while for others 1-2 months
are necessary.
Each product is packaged differently.
Each consignment consists of a product mix. (between 1 and 25) There
are circa 5 large customers (2000 products/month) , 5 medium ones (200/
month) and 10 small ones (20/month). (but none of these
order every single month). At the moment most customers need to wait
circa 2 months but the planning must be improved as sometimes an order
can be fulfilled in 2 days.
I need to:
1. provide future delivery dates to customers
2. plan work shifts (1-4 people)
3. plan which products to produce (from planned arrival date of raw material. I know 2-3 weeks in advance)
4. plan quantities to produce for each run. (At the moment we run 5-10 products a day)
5. optional-prepare some production benchmarks (per shift and per product). i have a vague idea though.
6. optional- calculate true cost per order ( in terms of matrials +man hours)
What should i use (on a limited budget) ??
* Excel template ?
* Access template ?
* online solution ?