[AccessD] Manufacturing Application

Coming back a bit late = I was trying to track down the application but can't find a copy.

I built exactly this a number of years ago. The company used it for producting all the paint 
manufactured in PNG until their parent company overseas was bought out by Akzno Nobel 
and they had to change to AN's worldwide system.

You are looking at a a wide range fo chemicals that come in bags and drums and 
forumae/processes to convert them into paint.   There are quite a few mixtures which are 
made up in advance and can then be used in formulations so you have some things which 
are treated both as material and product. 

The formulations will be recorded as  a series of steps with quantity of a component to be 
added and  a description of that stage.  The production sheet needs to generated for each 
paint batch based on the formulation, formula and qty to be produced..

Quantities in a forumla will be either weight based on volume based and you need to record 
the specific gravity of each liquid ingredient and end product so that you can  convert it to 
weight.  Quantities in formulae are per lb/kg or whatever. 

So there is a bit of math involved in converting a formula listing vomponents in grams/kg into 
a production sheet listing quantities and steps to produce 600 litres of end product.

That's the simple part.  Then comes stock control, production scheduling, material 
forecasting, sample testing results etc, ect. 





On 27 Feb 2014 at 9:23, Paul Hartland wrote:

> Rocky I will get back to you at some point, as soon as my friend can
> get back to me, as a start I have asked (probably the wrong question)
> if he could supply me with a list of all raw materials they currently
> have that are used in the manufacture of this specialised paint, so at
> least I can look at building a sort of raw parts inventory.
> 
> Paul
> 
> 
> On 26 February 2014 13:45, jack drawbridge <jackandpat.d at gmail.com>
> wrote:
> 
> > Paul,
> > There are a number of free data models at
> > http://www.databaseanswers.org
> >
> > use google or bing and use this search term
> >
> > *databaseanswers.org <http://databaseanswers.org> data model
> > manufacturing*
> >
> >
> > On Wed, Feb 26, 2014 at 1:55 AM, Paul Hartland <
> > paul.hartland at googlemail.com
> > > wrote:
> >
> > > To all,
> > >
> > > Has anyone had any experience in designing and developing a
> > > manufacturing application, I am trying to find a database model or
> > > example database to get an exact idea of requirements, basically a
> > > friend of mine works as
> > head
> > > accountant for a specialist paint manufacturer and he says there
> > > just
> > isn't
> > > anything out there to do exactly what they require, so being
> > > clever I
> > said