Question: I need lp model and excel solution. Thanks The We-Grow Co. plans to evaluate project alternatives by concerning net present values (NPV), the capital requirements

I need lp model and excel solution. Thanks

The We-Grow Co. plans to evaluate project alternatives by concerning net present values (NPV), the capital requirements and the available budget for the next four years as indicated in the following table. We-Grow has determined four project alternatives: plant expansion, warehouse expansion, purchasing new machinery, and new product research, respectively. PROJECTS Plant Expansion 90000 15000 20000 20000 NPV Year 1 Cap Rqmt Year 2 Cap Rqmt Year 3 Cap Rqmt Year 4 Cap Rqmt Warehouse Expansion 40000 10000 15000 New Machinery 10000 10000 New Product Total Research Capital 37000 Available 15000 40000 10000 50000 10000 40000 20000 15000 5000 4000 10000 35000 Build an appropriate binary LP model to select the best project-mix that maximizes the NPV with respect to the capital requirements and availabilities. Explain the optimum solution

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

QUESTION 1/2 (40 points) The We-Grow Co. plans to evaluate project alternatives by concerning net present values (NPV), the capital requirements and the available budget for the next four years as...

Please solve with excel solver!!!!! The A company. plans to evaluate project alternatives by concerning net present values (NPV), the capital requirements and the available budget for the next four...

The A company. plans to evaluate project alternatives by concerning net present values (NPV), the capital requirements and the available budget for the next four years as indicated in the following...

Hi, please provide detailed solution for these two questions. Thank you. RSM 333 Spring 2017 Assignment #2 Due Monday, February 6th @ 4pm in Commerce Office Problem #1: (20 marks) Project Analysis /...

The excel homework assignment below has five tabs that cover five different topics: Net Present Value Analysis, Capital Budgeting and Cost of Capital, Working Capital, Management, Financial Ratio...

please i need to solve the attached file ................................................ 1- Kyot limited finances a range of similar services to their clients. Kyot Management Co., Ltd. are...

Please create an excel spreadsheet with formulas for requirement 5 (pages 24-27)and requirement 6 (pages 28-31)only. Please submit in excel format. Both questions and answers are provided for...

Please process at your earliest convenience. I have enclosed the attached document and other required documents. Thank you for your help! Consider how Kyler Valley Spring Park Lodge could use capital...

Research web sites and identify, investigate and document five (5) companies that have made the Best Companies to Work For list. Read the descriptions of these companies. Your ESSAY FORMAT must...

In Exercises 1-2, consider the data points (- 5, 3), (0, 3), (5, 2), and (1 0, 0). Compute the least squares error for the given line. In each case, plot the points and the line. 1. y = 3 - 1/3x 2. y...

q , is a risk analysis technique in which "bad" and "good" sets of financial circumstances are compared with a most likely, on base case, situation. Project analysis Sensitivity analysis Monte Carlo...

Policymakers of Fakesylvania are considering implementing a national tax scheme.They face two alternatives: Tax Plan #1 A flat tax of 10% on all labor market earnings. Tax Plan #2 A head tax where...