Consider the following linear program, which maximizes profit for two products--regular (R) and super (S): Maximize:...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Consider the following linear program, which maximizes profit for two products--regular (R) and super (S): Maximize: 100R + 150S s.t. 1.0 R + 2.5 S 250 Wiring (hours) 4.0 R + 2.5 S 320 Welding (hours) 1.0 R + 4.0 S 300 Inspection (hours) Sensitivity Report: Cell $B$7 Name Regular = $C$7 Super = 100 150 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 39.26 0.00 65.19 0.00 140 250 62.5 87.5 Cell Name Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease $E$3 Wiring (hr/unit) 202.22 0 250 1E+30 47.78 $E$4 Welding (hr/unit) 320 18.52 320 430 132.5 $E$5 Inspection (hr/unit) 300 25.93 300 86 220 Answer the following questions from the sensitivity output of Excel Solver of an LP problem shown above: i) The optimal number of regular products to produce is and the optimal number of super products to produce is for total profits of $ ii) If the company wanted to increase the available hours for one of their constraints by two hours, they should increase iii) The profit on the super product could increase by $ without affecting the product mix. iv) If downtime reduced the available capacity for wiring by 40 hours, the profit would be reduced by $ v) A change in the market has increased the profit on the super product by $5. Total profit will increase by $ vi) If the company wanted to decrease the available hours for one of their constraints by eight hours, they should decrease vii) The number of slack hours in wiring is viii) Shadow price of inspection can be increased from $25.93 to $86 without affecting the product mix " Consider the following linear program, which maximizes profit for two products--regular (R) and super (S): Maximize: 100R + 150S s.t. 1.0 R + 2.5 S 250 Wiring (hours) 4.0 R + 2.5 S 320 Welding (hours) 1.0 R + 4.0 S 300 Inspection (hours) Sensitivity Report: Cell $B$7 Name Regular = $C$7 Super = 100 150 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 39.26 0.00 65.19 0.00 140 250 62.5 87.5 Cell Name Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease $E$3 Wiring (hr/unit) 202.22 0 250 1E+30 47.78 $E$4 Welding (hr/unit) 320 18.52 320 430 132.5 $E$5 Inspection (hr/unit) 300 25.93 300 86 220 Answer the following questions from the sensitivity output of Excel Solver of an LP problem shown above: i) The optimal number of regular products to produce is and the optimal number of super products to produce is for total profits of $ ii) If the company wanted to increase the available hours for one of their constraints by two hours, they should increase iii) The profit on the super product could increase by $ without affecting the product mix. iv) If downtime reduced the available capacity for wiring by 40 hours, the profit would be reduced by $ v) A change in the market has increased the profit on the super product by $5. Total profit will increase by $ vi) If the company wanted to decrease the available hours for one of their constraints by eight hours, they should decrease vii) The number of slack hours in wiring is viii) Shadow price of inspection can be increased from $25.93 to $86 without affecting the product mix "
Expert Answer:
Related Book For
Posted Date:
Students also viewed these general management questions
-
If you go to work for an employer that does not sponsor a retirement plan, what kind of personal retirement account would you probably establish? A traditional IRA or a Roth IRA? Give two reasons to...
-
State true or false: Natural logarithm of 0.0001 = - 9.21 (approximately) %3D O True O False
-
An opera glass has an objective lens of focal length +3.60 cm and a negative eyepiece of focal length -1.20 cm. How far apart must the two lenses be for the viewer to see a distant object at 25.0 cm...
-
The relation between the tension T and the steady shortening velocity v in a muscle is given by the Hill equation: (T + a)(v + b) = (T0 + a)b where a and b are positive constants and T0 is the...
-
The critical density for closure of the universe is pc 10 26 kg/m3 state pc in terms of the average number of nucleons per cubic meter.
-
The objective . . . is not to develop one single approach to measuring and reporting eco-efficiency. Rather it is to establish a general, voluntary framework that is flexible enough to be widely...
-
Review the data from Great Fender given in Exercise E23- 19. Consider the following additional information: Static budget variable overhead........... $ 5,500 Static budget fixed overhead...
-
A company makes a single product and has hired you as a consultant to help management select which alternative course of action they should take. What is the purpose of the company hiring you as a...
-
3. Find all integer solutions (a, b) to a2b+ a2+ 6ab + 6a+ 96 +9=2023
-
You decide to accept a quote from a store specializing in office remodeling. They offer to pay in quarterly installments due over 3 years, giving a footing of $600,000. of $600,000. The estimate as...
-
Corporate) taxes play an important role in making investment decisions. Taxes influence the incremental cash flows needed to assess the feasibility of an investment. Explain why and how taxes are...
-
Understanding how DRIPs work Under DRIP, the company gives any cash dividends that investors would have received to a bank, which acts as a trustee. The bank then uses the money to repurchase the...
-
What role do ethical considerations play in crisis management decision-making processes, particularly concerning stakeholder prioritization and resource allocation during tumultuous circumstances ?
-
what ways can technology, including artificial intelligence, data analytics, and digital platforms, be harnessed to enhance the efficiency and efficacy of crisis response and recovery efforts ?
-
In a turbulent pipe flow that is fully developed, the axial velocity profile is, as is illustrated in Fig. Compare the axial direction momentum flowrate calculated with the average velocity, with the...
-
Find the area of the surface generated by revolving the para- metric curve x = cos 1, y = sin? 1 (0 < I sa/2) about the y-axis.
-
The circuit parameters for the class-A emitter follower shown in Figure P8.16 are \(V^{+}=24 \mathrm{~V}, V^{-}=-24 \mathrm{~V}\), and \(R_{L}=200 \Omega\). The transistor parameters are \(\beta=50,...
-
Consider the BiCMOS follower circuit shown in Figure P8.20. The BJT transistor parameters are \(V_{B E}(\mathrm{on})=0.7 \mathrm{~V}, V_{C E}(\mathrm{sat})=0.2 \mathrm{~V}, V_{A}=\infty\), and the...
-
For the idealized class-B output stage in Figure 8.18 in the text, show that the maximum theoretical conversion efficiency for a symmetrical squarewave input signal is 100 percent. <00 B V+ A Figure...
Study smarter with the SolutionInn App