Question
An electric utility is experiencing a difficult time obtaining natural gas for electric generation. Fuels other than natural gas (called fuel-mixes) are purchased at an
An electric utility is experiencing a difficult time obtaining natural gas for electric generation. Fuels other than natural gas (called fuel-mixes) are purchased at an extra cost, which is transferred to the customer. Total monthly fuel expenses are now averaging $7,750,000.
An engineer with the city-owned utility has calculated the average revenue for the past 24 months using three fuel-mix situations
Gas Plentiful
< 30% other fuels purchased
>=30% other fuels purchased
The table below indicates the number of months that each fuel-mix situation occurred (i.e Gas Plentiful occurred 12 out of the last 24 months).
Can the utility expect to meet future monthly expenses based on the 24 months of data, if a similar fuel-mix pattern continues? (i.e. what is the expected EMV?) You can use Excel
Revenue & Fuel Mix Data | ||
Fuel-Mix Situation | Months in Past 24 | Average Revenue, $ per Month |
Gas plentiful | 12 | 5,270,000 |
<30% other | 6 | 7,850,000 |
>= 30% other | 6 | 12,130,000 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started