Bill of materials - Production planning

[Shmuel_Israeli]

I have products each product can have parts (name + quantity) or can be a bundle of parts (name + quantity).
I would like to create a production planning for a week.
I would like to create a view of all row material I need for the production of the current week.

For example Product 1,2,3 are simple product, Product 4 is a bundle product consists of products 2(qty 1),products 3(qty 2).

In the current week I need to create 10 products of Product 1 and 10 of product 4.
The report should show me:product 1 10, product 2: 10 and product 3: 20

Is it possible to implement it in Airtable?

Thank you,

Sam

[Kamille_Parks]

It sounds like you could repurpose this example meal planner base I made:

Airtable

Ultimate Meal Planner - Airtable Universe

This meal planner base has it all! Shopping list generator, recipe page builder, support for "sub-recipes", you name it. Mix-and-match entrees and side...

^ The base structure lets you create a recipe (Product), and each recipe can include ingredients (Parts) which have their own recipe. The Meals (Production Planning) table will let you describe which products you’re making on a particular day, and the Shopping List view in the Ingredients table will show the quantities of each ingredient (Part) you’ll need for the current week.

[Shmuel_Israeli]

Thank you Kamille_Parks.