Problem:
Linear programming and excel to satisfy requirements
A huge restaurant is preparing their food service for spring. The preparation requires to buy seafood, vegetables and meat in at least the amounts which given in the following table.
Food Minimum weight (lb)
Seafood 12
Vegetable 14
Meat 16
The food content and prices per 100 pounds is given in the following table. There is virtually unlimited supply of each kind of food.
Food Seafood Vegetable Meat
Content (lb) Content (lb) Content (lb) Price ($)
A 20 10 5 10
B 10 5 15 8
C 14 10 5 7
Please use EXCEL to solve the following question.
How much of each kind of food should be purchased to satisfy the requirements at minimum cost?