RE: Hidden Costs -- BPCS-L

Hi Ho Lynn.

The only place were you will find an accurate standard cost (based on cost
set 2) is in the CIC file.

Your are right in saying MRP140 affects this file. If a user deletes an item
in MRP140 you are in fact deleting the CIC record for that 
Item number. If your reporting is using the CIC file for standard costs that
Item will no longer show. 

You are also right in saying if you add this level (CFTLVL) + previous level
(CFPLVL) for blank cost buckets it will give you the standard cost.
Unfortunately the CMF file is rather big. Running queries against it can
take a bit of time.

Did you know that sum(CFTLVL + CFPLVL)(blank cost bucket)(cost set 2) is
written to your CIC file for every item when you do a cost rollup. 

I have written a program that regenerates the CIC file. This program acts in
two ways.
                1. Repopulates the CIC file. When cost roll in ran all
standards are updated in file CIC file.

                2. Updates all fields for MRP. You can view the results in
MRP140.

We run this program daily (during backup process, no one can be on the
system). It only takes a couple of minutes. We run it every day because new
items are added to the Item Master (IIM) and updates that effect our MRP/MPS
are done daily. 

We all know that even if you create in item the only way to create a CIC
record for it is either to transact against it or to add the item using
MRP140 and if you update an item in the Item Master (IIM) you need to update
the CIC through MRP140 to keep MRP in line.


        Any hoot, want a copy   

        Marc Lacelle    
        Royal Canadian Mint
        lacelle@rcmint.ca
        Keep on BPCS'ing

> ----------
> From:         KLChilds@aol.com[SMTP:KLChilds@aol.com]
> Reply To:     BPCS-L@midrange.com
> Sent:         Wednesday, December 01, 1999 11:17 AM
> To:   BPCS-L@midrange.com
> Subject:      Re: Hidden Costs
> 
> Hello,
> 
> We have addressed some of the problems you mentioned about costing.  First
> of 
> all, the only place that we have found a standard cost that is accurate
> and 
> always there is the CMF file.  We have a lot of old queries we still
> support. 
>   Many of them use a file as input that was created via query that is a 
> standard cost by item file.  We use the facility level for costing, the
> cost 
> set we are reporting (most of the time - cost set 2 - frozen standard) and
> 
> use the 0 bucket  records in CMF.  The cost this level and previous level
> are 
> added together to calculate total cost.  
> 
> There are many other places that cost is stored, but many time they are 
> either inaccurate or zero.  I believe the cost showing in INV300, for 
> instance, comes from the CIC file which is only current as of your last
> MRP 
> run.  Other places of note is in ITH there is a standard cost field.  It
> is 
> only populated if you have a standard cost BEFORE you do the transaction.
> 
> I also find it interesting your description of your WIP processing.  Have
> to 
> admit this has been a long-time issue we have yet to solve very well.  One
> of 
> the big problems I see is that there is no interface from WIP to GLD
> except 
> for inventory movement.  The accountants have already brought this to my 
> attention that this calls for a manual process to handle WIP accounting 
> properly.
> 
> Hope some of these ramblings help !
> 
> Lynn
> +---
> | This is the BPCS Users Mailing List!
> | To submit a new message, send your mail to BPCS-L@midrange.com.
> | To subscribe to this list send email to BPCS-L-SUB@midrange.com.
> | To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner: dasmussen@aol.com
> +---
> 
+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---