Question: Do It in Excel & share formula too ! 3.5-5.* Fred Jonasson manages a family-owned farm. To supple- ment several food products grown on the

Do It in Excel & share formula too !

Do It in Excel & share formula too ! 3.5-5.* Fred

Do It in Excel & share formula too ! 3.5-5.* Fred

3.5-5.* Fred Jonasson manages a family-owned farm. To supple- ment 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 nutri- tional 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: Nutritional Ingredient Kilogram Kilogram Kilogram Minimum of of of Daily Corn Tankage Alfalfa Requirement Carbohydrates Protein Vitamins 90 30 10 20 80 20 40 60 60 200 180 150 Cost $2.10 $1.80 $1.50 (a) Formulate a linear programming model for this problem. (b) Display the model on an Excel spreadsheet. (e) Use Solver to solve the model by the simplex method

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!