An electrical utility needs to generate 6,300 megawatts of electricity today. It has five generators (A, B, C, D, and E). If any electricity is generated by a given generator, that generator must be started up and a fixed start-up cost is incurred. There is an additional cost for each megawatt generated by a generator. These costs, as well as the maximum capacity of each generator, are shown in the following table. A B C D Fixed start-up cost $3,000 $2,000 $2,500 $1,500 $1,000 Cost per megawatt/day $5 $4 $6 generated $6 $7 Maximum capacity (MW/day 2,100 1,800 2,500 1,500 3,000 Click here for the Excel Data File Formulate and solve this model on a spreadsheet. a. Determine the minimum cost plan that meets the electrical needs for today. Note: Leave no cells blank. Enter "O" wherever required. Startup generator? (Enter 1 if "Yes", O if "No") Megawatt/day b. Determine the total cost. Total cost
An electrical utility needs to generate 6,300 megawatts of electricity today. It has five generators (A, B, C, D, and E). If any electricity is generated by a given generator, that generator must be started up and a fixed start-up cost is incurred. There is an additional cost for each megawatt generated by a generator. These costs, as well as the maximum capacity of each generator, are shown in the following table. A B C D Fixed start-up cost $3,000 $2,000 $2,500 $1,500 $1,000 Cost per megawatt/day $5 $4 $6 generated $6 $7 Maximum capacity (MW/day 2,100 1,800 2,500 1,500 3,000 Click here for the Excel Data File Formulate and solve this model on a spreadsheet. a. Determine the minimum cost plan that meets the electrical needs for today. Note: Leave no cells blank. Enter "O" wherever required. Startup generator? (Enter 1 if "Yes", O if "No") Megawatt/day b. Determine the total cost. Total cost
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter11: Simulation Models
Section: Chapter Questions
Problem 47P
Related questions
Question
![tes
An electrical utility needs to generate 6,300 megawatts of electricity today. It has five generators (A, B, C, D, and E). If any electricity is
generated by a given generator, that generator must be started up and a fixed start-up cost is incurred. There is an additional cost for
each megawatt generated by a generator. These costs, as well as the maximum capacity of each generator, are shown in the following
table.
Fixed start-up cost
A
$3,000
B
C
D
E
$2,000
$2,500
Cost per megawatt/day
$1,500
$1,000
generated
Maximum capacity (MW/day
$5
2,100
$4
* $6
$6
$7
1,800
2,500
1,500
3,000
Click here for the Excel Data File
Formulate and solve this model on a spreadsheet.
a. Determine the minimum cost plan that meets the electrical needs for today.
Note: Leave no cells blank. Enter "O" wherever required.
Startup generator? (Enter 1 if "Yes", 0 if "No")
Megawatt/day
b. Determine the total cost.
Total cost](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ff3453bcd-7bd0-41ad-883f-c0ea7009f067%2Fdb867f14-9603-48d6-9b79-4aa0ca0fe1ba%2Fjwj5ksj_processed.jpeg&w=3840&q=75)
Transcribed Image Text:tes
An electrical utility needs to generate 6,300 megawatts of electricity today. It has five generators (A, B, C, D, and E). If any electricity is
generated by a given generator, that generator must be started up and a fixed start-up cost is incurred. There is an additional cost for
each megawatt generated by a generator. These costs, as well as the maximum capacity of each generator, are shown in the following
table.
Fixed start-up cost
A
$3,000
B
C
D
E
$2,000
$2,500
Cost per megawatt/day
$1,500
$1,000
generated
Maximum capacity (MW/day
$5
2,100
$4
* $6
$6
$7
1,800
2,500
1,500
3,000
Click here for the Excel Data File
Formulate and solve this model on a spreadsheet.
a. Determine the minimum cost plan that meets the electrical needs for today.
Note: Leave no cells blank. Enter "O" wherever required.
Startup generator? (Enter 1 if "Yes", 0 if "No")
Megawatt/day
b. Determine the total cost.
Total cost
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 12 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,