Optimization

[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!

 

[Fluff]

Duplicate to: Optimization Calculator

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.