Business Homework Solutions
Problem
#3334

Capital budgeting - Chloe Schwasher, the vp of Finance for a major appliance manufacture

Chloe Schwasher, the vp of Finance for a major appliance manufacture, has before her 8 investment proposals submitted by various segments of the company for her approval or rejection. the table below summarizes each proposal's net present value (NPV)& capital requirements for the next 5 years. because of the limited cash availability not all proposal can be funded. Chloe's objective is to maximize the total NPV of the proposals to be funded. Help Chloe make the decision by sending her a memo w/your recommendations along w/the appropriate STORM outputs. Oh by the way there are some other conditions:
a) Proposals 1,2 & 3 are alternatives for the proposed but not mandatory construction of a new manufacturing plant.
b) proposls 4, 5 & 6 are alternatives for a mandatory new advertising campaign.
c) proposals 7 involves the purchase of a new & more powerful computer, & proposal 8 involves the installation of a new computerized inventory control system. Further the approval of the proposed inventory system is contingent on the approval of the computer system.
(                Proposal                     ($000)
              1   2   3  4  5   6   7   8    Capital
NPV ($000)-->151 197 119 70 130 253 165 300  Available

Capital     YR1 20 100 20 30 50  40  50   80   [230]
required    YR2 20  10 10 30 10  20  40   30   [100] ($000)      YR3 20  0 10 30 10   20  10   20   [50]
            YR4 20  0 10 20 10   20  10    0   [50]
            YR5 10  30 10 10 10  20  10    0   [50]

Note numbers in brackets are Capital Available ($000)
I know this is a maximization problem & I know there are 8 variables but I need the coefficients.  Also need the constraints.  I believe this is a mixed integer problem but I may be wrong.  I am putting the info you give me into a cd-rom program that I will run to get an answer.  Please give me the inputs and can you some how show the work involved?  Please help me.

Solution
What is this?
By OTA - Overall OTA Rating
Purchase Cost Now
$2.19 CAD (was ~$11.97)
Included in Download
  • Plain text response
  • Attached file(s):
    • Book1.xls
$2.19 Instant Download
Add to Cart
Why you can trust BrainMass.com
  • Your Information is Secure
  • Best Online Academic Help Service
  • Students find real academic Success
Related Solutions
Browse