can you make the solution for this linear programming problem to solve it in excel?

A number of power stations are committed to meeting the following electricity load

demands over a day:

There are three types of generating units available: $$ of type $1,10$ of type $2,$ and $5$ of type

Each generator has to work between a minimum and asmaximum level.

There is an hourly cost of running each generator at minimum level. In addition there is an

extra hourly cost for each megawatt at which a unit is operated above minimum level. To

start up a generator also involves a cost. All this information is given in the table $($with costs

in eura$)$:

In addition to meeting the estimated load demands there must be sufficient generators

working at any time to make it possible to meet an increase of load of up to $15\%.$ This

increase would have to be accomplished by adjusting the output generators already

operating within their permitted limits$.$

A few things to consider:

the demand must be met at every moment of the day!

two generating units of type $1$ at level $1000$ is the same as one generating unit at level

$850$ and the other at $1150?$

From a certain type of generator they are all identical: so it doesn't matter if unit $7$ of

type two is working or unit $9$ of type two

it is a repeating schedule: after $6$ p$.$m$.-12$ p$.$m$.$ the next period is again $12$ p$.$m$.-6$ a$.$m$.$

to get a feeling for the problem start with puzzling and finding a solution before you start

modelling

model building starts on paper, not sitting behind the computer!

don't be afraid to define many variables: it is convenient to define $($extra$)$ variables for

the production above minimum level

Report

Yourteport should contain:

If required in the assignment: the chosen values of the parameters!

A written out $($mathematical$)$ LP$-$model with the definition of the decision variables

and explanation of the constraints.

A global explanation how your Excel model is constructed $($together with the model

in Excel itself$)$ and a global explanation of the Solver part. For my convenience: use

yellow for the objective cell, green for cells with a formula and orange for the cells of

the decision variables!

An understandable presentation of your solution in the report. How much generators

of what type are working and started up during the day? How much electricity is

produced by each group of generators? What costs are made during the day and in

how much in total?

What would be the saving in total cost of skipping the $15\%$ reserve output

guarantee?

General tips on the use of the Excel Solver:

Sometimes in the definition of variables, Excel Solver use a$,($comma$)$ as separator of

areas of variables, but sometimes a ; $($semicolon$).$ This depends on your Excel

configuration!

If your model requires integer or binary variables: this is done via a constraint in the

Solver. With Integers: try a change in Options of the Integer Optimality $(\%)$ in $0\mathrm{.}01!$