Homework Help is Here – Start Your Trial Now!
Business
Operations Management
Yakima Construction Corporation (YCC) is considering a number of different development projects. The cash outflows that would be required to complete each project are indicated in the table below, along with the expected net present value of each project (all values in millions of dollars). NPV ($million) Year 1 Year 2 Project 1 Project 2 Project 3 Project 4 20 12 15 Cumulative Cash Outflow Required ($million) 8 14 10 18 12 18 4 14 20 9 Project 5 23

Yakima Construction Corporation (YCC) is considering a number of different development projects. The cash outflows that would be required to complete each project are indicated in the table below, along with the expected net present value of each project (all values in millions of dollars). NPV ($million) Year 1 Year 2 Project 1 Project 2 Project 3 Project 4 20 12 15 Cumulative Cash Outflow Required ($million) 8 14 10 18 12 18 4 14 20 9 Project 5 23

Practical Management Science
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
icon
Related questions
Question

Nikul 

New Exercise Bank Content Qu. 10-14 Yakima Construction Corporation (YCC) is considering a number of different development projects. The cash outflows that would be required to complete each project are indicated in the table below, along with the expected net present value of each project (all values in millions of dollars). Project 1 Project 2 Project 3 Project 4 Project 5 9 23 NPV ($million) 12 15 20 Cumulative Cash Outflow Required ($million) Year 1 8 10 12 4 14 Year 2 14 18 18 7 20 Year 3 17 25 24 9 25 Year 4 17 30 30 9 32 Click here for the Excel Data File Each project must be done in full (with the corresponding cash flows for all four years) or not done at all. Furthermore, there are the following additional considerations. Project 1 cannot be done unless Project 2 is also undertaken, and projects 3 and 4 would compete with each other, so they should not both be chosen. YCC expects to have the following cash available to invest in these projects: $30 million for year 1, $25 million for year 2, $16 million for year 3, and $12 million for year 4. Any available money not spent in a given year is then available to spend the following year. YCC's policy is to choose their projects so as to maximize their total expected NPV. Formulate and solve this model on a spreadsheet. a. Determine the combination of each project that YCC should undertake to maximize total expected NPV. Note: Leave no cells blank. Enter "O" wherever required. Project 1 Project 2 Project 3 Project 4 Project 5 Undertake? (Enter 1 if "Yes", 0 if "No")
Transcribed Image Text:New Exercise Bank Content Qu. 10-14 Yakima Construction Corporation (YCC) is considering a number of different development projects. The cash outflows that would be required to complete each project are indicated in the table below, along with the expected net present value of each project (all values in millions of dollars). Project 1 Project 2 Project 3 Project 4 Project 5 9 23 NPV ($million) 12 15 20 Cumulative Cash Outflow Required ($million) Year 1 8 10 12 4 14 Year 2 14 18 18 7 20 Year 3 17 25 24 9 25 Year 4 17 30 30 9 32 Click here for the Excel Data File Each project must be done in full (with the corresponding cash flows for all four years) or not done at all. Furthermore, there are the following additional considerations. Project 1 cannot be done unless Project 2 is also undertaken, and projects 3 and 4 would compete with each other, so they should not both be chosen. YCC expects to have the following cash available to invest in these projects: $30 million for year 1, $25 million for year 2, $16 million for year 3, and $12 million for year 4. Any available money not spent in a given year is then available to spend the following year. YCC's policy is to choose their projects so as to maximize their total expected NPV. Formulate and solve this model on a spreadsheet. a. Determine the combination of each project that YCC should undertake to maximize total expected NPV. Note: Leave no cells blank. Enter "O" wherever required. Project 1 Project 2 Project 3 Project 4 Project 5 Undertake? (Enter 1 if "Yes", 0 if "No")
Expert Solution
steps

Step by step

Solved in 4 steps with 11 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
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
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.
SEE MORE TEXTBOOKS