Shopping list/ Bill of materials

[dimbasco]

I guess my first post was way too long and complex.. I'll give it one more shot:

I have a list of Products:

Oranges
Apples
Multipack - 1
Bananas
Pears
Multipack - 2

I can sell Oranges, Apples, Bananas and Pears individually.
Multipacks contains the following:

Book1
	A	B	C	D	E
1		Oranges	Apples	Bananas	Pears
2	Multipack-1	2	2
3	Multipack-2		1	2
4	Multipack-3	1	1	1	1
Sheet1

Customer places an order for:
10 units Oranges
5 units Bananas
2 units Multipack - 2
1 unit Multipack - 1

IS there a way to calculate exactly how many of the following I need?
Oranges
Apples
Bananas
Pears

 

[just_jon]

Oh, I think it can be done in Excel, just that the formula sets might gag the machine.

Take fairwind's solution and apply it to a range of data at least large enough to handle your needs and see what happens, maybe?