The optimal solution is (G=55.83, F=21.67) and total profit = 495.83. See sensitivityreport below.%3DVariable CellsFinalReducedObjectiveAllowableAllowableCllNameValueCostCoefficientIncreaseDecrease$B$9 G$C$9 F55.83333333151021.66666667101E+307.5ConstraintsFinalShadowConstraintAllowableAllowableCellNameValuePriceR.H. SideIncreaseDecrease60014001E+30SB$14 Contract w/supplier LHSŞB$15 Production Ratio LHS200050-0.7550 216.6666667 1116.666667SB$16 Capacity LHS560800 0.6666666678001E+30If Capacity RHS increases by 10, from 800 to 810...Total profit will remain the sameThe shadow price will change, I have to re-run SOLVERTotal profit will increase by 0.67Total profit will increase by 6.67 Georgia Electronics produce two calculators: Graphic (G) and Financial (F). The modelis given below:Max Total Profit = 5*G + 10 FS.T.:Contract w/supplier 30*G + 15 F >= 6004'G - 8'F >= 5012 G+ 6*F <= 800Production RatioCapacityNon-negativityG,F >= 0The optimal solution is (G=55.83, F=21.67) and total profit = 495.83. See sensitivity%3Dreport below.

Given data is Objective function: Max Z=5G+15F Subject to constraints: 1.) 30G+15F≥6002.)…

Answered: The optimal solution is (G=55.83,…

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

Describe 3 ways that technology has been (or can be) used to increase revenue.
Q3
3
There is no alternative place inside plant premises to store the increased salt consumption. Also the existing storage area cannot be modified and expanded further. Moreover, with the due expansion coming up in next 1 year, the salt consumption will Increase by approx. 50%. 1) Suggest the solution & Innovative way to better utilize the existing space and alternatives for storage area of Salt avoiding any stock-out situation to arise. Nor the plant capacity to be curtailed due to low stock of Salt. Suggestion can be made in terms of new Technology to be adopted and any other Out of Box thinking!
6
Aa33 Economics A solar factory is considering to invest $100,000 in a new machine. The necessity for this machine is predicted to endure only two years due to a quick shift in product mix, after which the machine is expected to have a salvage value of $40,000. The addition of this equipment to the current manufacturing plant is expected to bring $65,000 per year in revenue and the cost of operating is anticipated to be $7,000 per year. The factory only has $75,000 in equity funds, so it needs to borrow the remaining $25,000 at an 8% yearly interest rate, which will be paid back in two equal annual installments. The factory’s effective corporate tax rate is 18%. Assume the asset qualifies for a MACRS property classification of seven years. What is the project’s net present value with a MARR of 16%? (First, you should determine the annual after-tax cash flows) A) -$7,651.5 B) $12,891.9 C) $17,348.5 D) Answers A, B and C are not correct
Lakewood Fashions must decide how many lots of assorted ski wear to order for its three stores. Information on pricing, sales, and inventory costs has led to the following payoff table, in thousands. Order size 2 lots 1 lot 1 lot 3 lots (a) Show a regret table. Order size 2 lots 3 lots Low 13 9 6 Low Demand Medium 16 23 38 High 16 38 61 Demand Medium (b) What decision should be made by the optimist? O 1 lot O2 lots O 3 lots (c) What decision should be made by the conservative? O 1 lot O 2 lots O3 lots (d) What decision should be made using minimax regret? O 1 lot O2 lots O 3 lots High Maximum Regret
James Calender is the buyer for "Joe's Radio Hut", a local electronics chain that has developed a loyal customer base with its quality service and competitive pricing. Due to the short selling lives of electronics products, James has only a single opportunity to order the new GO multifunction photo printer and hair dryer. The item sells for $139.24 and the per unit cost is $128.93. Any units remaining at the end of the season must be disposed of at a cost of $18.04. Demand for the item is believed to be normally distributed with a mean 605 and standard deviation 145.2. What is the cost of shortage? (specify answer to 2 decimal places)What is the critical fractile? (specify answer to 3 decimal places)What is the cost minimizing order quantity? (specify answer as a whole number)
Determine the optimal Q and TC given the following information: D = 30,000 boxes Ch = $2 Co $300 Discount schedule: Quantity (boxes) Price ($ per box) 43 1 to 9,999 10,000 to 14,999 41 15,000 to 19,999 38 20,000 or more 36 Show complete solution.
28. 4.4 The Gorman Manufacturing Company must decide whether to purchase a component part from a supplier or to manufacture the component at its own plant. If demand is high, it would be to Gorman's advantage to manufacture the component. If demand is low, however, Gorman's unit manufacturing cost will be high because of underutilization of equipment. The projected profit in thousands of dollars for Gorman's make-or-buy decision is as follows. Demand Medium $40 $45 Decision Manufacture component Purchase component a. Determine the best decisions using the maximax, maximin, and opportunity loss decision criteria. b. Assume that the probability of low demand is 0.35, of medium demand is 0.35, and of high demand is 0.30. What is the best decision using the expected value criterion and what is the expected value of perfect information? Low $220 $210 High $100 $70
4 (Using the same problem) A vendor for the local ballpark food stand is questioning whether to stock his concession with a large or small inventory. He believes that it will depend upon the size of the crowd. He has developed a payoff matrix for the various alternatives (stocking decision) and states of nature (size of crowd). What is the Expected Monetary Value (EMV)? Alternatives Large Inventory Small Inventory Probability A) $68,400 O B)-$20,000 O C) $10,000 O D) $51,500 O E) $78,400 Large Crowd $220,000 $90,000 .20 PROFIT ($) Average Crowd $50,000 $70,000 .50 Small Crowd -$2,000 -$5,000 30

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