I'm trying to construct from scratch a database program to calculate production costs for a bakery. (This is to replace an old Old OLD program that is poorly documented, extremely tempermental, and that does not cooperate with Windows well at all. <img src=/S/puke.gif border=0 alt=puke width=60 height=15>)

The DB factors in current production; standard labour, ingredient, and packaging costs; standard run speeds; and numerous miscellaneous factors to generate a "Standard Cost". This is then compared to actual labour, ingredient, and packaging costs for an "Actual to Standard" variance, to then yield the adjusted cost per unit. Multiple plants and product lines are involved. Similar products must be grouped for some calculations, but then broken back out for others.

My question is: does anyone know if there is a "stock" costing DB program out there that can be taken and customized to fit our needs? I've been working on this off and on for about a year and a half, tinkering with ways to automate input (ie, ODBC links to production control files), massaging calculations to match our current program, etc. I've got the feeling though that I've been trying to re-invent the wheel throughout this whole process.