Fox Enterprises is considering six projects for possible construction over the next four ycars. Fox can undertake any of the projects partially or completely. A partial undertaking of a project will prorate both the return and cash outlays proportionatel; The expected (present value) returns and cash outlays for the projects are given in th following table. Cash outlay ($1000) Project Year ! Year 2 Year 3 Year 4 Return ($1000) 10.5 14.4 2.2 2.4 324.00 8.3 12.6 9.5 3.1 358,00 10.2 14.2 5.6 4.2 177.50 4 7.2 10.5 7.5 5.0 148,00 12.3 10.1 8.3 6.9 6.3 182.00 9.2 7.8 5.1 123.50 Available funds ($1000) 60.0 70.0 35.0 20.0 (a) Formulate the problem as a linear program, and determine the optimal project mix that maximizes the total return using AMPL, Solver, or TORA. Ignore the time value of money. (b) Suppose that if a portion of project 2 is undertaken, then at least an equal portion of project 6 must be undertaken. Modify the formulation of the model, and find the new optimal solution. (c) In the original model, suppose that any funds left at the end of a year are used in the next year. Find the new optimal solution, and determine how much cach ycar "borrows" from the preceding year. For simplicity, ignore the time value of money.

Question

please answer the following question a , b, c, d using execl solver ?

Fox Enterprises is considering six projects for possible construction over the next
four ycars. Fox can undertake any of the projects partially or completely. A partial
undertaking of a project will prorate both the return and cash outlays proportionatel;
The expected (present value) returns and cash outlays for the projects are given in th
following table.
Cash outlay ($1000)
Project
Year !
Year 2
Year 3
Year 4
Return ($1000)
10.5
14.4
2.2
2.4
324.00
8.3
12.6
9.5
3.1
358,00
10.2
14.2
5.6
4.2
177.50
4
7.2
10.5
7.5
5.0
148,00
12.3
10.1
8.3
6.9
6.3
182.00
9.2
7.8
5.1
123.50
Available funds ($1000)
60.0
70.0
35.0
20.0
(a) Formulate the problem as a linear program, and determine the optimal project mix
that maximizes the total return using AMPL, Solver, or TORA. Ignore the time
value of money.
(b) Suppose that if a portion of project 2 is undertaken, then at least an equal portion
of project 6 must be undertaken. Modify the formulation of the model, and find the
new optimal solution.
(c) In the original model, suppose that any funds left at the end of a year are used in
the next year. Find the new optimal solution, and determine how much cach ycar
"borrows" from the preceding year. For simplicity, ignore the time value of money.
Expand
Transcribed Image Text

Fox Enterprises is considering six projects for possible construction over the next four ycars. Fox can undertake any of the projects partially or completely. A partial undertaking of a project will prorate both the return and cash outlays proportionatel; The expected (present value) returns and cash outlays for the projects are given in th following table. Cash outlay ($1000) Project Year ! Year 2 Year 3 Year 4 Return ($1000) 10.5 14.4 2.2 2.4 324.00 8.3 12.6 9.5 3.1 358,00 10.2 14.2 5.6 4.2 177.50 4 7.2 10.5 7.5 5.0 148,00 12.3 10.1 8.3 6.9 6.3 182.00 9.2 7.8 5.1 123.50 Available funds ($1000) 60.0 70.0 35.0 20.0 (a) Formulate the problem as a linear program, and determine the optimal project mix that maximizes the total return using AMPL, Solver, or TORA. Ignore the time value of money. (b) Suppose that if a portion of project 2 is undertaken, then at least an equal portion of project 6 must be undertaken. Modify the formulation of the model, and find the new optimal solution. (c) In the original model, suppose that any funds left at the end of a year are used in the next year. Find the new optimal solution, and determine how much cach ycar "borrows" from the preceding year. For simplicity, ignore the time value of money.

Expert Answer

Want to see the step-by-step answer?

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times may vary by subject and question complexity. Median response time is 34 minutes for paid subscribers and may be longer for promotional offers.
Tagged in
Business
Operations Management

Other

Related Operations Management Q&A

Find answers to questions asked by students like you.

Q: Please view the image and aswer the following

A: FIGURE 3 is the correct answer 

Q: 1. Determine the amount of slack in each of a project's activities (presented below), and identify t...

A: Click to see the answer

Q: Which of the following best describes the operational audit?(1) It requires the constant review by i...

A: Correct answer is (1) It requires the constant review by internal auditors of the administrative con...

Q: Does the ADA address the needs of persons with disabilities in the higher education setting?

