For each of the following problems, (a) draw the cash flow diagram; (b) present clean and clear manual solutions to the problem; (c) highlight the final answer (only the final answer as required by the problem) by enclosing it within a box.     The following are five proposed projects being considered by an engineer in an integrated transportation company for upgrading an intermodal shipment transfer facility for less than truckload lots of consumer goods. The interrelationships among the projects, and their respective cash flows for the coming budgeting period are shown.  Some of the projects are mutually exclusive.  Also, certain projects are dependent of others that may be included in the final portfolio.  Using the PW method and MARR=10%, determine what combination of projects is best if the capital to be invested is limited to $48,000. Projects B1 and B2 – mutually exclusive Projects C1 and C2 – mutually exclusive and contingent on the acceptance of B2 Project D – contingent on the acceptance of C2     Cash Flows at End of Year Project 0 1 2 3 4 B1 -50,000 20,000 20,000 20,000 20,000 B2 -30,000 12,000 12,000 12,000 12,000 C1 -14,000 4,000 4,000 4,000 4,000 C2 -15,000 5,000 4,000 3,000 2,000 D -10,000 6,000 6,000 6,000 6,000

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 21P
icon
Related questions
Question

For each of the following problems, (a) draw the cash flow diagram; (b) present clean and clear manual solutions to the problem; (c) highlight the final answer (only the final answer as required by the problem) by enclosing it within a box.

 

 

The following are five proposed projects being considered by an engineer in an integrated transportation company for upgrading an intermodal shipment transfer facility for less than truckload lots of consumer goods. The interrelationships among the projects, and their respective cash flows for the coming budgeting period are shown.  Some of the projects are mutually exclusive.  Also, certain projects are dependent of others that may be included in the final portfolio.  Using the PW method and MARR=10%, determine what combination of projects is best if the capital to be invested is limited to $48,000.

Projects B1 and B2 – mutually exclusive

Projects C1 and C2 – mutually exclusive and contingent on the acceptance of B2

Project D – contingent on the acceptance of C2

 

 

Cash Flows at End of Year

Project

0

1

2

3

4

B1

-50,000

20,000

20,000

20,000

20,000

B2

-30,000

12,000

12,000

12,000

12,000

C1

-14,000

4,000

4,000

4,000

4,000

C2

-15,000

5,000

4,000

3,000

2,000

D

-10,000

6,000

6,000

6,000

6,000

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

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,
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