Set up the mathematical formulation of linear programming problem for the following optimization problems. Solve them...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Set up the mathematical formulation of linear programming problem for the following optimization problems. Solve them using Excel Solver a. Failsafe Electronics Corporation primarily manufactures four highly technical products, which it supplies to aerospace firms that hold NASA contracts. Each of the products must pass through the following departments before they are shipped: wiring, drilling, assembly and inspection. The time requirements in each department (in hours) for each unit produced and its corresponding profit value are summarized in this table: PRODUCT WIRING DRILLING ASSEMBLY INSPECTION UNIT PROFIT XJ201 XM897 TR29 BR788 1.5 1.5 1.0 DEPARTMENT 3 1 2 3 CAPACITY (IN HOURS) 24 1 2 1,500 2,350 2,600 1,200 1.0 .5 .5 The production time available in each department each month and the minimum monthly production requirement to fulfill contracts are as follows: MINIMUM DEPARTMENT PRODUCT PRODUCTION LEVEL Wiring XJ201 Drilling XM897 Assembly TR29 Inspection BR788 Find the number of units of each product that needs to be produced in order to maximize profit. $9 $12 $15 $11 150 100 300 400 Set up the mathematical formulation of linear programming problem for the following optimization problems. Solve them using Excel Solver a. Failsafe Electronics Corporation primarily manufactures four highly technical products, which it supplies to aerospace firms that hold NASA contracts. Each of the products must pass through the following departments before they are shipped: wiring, drilling, assembly and inspection. The time requirements in each department (in hours) for each unit produced and its corresponding profit value are summarized in this table: PRODUCT WIRING DRILLING ASSEMBLY INSPECTION UNIT PROFIT XJ201 XM897 TR29 BR788 1.5 1.5 1.0 DEPARTMENT 3 1 2 3 CAPACITY (IN HOURS) 24 1 2 1,500 2,350 2,600 1,200 1.0 .5 .5 The production time available in each department each month and the minimum monthly production requirement to fulfill contracts are as follows: MINIMUM DEPARTMENT PRODUCT PRODUCTION LEVEL Wiring XJ201 Drilling XM897 Assembly TR29 Inspection BR788 Find the number of units of each product that needs to be produced in order to maximize profit. $9 $12 $15 $11 150 100 300 400
Expert Answer:
Answer rating: 100% (QA)
Step 13 Set up the given optimization problem in Excel as shown below Step 23 Formulae use... View the full answer
Related Book For
Quantitative Methods for Business
ISBN: 978-0324651751
11th Edition
Authors: David Anderson, Dennis Sweeney, Thomas Williams, Jeffrey cam
Posted Date:
Students also viewed these accounting questions
-
Bedco manufactures bed sheets and pillowcases which it supplies to a major hotel chain. It uses a just-in-time system and holds no inventories.The standard cost for the cotton which is used to make...
-
An electronics firm produces electronic components, which it supplies to various electrical manufacturers. Quality control records indicate that different employees produce different numbers of...
-
An electronics corporation manufactures four highly technical products that it supplies to aero-space firms. Each of the products must pass through the following departments before being shipped:...
-
Use a calculator to evaluate an ordinary annuity formula \[A=m\left[\frac{\left(1+\frac{r}{n}ight)^{n t}-1}{\frac{r}{n}}ight]\] for \(m, r\), and \(t\) (respectively) given in Problems 7-22. Assume...
-
If you were Gov. Blagojevichs public relations advisor, how would you have suggested he respond to the seating of Roland Burris as senator?
-
If the quadratic equation kx 2 + 6x + 4 = 0 has exactly one solution, what is the value of k? A) B) D) 74
-
In 2020, Peter purchased 150 shares of Able Manufacturing Corporation stock for \($75,000.\) Able is a C corporation that has 40 shareholders. None of the other 39 shareholders own more than 5% of...
-
Cammie received 100 NQOs (each option provides a right to purchase 10 shares of MNL stock for $10 per share) at the time she started working for MNL Corporation four years ago when MNL's stock price...
-
Find support reactions for a beam shown below. 3 kN 2 kN/m 30 A 1 m 1 m (a) Original beam 2 m UNA B
-
At the beginning of the year, Carla Vista Company had total assets of $763,000 and total liabilities of $296,000. Answer the following questions. (a) If total assets increased $134,000 during the...
-
Discuss inventory management techniques to ensure product availability and minimize overstock. Explain how these techniques contribute to cost control and customer satisfaction.
-
Why do firms elect rules other than NPV (e.g. payback rule)? Would the NPV rule be more appropriate? Why or why not?
-
Sevilla Chemicals earned $1 billion in after-tax operating income on capital invested of $5 billion last year. The firm's cost of equity is 12%, its debt-to-capital ratio is 25%, and the after- tax...
-
Why has risk management become important to Islamic banking operations nowadays? Explain
-
Illustrate how Artificial Intelligence can be helpful for legal data analysis; Illustrate the technology and legal challenges of applying AI for legal data analysis.
-
Bond Calculation Exercise The Government of Canada is issuing a new 4 year Bond Today to yield 10% annually. We wish to purchase $10,000 of the issue. How do we prove it is worth that amount to us?...
-
A company purchased $11,400 of merchandise on June 15 with terms of 3/10, n/45, and FOB shipping point. The freight charge, $1,200, was added to the invoice amount. On June 20, it returned $1,920 of...
-
The column shown in the figure is fixed at the base and free at the upper end. A compressive load P acts at the top of the column with an eccentricity e from the axis of the column. Beginning with...
-
For Floyd Distributors in Problem 29, we were given Q*= 25, D = 200, Ch = $5, and a normal lead-time demand distribution with = 12 and = 2.5. a. What is Floyds reorder point if the firm is willing...
-
Westside Auto purchases a component used in the manufacture of automobile generators directly from the supplier. Westsides generator production operation, which is operated at a constant rate, will...
-
Consider the following two-person, zero-sum game. Identify the pure strategy. What is the value of thegame? Player B Plaver48 57 2 410 dh
-
Is Fairmont in compliance with company policy that requires explicit approval of all hours of eighty hours or more.
-
In what year was the original company formed?
-
Answer the following questions: 1. Name at least five industries that might be affected by weather. 2. Is it appropriate for the forensic accountant/fraud examiner to examine the effect of weather?...
Study smarter with the SolutionInn App