學門類別
政大
哈佛
最新個案
- Leadership Imperatives in an AI World
- Vodafone Idea Merger - Unpacking IS Integration Strategies
- Snapchat’s Dilemma: Growth or Financial Sustainability
- V21 Landmarks Pvt. Ltd: Scaling Newer Heights in Real Estate Entrepreneurship
- Predicting the Future Impacts of AI: McLuhan’s Tetrad Framework
- Did I Just Cross the Line and Harass a Colleague?
- TNT Assignment: Financial Ratio Code Cracker
- Porsche Drive (A): Vehicle Subscription Strategy
- Porsche Drive (A) and (B): Student Spreadsheet
- Porsche Drive (B): Vehicle Subscription Strategy
-
City of London Water: Predicting Electricity Prices and Optimizing Operations - Student Spreadsheet
Student Spreadsheet to accompany product 9B19E004. -
City of London Water: Predicting Electricity Prices and Optimizing Operations
The manager of Water Operations at the City of London wanted to reduce the cost of pumping water by optimizing energy use. Water Operations had been consistently experiencing higher operational costs, and electricity bills accounted for up to 30 per cent of its direct costs. If the manager could predict the future cost of energy, she could schedule the operation of the water pumps to benefit from periods of low energy prices, potentially saving up to 25 per cent of the energy costs. The manager obtained the hourly Ontario electricity prices from 2003 to 2015, and wanted to use that data to evaluate how accurately she could predict future electricity prices. How should she proceed?