Reference no: EM132712197
Problem - The Chief Financial Officer of Eaton Medical Devices has determined that the firm's capital investment budget will be $5,000,000 for the upcoming year. Unfortunately, this amount is not sufficient to cover all of the positive NPV projects available to the firm.
Project
|
Cost
|
NPV
|
A
|
$1,061,191
|
$122,737
|
B
|
561,758
|
58,102
|
C
|
1,647,849
|
280,660
|
D
|
1,026,020
|
89,365
|
E
|
191,870
|
17,568
|
F
|
1,333,625
|
76,960
|
G
|
3,102,642
|
123,240
|
H
|
275,568
|
79,367
|
I
|
2,044,070
|
60,506
|
J
|
1,017,567
|
56,690
|
You have been asked to choose which investments should be made.
Required -
a. Using the Solver, determine which of the above projects should be included in the budget if the firm's goal is to maximize shareholder wealth. (Note: Set the Solver to use the Simplex LP method, and turn off the Ignore Integer Constraints setting.)
b. Now assume that the CFO has informed you that projects A and B are mutually exclusive, but one of them must be selected. Change your Solver constraints to account for this new information and find the new solution. (Use the same options as in part a)
c. Ignore the constraints from part b. The CFO has now informed you that Project I is of great strategic importance to the survival of the firm. It must be accepted. Which projects should be accepted?
d. Explain why the different constraints in parts a, b, and c cause different results. Which one results in the highest total investment? Which one has the highest overall NPV?
e. If you rank the projects by profitability index and then select them until you reach a total cost near $5,000,000 do you get the same results as when optimizing by NPV? Use the Rank. Avg function to rank the projects by profitability index in descending order.
Open-book management-employee commitment to goals
: Open-book management is an aspect of decentralized control in many organizations. Critically evaluate the relationship between open-book management
|
Examine all three pillars of sustainability
: How does excellence leads to sustainability. Be sure to examine all three pillars of sustainability: economic, social, and environmental.
|
Solve the total penalties that joan will be required to pay
: Solve the total penalties that Joan will be required to pay, assuming the failure to file was not fraudulent. Joan filed her individual income tax return 4½
|
Begin with a transitional expression
: Evaluated on these two requirements Each paragraph in your revised prompt response must contain at least six sentences.
|
Which one results in the highest total investment
: Explain why the different constraints in parts a, b, and c cause different results. Which one results in the highest total investment
|
Describe an internationally known organization
: Name and briefly describe an internationally known organization. Make sure you indicate the organization's industry
|
Calculate total penalties that joan will be required to pay
: Joan filed her individual income tax return 4½,Calculate the total penalties that Joan will be required to pay, assuming the failure to file was not fraudulent.
|
What is the amount return associated
: It usually takes Kwarta Corporation 8 calendar days to receive and deposit customer remittances. Kwarta is considering adopting a lockbox system and anticipates
|
Find what balance of accumulated depreciation-equipment
: Green Company purchased equipment on January 1, 2016 for $90,000. What is the balance of the Accumulated Depreciation-Equipment account at December 31, 2018?
|