A: The Americans with Disabilities Act (ADA) is made to prohibit any discrimination against people with...

Q: Develop a Data Flow Diagram Vendors send invoices to the AP department where they are reviewed and a...

A: These indicating the typical flow of data for invoice processing in an accounts department. The flow...

Q: What characteristic of perception explains why two different managers in a diverse environment may v...

A: The process by which the person chooses, explicate, and organizes the input on their own to give mea...

Q: 1. How would the external and internal factors affect your business as an entrepreneur.

A: Business is the process of making money by producing something or buying and selling products (like ...

Q: CASE 2. MODALITY COMPANY The following describes the expenditure cycle manual procedures for MODALIT...

A: The payment and purchase order cycle may be defined as the entire process or work cycle for purchasi...

Q: The Suregrip Tire Company carries a certain type of tire with the following characteristics:Average ...

A: We have Average annual sales (D) = 600 tires Standard deviation (σ) = 1 tire Ordering cost (O) = $40...

Q: The HIV/AIDS crisis has been called the worst pandemic since the fourteenth century’s Black Plague. ...

A: There are some reasons why pharmaceuticals have higher margins are stated below:- Different Demand p...

Q: Who are Mathur and Kenyon and what have they done?

A: Kenyon is actually: Alfred Kenyon MA FCA FCT, had a long career in industry as a corporate treasurer...

Q: What risk did Matt Maloney and Mike Evans took when they joined forces to start GrubHub?

A: The risks that M M & M Evans took when they associated to start Grub hub are client target &...

Q: Explain how a company can achieve lower production costs and increase productivity by improving the ...

A: Organization has many goals and objectives on the basis of which they run their operation but there ...

Q: Using the intuitive least cost method for the given transportation problem, answer the following: Cl...

A: Given Information:

Q: Forecasting Ticket Revenue for Orlando Magic Basketball Games For its first two decades of existence...

A: Given data,  Team  Date  Day of Week  Time of Year  Rating of the opponent  Additional sales Ph...

Q: Identify the types of auditreports that can be issued whenan unqualified opinion is notjustified

A: There are four types of audit reports: and unqualified opinion, a qualified opinion, and adverse opi...

Q: Describe when and where organisational politics occur and the forms of such behaviour takes. Support...

A: Organizational politics is very common in organizations. It is more likely to occur where competitio...

Q: Need a detailed self explanatory solutions for the following question What are the ways to sustain c...

A: Competitive advantage refers to a business situation where, a business is able to produce goods or s...

Q: There are two main issues that may arise in the course of managingPerformance throughout the year. W...

A: The two main issues that may arise in managing the performance throughout the year are as follows: 1...

Q: A. What is the optimal solution and what is the optimal value of the objective function? B. Which co...

A: a) The optimal solution is 2170 at AB = 100, BM = 60, AP = 0 and BP = 90.   b) Those constraints are...

Q: What is the effect of longer material pipelines and increased average inventorylevels?

A: Pipeline Inventory mentions to stock that is currently in transit between location and has not yet b...

Q: What Is Formal Approaches to Supply Base Rationalization?

A: Supplier rationalization, also known as supply base reduction [SBR] is the process of shrinking the ...

Q: How does Netflix’s internal culture negatively or positively affect their ability to stay competitiv...

A: A company’s culture helps in building values and behavior in the employees that contribute to the so...

Q: Summarize how SWOT analysis can be used to evaluate a company’s strengths, weaknesses, opportunities...

A: One of the most widely used strategic tools for planning is SWOT (Strengths, Weaknesses, Opportuniti...

Q: What will happen if any organization does not care "performance management" of employees? share all ...

A: The communication process occurring between the employee and employer to meet the objective of an or...

Q: Explain it early and correctly

A: Proportionality Assumption: This assumption states that each variable contributes to the objective f...

Q: Revise the following to make the tone conversational yet professional. Pursuant to your e-mail of t...

A: Given : Pursuant to your e-mail of the 12th, please be advised that your shipment was sent April 1...

Q: Is it ethical for special-interest groups to engage in shareholder activism?Explain your answer.

A: The shareholder activism is nothing new, it has existed since the shareholders had voting rights in ...

Q: What is a example topic of a A3 report?

A: Presentation to A3 Issue Solving In arrange for any trade to be fruitful, they must endeavor to mov...

Q: The Scott Corey accounting firm is installing a new computer system. Several things must be done to ...

A: The method of analyzing the set of activities related to the project of the company is known as the ...

Q: Please answer the following multiple choice question 1. Instead of money saved, I look at the produc...

A: Improshare