Mary loves ham and vegetable. Therefore, she has decided to go on a steady diet of only these two foods (plus some liquids and vitamin and supplements) for all her meals. She realizes that this isn’t the healthiest diet, so she wants to make sure that she eats the right quantities of the two foods to satisfy some key nutritional requirements. She has obtained the following nutritional requirement. She has obtained the following nutritional and cost information.

	Grams of Ingredient per Serving
	Ham	Vegetable	Daily Requirement
Carbohydrates	6	15	_<45
Protein	25	5	_>46
Fat	11	2	_<72
Cost per Serving	$6	$9

Mary wishes to determine the number of daily servings (may be fractional) of ham and vegetable that will meet this requirement at a minimum cost.

(a) Identify decision variables, objective function, and constraints and explain them in words, using at least 100 words. Keep in mind that you are not providing equations in part (a) and make sure you explain this in words.

(b) Formulate a mathematical linear programming model using equations.

(c) Solve a linear programming model for this problem on a spreadsheet, and interpret the results (meaning what is the optimal amount of daily serving for ham and vegetable, and what is the minimum cost at the optimal amount of servings of ham and vegetable?)? Answer this using at least 100 words. Please make sure you also need to provide results from your excel solver model and attach it separately.

Answer rating: 100% (QA)

a Decision variable H indicates the number of daily servings of Ham and V indicates the number of s... View the full answer