Management scientist software

Assignment Help Engineering Mathematics
Reference no: EM13962645

Fairview Manufacturing Company is considering a number of expansion projects to take place over the next four years. Specifically, Fairview Manufacturing needs to utilize a capital budgeting process to select appropriate opportunities from a total of five approved projects under consideration. Each project requires lump sum capital outlays over one or more of the years in the budgeting period where each year is subject to a budgetary (capital) constraint. The objective is to select the set of projects that maximizes a measure of total return on investment (net present value) without violating the capital requirements in each year. Project 1 requires a capital outlay of $300,000 in year 1. Project 2 requires a capital outlay of $500,000 in year 2 and an additional outlay of $100,000 in year 3. Project 3 requires an outlay of $100,000 in year 1, an outlay of $200,000 in year 2, another outlay of $100,000 in year 3, and another outlay of $200,000 in year 4. Project 4 requires an outlay of $1,000,000 in year 1, an outlay of $400,000 in year 2, and an outlay of $200,000 in year 3. Capital outlays for Project 5 consist of an initial outlay of $200,000 in year 1, and outlays of $500,000 and $100,000 in years 3 and 4 respectively. The net present value of benefits for these projects are $200,000, $300,000, $100,000, $500,000, and $400,000 for projects 1 through 5 respectively. Capital available for outlay for these projects are $1,200,000 in year 1, $800,000 in year 2, $800,000 in year 3, and $400,000 in year 4.

Fairview Manufacturing has additional considerations with respect to these projects that must be included in the capital budgeting process:

Projects 1 and 3 must be undertaken together, if at all; at most, four projects may be undertaken; Projects 4 and 5 are mutually exclusive and cannot be undertaken together; Projects 2 and 4 are dependent, and if one is undertaken, the other must be as well.

a. Formulate an appropriate linear programming model that can be used to determine the optimal project selection structure for the budgeting period.

b. Determine the optimal project selection using the Management Scientist software, including the projects to included and the total net present value contribution. Provide a narrative that explains the Management Scientist solution used.

Reference no: EM13962645

Questions Cloud

Determine corner points : After the hurricanes in Florida in the summer of 2004, FEMA sent disaster relief trucks to the state carrying bottled water and generators. Each truck could carry no more than 6000 pounds of cargo. Each case of bottled water weighed 25 pounds and ..
Monopolistic competition model : TC = F + c.q where TC is the total cost, F is the fixed cost and q is the output of the firm. q = S[1/n - b(P- Pbar)] where S is the market size, n is the number of firms, P is the price charged by an individual firm and Pbar is the average price in ..
All customers pay for their purchases at time of purchase : Horizon Books is a bookstore in downtown Madina Munawara. It carries an inventory of approximately 50,000 books. Customers come in and browse the shelves, select their books, and take them to one of three cashiers positioned in different parts of the..
Are technology-forcing standards a good idea : Are technology-forcing standards a good idea? Why or why not? The CAA makes the states - not polluters - responsible for complying with NAAQS. Does this make sense? Why or why not
Management scientist software : Determine the optimal project selection using the Management Scientist software, including the projects to included and the total net present value contribution. Provide a narrative that explains the Management Scientist solution used.
What is the electric potential at point x : A +0.605 mC charge is 0.113 m from point x, a -0.398 mC charge is 0.174 m from point x, and a -0.211 mC charge is 0.251 m from point x. What is the electric potential at point x?
Describe the facts about fully funded swaps inside ucits and : Describe the facts about Fully Funded Swaps inside UCITS and MiFID II Implications in the EU economic world. Define differnet kind of swaps.
Find steven''s utility maximizing choice of days : Steven receives utility from days spent traveling on vacation domestically (D) and days spent traveling on vacation in a foreign country (F), as given by the utility function U(D, F) = 10 × DF. In addition, the price of a day spent traveling domestic..
Prepare a paper on model of chronic condition management : Prepare a scholarly paper that focuses on one model of chronic condition management which addresses an area of chronic or complex condition management which you see within your practice.

Reviews

Write a Review

Engineering Mathematics Questions & Answers

  Find the exact value of the logarithmic expression

Write the exponential equation in logarithmic form. log864 = 2 - Find the exact value of the logarithmic expression without using a calculator. log636

  Evaluating recent research

Go to the online library and find a recent (no older than 3 years) article reporting the results of a nursing or health research study in which an ANOVA or Kruskall-Wallis test is used (try using health research and ANOVA or Kruskall-Wallis test a..

  Finite differences for odes

Convert the differential equation into a finite difference equation -  Use the finite difference equation from part1 to calculate numerically.

  Formulate the linear programming model for given problem

Formulate the Linear Programming model for this problem. Solve the problem using Excel Solver or QM for Windows.

  Types of picnic tables

Grand Lake Furniture Company makes two types of picnic tables, rectangular and hexagon. The hexagon table takes 4 hours to make and 2 hours to finish. the rectangular table takes 3 hours to build and 1 hour to finish.

  What initial velocity should it be hit to land in the hole

If the ball is struck and leaves the ground at an initial angle of 30 degree with the horizontal, then with what initial velocity should it be hit to land in the hole?

  Null and the alternative hypothesis

For problem below, state the null and the alternative hypothesis, determine a critical value, present a test statistic, and provide a p-value and your decision. Use

  Evaluate the indefinite integrals

Evaluate the indefinite integrals and Evaluate the definite integrals

  Considering the comfort and safety of passengers

When considering the comfort and safety of passengers why are women ignored in this case?

  Question regarding the apportionment problem

You are a census officer in a newly democratic nation and you have been charged with using the census data from the table below to determine how 100 congressional seats should be divided among the 10 states of the union.

  Formulate a linear program to help smm

If SMM wants to have at least 5 ads per day, but spend no more than $50,000 on Friday and no more than $75,000 on Saturday, formulate a linear program to help SMM decide how the company should advertise over the weekend.

  Implement the project within agreed procedures

Select a project and agree specifications and procedures and implement the project within agreed procedures and to specification.

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