In the current economy we are finding that we are having quite a few issues with regard to figuring profit and loss from production jobs.
Here is a little background of how we are currently doing things: We are on version 6.1.543, run production stamping jobs through inventory, use avg cost for finished goods, last cost for purchased goods and are trying to use the MRP module. We do not have the Quote module.
We quote the job and put the quoted standards into the method. After we have done a couple of runs or change the process, we find that the standard from the quote does not accurately reflect what we actually can do. If we do not change the standard then MRP scheduling and job suggestions are not accurate. If we change the standard then the estimated costs are not the same as the quote. We also have the issue with using last cost for our material - there is not a spot to put into the method what the quoted material price is so that you can see the variance for material purchased and used on the job.
We would like to be able to get MRP to suggest jobs as accurately as possible but we also need to be able to compare the actual run with the quoted price. If at all possible we do not want to purchase the Quote module as our estimators will continue to use Excel no matter what and the quote module would be used as just a placeholder which does not seem real "lean" to me.
I will appreciate any and all help you can give me on this. Thanks.
Kathy Schaich
Operations Support Manager
Ultra Tool & Mfg., Inc.
Here is a little background of how we are currently doing things: We are on version 6.1.543, run production stamping jobs through inventory, use avg cost for finished goods, last cost for purchased goods and are trying to use the MRP module. We do not have the Quote module.
We quote the job and put the quoted standards into the method. After we have done a couple of runs or change the process, we find that the standard from the quote does not accurately reflect what we actually can do. If we do not change the standard then MRP scheduling and job suggestions are not accurate. If we change the standard then the estimated costs are not the same as the quote. We also have the issue with using last cost for our material - there is not a spot to put into the method what the quoted material price is so that you can see the variance for material purchased and used on the job.
We would like to be able to get MRP to suggest jobs as accurately as possible but we also need to be able to compare the actual run with the quoted price. If at all possible we do not want to purchase the Quote module as our estimators will continue to use Excel no matter what and the quote module would be used as just a placeholder which does not seem real "lean" to me.
I will appreciate any and all help you can give me on this. Thanks.
Kathy Schaich
Operations Support Manager
Ultra Tool & Mfg., Inc.