tesAn electrical utility needs to generate 6,300 megawatts of electricity today. It has five generators (A, B, C, D, and E). If any electricity isgenerated by a given generator, that generator must be started up and a fixed start-up cost is incurred. There is an additional cost foreach megawatt generated by a generator. These costs, as well as the maximum capacity of each generator, are shown in the followingtable.Fixed start-up costA$3,000BCDE$2,000$2,500Cost per megawatt/day$1,500$1,000generatedMaximum capacity (MW/day$52,100$4* $6$6$71,8002,5001,5003,000Click here for the Excel Data FileFormulate 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/dayb. Determine the total cost.Total cost

There are 5 generators which may be used to generate electricity. The details are given…

Answered: An electrical utility needs to generate…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Create spreadsheets and use Solver to determine the correct volumes to be produced to minimize cost for the following problem. Your company has two trucks that it wishes to use on a specific contract. One is a new truck the company is making payments on, and one is an old truck that is fully paid for. The new truck’s costs per mile are as follows: 54₵ (fuel/additives), 24₵ (truck payments), 36₵ (driver), 12₵ (repairs), and 1₵ (misc.). The old truck’s costs are 60₵ (fuel/additives), 0₵ (truck payments), 32₵ (rookie driver), 24₵ (repairs), and 1₵ (misc.). The company knows that truck breakdowns lose customers, so it has capped estimated repair costs at $14,000. The total distance involved is 90,000 miles (to be divided between the two trucks).
A UCLA student saved $100,000 for the down payment on a $1,000,000 one-bedroom, two-bathroom home in Encino, California. She can qualify for either a $900,000 fully amortizing 30-year first mortgage loan at a 4.75% annual interest rate from Wells Fargo Bank, or she can qualify for a $790,000 fully amortizing 30-year first mortgage loan at a 4.25% annual interest rate with a $110,000 fully amortizing 30-year second mortgage loan at an 8.00% annual interest rate from Citibank. Should the student prefer the single $900,000 mortgage loan from Wells Fargo Bank or should she prefer the $790,000 first mortgage loan and $110,000 second mortgage loan package from Citibank? Single loan from Wells Fargo Bank No difference Depends on all the terms and conditions in the loan documents from Wells Fargo Bank as compared to those from Citibank Loan package from Citibank
In a transition probability matrix, the sum of every column is 1. True False
Federal Rent-a-Car is putting together a new fleet. It is considering package offers from three car manufacturers. Fred Motors is offering 5 small cars, 5 medium cars, and 10 large cars for $500,000. Admiral Motors is offering 5 small, 10 medium, and 5 large cars for $400,000. Chrysalis is offering 10 small, 5 medium, and 5 large cars for $300,000. Federal would like to buy at least 650 small cars, at least 500 medium cars, and at least 650 large cars. How many packages should it buy from each car maker to keep the total cost as small as possible? Fred Motors packages Admiral Motors packages Chrysalis packages What will be the total cost?$
Federal Rent-a-Car is putting together a new fleet. It is considering package offers from three car manufacturers. Fred Motors is offering 5 small cars, 5 medium cars, and 10 large cars for $500,000. Admiral Motors is offering 5 small, 10 medium, and 5 large cars for $400,000. Chrysalis is offering 10 small, 5 medium, and 5 large cars for $300,000. Federal would like to buy at least 550 small cars, at least 500 medium cars, and at least 550 large cars. How many packages should it buy from each car maker to keep the total cost as small as possible? |packages | packages |packages Fred Motors Admiral Motors Chrysalis What will be the total cost? 2$
Respond to each of the items using the following time series data. Period Demand 144 2 172 3 157 4 160 144 181 7 160 8 176 9. 149 10 183 11 182 12 149 13 153 14 164 15 153 16 104 Click here for the Excel Data File b. Compute all possible forecasts using a five-period moving average. (Round your answers to 1 decimal place.) Absolute Period Demand 5-period SMA Errors 1 144 172 3 157 4. 160 5 144 181 7 160 8 176 9 149 10 183 11 182 12 149 13 153 14 164 LO
Investment A woman invests $360,000 in three different mutual funds. One averages 12% per year,and another averages 16% per year. A third fundaverages 8% per year, and because it has much lessrisk, she invests twice as much in it as in the sum ofthe other two funds. To realize an annual return of$35,200, how much should she invest in each fund?
A solid steel shaft is to transmit a torque of 10kN - m If the shearing stress is not to exceed overline 45MPa find the minimum diameter of the shaft.A solid steel shaft is to transmit a torque of 10kN - m If the shearing stress is not to exceed overline 45MPa find the minimum diameter of the shaft. A solid steel shaft is to transmit a torque of 10kN - m If the shearing stress is not to exceed overline 45MPa find the minimum diameter of the shaft?
help please
A student who is majoring in accounting has two jobs offers: one from PwC for $80,000 and one for E&Y for $76,000. She just found out that she has also received an offer from her dream company, Deloitte for $72,000. She also heard from friends that another student last year may have received an offer averaging around $90,000. She wants to take the Deloitte offer, but her OB professor tells her that she needs to negotiate with them for a better salary. In this negotiation, what is her BATNA? O a O b. $76,000 $72,000 $90,000 $18,000 (the difference between $90,000 and $72,000) OC O d. Oe. $80,000
Company A's stock sells for $142 a share and has a 3-year average annual return of $27 per share. The beta value, a measure of risk, is 0.38. Company B sells for $149 a share and has a 3-year average annual return of $61 a share. The beta value is 1.23. Tori wants to spend no more than $12000 investing in these two stocks, but she wants to obtain at least $3000 in annual revenue. Tori also wants to minimize the risk, that is, the beta value. Determine how many shares of each stock Tori should buy.
Consider a buying firm and a supplier negotiating terms for a contract. Suppose the Marginal Benefit to the buying firm of additional contract provisions in a contract (x) to the firm is: MB = 20,000 – 400x. Suppose the Marginal Cost to the buying firm of additional contract provision to the firm is: MC = 100x. What is the optimal number of contract provisions? Reconsider the previous question. If the maximum value (or price) of the contract that the buying firm is willing to pay for is $3,000, what would you expect the firm to do? a) Use the spot market b) Vertically integrate c) Continue to contract d) engage in holdup

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS