Skip to main content

Bill of Materials (BOM) with AnyDB

Overview​

The "Bill of Materials - BOM" template provides a structured and dynamic way for businesses to list and manage all components required to manufacture a product. It automates cost calculations and offers a clear view of materials, making it indispensable for production and inventory planning. Additionally, users can decide strategically if it is a better cost efficient option, to make or outsource a particular component production of your product.

Business Problem​

Imagine a company that manufactures custom-designed wooden chairs. To build a single "Wooden Chair", manufacturer would use a Bill of Materials (BOM) to outline everything needed for its creation. Additionally, the company can manage and scale its product portfolio.

Solution Summary​

By using our BOM template, the company can:

  • Order precisely: Know exactly how many components are needed to mount a product.
  • Optimise costs: Determine the manufacturing cost per product, helping with pricing and profitability.
  • Streamline assembly: Provide clear instructions and component lists to the assembly team.
  • Share it externally: Provide relevant data to suppliers and other business partners.

Template structure​

Bill of Materials (BOM)

Step-by-Step Instructions​

Step 1: Set up your database​

  1. Click on the three dots
  • Select + new database
  • Type a database name and click on add
  1. Go to your new database and click on + New

Bill of Materials (BOM)

  1. Search for: "BOM" and click on it

Bill of Materials (BOM)

As shown in the next image, you can:

  • Add final product images
  • Type the assembly name
  • Type the responsible name
  • And set up the BOM level which means final product or a component that needs subcomponents.

Bill of Materials (BOM)

Step 2: Add all components that do not have subcomponents​

As shown in the image below, go to the part: "components without subcomponents"

  1. Click on the cell and attach an image of component
  2. On label, type the component name
  3. Type the ID code of each component
  4. Type quantity and unit cost of each one

Bill of Materials (BOM)

Step 3: Add BOM level for components with subcomponents​

If you have got components that need subcomponents to be assembled, than you:

  1. Go to + add and select BOM template
  2. Click on the cell that informs: "double click to select"
  3. Select another BOM template item
  4. Add components information

If in your case, you only mount the final product and therefore, there is no need for subcomponent items, you can:

  1. Optionally delete the first table (components with subcomponents).
  2. Review the formula/functions (consult: AnyDB Formula Reference)

Sharing & Collaboration​

  • Assign task ownership and task-level responsibility
  • Collaborate in real time with team-based access and permissions

Tips & Best Practices​

  • Use color-coded priority fields to flag high-risk tasks
  • Add follow-up dates for key milestones or reviews
  • Use folders or tags to group projects by type or initiative
  • Use Pages for unstructured notes, retrospectives, or planning docs

Why Use AnyDB for File Sharing​

BenefitHow AnyDB Supports It
Unified StorageStore files alongside business records and documents
Fine-Grained SharingPublic, guest, and team-based permissions
Built-In PreviewsView PDFs, images, videos, and docs inside AnyDB
Structured MetadataAdd tags, links, and notes directly to files
Scalable OrganizationUse folders and custom templates to group related files
Unlimited Public SharesShare securely without login (based on access level)

Pro Tip: Clone