ASSIGNMENT WEIGHTING: 50% There are five parts to this assignment (A-E). You must answer four out of five parts. Each Part completed is worth 12.5%. Your submission should be prepared in one document....




ASSIGNMENT WEIGHTING: 50%



There are five parts to this assignment (A-E). You must answer four out of five parts. Each Part completed is worth 12.5%. Your submission should be prepared in one document.



If you wish to submit supplementary work you can add it to the appendix or upload separately to Brightspace. However, I would expect all major items of the report to be included in the main document.



The document should be prepared professionally using the Harvard referencing system. A guided word count is given beside each question.







Sheet1 Day-ahead Price [EUR/MWh] 2/1/2023 - 00-1 2/1/2000 - 01-5 2/1/2001 - 02-4.66 2/1/2002 - 03-5 2/1/2003 - 04-5.01 2/1/2004 - 05-5.01 2/1/2005 - 06-5.21 2/1/2006 - 07-5.1 2/1/2007 - 080 2/1/2008 - 096.2 2/1/2009 - 1026 2/1/2010 - 1134.3 2/1/2011 - 1235.63 2/1/2012 - 1334.9 2/1/2013 - 1433.97 2/1/2014 - 1534.92 2/1/2015 - 1630.08 2/1/2016 - 1742.64 2/1/2017 - 1870 2/1/2018 - 19106.78 2/1/2019 - 2085 2/1/2020 - 2175 2/1/2021 - 2256.85 2/1/2022 - 2348 2/2/2023 - 0044.38 2/2/2000 - 0145.34 2/2/2001 - 0245.19 2/2/2002 - 0341.8 2/2/2003 - 0439.54 2/2/2004 - 0534.73 2/2/2005 - 0627.21 2/2/2006 - 0724.8 2/2/2007 - 0824.8 2/2/2008 - 0925 2/2/2009 - 1028.99 2/2/2010 - 1135 2/2/2011 - 1232.7 2/2/2012 - 1333.51 2/2/2013 - 1432 2/2/2014 - 1527.77 2/2/2015 - 1627.77 2/2/2016 - 1735 2/2/2017 - 1855.65 2/2/2018 - 1951.07 2/2/2019 - 2037.42 2/2/2020 - 2132.7 2/2/2021 - 2224.8 2/2/2022 - 2316.96 2/3/2023 - 0014.82 2/3/2000 - 0114.48 2/3/2001 - 0213.1 2/3/2002 - 033.3 2/3/2003 - 043.2 2/3/2004 - 055 2/3/2005 - 0622.64 2/3/2006 - 0727.19 2/3/2007 - 0835.5 2/3/2008 - 0939.56 2/3/2009 - 1039.1 2/3/2010 - 1134.82 2/3/2011 - 1233.98 2/3/2012 - 1335.69 2/3/2013 - 1431.51 2/3/2014 - 1531.7 2/3/2015 - 1634.65 2/3/2016 - 1744.74 2/3/2017 - 1856.62 2/3/2018 - 1955 2/3/2019 - 2043.4 2/3/2020 - 2135 2/3/2021 - 2230.69 2/3/2022 - 2324.92 2/4/2023 - 0020.29 2/4/2000 - 0116.98 2/4/2001 - 020.69 2/4/2002 - 030 2/4/2003 - 040 2/4/2004 - 050 2/4/2005 - 060 2/4/2006 - 0720.06 2/4/2007 - 0830.81 2/4/2008 - 0943.09 2/4/2009 - 1038 2/4/2010 - 1136.28 2/4/2011 - 1232.94 2/4/2012 - 1338.21 2/4/2013 - 1438.88 2/4/2014 - 1539.19 2/4/2015 - 1638.21 2/4/2016 - 1755.39 2/4/2017 - 18111 2/4/2018 - 19153.37 2/4/2019 - 20100 2/4/2020 - 2178.01 2/4/2021 - 2267.08 2/4/2022 - 2343.75 2/5/2023 - 0039.06 2/5/2000 - 0134.85 2/5/2001 - 0235.82 2/5/2002 - 0335.21 2/5/2003 - 0433.47 2/5/2004 - 0532 2/5/2005 - 0639.31 2/5/2006 - 0743.5 2/5/2007 - 0853.29 2/5/2008 - 0956.23 2/5/2009 - 1068.51 2/5/2010 - 1171.46 2/5/2011 - 1271.46 2/5/2012 - 1365 2/5/2013 - 1455.33 2/5/2014 - 1552.62 2/5/2015 - 1654.06 2/5/2016 - 1756.7 2/5/2017 - 1885.6 2/5/2018 - 1995 2/5/2019 - 2064.86 2/5/2020 - 2151.18 2/5/2021 - 2243.37 2/5/2022 - 2341.13 2/6/2023 - 0035.18 2/6/2000 - 0134 2/6/2001 - 0233.35 2/6/2002 - 0330.88 2/6/2003 - 0427.28 2/6/2004 - 0530.84 2/6/2005 - 0630.84 2/6/2006 - 0735.18 2/6/2007 - 0843.27 2/6/2008 - 0948.61 2/6/2009 - 1050.93 2/6/2010 - 1146.19 2/6/2011 - 1242.81 2/6/2012 - 1341 2/6/2013 - 1438.78 2/6/2014 - 1538.31 2/6/2015 - 1639.18 2/6/2016 - 1743 2/6/2017 - 1851.01 2/6/2018 - 1951 2/6/2019 - 2038.27 2/6/2020 - 2135.1 2/6/2021 - 2231 2/6/2022 - 2323.5 2/7/2023 - 0033.74 2/7/2000 - 0132 2/7/2001 - 0227.21 2/7/2002 - 0321 2/7/2003 - 044 2/7/2004 - 050.35 2/7/2005 - 06-1 2/7/2006 - 0720.01 2/7/2007 - 0831 2/7/2008 - 0934.26 2/7/2009 - 1035.93 2/7/2010 - 1135.93 2/7/2011 - 1236.7 2/7/2012 - 1333.83 2/7/2013 - 1432.13 2/7/2014 - 1531.29 2/7/2015 - 1633 2/7/2016 - 1739.72 2/7/2017 - 1848.35 2/7/2018 - 1947.79 2/7/2019 - 2045.02 2/7/2020 - 2138.52 2/7/2021 - 2234.87 2/7/2022 - 2328.11 2/8/2023 - 0026.76 2/8/2000 - 0125.16 2/8/2001 - 0225.14 2/8/2002 - 0321.84 2/8/2003 - 0420.25 2/8/2004 - 0518.73 2/8/2005 - 0622 2/8/2006 - 0724 2/8/2007 - 0826.76 2/8/2008 - 0926.76 2/8/2009 - 1031.16 2/8/2010 - 1132.24 2/8/2011 - 1231.39 2/8/2012 - 1327.9 2/8/2013 - 1426.76 2/8/2014 - 1526.76 2/8/2015 - 1626.76 2/8/2016 - 1730 2/8/2017 - 1842.85 2/8/2018 - 1952.87 2/8/2019 - 2042.85 2/8/2020 - 2138.25 2/8/2021 - 2238.25 2/8/2022 - 2330.34 2/9/2023 - 0024.43 2/9/2000 - 0116.25 2/9/2001 - 028.85 2/9/2002 - 030 2/9/2003 - 04-8.02 2/9/2004 - 05-8.33 2/9/2005 - 06-8.33 2/9/2006 - 07-8.33 2/9/2007 - 08-8.33 2/9/2008 - 09-5.51 2/9/2009 - 1018.7 2/9/2010 - 1126.48 2/9/2011 - 1235.9 2/9/2012 - 1335.9 2/9/2013 - 1435.9 2/9/2014 - 1527.21 2/9/2015 - 1631.1 2/9/2016 - 1735.9 2/9/2017 - 1846.02 2/9/2018 - 1946.7 2/9/2019 - 2035.9 2/9/2020 - 2129.2 2/9/2021 - 2226.48 2/9/2022 - 2316.64 2/10/2023 - 00-5.5 2/10/2000 - 01-8.05 2/10/2001 - 02-8.32 2/10/2002 - 03-8.02 2/10/2003 - 04-8.05 2/10/2004 - 05-8.1 2/10/2005 - 06-7.2 2/10/2006 - 0722.59 2/10/2007 - 0840.55 2/10/2008 - 0943.23 2/10/2009 - 1041.99 2/10/2010 - 1138.39 2/10/2011 - 1236.24 2/10/2012 - 1340.98 2/10/2013 - 1441.09 2/10/2014 - 1535.67 2/10/2015 - 1636.18 2/10/2016 - 1744.13 2/10/2017 - 1850.84 2/10/2018 - 1953.42 2/10/2019 - 2047.39 2/10/2020 - 2138.47 2/10/2021 - 2228.36 2/10/2022 - 2322.5 2/11/2023 - 000 2/11/2000 - 010 2/11/2001 - 02-0.12 2/11/2002 - 03-0.12 2/11/2003 - 04-3 2/11/2004 - 05-3 2/11/2005 - 06-5.51 2/11/2006 - 070 2/11/2007 - 0825.02 2/11/2008 - 0927.02 2/11/2009 - 1026.8 2/11/2010 - 1125.03 2/11/2011 - 1225.47 2/11/2012 - 1325.03 2/11/2013 - 1425.01 2/11/2014 - 1525.01 2/11/2015 - 1625.02 2/11/2016 - 1725.47 2/11/2017 - 1838.31 2/11/2018 - 1942.94 2/11/2019 - 2040.59 2/11/2020 - 2136.48 2/11/2021 - 2229.63 2/11/2022 - 2327.02 2/12/2023 - 0029 2/12/2000 - 0124.52 2/12/2001 - 0223.21 2/12/2002 - 0319.54 2/12/2003 - 0416.03 2/12/2004 - 0524.42 2/12/2005 - 0626 2/12/2006 - 0735.51 2/12/2007 - 0845.44 2/12/2008 - 0949.17 2/12/2009 - 1051.98 2/12/2010 - 1155.39 2/12/2011 - 1262.85 2/12/2012 - 1359.6 2/12/2013 - 1454.28 2/12/2014 - 1556.19 2/12/2015 - 1668.3 2/12/2016 - 1765.46 2/12/2017 - 1865.48 2/12/2018 - 1973.82 2/12/2019 - 2047.64 2/12/2020 - 2137.61 2/12/2021 - 2235.2 2/12/2022 - 2327.21 2/13/2023 - 0035 2/13/2000 - 0123.92 2/13/2001 - 0225 2/13/2002 - 0323.79 2/13/2003 - 0423.9 2/13/2004 - 0522.77 2/13/2005 - 0629.51 2/13/2006 - 0735.85 2/13/2007 - 0841.56 2/13/2008 - 0945.86 2/13/2009 - 1043.82 2/13/2010 - 1137.55 2/13/2011 - 1236.79 2/13/2012 - 1335.99 2/13/2013 - 1435.96 2/13/2014 - 1536.26 2/13/2015 - 1637.73 2/13/2016 - 1750.04 2/13/2017 - 18100.72 2/13/2018 - 19161.36 2/13/2019 - 20120.87 2/13/2020 - 2181.23 2/13/2021 - 2245.16 2/13/2022 - 2336.01 2/14/2023 - 0083.4 2/14/2000 - 0142 2/14/2001 - 0240.9 2/14/2002 - 0327.21 2/14/2003 - 041.55 2/14/2004 - 050 2/14/2005 - 060 2/14/2006 - 070 2/14/2007 - 0826.62 2/14/2008 - 0927.21 2/14/2009 - 1027 2/14/2010 - 1127 2/14/2011 - 1227 2/14/2012 - 1327 2/14/2013 - 1427 2/14/2014 - 1527 2/14/2015 - 1627 2/14/2016 - 1728.88 2/14/2017 - 1850.37 2/14/2018 - 1965.48 2/14/2019 - 2050.04 2/14/2020 - 2138.75 2/14/2021 - 2234.05 2/14/2022 - 2331.7 2/15/2023 - 0041.07 2/15/2000 - 0118.71 2/15/2001 - 0218.71 2/15/2002 - 03-2.44 2/15/2003 - 04-2.55 2/15/2004 - 05-2.6 2/15/2005 - 06-2.6 2/15/2006 - 07-5 2/15/2007 - 080 2/15/2008 - 090 2/15/2009 - 1018.71 2/15/2010 - 1126 2/15/2011 - 1226 2/15/2012 - 1326 2/15/2013 - 1426 2/15/2014 - 1524.9 2/15/2015 - 1627.21 2/15/2016 - 1728.94 2/15/2017 - 1852.92 2/15/2018 - 1958.65 2/15/2019 - 2044.68 2/15/2020 - 2128.34 2/15/2021 - 2225 2/15/2022 - 2320.01 2/16/2023 - 005 2/16/2000 - 01-5.03 2/16/2001 - 02-5.18 2/16/2002 - 03-5.04 2/16/2003 - 04-5.09 2/16/2004 - 05-5.19 2/16/2005 - 06-5.15 2/16/2006 - 07-5.04 2/16/2007 - 080 2/16/2008 - 090 2/16/2009 - 104.5 2/16/2010 - 1120.19 2/16/2011 - 1222.45 2/16/2012 - 1325.67 2/16/2013 - 1425.67 2/16/2014 - 1524.17 2/16/2015 - 1625.67 2/16/2016 - 1730 2/16/2017 - 1853 2/16/2018 - 1957.41 2/16/2019 - 2045.7 2/16/2020 - 2136.74 2/16/2021 - 2225.67 2/16/2022 - 2311.17 2/17/2023 - 00-1.02 2/17/2000 - 010 2/17/2001 - 02-1.02 2/17/2002 - 030 2/17/2003 - 045.8 2/17/2004 - 057.9 2/17/2005 - 0619 2/17/2006 - 0724.24 2/17/2007 - 0840.9 2/17/2008 - 0943.48 2/17/2009 - 1042 2/17/2010 - 1139.04 2/17/2011 - 1235 2/17/2012 - 1328.77 2/17/2013 - 1426 2/17/2014 - 1526 2/17/2015 - 1627.21 2/17/2016 - 1737.78 2/17/2017 - 1849.46 2/17/2018 - 1957.63 2/17/2019 - 2048.23 2/17/2020 - 2134.42 2/17/2021 - 2232.38 2/17/2022 - 2324.7 2/18/2023 - 0021.5 2/18/2000 - 0119 2/18/2001 - 0216.19 2/18/2002 - 0310.83 2/18/2003 - 0410.13 2/18/2004 - 055 2/18/2005 - 0619.95 2/18/2006 - 0727.21 2/18/2007 - 0837.81 2/18/2008 - 0940.78 2/18/2009 - 1045 2/18/2010 - 1139.39 2/18/2011 - 1237.58 2/18/2012 - 1338.95 2/18/2013 - 1436.66 2/18/2014 - 1534.25 2/18/2015 - 1631.16 2/18/2016 - 1737.12 2/18/2017 - 1850 2/18/2018 - 1956.59 2/18/2019 - 2051.53 2/18/2020 - 2141.78 2/18/2021 - 2235 2/18/2022 - 2327.09 2/19/2023 - 0024.77 2/19/2000 - 0123.82 2/19/2001 - 0222.31 2/19/2002 - 0323.05 2/19/2003 - 0424.36 2/19/2004 - 0526.76 2/19/2005 - 0631.15 2/19/2006 - 0737.57 2/19/2007 - 0841.99 2/19/2008 - 0945.5 2/19/2009 - 1047.15 2/19/2010 - 1146.1 2/19/2011 - 1244 2/19/2012 - 1342.13 2/19/2013 - 1438.48 2/19/2014 - 1536.6 2/19/2015 - 1634.45 2/19/2016 - 1737.77 2/19/2017 - 1845.71 2/19/2018 - 1950.54 2/19/2019 - 2046.07 2/19/2020 - 2141.81 2/19/2021 - 2239.79 2/19/2022 - 2331.5 2/20/2023 - 0028.41 2/20/2000 - 0126.83 2/20/2001 - 0225.75 2/20/2002 - 0325.88 2/20/2003 - 0425.52 2/20/2004 - 0525.52 2/20/2005 - 0632.5 2/20/2006 - 0736.86 2/20/2007 - 0840.13 2/20/2008 - 0944.39 2/20/2009 - 1044.07 2/20/2010 - 1138.26 2/20/2011 - 1235.1 2/20/2012 - 1331 2/20/2013 - 1429.82 2/20/2014 - 1527 2/20/2015 - 1629.82 2/20/2016 - 1735 2/20/2017 - 1844.73 2/20/2018 - 1954.99 2/20/2019 - 2046.59 2/20/2020 - 2140.61 2/20/2021 - 2238.34 2/20/2022 - 2328.65 2/21/2023 - 0025.45 2/21/2000 - 0122.22 2/21/2001 - 027.56 2/21/2002 - 03-1.02 2/21/2003 - 04-1.05 2/21/2004 - 05-1.07 2/21/2005 - 06-1.1 2/21/2006 - 070 2/21/2007 - 0836.93 2/21/2008 - 0939.74 2/21/2009 - 1040.68 2/21/2010 - 1138.49 2/21/2011 - 1240.3 2/21/2012 - 1340.68 2/21/2013 - 1438.71 2/21/2014 - 1534.74 2/21/2015 - 1635 2/21/2016 - 1738.37 2/21/2017 - 1848.28 2/21/2018 - 1953.18 2/21/2019 - 2045.54 2/21/2020 - 2139.61 2/21/2021 - 2234 2/21/2022 - 2325.01 2/22/2023 - 006.09 2/22/2000 - 01-5.27 2/22/2001 - 02-6.17 2/22/2002 - 03-7.42 2/22/2003 - 04-7.86 2/22/2004 - 05-7.86 2/22/2005 - 06-10 2/22/2006 - 070 2/22/2007 - 080 2/22/2008 - 0920.96 2/22/2009 - 1027.21 2/22/2010 - 1137.8 2/22/2011 - 1237.58 2/22/2012 - 1337.3 2/22/2013 - 1436.84 2/22/2014 - 1528.49 2/22/2015 - 1628.49 2/22/2016 - 1729.49 2/22/2017 - 1842.62 2/22/2018 - 1956.47 2/22/2019 - 2047.81 2/22/2020 - 2139.28 2/22/2021 - 2241.23 2/22/2022 - 2331.45 2/23/2023 - 0031.21 2/23/2000 - 0129.29 2/23/2001 - 0230.28 2/23/2002 - 0330.2 2/23/2003 - 0427.17 2/23/2004 - 0530.38 2/23/2005 - 0634.32 2/23/2006 - 0734.32 2/23/2007 - 0823.88 2/23/2008 - 0929.3 2/23/2009 - 1031.47 2/23/2010 - 1139 2/23/2011 - 1239.57 2/23/2012 - 1339.85 2/23/2013 - 1441.4 2/23/2014 - 1541.05 2/23/2015 - 1641.4 2/23/2016 - 1755.39 2/23/2017 - 18100.73 2/23/2018 - 19135 2/23/2019 - 2060.6 2/23/2020 - 2145.83 2/23/2021 - 2245.05 2/23/2022 - 2337.3 2/24/2023 - 0046.91 2/24/2000 - 0144.65 2/24/2001 - 0227.21 2/24/2002 - 03-3 2/24/2003 - 04-6.4 2/24/2004 - 05-9.02 2/24/2005 - 06-9.02 2/24/2006 - 07-1 2/24/2007 - 0835.92 2/24/2008 - 0939 2/24/2009 - 1041.64 2/24/2010 - 1141.61 2/24/2011 - 1240.53 2/24/2012 - 1336.01 2/24/2013 - 1435.36 2/24/2014 - 1534 2/24/2015 - 1635.24 2/24/2016 - 1737.41 2/24/2017 - 1848.01 2/24/2018 - 1955.08 2/24/2019 - 2054 2/24/2020 - 2146.06 2/24/2021 - 2241.42 2/24/2022 - 2329.97 2/25/2023 - 0033.95 2/25/2000 - 0131.24 2/25/2001 - 0232.36 2/25/2002 - 0329.68 2/25/2003 - 0426.87 2/25/2004 - 0526.5 2/25/2005 - 0629.14 2/25/2006 - 0736.91 2/25/2007 - 0847.99 2/25/2008 - 0951.03 2/25/2009 - 1048.84 2/25/2010 - 1139.08 2/25/2011 - 1235.72 2/25/2012 - 1336.02 2/25/2013 - 1435.83 2/25/2014 - 1535.8 2/25/2015 - 1632.39 2/25/2016 - 1741 2/25/2017 - 1849.23 2/25/2018 - 1963.83 2/25/2019 - 2052.28 2/25/2020 - 2141 2/25/2021 - 2236.13 2/25/2022 - 2330.87 2/26/2023 - 0034.23 2/26/2000 - 0133 2/26/2001 - 0230.48 2/26/2002 - 0329 2/26/2003 - 0424.99 2/26/2004 - 0524.58 2/26/2005 - 0630 2/26/2006 - 0737.75 2/26/2007 - 0842.11 2/26/2008 - 0950.24 2/26/2009 - 1049.78 2/26/2010 - 1138.68 2/26/2011 - 1235.18 2/26/2012 - 1335.18 2/26/2013 - 1434.3 2/26/2014 - 1534.32 2/26/2015 - 1639.23 2/26/2016 - 1742.14 2/26/2017 - 1865 2/26/2018 - 19120.86 2/26/2019 - 20100 2/26/2020 - 2171 2/26/2021 - 2254.65 2/26/2022 - 2343.94 2/27/2023 - 0046.66 2/27/2000 - 0142.95 2/27/2001 - 0240 2/27/2002 - 0337.43 2/27/2003 - 0436.76 2/27/2004 - 0535.07 2/27/2005 - 0636.02 2/27/2006 - 0742.4 2/27/2007 - 0850.42 2/27/2008 - 0954.46 2/27/2009 - 1054.89 2/27/2010 - 1144.76 2/27/2011 - 1241.24 2/27/2012 - 1339.28 2/27/2013 - 1434.98 2/27/2014 - 1534 2/27/2015 - 1634.03 2/27/2016 - 1743.27 2/27/2017 - 1851.53 2/27/2018 - 19116.67 2/27/2019 - 2060.2 2/27/2020 - 2144.42 2/27/2021 - 2243.54 2/27/2022 - 2335.07 2/28/2023 - 0035.14 2/28/2000 - 0134.29 2/28/2001 - 0234.8 2/28/2002 - 0334.29 2/28/2003 - 0430.44 2/28/2004 - 0527.5 2/28/2005 - 0629 2/28/2006 - 0731 2/28/2007 - 0838 2/28/2008 - 0943.1 2/28/2009 - 1044 2/28/2010 - 1143.06 2/28/2011 - 1241.6 2/28/2012 - 1341.4 2/28/2013 - 1437.66 2/28/2014 - 1537.48 2/28/2015 - 1637.55 2/28/2016 - 1739 2/28/2017 - 1850.69 2/28/2018 - 1957.87 2/28/2019 - 2048.32 2/28/2020 - 2142.97 2/28/2021 - 2237.41 2/28/2022 - 2330.2 2/29/2023 - 0030.11 2/29/2000 - 0116.1 2/29/2001 - 0223.64 2/29/2002 - 0316.61 2/29/2003 - 049.39 2/29/2004 - 052.8 2/29/2005 - 060 2/29/2006 - 07-3.93 2/29/2007 - 080 2/29/2008 - 0917.31 2/29/2009 - 1030.11 2/29/2010 - 1135 2/29/2011 - 1236.98 2/29/2012 - 1334.75 2/29/2013 - 1429 2/29/2014 - 1529.6 2/29/2015 - 1633.42 2/29/2016 - 1734.39 2/29/2017 - 1846.5 2/29/2018 - 1954.37 2/29/2019 - 2046.01 2/29/2020 - 2136 2/29/2021 - 2230.11 2/29/2022 - 2315.2 Sheet1 Contract Energy Rate (c/kWh) Winter Day (Oct - Mar)8 Winter Night (Oct - Mar)6 Summer Day (Apr - Sept)7 Summer Night (Apr - Sept)5 Forecast Consumption Details for 2020JanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberTotal Day Units209271997520584212592274427495302872951923703218802025320072278700 Night Units1023791811015610990117671487116882162761350611652103129631145461 Total Units311642915630740322493451142367471694579537208335323056629703424161 Contract Gas Base (p/therm)626262494949494949585858 Forward Curve (p/therm) March 1st 2019 WINTERWINTERWINTERSUMMERSUMMERSUMMERSUMMERSUMMERSUMMERSUMMERWINTER EnergyJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberTOTAL DayCONTRACT RATES NightCONTRACT RATES Total Energy Charges0 Gas Sensitivity (c/kWh)0.0830.0830.0830.0830.0830.0830.0830.0830.0830.0830.0830.0830.083 Gas Adjustment Total Energy Charges (Inc Gas Adjustment) Sheet2 Contract Energy Rate (c/kWh) Winter Day (Oct - Mar)8 Winter Night (Oct - Mar)6 Summer Day (Apr - Sept)7 Summer Night (Apr - Sept)5 Forecast Consumption Details for 2020JanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberTotal Day Units209271997520584212592274427495302872951923703218802025320072278700 Night Units1023791811015610990117671487116882162761350611652103129631145461 Total Units311642915630740322493451142367471694579537208335323056629703424161 Contract Gas Base (p/therm)626262494949494949585858 Forward Curve (p/therm) March 1st 2019 WINTERWINTERWINTERSUMMERSUMMERSUMMERSUMMERSUMMERSUMMERSUMMERWINTER EnergyJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberTOTAL DayCONTRACT RATES NightCONTRACT RATES Total Energy Charges Gas Sensitivity (c/kWh)0.0830.0830.0830.0830.0830.0830.0830.0830.0830.0830.0830.083 Gas Adjustment Total Energy Charges (Inc Gas Adjustment) Sheet1 DateTimeDay-ahead Price [EUR/MWh]Day-ahead Price [GBP/MWh]UK EUR/MWh 2/1/1923 - 0050.0446.0152.5 2/1/1900 - 0150.0746.0352.53 2/1/1901 - 0250.146.0652.55 2/1/1902 - 0349.4245.4451.85 2/1/1903 - 0448.9344.9851.33 2/1/1904 - 0548.944.9651.3 2/1/1905 - 0651.5347.3754.06 2/1/1906 - 0762.4560.0368.5 2/1/1907 - 0869.086270.75 2/1/1908 - 0977.7869.8179.66 2/1/1909 - 1083.2671.2481.3 2/1/1910 - 1183.6871.681.7 2/1/1911 - 1281.9168.4278.08 2/1/1912 - 138066.8576.28 2/1/1913 - 1470.358.766.98 2/1/1914 - 1569.5358.0866.28 2/1/1915 - 1668.8357.565.61 2/1/1916 - 1773.2361.1769.8 2/1/1917 - 1881.986877.59 2/1/1918 - 1977.816574.17 2/1/1919 - 2073.026169.61 2/1/1920 - 2166.2855.3763.18 2/1/1921 - 2267.0857.465.5 2/1/1922 - 235747.0853.73 2/2/1923 - 0056.4752.0959.25 2/2/1900 - 0158.555461.42 2/2/1901 - 0256.2851.9159.04 2/2/1902 - 035348.154.71 2/2/1903 - 0450.3545.3451.57 2/2/1904 - 0549.8744.951.07 2/2/1905 - 0648.4143.5949.58 2/2/1906 - 0751.9645.651.87 2/2/1907 - 0855.5146.6653.07 2/2/1908 - 0960.0950.3657.28 2/2/1909 - 107058.6666.72 2/2/1910 - 117159.567.68 2/2/1911 - 127652.960.17 2/2/1912 - 1375.2551.158.12 2/2/1913 - 1471.484955.73 2/2/1914 - 1570.2747.9854.57 2/2/1915 - 1670.235056.87 2/2/1916 - 1782.55764.83 2/2/1917 - 1814478.989.74 2/2/1918 - 19159.2278.6989.5 2/2/1919 - 20113.7463.772.45 2/2/1920 - 21766169.38 2/2/1921 - 22655461.42 2/2/1922 - 2370.65259.14 2/3/1923 - 006251.558.76 2/3/1900 - 0165.7156.2364.16 2/3/1901 - 0264.1954.9362.68 2/3/1902 - 0357.1648.9255.81 2/3/1903 - 0449.6544.5650.85 2/3/1904 - 0547.7543.950.09 2/3/1905 - 064743.950.09 2/3/1906 - 0746.9343.950.09 2/3/1907 - 0846.764450.21 2/3/1908 - 0946.7944.8451.16 2/3/1909 - 1054.9750.5457.67 2/3/1910 - 115752.4159.8 2/3/1911 - 1260.1851.558.76 2/3/1912 - 1365.355.8863.76 2/3/1913 - 1465.355.8863.76 2/3/1914 - 1565.445663.9 2/3/1915 - 1659.4650.8858.06 2/3/1916 - 1772.5265.174.27 2/3/1917 - 1891.984.596.41 2/3/1918 - 1982.5575.986.6 2/3/1919 - 206257.0165.04 2/3/1920 - 2154.9753.1760.67 2/3/1921 - 2252.748.4655.29 2/3/1922 - 2349.3244.2750.52 2/4/1923 - 0048.4544.5550.83 2/4/1900 - 0147.9644.0950.31 2/4/1901 - 0247.8944.0350.24 2/4/1902 - 0340.7337.4542.73 2/4/1903 - 0437.8834.8339.74 2/4/1904 - 0539.9336.7141.89 2/4/1905 - 0648.4144.5150.78 2/4/1906 - 0760.8357.5165.62 2/4/1907 - 0856.985057.05 2/4/1908 - 0965.4955.9763.86 2/4/1909 - 1067.5256.464.36 2/4/1910 - 1166.7555.7663.62 2/4/1911 - 1272.8352.8960.35 2/4/1912 - 1377.2950.857.96 2/4/1913 - 1477.0948.8755.77 2/4/1914 - 1577.2949.7656.77 2/4/1915 - 16136.1152.0559.39 2/4/1916 - 1715057.3665.44 2/4/1917 - 1828568.8278.52 2/4/1918 - 19270.374.1284.57 2/4/1919 - 20130.774.2384.7 2/4/1920 - 2180.1666.9776.41 2/4/1921 - 226958.1166.3 2/4/1922 - 2365.9655.162.87 2/5/1923 - 0061.1951.158.33 2/5/1900 - 0154.664854.79 2/5/1901 - 0250.5346.4453.01 2/5/1902 - 0349.3843.6649.84 2/5/1903 - 0447.0843.2749.39 2/5/1904 - 0547.3643.5349.69 2/5/1905 - 0649.7450.8858.08 2/5/1906 - 0751.7456.1964.14 2/5/1907 - 0869.0863.4972.47 2/5/1908 - 0973.8967.9177.52 2/5/1909 - 1070.163.1972.13 2/5/1910 - 116356.5364.53 2/5/1911 - 1257.9153.2260.76 2/5/1912 - 1356.7752.1759.55 2/5/1913 - 1456.5551.9759.33 2/5/1914 - 1555.495158.22 2/5/1915 - 1656.251.6558.96 2/5/1916 - 1764.4356.5564.55 2/5/1917 - 1870.665967.35 2/5/1918 - 1968.4957.1965.28 2/5/1919 - 2066.5455.5663.42 2/5/1920 - 2161.8752.9260.41 2/5/1921 - 225547.5254.24 2/5/1922 - 2353.6443.249.31 2/6/1923 - 0050.8543.5549.65 2/6/1900 - 0150.8443.5449.64 2/6/1901 - 0250.5744.0950.27 2/6/1902 - 0348.4643.5349.63 2/6/1903 - 0447.3443.5649.67 2/6/1904 - 0547.3843.5949.7 2/6/1905 - 0650.5746.5353.05 2/6/1906 - 0756.2355.3963.15 2/6/1907 - 0863.6354.9162.6 2/6/1908 - 0965.8559.1567.44 2/6/1909 - 1066.796068.41 2/6/1910 - 1160.9754.7762.45 2/6/1911 - 1257.3849.6856.64 2/6/1912 - 1357.649.3356.24 2/6/1913 - 1455.8847.8654.57 2/6/1914 - 1557.0948.955.75 2/6/1915 - 1659.6651.0958.25 2/6/1916 - 1770.066068.41 2/6/1917 - 1883.9670.280.03 2/6/1918 - 1986.127282.09 2/6/1919 - 2081.747079.81 2/6/1920 - 2170.4658.9167.16 2/6/1921 - 2257.0648.8755.71 2/6/1922 - 2353.5343.649.7 2/7/1923 - 0053.7144.9751.19 2/7/1900 - 015243.9950.08 2/7/1901 - 025245.351.57 2/7/1902 - 035044.350.43 2/7/1903 - 044843.9550.04 2/7/1904 - 0546.7743.149.06 2/7/1905 - 0647.2343
May 05, 2021
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here