Results 1 to 5 of 5
  1. #1
    Goyooper is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2019
    Posts
    4

    Access database design for a small handmade manufacturing business

    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.

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,852

  3. #3
    Bullschmidt's Avatar
    Bullschmidt is offline Freelance DB Developer
    Windows 10 Office 365
    Join Date
    Mar 2020
    Location
    USA
    Posts
    64
    And here's a link that could be useful:
    Inventory Control: Quantity on Hand
    http://www.allenbrowne.com/AppInventory.html

  4. #4
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    21,212
    Post 3 was moderated, I'm posting to trigger email notifications. The link doesn't look valid though.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    Bullschmidt's Avatar
    Bullschmidt is offline Freelance DB Developer
    Windows 10 Office 365
    Join Date
    Mar 2020
    Location
    USA
    Posts
    64
    The link doesn't look valid though.
    Oops sorry - fixed it...

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 12-06-2017, 07:59 AM
  2. Best way to design this small database
    By Angiec in forum Database Design
    Replies: 6
    Last Post: 01-08-2016, 03:14 PM
  3. Replies: 7
    Last Post: 05-27-2015, 07:11 AM
  4. A Challenging Database Design for Manufacturing Process.
    By cap.zadi in forum Database Design
    Replies: 6
    Last Post: 11-10-2012, 11:31 AM
  5. Small Business Question
    By P5C768 in forum Access
    Replies: 1
    Last Post: 09-28-2009, 08:27 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums