Re: BOM, SFC in fermentation mfg

> Our problem is big different between on hand balance of raw material in
>  BPCS and reality in warehouse.
>  Process take 200 hours. Exact raw material consumption is know after the
>  end of process.
>  And this create our problem.

Can you break your process down into individual steps that would have their
own part numbers, so that the 200 hours becomes a series of faster delivery
of info to your data base?

We have similar situation with our work-in-process actual costs.
I have a modification proposal to my management to solve our problem, in
which a similar modification for you might solve your problem.

We have a significant turn-over of new customer parts, such that we are
almost always having in production parts we never made before.
CST900 sends actual cost to manufactured items in the sequence of the shop
order #s being purged, and use latest actual cost on consumed materials, such
as sub-assemblies.  Invariably the parent parts get shop order #s earlier
than those of the component parts, due to the way our items are numbered.
This means that the parent items get actual costs updated from component
parts from an earlier production run.  Due to variety in sizes of production
runs this sends spikes to cost variances.

Now my suggestion is to have a clone of the CST900 process which leaves all
the shop orders intact & only updates the actual costs based on the same
criteria as CST900.

Before a CST900 run, we would do this several times to get actual cost
up-to-date with what's in production.

Or perhaps we could explore the sequence & do it by BOM children up to where
used ... I did look at the logic & concluded that was a bit much for me to
manage.

This kind of thinking might apply to you.

There is data in the open shop orders that is not getting to your inventory.
You want it to generate adjustments, perhaps in the form of reversals
prepared similar to the logic of General Ledger reversals.
When the shop orders do close, you want the reversals to be posted,
corresponding to all adjustments on the shop order #s just closed.

MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)
BPCS 405 CD Manager / Programmer @ Global Wire Technologies Incorporated
http://www.globalwiretechnologies.com = new name same quality wire
engineering company: fax # 812-424-6838