Question

A power company has a maximum daily capacity of 5 million kilowatt-hours (kWh) of electric power available. The daily demand for power from customers is the total of the peak hours demand and off-peak hours demand. The following functions estimate the high-demand (peak) hours and low-demand (off-peak) hours (unit in millions of kWh):

High demand : 10 – 0.08ph + 0.007pl

Low demand : 9 – 0.18pl + 0.004ph , where variable pl represents the price per kilowatt-hour during low-demand hours, and ph is the price per kilowatt-hour during high-demand (peak) hours. Formulate and solve a nonlinear programming model to determine the price structure (per kWh) that will maximize revenue.

(I have to make one word file which clearly states the objective function, decision variables, constraints, and solution of all questions 2. one workbook which contains the spreadsheet file with formula and answer report for all questions (using separate worksheets for different questions) here is photo of question.

20Assignment 2019-20B%20(2).pdf A power company has a maximum daily capacity of 5 million kilowatt-hours (kWh) of electric po

0 0
Add a comment Improve this question Transcribed image text
Answer #1

First, we input the functions, total demand and total revenue as below :

5,000,000 Maximum daily capacity 2 PL 3PH 4 High Demand Hours 5 Low Demand Hours 6 Total Demand Hours 7 Total Revenue 10,000,

5000000 1 Maximum daily capacity 2 PL 3 PH 4 High Demand Hours 5 Low Demand Hours 6 Total Demand Hours 7 Total Revenue =(10-(

The functions estimate the demand in millions of kWh. Hence, we multiply the given functions with 1000000.

Next, we enter the inputs into Solver as below :

с D E F G H 1 Maximum daily capacity 2 PL B 5,000,000 Solver Parameters Set Objective: SB571 3 PH 4 High Demand Hours 5 Low D

Solving the model, we get the following output. This is the price structure to maximize revenue.

5,000,000 44.67 1 Maximum daily capacity 2 PL 3 PH 4 High Demand Hours 5 Low Demand Hours 6 Total Demand Hours 7 Total Revenu

в 1 Maximum daily capacity 5000000 2 P 44.6718684772355 3 PH 82.5232467557665 4 High Demand Hours = (10-10.08*B3)+(0.007*B2))

Add a comment
Know the answer?
Add Answer to:
A power company has a maximum daily capacity of 5 million kilowatt-hours (kWh) of electric power...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 6. In a certain city, the daily consurmption of electric power, in millions of kilowatt-hours, can...

    6. In a certain city, the daily consurmption of electric power, in millions of kilowatt-hours, can be treated as a random variable having a gamma distribution with o-3 and 0 -3. If the power plant has a daily capacity of 12 million kilowatt-hours, what is the probability that this power supply will be inadequate on any given day? Scanned with CamScanner

  • Question 5 (a) A electric power distributor charges residential customers $0.10 per kilowatt-hour (kWh) The company...

    Question 5 (a) A electric power distributor charges residential customers $0.10 per kilowatt-hour (kWh) The company advertises that "green power" is available in 150 kWh blocks for an additional $4 per month per block. (i) A customer uses an average of 300k Wh per month and commits to one monthly 150k Wh (3 marks) (4 marks) (4 marks) block of green power, what is the annual power bill? (ii) What is the average cost per kWh using green power during...

  • 4. CIP has three electric power plants that supply the power needs of four cities. Each power plant can supply the following numbers of kilowatt-hours (kwh) of electricity: plant 1, 35 million; pl...

    4. CIP has three electric power plants that supply the power needs of four cities. Each power plant can supply the following numbers of kilowatt-hours (kwh) of electricity: plant 1, 35 million; plant 2, 50 million; plant 3, 40 million. The peak power demands in these cities, which occur at the same time (2:00 P.M.), are as follows (in kwh): city A, 20 million; city B, 20 million; city C, 30 million; city D, 30 million. The costs of sending...

  • Please help me answer Problem #14. Thank you so much 13. The San Francisco Power Company...

    Please help me answer Problem #14. Thank you so much 13. The San Francisco Power Company faces a total cost function of TC = (1/2)Q2 + 100,000 where prices are in cents/kilowatt-hour and quantities are in millions of kilowatt-hours. The demand function of San Francisco residents for off-peak hours is: D: P = 4-Q or D.: Q=4-P. The demand function of San Francisco residents for peak hours is: D: P = 8-Q or D : Q = 8 - P...

  • The state of Missouri has three major power-generating companies (A, B, and C)

    The state of Missouri has three major power-generating companies (A, B, and C). During the months of peak demand, the Missouri Power Authority authorizes these companies to pool their excess supply and to distribute it to smaller, independent power companies that do not have generators large enough to handle the demand. Excess supply is distributed on the basis of cost per kilowatt hour transmitted. The following table shows the demand and supply in millions of kilowatt hours and the cost...

  • Gotham Bridge and Tunnel Authority practices peak-load pricing. During peak hours when bridges are at capacity...

    Gotham Bridge and Tunnel Authority practices peak-load pricing. During peak hours when bridges are at capacity and the price elasticity of demand is −3, Gotham charges $25 per bridge crossings. During off-peak hours the price elasticity of demand is −5. How much should Gotham charge during off-peak hours to maximize profit? $18 $24 $20 $21 There is not enough information to answer this question.

  • 3-86 The demand for electric power is usually much higher during the day than it is...

    3-86 The demand for electric power is usually much higher during the day than it is at night, and utility companies often sell power at night at much lower prices to encourage con- sumers to use the available power generation capacity and to avoid building new expensive power plants that will be used only a short time during peak periods. Utilities are also will ing to purchase power produced during the day from private parties at a high price. Suppose...

  • How do you setup this problem is Excel Solver to solve the problem? 21. Star Power...

    How do you setup this problem is Excel Solver to solve the problem? 21. Star Power Company is a power company in the Midwest region of the united States. Star buys and sells energy on the spot market. Star can store power in a high-capacity battery that can store up to 60 kWh (kilowatt hours). During a particular period, Star can buy or sell electricity at the market price known as LMP (Locational Marginal Price). The maximum rate that power...

  • In the UK, the demand for electric power is usually much higher during the day than...

    In the UK, the demand for electric power is usually much higher during the day than it is at night, and utility companies often sell power at night at much lower prices to encourage consumers to use the available power generation capacity and to avoid building new expensive power plants that will be used only a short time during peak periods. Utilities are also willing to purchase power produced during the day from private parties at a high price. Suppose...

  • Question 2 Moresan Co. gathered the following information on power costs and factory machine usage for...

    Question 2 Moresan Co. gathered the following information on power costs and factory machine usage for the last six months: Month Power Cost Factory Machine Hours January $24,400 13,900 February 30,400 17,600 March 29,000 16,800 April 22,340 13,200 May 19,900 11,600 June 16,900 8,600 Using the high-low method of analyzing costs, answer the following questions. What is the estimated variable portion of power costs per factory machine hour? (Round answer to 2 decimal places, e.g. 15.25.) Variable power costs $...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT