laguerriere
New Member
- Joined
- Mar 21, 2009
- Messages
- 1
Dear forum users,
I am working on a tool which graphically shows the stock coverage in weeks for all products we have, per product.
We have pre-defined max coverage and min coverage.
On this picture you can see in blue the max, in rose the min and in yellow the actual (projected) coverage.
Formerly, my colleague used to click on the drop-down, choose a product name (in order to display the graph) and
write down her notes manually. I think it's very inefficient.
There are following types of notes that can be combined:
- Picture shows: stock real > stock max (bad)
Reasons:
- production too early (stock real did not attain the min level and the plant started producing
Example: on the chart of Prod1 you can see that it started the production in Week 6, but ideally it should have started
in week 8
- lotsize too big (even after attaining the min level and sometimes going under it the plant still has too high production)
Example: the plant starts producing in week 8 but produces so much that it goes over the max in week 11
Picture shows: stock real < stock min (bad)
- reason is plant policy
I would like to ask you , wheather it is possible to generate this type of notes automatically by using formulas, for ex. IF etc.
Example sheet see "notes"
The graph is based on the 3 values mentioned above: min, max & real. It it possible to have a message analysing the lotsize as well?
see the sample file (unfortunately, google docs deleted my charts)
http://spreadsheets.google.com/pub?key=p47dk9zqK1Alvl9dPUe79AA
I am working on a tool which graphically shows the stock coverage in weeks for all products we have, per product.
We have pre-defined max coverage and min coverage.
On this picture you can see in blue the max, in rose the min and in yellow the actual (projected) coverage.
Formerly, my colleague used to click on the drop-down, choose a product name (in order to display the graph) and
write down her notes manually. I think it's very inefficient.
There are following types of notes that can be combined:
- Picture shows: stock real > stock max (bad)
Reasons:
- production too early (stock real did not attain the min level and the plant started producing
Example: on the chart of Prod1 you can see that it started the production in Week 6, but ideally it should have started
in week 8
- lotsize too big (even after attaining the min level and sometimes going under it the plant still has too high production)
Example: the plant starts producing in week 8 but produces so much that it goes over the max in week 11
Picture shows: stock real < stock min (bad)
- reason is plant policy
I would like to ask you , wheather it is possible to generate this type of notes automatically by using formulas, for ex. IF etc.
Example sheet see "notes"
The graph is based on the 3 values mentioned above: min, max & real. It it possible to have a message analysing the lotsize as well?
see the sample file (unfortunately, google docs deleted my charts)
http://spreadsheets.google.com/pub?key=p47dk9zqK1Alvl9dPUe79AA