An electrical utility needs to generate 6,500 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 costCost per megawatt/day generatedMaximum capacity (MW/day)Click here for the Excel Data FileA$3,000Startup generator? (Enter 1 if "Yes", 0 if "No")Megawatt/day generatedb. Determine the total cost.Total cost$52,100B$2,000$41,800C$2,500$62,500Formulate 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 "0" wherever required.D$1,500$61,500$1,000$73,000

Linear programming helps us to find the optimal solution/best outcome, given the constraints. Here…

Answered: An electrical utility needs to generate…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter11: Simulation Models

Section: Chapter Questions

Problem 54P

See similar textbooks

Similar questions

It costs a pharmaceutical company 75,000 to produce a 1000-pound batch of a drug. The average yield from a batch is unknown but the best case is 90% yield (that is, 900 pounds of good drug will be produced), the most likely case is 85% yield, and the worst case is 70% yield. The annual demand for the drug is unknown, with the best case being 20,000 pounds, the most likely case 17,500 pounds, and the worst case 10,000 pounds. The drug sells for 125 per pound and leftover amounts of the drug can be sold for 30 per pound. To maximize annual expected profit, how many batches of the drug should the company produce? You can assume that it will produce the batches only once, before demand for the drug is known.
Barbara Flynn sells papers at a newspaper stand for $0.40. The papers cost her $0.30, giving her a $0.10 profit on each one she sells. From past experience Barbara knows that: a) 20% of the time she sells 150 papers. b) 20% of the time she sells 200 papers. c) 30% of the time she sells 250 papers. d) 30% of the time she sells 300 papers. Assuming that Barbara believes the cost of a lost sale to be $0.05 and any unsold papers cost her $0.30 and she orders 250 papers. Use the following random numbers: 14, 4, 13, 9, and 25 for simulating Barbara's profit. (Note: Assume the random number interval begins at 01 and ends at 00.) Based on the given probability distribution and the order size, for the given random number Barbara's sales and profit are (enter your responses for sales as integers and round all profit responses to two decimal places): Random Number Sales Profit 14 4 13 9 25
A man wants to set up a 529 college savings account for his granddaughter. How much would he need to deposit each year into the account in order to have $70,000 saved up for when she goes to college in 17 years, assuming the account earns a 6% return. Annual deposit: $
A young computer engineer has $12,000 to invest and three different investment options (funds) to choose from. Type 1 guaranteed investment funds offer an expected rate of return of 7%, Type 2 mixed funds (part is guaranteed capital) have an expected rate of return of 8%, while an investment on the Stock Exchange involves an expected rate of return of 12%, but without guaranteed investment capital. Computer engineer has decided not to invest more than $2,000 on the Stock Exchange in order to minimize the risk. Moreover for tax reasons, she needs to invest at least three times more in guaranteed investment funds than in mixed funds. Assume that at the end of the year the returns are those expected; she is trying to determine the optimum investment amounts. (a) Express this problem as a linear programming model with two decision variables.(b) Solve the problem with the graphical solution procedure and define the optimum solution.
An electric cooperative's power generation costs $3.20/kWh. Data for two 50-horsepower motors are as shown below. If the interest rate is 20%, determine how many hours should the motors be operated at full load for them to be economical. If the number of hours exceeds the breakeven point, which of the two motors is more economical?
At a small but growing airport, the local airline company is purchasing a new tractor for a tractor-trailer train to bring luggage to and from the airplanes. A new mechanized luggage system will be installed in 3 years, so the tractor will not be needed after that. However, because it will receive heavy use, so that the running and maintenance costs will increase rapidly as the tractor ages, it may still be more economical to replace the tractor after 1 or 2 years. The following table gives the total net discounted cost associated with purchasing a tractor (purchase price minus trade-in allowance, plus running and maintenance costs) at the end of year i and trading it in at the end of year j (where year O is now). i 012 1 $13,000 j 2 $28,000 $17,000 3 $48,000 $33,000 $20,000 The problem is to determine at what times (if any) the tractor should be replaced to minimize the total cost for the tractors over 3 years. (a) Formulate this problem as a minimum cost flow problem by showing the…
At a small but growing airport, the local airline company is purchasing a new tractor for a tractor-trailer train to bring luggage to and from the airplanes. A new mechanized luggage system will be installed in 3 years, so the tractor will not be needed after that. However, because it will receive heavy use, so that the running and maintenance costs will increase rapidly as the tractor ages, it may still be more economical to replace the tractor after 1 or 2 years. The following table gives the total net discounted cost associated with purchasing a tractor (purchase price minus trade-in allowance, plus running and maintenance costs) at the end of year i and trading it in at the end of year j (where year O is now). i B 012 1 $13,000 j 2 $28,000 $17,000 3 $48,000 $33,000 $20,000 The problem is to determine at what times (if any) the tractor should be replaced to minimize the total cost for the tractors over 3 years. (a) Formulate this problem as a shortest-path problem by drawing a…
Your answer is partially correct. An independent contractor for a transportation company needs to determine whether she should upgrade the vehicle she currently owns or trade her vehicle in to lease a new vehicle. If she keeps her vehicle, she will need to invest in immediate upgrades that cost $5,200 and it will cost $1,300 per year to operate at the end of year that follows. She will keep the vehicle for 5 years; at the end of this period, the upgraded vehicle will have a salvage value of $3,800. Alternatively, she could trade in her vehicle to lease a new vehicle. She estimates that her current vehicle has a trade-in value of $9,800 and that there will be $4,100 due at lease signing. She further estimates that it will cost $2,900 per year to lease and operate the vehicle. The independent contractor's MARR is 11%. Compute the EUAC of both the upgrade and lease alternatives using the insider perspective. Click here to access the TVM Factor Table Calculator. 1943.56 EUAC(keep): $…
Williams Auto has a machine that installs tires. The machine is now in need of repair. The machineoriginally cost $10,000 and the repair will cost $1,000, but the machine will then last two years.The labor cost of operating the machine is $0.50 per tire. Instead of repairing the old machine,Williams could buy a new machine at a cost of $5,000 that would also last two years; the labor costwould then be reduced to $0.25 per tire. Should Williams repair or replace the machine if it expectsto install 10,000 tires in the next two years?
An airline studied the data from their passenger records and noted that their customers turn up only about 95% of the time. A flight can accommodate 40 passengers and each seat costs 4,000 Php. Suppose each passenger books a ticket independently and the airline decides to sell 42 tickets for the flight. If more than 40 show up for the flight , then the extra passengers will be compensated PhP10,000 for rebooking and other expenses. 5. If Profit = Ticket sales-Compensation of Bumped passenger(s). What is the profit if 42 customers show up?
A manufacturing firm has four plants and wants to find the most efficient means of meeting the requirements of its four customers. The relevant information for the plants and customers, along with shipping costs in dollars per unit, are shown in the table below: Customer (requirement) Factory (capacity) Customer 1 (125) Customer 2 (150) Customer 3 (175) Customer 4 (75) A (100) $ 15 $ 10 $ 20 $ 17 B (75) $ 20 $ 12 $ 19 $ 20 C (100) $ 22 $ 20 $ 25 $ 14 D (250) $ 21 $ 15 $ 28 $ 12 How many arcs will the network have?
A manufacturing firm has four plants and wants to find the most efficient means of meeting the requirements of its four customers. The relevant information for the plants and customers, along with shipping costs in dollars per unit, are shown in the table below: Customer (requirement) Factory (capacity) Customer 1 (125) Customer 2 (150) Customer 3 (175) Customer 4 (75) A (100) $ 15 $ 10 $ 20 $ 17 B (75) $ 20 $ 12 $ 19 $ 20 C (100) $ 22 $ 20 $ 25 $ 14 D (250) $ 21 $ 15 $ 28 $ 12 Note: This question requires Solver.Formulate the problem in Solver and find the optimal solution. What is the optimal quantity to ship from Factory B to Customer 3? Multiple Choice 25 units 50 units 75 units 100 units 125 units

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS