[AccessD] Building A Product Costing Database

Paul:

Do they want standard or actual costs (or both)? For standard costing 
you'll need a bill of materials processor function with cost roll-up.  
For actual costs you'll need to capture standard material cost when it's 
issued to work orders and actual labor through a labor distribution 
function.  Also for actuals you'll need to capture purchase price 
variance on purchased parts since that changes the actual costs.  If 
they can go with standard costs that makes life a whole lot simpler.

Have a look at www.e-z-mrp.com . There are screens shots and reports.  
Let me know if there's anything there of interest.  Be happy to give any 
help I can on the basic design.  I think this is an app which could 
benefit from a real solid design up front before writing.  Run it by 
management and make sure all the functionality is there that they want. 

Regards,,

Rocky


paul.hartland at fsmail.net wrote:
> To all,
> I am sure that I have seen something similar discussed on this list before but for some reason I can't access the archives !!!!....Anyway I am looking at building a production database (in the first instance for a paint company).....It will have to start from the very raw materials right through to the end product and produces costs, has anyone done something similar before that I could possibly have a look at (don't want code etc, just want to get the basic understanding of how something like this should work).
>
> The database would have to produce costs at every stage as they will in some instances use a completed product which they have in stock to mix in with other raw materials to produce another type/colour of paint etc.
>
> Thanks in advance for any help.
>
> Paul Hartland
>   

-- 
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com