Decision variables.

The assignment should be done using Microsoft office 2010 not olden than that. Please this is important. I have attached all the requirements and go through it carefully and everything must be met. The five models must be done on 5 individual spreadsheets. The report must be address to Mr. Oscar and should be professional. The recommendations should be genuine and the calculations perfect. I Have attached an image of the constraints and how it must be to give a basic idea. please mention the constraints as told in the report clearly and explain each spreadsheet. the contribution of each part of the assignment has been mentioned in the attachment please work accordingly as that is the rubric's cube.

1. Decision variables
The decision variables in the five models will be the number of each type of golf hole
that is to be constructed.
2. Objective function
The objective function of the models is maximizing the total enjoyment index the golfers
will derive from the clubhouse and the golf holes’ configuration.
3. Constraints
These are the factors that hinder the implementation of the models. They are due to the
international set standards for a golf resort, the firm’s resource limitation or the
preference of the shareholders and/ or the managers. For the action plan constraints are
represented as mathematical equations.
4. Mathematical expression of the models
For the purpose of the mathematical expression lets have the variables;
y1=Straight par 5
y2=Dogleg par 5
y3=Straight par 4
y4 =Dogleg par 4
y5=Long par 3
y6=Short par 3
z1=Standard clubhouse
z2=Exclusive clubhouse
Standard Clubhouse
Max ; 2 y1 +1.5 y2+1.5 y3 +2 y4 +1.75 y5 +2.25 y6
subject ¿
5 y1+ 5 y2 +4 y3 +4 y4 +3 y5+ 3 y6 ≤ 72
5 y1+ 5 y2 +4 y3 +4 y4 +3 y5+ 3 y6 ≥ 70
y1 + y2+ y3+ y4 + y5 + y6=18
3 y1+ 3.5 y2+2 y3 +2.5 y4 + y5 +0.75 y6 +2 z1 ≤ 42
3 y1+ 3.5 y2+2 y3 +2.5 y4 + y5 +0.75 y6 +2 z1 ≥36

$ 1,000,000 y1 +$ 1,500,000 y2+ $ 750,000 y3 +$ 900,000 y 4 +$ 600,000 y5 +$ 650,000 y6 $ 3,500,000 z1 ≤=$
y1 ≥ 1
y2 ≥1
y3 ≥2
y4 ≥ 2
y5 ≥1
y6 ≥1
y1 + y2 ≤ 4
y3 + y4 ≤ 14
y5 + y6 ≤ 4
Exclusive clubhouse
Max ; 2 y1 +1.5 y2+1.5 y3 +2 y4 +1.75 y5 +2.25 y6 +4 z2
subject ¿
5 y1+ 5 y2 +4 y3 +4 y4 +3 y5+ 3 y6 ≤ 72
5 y1+ 5 y2 +4 y3 +4 y4 +3 y5+ 3 y6 ≥ 70
y1 + y2+ y3+ y4 + y5 + y6=18
3 y1+ 3.5 y2+2 y3 +2.5 y4 + y5 +0.75 y6 +4 z2 ≤ 42
3 y1+ 3.5 y2+2 y3 +2.5 y4 + y5 +0.75 y6 +4 z2 ≥ 36
$ 1,000,000 y1 +$ 1,500,000 y2+ $ 750,000 y3 +$ 900,000 y 4 +$ 600,000 y5 +$ 650,000 y6 $ 6,000,000 z2 ≤=$
y1 ≥ 1
y2 ≥1
y3 ≥2
y4 ≥ 2
y5 ≥1
y6 ≥1
y1 + y2 ≤ 4
y3 + y4 ≤ 14

y5 + y6 ≤ 4
1st Option
Max ; 2 y1 +1.5 y2+1.5 y3 +2 y4 +1.75 y5 +2.25 y6 +4 z2
subject ¿
5 y1+ 5 y2 +4 y3 +4 y4 +3 y5+ 3 y6 ≤ 72
5 y1+ 5 y2 +4 y3 +4 y4 +3 y5+ 3 y6 ≥ 70
y1 + y2+ y3+ y4 + y5 + y6=18
3 y1+ 3.5 y2+2 y3 +2.5 y4 + y5 +0.75 y6 +3.2 z2 ≤ 42
3 y1+ 3.5 y2+2 y3 +2.5 y4 + y5 +0.75 y6 +3.2 z2 ≥36
$ 1,000,000 y1 +$ 1,500,000 y2+ $ 750,000 y3 +$ 900,000 y 4 +$ 600,000 y5 +$ 650,000 y6 $ 6,000,000 z2 ≤=$
y1 ≥ 1
y2 ≥1
y3 ≥2
y4 ≥ 2
y5 ≥1
y6 ≥1
y1 + y2 ≤ 4
y3 + y4 ≤ 14
y5 + y6 ≤ 4
2nd Option
Max ; 2 y1 +1.5 y2+1.5 y3 +2 y4 +1.75 y5 +2.25 y6 +4 z2
subject ¿
5 y1+ 5 y2 +4 y3 +4 y4 +3 y5+ 3 y6 ≤ 72
5 y1+ 5 y2 +4 y3 +4 y4 +3 y5+ 3 y6 ≥ 70
y1 + y2+ y3+ y4 + y5 + y6=18
3 y1+ 3.5 y2+2 y3 +2.5 y4 + y5 +0.75 y6 +4 z2 ≤ 42
3 y1+ 3.5 y2+2 y3 +2.5 y4 + y5 +0.75 y6 +4 z2 ≥ 36

$ 1,000,000 y1 +$ 1,500,000 y2+ $ 750,000 y3 +$ 900,000 y 4 +$ 600,000 y5 +$ 650,000 y6 $ 5,100,000 z2 ≤=$
y1 ≥ 1
y2 ≥1
y3 ≥2
y4 ≥ 2
y5 ≥1
y6 ≥1
y1 + y2 ≤ 4
y3 + y4 ≤ 14
y5 + y6 ≤ 4
3rd Option
Max ; 2 y1 +1.5 y2+1.5 y3 +2 y4 +1.75 y5 +2.25 y6 +4 z2
subject ¿
5 y1+ 5 y2 +4 y3 +4 y4 +3 y5+ 3 y6 ≤ 72
5 y1+ 5 y2 +4 y3 +4 y4 +3 y5+ 3 y6 ≥ 70
y1 + y2+ y3+ y4 + y5 + y6=18
3 y1+ 3.5 y2+2 y3 +2.5 y4 + y5 +0.75 y6 +4 z2 ≤ 42
3 y1+ 3.5 y2+2 y3 +2.5 y4 + y5 +0.75 y6 +4 z2 ≥ 36
$ 1,000,000 y1 +$ 1,500,000 y2+ $ 750,000 y3 +$ 900,000 y 4 +$ 600,000 y5 +$ 650,000 y6 $ 6,000,000 z2 ≤=$
y1 ≥ 1
y2 ≥1
y3 ≥2
y4 ≥ 2
y5 ≥1
y6 ≥1
y1 + y2 ≤ 4
y3 + y4 ≤ 14

y5 + y6 ≤ 4