Three seller offers three foods, which contain three different nutrients. We are given Table 3 with the nutritional content of a unit of each food, the minimum requirement of each nutrient, and the selling price for a unit of each food. I want to design a diet so as to satisfy the minimum requirement of the nutrients and minimize the total price to purchase the food in the diet. 

How do I solve this Linear Programming problem with excel AND obtain a sensitivity report?

 

Transcribed Image Text:

Carbohydrates Fat Protein Unit Price Burger Fried Rice 4 3 4 5 Pizza Minimum Requirement 3 3 2 4 4 Table 3: Food 3 2 3 12 8 20 Carbohydrates Fat Protein Unit Price Burger Fried Rice 4 3 4 5 Pizza Minimum Requirement 3 3 2 4 4 Table 3: Food 3 2 3 12 8 20

Answer rating: 100% (QA)

Decision Variables Let x number of burgers y number of fried rice z number of pizza Objective is to ... View the full answer