× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



My boss asked me for alternative solution choices, so I am asking how other companies on BPCS cope, in case there's an idea I have not thought of, or which has fallen out of my brain.

Situation: We're on 405 CD, off OSG, on AS/400 V5R1.

We repetitively make-to-order for Original Equipment Manufacturers.
There's a lot of model churning ... new models being added, old models falling off schedule ... for many customers we are doing same approx $ volume business as years ago, just that the parts are not identical

Customer lead time = 2 weeks typically
Vendor lead time = 6-12 weeks
Some customers want us to keep 3-6 months raw materials on hand due to vendor bottlenecks.
We setup various systems to order safety stock to cover expected future needs.

Problem: As customer business evolves, we don't notice, until auditors question mega bucks tied up in safety stock for long gone customer business, then it can be very time consuming to research each scenario. Last year, we wrote off 6% of the value of our inventory due to this.

KISS = an unofficial mandate.
Any solution must be simple to comprehend by
* the people who approve it;
* the people who implement it; and
* the people who audit that it is working.

I have proposed in the past:
* replace fixed safety stock with seasonal safety;
* use MRP100 forecast and quarterly share the info with customers, asking them to identify items they will no longer reimburse us for (when they reach end of life cycle need some part from us)
* me write a "Business Evaporation Detector" program to list items where current orders volume do not match historical average sales in last year, to project impact on $ tied up in safety stock, by customer item, page break totalled by customer
* I am now working on an "Only child detector" to list raw materials whose need will be dramatically impacted by engineering revision changes (up or down)

So, are there any better ideas than what I already know?
-
Al Mac



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.