A farmer is planning his spring planting.He has 20 acres on which he can plant a combination of Corn,Pumpkins and Beans.He wants to maximize his profit but there is a limited demand for each crop.Each crop also requires fertilizer and irrigation water which are in short supply.The following table summarizes the data for the problem.
Crop Corn Pumplin Beans Profit per Acre $)2,1009001,050 Yield per Acre 1b) 21,00010,0003,500 Maximum Demønd lb) 200,000180,00080,000 Irrigation acre ft) 231 Fertilizer poundls/acre) 500400300
Suppose the farmer can purchase more fertilizer for $2.50 per pound,should he purchase it and how much can he buy and still be sure of the value of the additional fertilizer? Base your response on the following Analytic Solver Platform sensitivity output.
changing cills
Cell $ B$4$C$4$D$4 Name Acres of Corn Acres of Pumpkin Acres of Beans Final Value 9.52010.79 Reduced Cost 0−500.010 Objective Coefficient 2100899.991050 Allowable Increase 1E+30500.01210 Allowable Decrease 3501E+30375.00
Constraints
Cell $E$8$E$9$E$10$E$11 $F$12 Name Com demand Used Pumplin demand Used Bean demand Used Water Used Fertilizer IJsed Final Value 200000037777.7829.848000 Shadow Price 0.01700035 Constraint R.H. Side 20000018000080000508000 Allowable Increase 1360001E+301E+301E+303619.04 Allowable Decrease 15200018000042222.2220.153238.09
Definitions:
Mexican American
Referring to Americans of Mexican descent, often emphasizing their cultural, social, and economic experiences.
Anglo American
Pertaining to people, institutions, or culture derived from English or United States origins.
Asian
Pertaining to the largest and most populous continent, encompassing a wide variety of cultures, ethnicities, and languages.
Harlow
Refers to Harry Harlow, a psychologist known for his research on maternal separation and social isolation in rhesus monkeys.