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

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
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%?
Hand written solutions are strictly prohibited
Which of these changes will serve to break order synchronization?
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
using spreadsheet models Using the Reciprocal Method allocate service centre costs Manufacturing $910,000 Assembly $175,000 Maintenance $472,000 Robotics $675,000 Department No. of Maintenance Jobs No. of Robotic Machines Manufacturing 265 16 Assembly 75 52 Maintenance 10 Robotics 28
d CE Additional Algo 5-11 Attrition Losses and Yields A process has three resources and two types of flows. The first flow has a demand of 20 units per day, and the second flow has a demand of 40 units per day. The first flow type visits all three resources, while the second flow type only visits the first and the third resources. The capacity is 100 units per day at the first resource, 40 units per day at the second resource, and 70 units per day at the third resource. 1. What is the demand total for each resource? Note: Do not round intermediate calculations. Resource Resource 1 Resource 2 Resource 3 Resource Resource 1 Resource 2 Resource 3 Type 1 20 20 20 Implied Utilization Actual Flow Rate 1 Actual Flow Rate 2 Type 2 2. What is the implied utilization for each resource? Note: Round your answers to 2 decimal places. 40 TO 40 Demand Total 3. What is the actual flow rate for each flow? Note: Round your answers to 2 decimal places.

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