Explore BrainMass

Linear programming and excel to satisfy requirements

Please take a look at my attachment.

Please include the solutions and how you arrived at answers to this question.

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?


Solution Preview


Please refer attached files for complete details on your ...

Solution Summary

The math formulation is given in word file and optimal solution using Excel Solver is in excel file.
Explanations are given in detail, step-by-step.