Question 2

Fred Jonasson manages a family-owned farm. To supplement several food products grown on the

farm, Fred also raises pigs for market. He now wishes to determine the quantities of the available

types of feed (corn, tankage, and alfalfa) that should be given to each pig. Since pigs will eat any

mix of these feed types, the objective is to determine which mix will meet certain nutritional

requirements at a minimum cost. The number of units of each type of basic nutritional ingredient

contained within a kilogram of each feed type is given in the following table, along with the

daily nutritional requirements and feed costs:

Kilogram Kilogram Kilogram

of

of

of

Ingredient Corn Tankage

Nutritional

Alfalfa

Carbohydrates 90

Protein

30

Vitamins

10

Cost

$2.10

20

80

20

$1.80

40

60

60

$1.50

Minimum

Daily

Requirement

200

180

150

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

(b) Obtain the optimal solution using Microsoft Excel Solver and Python Solver. Attach the

completed Excel and Python files containing the codes and solutions.