thanks

Farmer Jones operates an 800 acre irrigated farm in the Red River Valley of Arizona. Jones raises wheat, alfalfa, and beef. The Red River Valley Water Authority has allotted 500 acre feet to Jones for the following year. Jones expects that wheat will sell at S6 per bushel, alfalfa will sell at S140 per ton, and beef will sell at S250 per ton. Jones expects a wheat yield of 60 bushels per acre and an alfalfa yield of 4 tons per acre. Her miscellaneous expenses are S20 per acre of wheat, $30 per acre of alfalfa, and $50 per ton of beef. Each ton of beef requires 1 ton of alfalfa for feed. Resource usage by activity per acre is given by Water Land (Acre-ft) (Acres) Activity Plant Wheat (Acres) Aila (A) Raise Beef (Tons) 2.00 3.00 0.05 1.0 1.0 0.1 Jones' production problem was formulated as a linear program and was solved in Excel. Solver generated the following sensitivity result: Farmer Jones operates an 800 acre irrigated farm in the Red River Valley of Arizona. Jones raises wheat, alfalfa, and beef. The Red River Valley Water Authority has allotted 500 acre feet to Jones for the following year. Jones expects that wheat will sell at S6 per bushel, alfalfa will sell at S140 per ton, and beef will sell at S250 per ton. Jones expects a wheat yield of 60 bushels per acre and an alfalfa yield of 4 tons per acre. Her miscellaneous expenses are S20 per acre of wheat, $30 per acre of alfalfa, and $50 per ton of beef. Each ton of beef requires 1 ton of alfalfa for feed. Resource usage by activity per acre is given by Water Land (Acre-ft) (Acres) Activity Plant Wheat (Acres) Aila (A) Raise Beef (Tons) 2.00 3.00 0.05 1.0 1.0 0.1 Jones' production problem was formulated as a linear program and was solved in Excel. Solver generated the following sensitivity result