Using Excel to Make the Production Plan

Excel is used very often, it is also very powerful. I think, how far you can imagine, how powerful it will be. The following is an example to use Excel to make production plan.
If your company’s products are assembly products, and you manufactures the sub-products and assemble the products. When you get order from customers, you need to compute how much sub-products are needed, so you can assign the manufacture plan inside and outsourcing plan.
How do you achieve this by Excel?
You establish a two dimension table:
AA BB CC
10 20 30 sub-product amount
A 1 1 0 30
B 1 0 1 40
C 0 1 1 50
The AA,BB and CC are assembly products in above table. The requirement for AA,BB and CC is 10,20 and 30. AA need 1 A and 1 B to assemble. BB need 1 A and 1 C to assemble. CC need 1 B and 1 C to assemble.
Then, you can calculate, you need 30 A, 40 B and 50 C.
To calculate the requirement for sub-products, you need to product two rows. You had better use the “SUMPRODUCT” function, it will become easy. You can know the detail of this function by searching on the internet