Optimization5

xlsx

School

Thompson Rivers University *

*We aren’t endorsed by this school

Course

6250

Subject

Economics

Date

Feb 20, 2024

Type

xlsx

Pages

Uploaded by AdmiralComputer13551

683f2caf93bc21bb37b71aae80063f64517c0dab.xlsx Distance (km) Boston Chicago Dallas Los Angeles Miami Cost Chicago 983 1,205 2,112 1,390 What would be the revised minimum cost if Dallas Source could produce 1 more unit of electricity = Dallas 1,815 1,205 801 1,332 What would be the revised minimum cost if Miami Source could produce 1 more unit of electricity = Miami 1,539 1,390 1,332 2,757 What would be the revised minimum cost if Boston required 1 more unit of electricity = Problems From Chapter #31 Using Solver to minimize Transportation Costs Problem #5: The following table gives the distances between Boston, Chicago, Dallas, Los Angeles, and Miami. Each city requires 40,000 kilowatt hours (kWh) of power, and Chicago, Dallas, and Miami are capable of producing 70,000 kWh. Assume that shipping 1,000 kWh over 100 Kilometres costs $4. Sources can ship to themselves but cost is $0 From where should power be sent to minimize the cost of meeting each city’s demand? % Change from original Set up and solve this model and find the minimum cost given the constraints. Put your answer in the space below In additional answer the three marginal insight questions. - insights are always based off the original model so make sure you return to the original setting each time - You might want to copy the model down below and use this to get your insights that way your original model is always correct. - you will also have to copy and paste as values for each insight so you remove the formulas ANSWER:

Discover more documents: Sign up today!

Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Related Documents

WEEK 12 ASSIGMENT ECO 252-02 W.docx

WEEK 14 ASSIGMENT ECO 252-02 W.docx

WEEK 3 ASSIGMENT ECO 252-02 W.docx

WEEK 2 ASSIGMENT ECO 252-02 W.docx

Lec 1 Exercise.pdf

Optimization1.xlsx

Optimization2.xlsx

MAC Salary Report.docx

Mastered Report.docx

Module 6 Discussion.docx

GP1-Group 12-Checked.xlsx

Review Test Submissio3.docx

Recommended textbooks for you

Managerial Economics: A Problem Solving Approach

Economics

ISBN:9781337106665

Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor

Publisher:Cengage Learning

Managerial Economics: Applications, Strategies an...

Economics

ISBN:9781305506381

Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris

Publisher:Cengage Learning

Microeconomics: Principles & Policy

Economics

ISBN:9781337794992

Author:William J. Baumol, Alan S. Blinder, John L. Solow

Publisher:Cengage Learning

Survey Of Economics

Economics

ISBN:9781337111522

Author:Tucker, Irvin B.

Publisher:Cengage,

Micro Economics For Today

Economics

ISBN:9781337613064

Author:Tucker, Irvin B.

Publisher:Cengage,

Economics Today and Tomorrow, Student Edition

Economics

ISBN:9780078747663

Author:McGraw-Hill

Publisher:Glencoe/McGraw-Hill School Pub Co

SEE MORE TEXTBOOKS

Recommended textbooks for you

Managerial Economics: A Problem Solving Approach
Economics
ISBN:9781337106665
Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:Cengage Learning
Managerial Economics: Applications, Strategies an...
Economics
ISBN:9781305506381
Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:Cengage Learning
Microeconomics: Principles & Policy
Economics
ISBN:9781337794992
Author:William J. Baumol, Alan S. Blinder, John L. Solow
Publisher:Cengage Learning
Survey Of Economics
Economics
ISBN:9781337111522
Author:Tucker, Irvin B.
Publisher:Cengage,
Micro Economics For Today
Economics
ISBN:9781337613064
Author:Tucker, Irvin B.
Publisher:Cengage,
Economics Today and Tomorrow, Student Edition
Economics
ISBN:9780078747663
Author:McGraw-Hill
Publisher:Glencoe/McGraw-Hill School Pub Co