Question

In: Operations Management

Farming You operate three farms in Colorado. The acreage and irrigation water available for the three...

Farming

You operate three farms in Colorado. The acreage and irrigation water available for the three farms are shown below:

Water Available

Farm               Acreage          (acre feet)

1                      400                  1500

2                      600                  2000

3                      300                  900

Three crops can be grown. However, the maximum acreage that can be grown of each crop is limited by the amount of appropriate harvesting equipment available. The three crops are described below:

Total

Harvesting     Water                         Expected

Capacity         Requirements            Profit

Crop               (in acres)        (in acre-feet/acre)      (in $/acre)

Milo                700                  6                                  400

Cotton             800                  4                                  300

Wheat              300                  2                                  100

If any combination of crops can be grown on each farm (within the constraints) then what should you plant on each farm? What will the resulting profit be?

Please show and explain using excel

Solutions

Expert Solution

Below is the screenshot of the LP table -

Below is the screenshot of the formula applied -

Below is the screenshot of the solver -

Below is the screenshot of the result obtained -


Related Solutions

Organic Farms is considering an investment in a new irrigation system that will cost $65,000 and...
Organic Farms is considering an investment in a new irrigation system that will cost $65,000 and last for four years. The firm's cost of capital, appropriate for this project, is 8.00% per year. The incremental free cash flows for the irrigation project are as follows: Year Free Cash Flows 0 -$65,000 1 20,300 2 20,300 3 20,300 4 20,300 Compute the NPV for the project. Identify the correct formula used to solve the previous problem. Compute the IRR for the...
Mr. Agirich of Aggie Farms is thinking about investing in a center pivot irrigation system to...
Mr. Agirich of Aggie Farms is thinking about investing in a center pivot irrigation system to irrigate 100 acres of land. The irrigation system costs $70,000. Mr. Agirich expects that the irrigation system will increase yield and thus operating receipts by $15,000 per year but it will cost $4,000 a year to pay for electricity, maintenance, and additional labor. Mr. Agirich plans on keeping the irrigation system for 4 years before replacing it with a new one and he thinks...
Mr. Agirich of Aggie Farms is thinking about investing in a center pivot irrigation system to...
Mr. Agirich of Aggie Farms is thinking about investing in a center pivot irrigation system to irrigate 100 acres of land. The irrigation system costs $70,000. Mr. Agirich expects that the irrigation system will increase yield and thus operating receipts by $15,000 per year but it will cost $4,000 a year to pay for electricity, maintenance, and additional labor. Mr. Agirich plans on keeping the irrigation system for 4 years before replacing it with a new one and he thinks...
Mr. Agirich of Aggie Farms is thinking about investing in a center pivot irrigation system to...
Mr. Agirich of Aggie Farms is thinking about investing in a center pivot irrigation system to irrigate 100 acres of land. The irrigation system costs $70,000. Mr. Agirich expects that the irrigation system will increase yield and thus operating receipts by $15,000 per year but it will cost $4,000 a year to pay for electricity, maintenance, and additional labor. Mr. Agirich plans on keeping the irrigation system for 4 years before replacing it with a new one and he thinks...
A Rankine cycle power plant is being developed to operate an irrigation system. In this power...
A Rankine cycle power plant is being developed to operate an irrigation system. In this power plant solar energy will be used to boil a low boiling point fluid within glazed flat plate solar collectors. The working fluid that has been selected is the commonly used refrigerant R 134a (1, 1, 1, 2 tetrafluoroethane), tabulated properties of which may be found in Tables A11, A12 and A13 at the rear of the prescribed text. The plates being used for the...
A Rankine cycle power plant is being developed to operate an irrigation system. In this power...
A Rankine cycle power plant is being developed to operate an irrigation system. In this power plant solar energy will be used to boil a low boiling point fluid within glazed flat plate solar collectors. The working fluid that has been selected is the commonly used refrigerant R 134a (1, 1, 1, 2 tetrafluoroethane), tabulated properties of which may be found in Tables A11, A12 and A13 at the rear of the prescribed text. The plates being used for the...
Trout farming is a perfectly competitive industry and all trout farms have the same cost curves....
Trout farming is a perfectly competitive industry and all trout farms have the same cost curves. when the market price is $25 a fish, farms maximize profit by producing 200 fish a week. at this output, average total cost is $20 a fish and average variable cost is $15 a fish. minimum average variable cost is $12 a fish. i) If the price falls to $20 a fish, will a trout farm produce 200 fish a week. Explain why or...
A small water pump is used for an irrigation project. The pump takes water in from...
A small water pump is used for an irrigation project. The pump takes water in from a river at 10oC, 100 kPa at a mass flow rate of 16.83 kg/s. The exit line enters a pipe that goes up to an elevation 26.15 mm above the pump and river, where the water runs into an open channel. Assume the process is adiabatic and that the water stays at 10 oC. Find the required pump work.
. During droughts, water for irrigation is pumped from the ground. When ground water is pumped...
. During droughts, water for irrigation is pumped from the ground. When ground water is pumped excessively, the water table lowers. In California, lowering water tables have been linked to reduced water quality and sinkholes. A particular well in California’s Inland Empire has been monitored over many years. In 1994, the water level was 250 feet below the land surface. In 2000, the water level was 261 feet below the surface. In 2006, the water level was 268 feet below...
explain the water footprint impacts on environment, water stress for irrigation and industrial activities in oman
explain the water footprint impacts on environment, water stress for irrigation and industrial activities in oman
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT