USA: +1 (725) 712-1730
USA: +1 (725) 712-1730

Question & Answer: PLEASE SOLVE USING EXCEL AND SOLVER AND TAKE A SCREEN…..

PLEASE SOLVE USING EXCEL AND SOLVER AND TAKE A SCREEN SHOT AND UPLOAD THE PICTURE THANK YOU!!!!!!!!!!!!!!!!! ANSWER NUMBER 4 A) B) AND C)

You would like to make a nutritious meal of eggs, mixed vegetables and brown rice. The meal should provide at least 35 g of carbohydrates, at least 25 g of protein, and no more than 45 g of fat. One serving of eggs contains 2 g of carbohydrates, 18 g of protein, and 12 g of fat. A serving of mixed vegetables contains 14 g of carbohydrates, 15 g of protein, and 8 g of fat. A serving of rice contains 40 g of carbohydrates, 6 g of protein, and 1 g of fat. A serving of eggs costs $2, a serving of mixed vegetables costs $4, and a serving of rice costs $3. Formulate a linear optimization model that could be used to determine the number of servings of eggs, mixed vegetables, and rice for your meal that meets the nutrition requirements at minimal cost. (You do not need to find the optimal solution to the model

Expert Answer

The decision variable in Green
The constrains are in Blue
And the objective function is in Orange

On solving:

Eggs Mixed Veg Brown Rice
Carbohydrates 2 14 40
Protein 18 15 6
Fat 12 8 1
Cost 2 4 3
Decision Variable No of serving 4 0 1
Constrains min requirement 48 >= 35 Carbohydrates
78 >= 25 Protein
49 >= 45 Fat
Objective functions Total cost 11 Minimize

Hint: Use the sumproduct formula for cost and constrain.

A,B,C (all are answered in the above sheet)

Still stressed from student homework?
Get quality assistance from academic writers!
Order now