(a) Formulate a goal programming model for this problem.

(b) Reformulate this model as a linear programming model.

(c) Use the Excel Solver to solve this model. (Take print screen of your Excel solution)

(d) Now suppose that the government concludes that the importance of the various goals differs greatly so that a preemptive goal programming approach should be used. In particular, the first priority goal is citizens fed >= 1,750,000, the second-priority goal is foreign capital >= $70,000,000, and the third-priority goal is citizens employed d = 200,000. Use the goal programming technique to formulate one complete linear programming model for this problem.

(e) Use the streamlined procedure to solve the problem as formulated in part (d).

(f) Use the sequential procedure to solve the problem as presented in part (d).

PLEASE DONT COPY AND PASTE THE ANSWERS THAT ALREADY EXIST IN CHEGG,

THIS IS NOT THE SAME QUESTION THAT'S WHY I POST AGAIN!

Montega is a developing country which has 15,000,000 acres of publicly controlled agricultural land in active use. Its government currently is planning a way to divide this land among three basic crops (labeled 1, 2, and 3) next year. A certain percentage of each of these crops is exported to obtain badly needed foreign capital (dollars), and the rest of each of these crops is used to feed the populace. Raising these crops also provides employment for a significant proportion of the population. Therefore, the main factors to be considered in allocating the land to these crops are (1) the amount of foreign capital generated, (2) the number of citizens fed, and (3) the number of citizens employed in raising these crops. The following table shows how much each 1,000 acres of each crop contributes toward these factors, and the last column gives the goal established by the government for each of these factors. Factor Contribution per 1,000 Acres Crop: 1 2 3 $3,000 $5,000 $4,000 150 75 100 10 15 12 Goal Foreign capital Citizens fed Citizens employed 2570,000,000 2 1,750,000 - 200,000 In evaluating the relative seriousness of not achieving these goals, the government has concluded that the following deviations from the goals should be considered equally undesirable: (1) each $100 under the foreign-capital goal, (2) each person under the citizens fed goal, and (3) each deviation of one (in either direction) from the citizens-employed goal. (a) Formulate a goal programming model for this problem. (b) Reformulate this model as a linear programming model. (c) Use the Excel Solver to solve this model. (Take print screen of your Excel solution)