Question: Using Excel Solver, please solve the 0-1 integer model for the recreation facility selection problem. Recall: 0-1 integer model example Recreation facilities selection to maximize

Using Excel Solver, please solve the 0-1 integer model for the recreation facility selection problem.

Using Excel Solver, please solve the 0-1 integer

Using Excel Solver, please solve the 0-1 integer

Recall: 0-1 integer model example Recreation facilities selection to maximize daily usage by residents. Resource constraints: 200,000 TL budget; 40 000 m2 of land. Selection constraint: either athletic field or gymnasium (not both). Recreation Facility Expected Usage (people/day) Cost (TL) Land Requirement (thousand m2) Swimming pool Tennis Center Athletic field Gymnasium 300 90 400 150 70,000 20,000 50,000 110,000 10 8 28 12 Recall: Recreation Project Integer Programming Model: Maximize Z = 300x1 + 90x2 + 400x3 + 150X4 subject to: 70,000x4 + 20,000x2 + 50,000x3 + 110,000x4 = 200,000 TL 10x1 + 8x2 + 28X3 + 12x4 S 40 (thousand m2) X3 + X4 S1 facility X1, X2, X3, X4 = 0 or 1 X1 = whether to construct a swimming pool or not x2 = whether to construct a tennis center or not x3 = whether to construct an athletic field or not X4 = whether to construct a gymnasium or not = =

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!