Question 54) ListenA company produces A and B. The objective is to determine the number of units of Aand B to produce to maximize total profit. The model is presented below:Max 2A + 6BS.T.Production 3A + B <= 60Raw Materials 2A + 4B >= 50Order 4A - 2B >= 20N-N A, B >= 0Assume the optimal solution is (A-14, B=18) and total profit = 136. Consider thefollowing sensitivity report: Following the same case, optimal solution is (A=14, B-18), total profit = 136, and sensitivityreport given below.Variable CellsFinal Reduced Objective Allowable AllowableCell$B$9 units ASC$9 units BNameValueCostCoefficient IncreaseDecrease1416141861E+30 5.333333333ConstraintsFinal Shadow Constraint Allowable AllowableCellNameValuePriceR.H. SideIncreaseDecreaseSB$14 Production LHS$B$15 Raw Materials LHS602.8601E+302510050501E+30SB$16 Order LHSWhat happens if Prodluction's RHS = 50 (instead of 60) AND Order's RHS = 30(instead of 20)?20-1.62050140%3!Optimal solution will change, new total profit = 92Optimal solution will change, I need to re-run SOLVER to get the new totalprofitOptimal solution will stay the same, new total profit = 92Optimal solution stay the same, new total profit = 124%3!

Linear programming is a technique used to maximize or minimize the set of given variables. These…

Answered: Following the same case, optimal…

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

Standard Costing; Variance Analysis; Strategic Considerations In a Wall Street Journalarticle, the author notes that various retailers in the United States (e.g., Meijer, Gap, and OfficeDepot) are turning to consulting firms, such as Accenture, to develop engineered labor standards forcashiers and other retail workers. Monitoring labor-hour consumption (i.e., labor efficiency) undersuch standards involves timing from the first scan of an item in a customer’s purchase to the production of a sales receipt for the customer. A commentator for Meijer states that the system now in usehas enabled the company to more efficiently staff stores while concomitantly increasing customerservice ratings. A representative from another client of Accenture states that the new system allowsthe retailer to determine how many workers to schedule at a given time, resulting in a labor-costreduction of approximately 8%. Engineered standards were developed many years ago in a manufacturing environment, at…
1
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
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)
No probabilities are known for the occurrence of the nature states. Compare the solutions obtained by each of the following criteria: Savage
2. If the projected or forecasted sales of Malinao Bakery for the month of Januaryis 2100 loaves of bread, beginning inventory 50 loaves and the selling price isP50 per loaves. How much are the projected sales in peso of Malinao Bakeryfor January?A. P100,000. C. P107,500.B. P100,500. D. P105,000.
Q7. The president of Rose Bowl Enterprises, Desmond Howard, projects the firms aggregate DEMAND requirements over the next 8 months as follows: These are the monthly DEMAND, not production. MONTH JAN FEB MAR APR MAY JUN JULY AUG DEMAND 1,400 1,600 1,800 1,800 2,200 2,200 1,800 1,800 PRODUCTION 1,600 from December INVENTORY 200 from Dec plus 200 His operations manager is considering a new plan, which begins in January with 200 units on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle time costs. The plan is called plan A. Plan A: Vary the workforce level to execute a strategy that produces the quantity demanded in the prior month. The December demand was given as 1,600 units per month. Therefore, the production for JAN will be 1,600. However, only 1,400 are needed. Therefore, the extra 200 produced go into inventory and there is a holding cost for inventory. Also, per the above, you already have 200 units in inventory…
please answer in 30 mins. answer if 100% sure.

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