I am not able to understand the above solution. Can you please help me ? What are the constraint? What is the solution Equation with graph or Can i get solution in Excel solver

A farm owner in Des Moines, Iowa, is interested in determining how to divide the farmland among the four different types of crops. The farmer owns two farms in separate locations and has decided to plant the following four types of crops in these farms: Corn, Wheat, Bean, and Cotton. The first farm consists of 1450 acres of land, while the second farm consists of 850 acres. Any of the four crops may be planted on either farm. However, after a survey of the land, based on the characteristics of the farmlands, the table below shows the maximum acreage restrictions the farm owner has placed for each crop.

Farm	Corn	Wheat	Bean	Cotton
Farm 1	550	450	350	400
Farm 2	250	300	200	350

The profit per acre for each crop is estimated as follows:

Crop	Profit/Acre
Corn	$500
Wheat	$400
Bean	$300
Cotton	$350

In determining the optimal land cultivation, the farm owner has to account for the cost of fertilizer estimate for each acre of land. Due to the different terrain and soil, the two farms have different costs of fertilizer per acre.

Farm	Cost Of Fertilizer/Acre
Farm 1	$100
Farm 2	$70

Seasonal demand for the four crops:

Crop	Seasonal demand (acres worth)
Corn	450
Wheat	550
Bean	400
Cotton	600

The farm owner has a storage facility that can store 100 acres of excess supply of different crops. In addition, the farm owner wants to ensure the total wheat and

bean cultivation must be proportionally equal to the maximum acreage restrictions of both the farms.

Required:

Develop a linear programming model that will enable the farm owner to determine the optimal plantation of each crop on each farm to maximize the profit.

Formulate this problem as an LP problem and solve it by computer procedure.

Analyze the sensitivity report of the problem and describe the reduced cost, dual values, and allowable limits.

Create a managerial report for submission to the farm owner. Provide snapshots of your solutions in your report for more clarity.