Looking for help building a custom job shop management database
Hello,
I run a cabinet manufacturing company. We currently use printed out spreadsheets for everything. I would like a tidy database that could manage our “jobs”. I’ll try to outline how it would work here:
We have multiple projects with multiple builders.
Each project has multiple plans (Plan 1, Plan 2, Plan 3)
Each plan has multiple options (Door 1, 2, 3, Stain color 1, 2, 3, Optional Bath 3, etc.), each with an individual price, for which the price is split up by “material”, “stain”, “prefab door cost”, installation, delivery, tax, etc.
For each phase of a project our sales reps will create a “sequence” which is a list of all the houses or “lots” with the associated plan number and all the associated options that were selected.
Also for each phase our reps will turn in a “breakdown” that has a tally of all the units for that phase, and all the options for that phase.
I would like a database in which we store all of our option prices by plan and project. Each price will be unique f