I need d) e) and f) Optimal Objective Value =62000.00000VariableValueReduced CostS4000.000000.00000M10000.000000.00000ConstraintSlack/SurplusDual Value10.00000-0.0566720.000002.166677000.000000.00000ObjectiveAllowableAllowableVariableCoefficientIncreaseDecrease8.00000Infinite4.25000M3.000003.40000InfiniteRHSAllowableAllowableConstraintValueIncreaseDecrease11200000.00000300000.00000420000.00000260000.0000042000.0000012000.0000033000.000007000.00000Infinite 10. Recall the Innis Investments problem (Chapter 2, Problem 39). LettingS = units purchased in the stock fundM = units purchased in the money market fundleads to the following formulation:Min8S +3Ms.t.50S + 100M < 1,200,000Funds available5S +4M >60,000Annual income3,000Units in money marketS, M > 0The computer solution is shown in Figure 3.16.a. What is the optimal solution, and what is the minimum total risk?b. Specify the objective coefficient ranges.c. How much annual income will be earned by the portfolio?d. What is the rate of return for the portfolio?e. What is the dual value for the funds available constraint?f. What is the marginal rate of return on extra funds added to the portfolio?

Rate of return = Annual IncomeFunds invested×100 Rate of return = 600001200000×100=0.05×100=5%

Answered: I need d) e) and f)

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

5.9)
23. The theory of loss aversion and reference dependence implies that (a) equilibrium allocations will usually be outside the Pareto set (b) the location of the Pareto set may depend on the initial allocation (c) the Pareto set is piecewise linear (d) the Pareto set is reduced to a single point in the Edgeworth box (e) the Pareto set lies on two adjacent sides of the Edgeworth box
1. a.Describe in laymen's term, what is meant by optimum yield function. b. How does the optimum yield level of a logistic function compare to its carrying capacity?
1. Aljon, a softdrink dealer, delivers 14 cases on Monday, 10 cases on Tuesday, 12 cases on Wednesday, 15 cases on Thursday, 19 cases on Friday, and 20 cases on Saturday. How many cases are delivered on the average each day?
Materials requirement planning is most closely linked with which capacity module? Group of answer choices Rough cut capacity planning Capacity requirement planning Resource planning Master capacity scheduling
Order 1 2 3 4 5 Time Since Order Arrived (hours ago) 3 1 0 6 5 You answered Sequence Order The due dates reflect the need for the order to be at its next operation. Develop separate schedules by using the FCFS and EDD rules. Compare the schedules on the basis of average flow time and average past due hours. Using the FCFS (first come, first served) decision rule for sequencing the orders, the order is Sequence Order Estimated Machine Time (hours) 15 9 7 10 3 1 5 Rule EDO FCFS 4 4 Using the EDD (earliest due date) decision rule for sequencing the orders, the order is (to resolve a tie, use order in which the orders were received) ¹2 1 4 2 3 Due Date (hours from now) 5 5 3 18 20 21 12 The average flow time and average past due hours for each option (enter your responses are real numbers rounded to two decimal place Average Flow Time Average Past Due Hours
Please, explain in simple terms of how you find the answer , so I may understand and process information given. Thank you soo much. By the way I have uploaded this question before but it wasn't clear .
Pls solve this question correctly in 5 min i will give u like Question # 2 A company produces two products, A and B. The sales volume for product A is at least 40% of the total sales of the two products. Both products use the same raw material, of which the daily availability is limited to 200 kg. Products A and B use this raw material at the rates of 5 kg/unit and 2 kg/unit, respectively. The sales prices for the two products are $50 and $20 per unit. Determine the following: a)Optimum volume of each product to be produced? b)What impact does the production mix have, in case the sales price of Product B decreases by 50%?
Machine 1 Machine m Mm Notation: MIP models for scheduling single stage "m" parallel machines Indices k-machine no.,k € (1.m) 1-job,i € (1.n) 1-job,j e (1. n} Input parameters m= total number of machines n= number of jobs Pprocessing time of job" d,- due date of job " M-large number Decision variables TO_startup time of job " Yu hinary variable, 1:1f job"C precedes job"f in the processing sequence,0: otherwise Wa- himary variable, 1:if job "Tis processed on machine "k",0 otherwise k machine no.,k € {1 - m} 1- Job,Ie (1. . m) 1-Job./E (1.n) M-total number of machines nnumber of Jobs A-processing time of fob "f d- due date of fob " M- large mumber Decision varlables xstartup time of job Yu= binary variable, 1:4f job precedes job " in the processing sequence,0: otherwise W-binary variable, 1:1f fob "C is processed on machine "k", 0: otherwtse
Shown below is a partially completed MPS record for hand drills. a. Develop the MPS record for the hand drills. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.) Item: Hand drills Quantity on Hand: 30 Forecast Customer orders (booked) Projected on-hand inventory MPS quantity MPS start 1 15 20 N 40 25 3 15 15 Week Available-to- promise (ATP) inventory b. A distributor of the hand drills places an order for 15 units. What is the appropriate shipping date for the entire order? The order should ship on week (Enter your response as an integer.) 4 20 20 Order Policy: 60 units Lead Time: 1 week 5 55 0 6 35 0
Kindly give me right solution with clear calculations. This is not a graded question
Given the following decision tree, calculate the EMV and the best decision that should be made. Office Growth BUILD EXPAND a. EMV: $393000; Decision: Build Ob. EMV: $522000; Decision: Build OC. EMV: $915000; Decision Expand and Build Od EMV: $393000; Decision: Expand High Demand Low Demand High Demand Low Demand 60% Probability $650,000 Impact 40% Probability $330,000 Impact 70% Probability $510,000 Impact 30% Probability $120,000 Impact

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS