Part $1.$ Warehouse Space Allocation You are tasked with storing wheat, corn, and soybeans for a month across three warehouses, each with limited capacity. The goal is to maximize total profit $()$ by optimizing how many bushels of each crop to store in each warehouse. Each warehouse has a different storage capacity and holding cost per bushel, and each crop has a specific demand that must be met. Warehouse Available Space $($cubic feet$)$ Holding Costs Per Bushel $($$$)115,0000\mathrm{.}50212,0000\mathrm{.}75310,0000\mathrm{.}60$ Crop Space Per Bushel $($cubic feet$)$ Revenue Per Bushel $($$$)$ Total Demand $($bushels$)$ Wheat $281,000$ Corn $3101,500$ Soybeans $4128001)(8$ points$)$ Using the provided information regarding the warehouse capabilities and crop demands, calculate the optimal number of bushels of each crop to store in each warehouse. Use Excel$$s Solver to maximize total profit. Use an integer constraint to keep your decision variables as whole numbers. What is the optimal allocation of crops for each warehouse, and what is the maximum profit? $2)(3$ points$)$ Create a copy of your linear program that you created and solved in Question $1.$ Use an integer constraint to keep your decision variables as whole numbers. Suppose the total available space in Warehouse $2$ is reduced by $50\%.$ Modify your model, then resolve. How does this influence total profit and the allocation of crops for each warehouse in the baseline scenario in Question $1?$ Can you still meet the demand for all crops? $3)(3$ points$)$ Create a copy of your linear program that you created and solved in Question $1.$ Use an integer constraint to keep your decision variables as whole numbers. Suppose the demand for wheat increases by $200$ bushels, but the demand for corn decreases by $300$ bushels. Modify your model, then resolve. How does this affect your warehouse allocation and total profit? What is the new allocation of crops, and how does profit change from the baseline scenario in Question $1?$