Homefood is a company that serves lunch to kids in a local elementary school. Homefood wants to offer a nutritional, well-balanced diet for kids. It identified and analyzed 4 different food groups (1,2,3, 4) and determined the contributions a serving from each food group makes to 4 different nutritional categories (A, B, C, D), shown in the following table. The last two columns of the table show the minimum and maximum nutrients required daily for each kid. Maximum values of 9999 indicate that no maximum value applies to that particular nutritional requirement.

Nutrients	Food 1	Food 2	Food 3	Food 4	Lower Daily Limit	Upper Daily Limit
A	1.4	16.2	3.4	6.4	62	65
B	5.9	47.7	20.3	61.1	145	9999
C	108	0	6	5	140	9999
D	1	17.9	14.8	42.1	0	225
Cost per serving	$1.01	$0.97	$0.56	$1.28
Preference rating	18	4	17	58

Homefood uses the above information to design a diet (servings of each food group) that meets the indicated nutritional requirements. The last two rows of the table list the cost and the preference rating per serving of each food group, which represent two different objectives that can be pursued in creating a diet. First, we may want to identify the diet that meets the nutritional requirements at a minimum cost. Although such a diet might be very economical, it might also be very unsatisfactory to the tastes of the students. Another objective that could be pursued would be that of determining the diet that meets the nutritional requirements and produces the highest total preference rating. However, this solution is likely to be quite expensive.

Questions:
a) Formulate an MOLP model for this problem, and implement the model in a spreadsheet “Prob2a”. Determine the best possible value for each objective in the problem. Record both solutions. What is the lowest possible cost and the corresponding preference rating? What is the highest possible preference rating and the corresponding cost?
b) Determine the solution that minimizes the maximum weighted percentage deviation from the
optimal objective function values. Suppose Homefood considers minimizing the cost twice as important as maximizing the preference rating. Write the LP formulation and solve it using SOLVER or ASPE in sheet “Prob2b”. Describe your solution including the actual percentage deviation for each objective.

Answer rating: 100% (QA)

a a The MOLP model for this problem is Maximize Z 101x1 097x2 056x3 128x4 Subject to 14x1 162x2 34x3 ... View the full answer