Optimization Calculator

[Holden_looper]

I have a list of diffrent size hoods for my restaurants and a list of fryers, grill, and food transfer station sizes and want to make a tool on excel that will tell me how many fryers I can fit into a hood when I type in how big the hood is. I.e my main fryer is 18in, I have a narrow fryer that is 13.5 in, and food transfer station that is 17 in and I have to have 2 grills that are each 12.5 in. I have a long list of hood sizes but what to make a optimization tool that I can put in a number like 150in and it would tell me I can put X amount of fryers, 2 grills and X amount of transfer station. If you can help with this it would be really appreciated!

 

[Kerryx]

Solver may help

Book1
	A	B	C	D
1	Item	Item size	No Items	Total Size
2	Mfry	18	0	0
3	Nfry	13.5	0	0
4	FTS	17	0	0
5	Grill	12.5	0	0
6				0
Sheet2

Cell Formulas
Range	Formula
D2:D5	D2	=C2*B2
D6	D6	=SUM(D2:D5)

Named Ranges
Name	Refers To	Cells
solver_adj	=Sheet2!$C$2:$C$5	D2
solver_lhs1	=Sheet2!$C$2	D2
solver_lhs2	=Sheet2!$C$2:$C$5	D2
solver_lhs3	=Sheet2!$C$3	D3
solver_lhs4	=Sheet2!$C$4	D4
solver_lhs5	=Sheet2!$C$5	D5
solver_lhs6	=Sheet2!$C$5	D5
solver_lhs7	=Sheet2!$C$5	D5
solver_lhs8	=Sheet2!$C$5	D5