Formulate and lp tableau and solve using excel solver turn


Formulate and LP tableau and solve using excel solver. Turn in your tableau formulation, excel table and solution reports from excel solver. Bob produces cattle, alfalfa, and com. He has 1000 acres of land and also has access to 5000 acres of public grazing land. For each head of cattle he earns $250 in profit. For each acre of alfalfa he earns $180, and for each acre of com he earns $220. Each head of cattle requires 0.1 acre of land out of his private land (1000 acres) and 5 Acres of public grazing land. Because of various technological requirements com acreage can be no more than 3 times the acreage of alfalfa. Due to government regulation, for each head of cattle he has to plant 2 acres of alfalfa and 3 acres of com (don't think of this as feeding requirement). Suppose that he buys the feed for his cattle from outside suppliers and the cost has been factored into the $250 per head profit. Everything he plants is sold for profit. Determine optimal mix of com, alfalfa, and cattle production.

Request for Solution File

Ask an Expert for Answer!!
Operation Management: Formulate and lp tableau and solve using excel solver turn
Reference No:- TGS01373904

Expected delivery within 24 Hours