If profit contribution for G increases by 12, from 5 to 17,Since the optimal solution will change, I need to re-run SOLVERO Optimal solution will change, new total profit = 1165.83Both optimal solution and total profit will remain the sameOptimal solution remains the same, new total profit = 1165.83%3D Georgia Electronics produce two calculators: Graphic (G) and Financial (F). The modelis given below:Max Total Profit = 5'G + 10'F%3!S.T.:Contract w/supplier 30*G + 15'F>= 600Production Ratio4*G - 8*F >= 50CapacityNon-negativity12'G + 6*F <= 800G.F >= 0The optimal solution is (G=55.83, F=21.67) and total profit = 495.83. See sensitivityreport below.%3DVariable CellsFinalReducedObjectiveAllowableAllowableCellNameValueCostCoefficientIncreaseDecreaseSB$9 G55.833333331510$C$9 F21.66666667101E+307.5ConstraintsFinalShadowConstraintAllowableAllowableCellNameValuePriceR.H. SideIncreaseDecreaseSB$14 Contract w/supplier LHS200060014001E+30$8$15 Production Ratio LHS50-0.7550 216.6666667 1116.666667$B$16 Capacity LHS800 0.6666666675608001E+30

We have been given the LP formulation data that includes Objective function or total profit value,…

Answered: If profit contribution for G increases…

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

Bob and Dora Sweet wish to start investing $1,000 each month. The Sweets are looking at five investment plans and wish to maximize their expected return each month. Assume interest rates remain fixed and once their investment plan is selected they do not change their mind. The investment plans offered are: Fidelity 9.1% return per year Optima 16.1% return per year CaseWay 7.3% return per year Safeway 5.6% return per year National 12.3% return per year Since Optima and National are riskier, the Sweets want a limit of 30% per month of their total investments placed in these two investments. Since Safeway and Fidelity are low risk, they want at least 40% of their investment total placed in these investments.Formulate the LP model for this problem, using the standard LP format. Remember to define the objective function, the decision variables, and label the constraint functions. There is no need to solve the problem. Note:- Do not provide handwritten solution. Maintain…
4
Company X is planning to run a project that requires an initial investment of RM 80,000.Operation cost is estimated at RM 20,000 per year starting one year from the start of theproject until its project life. Starting second year onwards, the operation cost is expectedto increase by RM 5,000 from previous year. The project will start to generate its annualincome of RM 70,000 on the second year until fifth year. The salvage value of the projectis RM 50,000 and its project life is five years. a) Construct the cash flow diagram to summarize the above transactions. b) Determine the expected project value at the end of five years. Assume the growth rateis 12%.
3
Over the next three years, the expected path of 1-year interest rates is 4, 1, and 1 percent, and the 1-yaer, 2-year, and 3-year term premia are 0, 1, and 2 percent, respectively. The liquidity premium theory of the term structure predicts that the yield curve Question 4 options: slopes upward. has a ^ shape. slopes downward. has a V shape.
3) Maximize Z= 2x, +x2 +3x 3 X+x2+2x3 <25 + X3 5 8 X2+ x3 S10 X1, X2, X3 2 0 Subject to IMe
4
The following is a payoff an Electronic Company's Product The State of Nate Decision Alternative 0.69 0.31 S2 D1 14 D2 13 D3 11 The Expected values for the payoff table as follows: E(D1= 5.72 EID2)= 11.45 EID3) 9.14 What should be the payoff value for the D2 under S1 to keep the solution.or Clek Sne and Sub to abeit Cliok Soella e all ao
Problem 2 Suppose that for years East Campus' short-run Phillips Curve was such that each 1 percentage point increase in its unemployment rate was associated with a 2-percentage point decline in its inflation rate. Then, during several recent years, the short-run pattern changed such that its inflation rate rose by 3 percentage points for every 1 percentage point drop in its unemployment rate. Graphically, did East Campus' Phillips Curve shift upward or did it shift downward?
If the profit per unit on Tables (T) increases to $750 and simultaneously the profit per unit on Chairs (C) increases to $425, determine the new objective function value. Variable Cells Variable Name Value Cost T C Constraints 1 Number Name 2 Final Reduced Objective Allowable Allowable 3 Tables 18 0 Chairs 30 0 Coefficient Increase Decrease 720 395 Cleaning 1920 0 Fabric 4480 0.125 4480 Final Shadow Constraint Allowable Allowable 2080 90 Value Price R.H. Side Increase Decrease Testing 1600 0.188 1600 65 $26.250 O $27.690 O $1,440 Must recalculate. Change violated the 100% nule $24.810 1120 25 1E+30 80 40 160 160 320
Problem 7-41 Southern Oil Company produces two grades of gasoline: regular and premium. The profit contributions are $0.30 per gallon for regular gasoline and $0.50 per gallon for premium gasoline. Each gallon of regular gasoline contains 0.3 gallons of grade A crude oil and each gallon of premium gasoline contains 0.6 gallons of grade A crude oil. For the next production period, Southern has 18,000 gallons of grade A crude oil available. The refinery used to produce the gasolines has a production capacity of 50,000 gallons for the next production period. Southern Oil's distributors have indicated that demand for the premium gasoline for the next production period will be at most 20,000 gallons. a. Formulate linear programming model that can be used to determine the number of gallons of regular gasoline and the number of gallons of premium gasoline that should be produced in order to maximize tota profit contribution. If required, round your answers to two decimal places. L Let R = P =…

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