Can anyone help me in setting up and solving a minimization problem with Excel Solver?

Question

A hospital has 6 wings and 3 food serving stations. Each station has a set capacity and each wing has a certain number of patients to be fed. The problem only gives the number of minutes it takes for each station to deliver to each wing. I need help setting up the problem to use Solver to figure out which station should deliver what amount of meals to which wings. If you are good with Excel solver and would like to help, please post your email address so that I can send you all the data for the problem. Thanks.

Answer 1

Try this link to see if it will help you:

http://www.accountingweb.com/cgi-bin/item.cgi?id=101369&d=815&h=817&f=816&dateformat=%25B+%25e,+%25Y