Linear programming and excel to satisfy requirements
Not what you're looking for?
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?
Purchase this Solution
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.
Solution Preview
Hi,
Please refer attached files for complete details on your ...
Purchase this Solution
Free BrainMass Quizzes
Geometry - Real Life Application Problems
Understanding of how geometry applies to in real-world contexts
Multiplying Complex Numbers
This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.
Exponential Expressions
In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.
Know Your Linear Equations
Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.
Solving quadratic inequalities
This quiz test you on how well you are familiar with solving quadratic inequalities.