The company H considers four investment alternatives over the next four years. The company's budget for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The company "H" considers four investment alternatives over the next four years. The company's budget for each year as follows: 45 million won in the first year, 50 million won in the second year, 43 million won in the third year, and 37 million won in the fourth year. Due to budget constraints, the company wants to choose the combination of projects that is expected to get the maximum benefit. The estimated NPV and capital expenditure for each project are presented as follows. Project Factory expansion Warehouse expansion Machine replacement New product R&D Capital expenditure (unit - milion won) 국항공대학교 KAVIATION UNIVERSITY NPV (net present value) (estimated, unit - milion won) 1st year 2nd year 3rd year 4th year 95 15 20 15 37 10 20 7 12 11 0 4 35 17 10 9 25 15 0 10 (1) Formulate an IP model for the optimal project selection so as to maximize NPV. (2) Make a spreadsheet model corresponding to your IP model in (1) and solve it using Excel Solver. Assign7 - #6. Investment (2/2) (3) If the factory is not expanded, the warehouse cannot be expanded. What constraints should be added to your IP model? (4) If the factory is expanded, the warehouse must be expanded. What constraints should be added to your IP model? (5) If factory expansion and machine replacement are not carried out at the same time, new product R&D cannot be conducted. What constraints should be added to your IP model? The company "H" considers four investment alternatives over the next four years. The company's budget for each year as follows: 45 million won in the first year, 50 million won in the second year, 43 million won in the third year, and 37 million won in the fourth year. Due to budget constraints, the company wants to choose the combination of projects that is expected to get the maximum benefit. The estimated NPV and capital expenditure for each project are presented as follows. Project Factory expansion Warehouse expansion Machine replacement New product R&D Capital expenditure (unit - milion won) 국항공대학교 KAVIATION UNIVERSITY NPV (net present value) (estimated, unit - milion won) 1st year 2nd year 3rd year 4th year 95 15 20 15 37 10 20 7 12 11 0 4 35 17 10 9 25 15 0 10 (1) Formulate an IP model for the optimal project selection so as to maximize NPV. (2) Make a spreadsheet model corresponding to your IP model in (1) and solve it using Excel Solver. Assign7 - #6. Investment (2/2) (3) If the factory is not expanded, the warehouse cannot be expanded. What constraints should be added to your IP model? (4) If the factory is expanded, the warehouse must be expanded. What constraints should be added to your IP model? (5) If factory expansion and machine replacement are not carried out at the same time, new product R&D cannot be conducted. What constraints should be added to your IP model?
Expert Answer:
Answer rating: 100% (QA)
1 C 45 50 43 37 I 15 25 20 15 95 37 10 11 15 0 7 4 12 35 20 17 10 0 10 9 P 1 2 3 4 5 6 7 8 9 10 11 1... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
A proposed factory expansion project has an expected net present value of $100,000 with a standard deviation of $50,000.What is the probability that the project will have a negative net present value...
-
A planned factory expansion project has an estimated initial cost of $800,000. Based on a discount rate of 20 percent, the present value of the future cost savings from the expansion is $843,000....
-
Get project numbers for projects supplied by at least one supplier not in the same city.
-
Find the number density N/V for electrons such that (a) e -a = 1 and (b) e -a = 10 -6 .
-
The Rollins Sporting Goods Company manufactures baseballs for the professional minor and major leagues at its plants in Costa Rica. According to the rules of major league baseball, a baseball must...
-
What is the "typical" business cycle stock price relationship?
-
Abbott, Inc., plans to issue \(\$ 500,000\) of ten percent bonds that will pay interest semiannually and mature in five years. Assume that the effective interest rate is 12 percent per year...
-
The five nodes in the following network represent points one year apart over a four-year period. Each node indicates a time when a decision is made to keep or replace a firms computer equipment. If a...
-
Illustrate the reasons why delivery does not often take place for futures contracts. Analyse the binomial model of option pricing. Make sure you discuss both the onestep case and the two-step case,...
-
The Gorman Group is a financial planning services firm owned and operated by Nicole Gorman. As of October 31, 2014, the end of the current fiscal year, the accountant for The Gorman Group prepared an...
-
Ned sold the following items last year: Item Holding Period Gain/(Loss) Office Equipment Used for Business Inventory Sales ABC Stock Held for Investment Furniture Used for Business Vacation home...
-
For this role-play, you are required to demonstrate how you would conduct a staff briefing with kitchen staff before the start of a service session, and provide an overview of the session. advise...
-
Like the Windows operating system, Linux also provides keyboard shortcuts for most commands, allowing users to simply press two or more keys on the keyboard at same time instead of typing the exact...
-
1. Balance the chemical Equation P4+02-P203 2. In Ideal Gas Laws, What relation does pressure and volume have? 3. Which is least harmful? Alpha, Beta or Gamma? 4. What is the Mass in grams of 0.850...
-
Batman (mass = 87.8 kg) jumps straight down from a bridge into a boat (mass = 422 kg) in which a criminal is fleeing. The velocity of the boat is initially + 10.9 m/s. What is the velocity of the...
-
Henderson's Hardware has a ROA of 18%, a profit margin of 9% and a ROE of 25%. What is its equity multiplier? Enter the number without putting the times (x) symbol next to it. Round your final answer...
-
3) Evaluate the integral: f -25 xx+36 dx a. Which trig substitution is correct for this integral? A. x = 36sec(0) B. x=36tan(0) C. x=36sin(0) D. x = 6tan(0) E. x = 6sin(0) F. x = -25sec(0) b. Which...
-
2. Assume a person bends forward to lift a load "with his back" as shown in Figure P12.42a. The person's spine piv- ots mainly at the fifth lumbar vertebra, with the principal supporting force...
-
According to the American Lung Association, 90% of adult smokers started smoking before turning 21 years old. (a) Compute the mean and standard deviation of the random variable X, the number of...
-
Researchers wish to know if there is a link between hypertension (high blood pressure) and consumption of salt. Past studies have indicated that the consumption of fruits and vegetables offsets the...
-
To predict future enrollment, a local school district wants to know the number of children in the district under the age of 5. Fifty households within the district were sampled, and the head of...
-
Which of the following techniques involves the creation and use of a pair of public and private keys? a. hashing c. symmetric encryption b. asymmetric encryption d. key escrow
-
Which of the following is a preventive control? a. penetration testing c. training b. patch management d. log analysis
-
The approach to perimeter defense that involves examining only information in the packet header of each individual IP packet is referred to as a. deep packet inspection c. stateful packet filtering...
Study smarter with the SolutionInn App