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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!