Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The answer must be given in Excel format. Can you please check if my work (shown below) is correct? If not, please explain why. 3-14.
The answer must be given in Excel format. Can you please check if my work (shown below) is correct? If not, please explain why.
3-14. Farm Management. A firm operates four farms of comparable productivity. Each farm has a certain amount of usable acreage and a supply of labor hours to plant and tend the crops. The data for the upcoming season are shown below. LABOR HOURS AVAILABLE PER MONTH FARM USABLE ACREAGE 500 900 300 700 1700 3000 900 2200 The organization is considering three crops for planting. These crops differ primarily in their expected profit per acre and in the amount of labor they require, as shown below MONTHLY LABOR HOURS REQUIRED PER ACRE EXPECTED PROFIT PER ACRE (S) CROP MAXIMUM ACREAGE 500 200 300 700 4 300 Furthermore, the total acreage that can be devoted to any particular crop is limited by the associated requirements for harvesting equipment. In order to maintain a roughly uniform workload among the farms, management's policy is that the percentage of usable acreage planted must be the same at each farm. However, any combination of the crops may be grown at any of the farms as long as all constraints are satisfied (including the uniform-workload requirement). Management wishes to know how many acres of each crop should be planted at the respective farms in order to maximize expected profit. Formulate this as a linear programming model and solve itStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started