In Need of an excel expert.

I want to make a inventory management excel sheet for T-shirt manufacturing. Need a products page , raw materials with different sizes column, a bill of materials sheet and an order sheet. I want the entries to be calculated based on sales and purchase. I have a mock excel spreadsheet for reference. Either that mock excel sheet can be adjusted to the liking or can be used as a base to create a new one. In T-shirt manufacturing one t-shirts design will be printed on various sizes i.e. xs, s,m,l,xl,xxl,xxxl. So the way i want is for example. In raw materials column if i enter gents white tshirt. The in number of tshirt should be entered in the size column and the total should be calculated at the end. The size column is important as this will avoid multiple entries of same design. A damage column is also required as when preparing few t-shirts gets damaged. In the bill of materials sheet i want a damage column and once an entry is made it should be calculated and it should be subtracted. The damage column should also have size chart. For example. If i entry 5 damage pcs in the L size Column of the damaged column or damaged spreadsheet. It should get adjusted in the bill of materials. The excel sheet i have doesn’t have size columns. You can use it as a reference and /or change it accordingly to my liking. Most of the formulas are already entered in the excel sheet that i have. If you can change that no problem but if changing is too complicated and making a new one is easier for you , we will go with that.

Please respond. Thank you.

Karan singhaal