This web page contains a live and functional spreadsheet created with
SpreadsheetConverter
. Please enable JavaScript in your web browser for the live calculations to work properly.
CALCULATING THE MERIT ORDER
Welcome to the Merit Order Model for Week 1. In this model, you are the owner of a power production company have 6 generation units: Coal, OCGT, CCGT, Nuclear, Wind and Solar.
Each of these units have a capacity of 500MW. You can bid these units at the marginal cost, which depends on the price of the fuel of the given generation unit. You can change
the boxes highlighted in orange to change the marginal cost of the generation units. This can be used to answer the questions on the EdX page.
INPUT
#
DESCRIPTION
PRICE (€/MWh)
CAPACITY (MW)
PRICE OF COAL (€/ton)
PRICE OF GAS (€/m3)
PRICE OF NUCLEAR (€/kg)
1
Coal
500
2
Gas (OCGT)
500
3
Gas (CCGT)
500
DEMAND (MW)
4
Nuclear
500
5
Wind
0.00
500
6
Solar
0.00
500
FINAL MERIT ORDER
#
DESCRIPTION
PRICE (€/MWh)
CAPACITY (MW)
Print All Information
Please host the converted page in server to use Print All.
Update
Reset
Print All
Submit