Reference no: EM131693009
The Student Center is preparing a special breakfast to attract veterans to the university. The School's dieticians have decided to serve four items: eggs, toast, sausage, and orange juice (plus coffee). The dieticians have set the minimum vitamin and calorie requirements, and minimum servings sizes, for the breakfast as follows:
Vitamin content per unit (Per Gram):
Vitamin Eggs Toast Sausage Orange Juice Minimum Requirement
A 3 2 1 0 400 Grams
B 2 1 2 0 500 Grams
C 1 0 0 4.5 700 Grams
Total Calories 2 3 3.2 3.6 1000 Calories
Minimum serving Size (Grams)
Eggs Toast Sausage Orange Juice
125 100 70 125
If the unit costs are $0.005 per gram of eggs, $0.003 per gram of of toast, $0.015 per gram of sausage, and $0.01 per gram of orange juice, use excel/solver to find the least-cost (minimal) solution for a breakfst that meets all the requirement for vitamins, calories, and serving sizes. Create a formulation section, data table section, and model section for decision variables, objective function, and LHS and RHS columns of constraints. Find the optimal menu solution with Solver and write a statement about what the total cost, servings sizes, and calorie count will be.
Please inlcude Excel formulas