Determine the optimal project mix

Assignment Help Operation Management
Reference no: EM13859297

Fox Enterprises is considering six projects for possible construction over the next 4 years. Fox can undertake any of the projects partially or completely. A partial undertaking of a project will prorate both the return and cash outlays proportionately. The expected (present value) returns and cash outlays for the projects are given in the following

Cash Outlay ($1000)

Project

Year 1

Year 2

Year 3

Year 4

Return ($1000)

1

10.5

14.4

2.2

2.4

32.40

2

8.3

12.6

9.5

3.1

35.80

3

10.2

14.2

5.6

4.2

17.75

4

7.2

10.5

7.5

5.0

14.80

5

12.3

10.1

8.3

6.3

18.20

6

9.2

7.8

6.9

5.1

12.35

Available funds ($1000)

60.0

70.0

35.0

20.0

 

Formulate the problem as a linear program (identify your x values, state the objective function, identify your constraints), and determine the optimal project mix that maximizes the total return using Excel Solver. Ignore the time value of money.

Reference no: EM13859297

Questions Cloud

What is the relationship between legal and ethical issues? : What is the relationship between legal and ethical issues?
Create a histogram of the daily commute times : Create a histogram of the daily commute times. Find the most representative average daily commute time across this distribution.
Create a plan to hire an employee for a position : You should create a plan to hire an employee for a position within your organization to support a recent change. In this plan, you should include the hiring criteria you will use to determine the right person for the job.
What are the critical issues surrounding the newly released : What are the critical issues surrounding the newly released tape?
Determine the optimal project mix : Formulate the problem as a linear program (identify your x values, state the objective function, identify your constraints), and determine the optimal project mix that maximizes the total return using Excel Solver. Ignore the time value of money
Eds building company has the production function q : Eds building company has the production function q=20L - L^2. L is the quantity of labor Ed employs. 1. Find marginal production of labor and the average product of Labor  2. For what value of L is MPl greater than 0? For what values is it diminish..
Endogenous verses exogenous growth theoriesin : Research Project 2: Endogenous Verses Exogenous Growth TheoriesIn neoclassical growth models, the sources of growth, is exogenous usually "technology". Such theoretical models hence are able to describe how an economy grows, but not why it grows. To ..
What are the advantages of investing in the common stock : What are the advantages of investing in the common stock rather than the corporate bonds of a company? Compare the certainty of returns for a bond with those for a common stock.
Local government is considering imposing a revenue : The local government is considering imposing a revenue-neutral (tax revenue would be the same in eithercase) 6.25% tax on either tanning beds or soft drinks. Tanning has an elasticity of demand = ?d = -0.9,while soft drinks' ?d = -0.7. Assume the sup..

Reviews

Write a Review

Operation Management Questions & Answers

  There are lots of differences between a quality culture and

there are various differences between a quality culture and a traditional culture. while formulating strategies and

  The electronic medical record for patients and for providers

You have been asked by your supervisor to speak at the next manager meeting about the following topic- What are the advantages and disadvantages of the electronic medical record for patients and for providers

  Probability tree-marginal-conditional-joint probabilities

A metropolitan school system consists of three districts north, south, and central. The north dis-trict contains 25% of all students, the south district contains 40%, and the central district contains 35%. A minimum-competency test was given to all s..

  Create a case study analysis on the company''s external

Conduct a SWOT analysis on the case study company's external and global environment. Create a case study analysis on the company's external and global environmental issues while focusing upon the remote, industry, and operating environments.

  Explain how organization has implemented generic marketing

Pick any retail establishment of your choice in order to assess explain how organization has implemented generic marketing strategy also segmentation strategies.

  Write the formula for price elasticity of demand

Write the formula for price elasticity of demand and describe what it means. How would you expect the price elasticity of demand for health care to vary with health status

  Explain how might principles of scientific management be use

Explain how might principles of scientific management be useful to Springs Industries. Explain how about the quantitative approach.

  Calculating number of vats

A machine cell uses 242 pounds of a certain material each day. Material is transported in vats that hold 12 pounds each. Cycle time for the vats is about two hours.

  Select a film or book

Select a film or book, fiction or non-fiction, or a current news story. Identify and discuss one or more ethical conflicts the story presents with reference to the moral theories.

  A company has recorded the last five days of daily

A company has recorded the last five days of daily demand on their only product. Those values are 120, 125, 124, 128, and 133. The time from when an order is placed to when it arrives at the company from its vendor is 5 days

  International businesspeople avoid relying on self-reference

How can international businesspeople avoid relying on the self-reference criterion when dealing with people from other cultures? Does it make a difference if the business activity is conducted in the home or the host country?

  Analyze the different ways to evaluate economic performance

Analyze the different ways to evaluate economic performance and determine which provides the best assessment of the economy. Explain your rationale.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd