This web page contains a live and functional spreadsheet created with
A developer has a plot of land available on which he can build. He can build either office units
or houses. Let
be the numbers of office units and
the number of houses to be built.
He decides to build:
at least 10 office units
at least 20 houses
Planning regulations prevent him from constructing more than 60 buildings in total.
Further, each office unit requires 400 squares metres and each house requires 200 square metres of land.
The total available area of the plot is 16000 square metres.
The builder makes a profit of £13,500 on each office unit and a profit of £9,500 on each house.
How many houses and how many office units should be built to maximise profits?
Enter two points for each constraint line to generate a plot in the window below.
You should choose points which clearly show the region formed by the constraints.
[No canvas support]
Starting with the corner point nearest the origin,
, enter the corner points in clockwise order:
Give your answers rounded to 2 decinmal places.
" based on your
Feasible Region Corner Points
Corner Point 1
Corner Point 2
Corner Point 3
Corner Point 4
The objective function is maximised at corner point number: