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)
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?
Please refer attached files for complete details on your ...
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.