Phantom Job Costs (mfg-var)

Yahoo Archive
1
Do you use the Quality Module?

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Todd Caughey
Sent: Friday, September 09, 2005 12:06 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Phantom Job Costs (mfg-var)


This is going to be real confusing to explain because I am already confused and if I understood it I might not be asking about it.
But here goes...
Say we have a job to make 50 parts and we have parts in various stages of WIP while 10 get finished and shipped. Then for whatever reason we close the job before the rest are completed. The parts that shipped and invoiced get the costs associated with just them so if I do an invoice based margin report they look OK. But the remaining cost into the job for the 40 parts in various stages of completion never gets allocated to the parts that shipped making them look "good" whereas in reality the whole job was a complete loser. The cost shows up on the Inventory/WIP Recconciliation report as MFG-VAR and on the Produciton Detail the profitability is correct. But any report looking only at invoices gets only the costs attached to the parts that shipped as of the time they shipped.

Is there any means where the invoice costs are "corrected" to absorb the total job cost onto the parts that shipped? Or are those costs frozen forever? We also have the situation where parts ship but more costs are posted to the job months later (slow billing from subcontract vendors) and then the job is closed. Is there any way to get these costs too reflected in the invoice costs per piece? The differences amount to over $100K per year and really distort the perception about whether a part made money or not.

I have played with my reports to link invoice order releases to the job and get a piece price from that but this does not always work correctly. Mostly due to multiple jobs linked to releases. Before I spend days making it handle all the possabilities is there any hope for the invoicing side to have the right costs - even much later when the job is closed?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.


[Non-text portions of this message have been removed]




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
2
This is going to be real confusing to explain because I am already confused and if I understood it I might not be asking about it.
But here goes...
Say we have a job to make 50 parts and we have parts in various stages of WIP while 10 get finished and shipped. Then for whatever reason we close the job before the rest are completed. The parts that shipped and invoiced get the costs associated with just them so if I do an invoice based margin report they look OK. But the remaining cost into the job for the 40 parts in various stages of completion never gets allocated to the parts that shipped making them look "good" whereas in reality the whole job was a complete loser. The cost shows up on the Inventory/WIP Recconciliation report as MFG-VAR and on the Produciton Detail the profitability is correct. But any report looking only at invoices gets only the costs attached to the parts that shipped as of the time they shipped.

Is there any means where the invoice costs are "corrected" to absorb the total job cost onto the parts that shipped? Or are those costs frozen forever? We also have the situation where parts ship but more costs are posted to the job months later (slow billing from subcontract vendors) and then the job is closed. Is there any way to get these costs too reflected in the invoice costs per piece? The differences amount to over $100K per year and really distort the perception about whether a part made money or not.

I have played with my reports to link invoice order releases to the job and get a piece price from that but this does not always work correctly. Mostly due to multiple jobs linked to releases. Before I spend days making it handle all the possabilities is there any hope for the invoicing side to have the right costs - even much later when the job is closed?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.


[Non-text portions of this message have been removed]