Need your help

[Etibar]

I have a list of row materials.for example: 100kg tobacco,100kg filters,100kg paper.
I know that to produce 1 pack of cigarette i need to have 0.001kg filter,0.001 tobacco and 0.001 paper.

What formula should i put there,so that i could see how many cigarettes can i produce with row materials that i have on hand?

Thank you

 

[mole999]

if you divided each 100kg by 0.001kg then picked the min value, then you would be able to see how many you could make from the minimum value

Excel Workbook
	A	B	C	D
1	100	100	100
2	0.001	0.001	0.001
3	100000	100000	100000	100000
Sheet1

 

[JLGWhiz]

If you have your raw material listed in column A, the available amounts of the materia in column B and the amount of each material to produce 1 unit of product in column C, then in D1

=INT(MIN(B1/C1, B2/C2, B3/C3))

This is based on the fact that the most you can produce is what you have material to use in manufacturing.

 

[Etibar]

Thanks man.you are genius.

 

[Etibar]

Thank you)