In the general diet problem, the objective function is a minimization of profit obtained from selling the foods. Answer 3 4 5 6 7 8 9 Question 2: (40 Points) ALP model formulation and computer solution Problem statement A group of scouts is spending a few days in a remote hostel where the only foods available are the ones listed in the table below.
After consulting with a nutritionist, the group leader learned that a satisfactory diet has at least 2000 kcal of energy, egg of protein, and 800 MGM of calcium. The nutritionist also recommended supplementing with pills of vitamin and iron, which are available for free in the hostel. Since some of the scouts would be happy to subsist on 10 servings of beef and beans, the leader has decided to impose variety by having a limit on the number of servings/day for each of the six foods. The leader of the group wants to minimize the cost of feeding his group while satisfying minimum nutrition requirements.
Serving Size Energy (Kcal) Protein Calcium (MGM) Price Cents/serving Limit Serving ‘day Oatmeal 110 Chicken 1 cog 205 32 12 24 Eggs Large 160 13 Whole Milk CHIC 285 Cherry Pie egg 420 20 Beef & Beans egg 260 14 19 a. Formulate a linear programming model to minimize the cost per scout per day. (20 Points) b. Solve the using Excel Solver. The formulas in the LASH of the constraint must be formatted correctly for copying down. (1 5 Points) c. Print the solution sheet and the formula sheet formatted according to the standard computer printout requirements. Make sure your name is in the heading of each sheet. 5 Points). Decision Variables XSL = Number of Oatmeal servings per day to feed to each scout. 2 = Number of Chicken servings per day to feed to each scout. Xx = Number of Eggs servings per day to feed to each scout. XSL = Number of Whole Milk servings per day to feed to each scout. Xx = Number of Cherry Pie servings per day to feed to each scout. Xx = Number of Beef & Beans servings per day to feed to each scout. *** Another correct answer is to model decision variables per gram, egg, etc. In that case, for the rest of the model, the numbers have to be divided by the serving size.