Could you give me some direction on an Access database design for a small handmade manufacturing business (1 or 2 person operation)
creates their goods from mostly purchased materials/supplies, but may also include other products made in house. Lets call the combined used materials used a recipe.
The recipe would deduct the amounts of each item used to make the produced item that will become available for sale.
The way I see it
I purchase items to manufacture items I create
1 Copper sheet 12 x 18 inches $22.00
1 1/8" round brass rod 36 inches long $4.00
1 pk of 4 8/32 brass acorn nuts 2.00
the amounts needed to create an item (recipe)
1 3.5 x3.5 inches copper sheet
1 3x3 inches copper sheet
1 2.5x2.5 inches copper sheet
9 inches of 1/8 inches brass rod
1 each 8/32 brass acorn nut
Also may include another recipe or Sub Recipe
This would need to deduct from supplies inventory,
Add to available inventory for sale and flag supplies that are or below the reorder point.
When the items are sold will need to calculate and post to the COGS as weighted Average Cost
I having a very difficult time trying to work out a design and processes to accomadate all involved.
For some reason I just keep running into walls with this.
I am doing this at no charge for this young lady that is just getting started but has evolved at a rate that she is
running out of stock which takes her time to restock because of shipping times to her door.
If you could be so kind to help me in any way to see the design/structure and processes need to accomplish this project I would be very thankful for you input.