A4DEFGH6 Variable CellsFinal Reduced Objective Allowable AllowableCell NameValueCostCoefficientIncreaseDecrease$B$14 Gallons Produced Product A$C$14 Gallons Produced Product B2501021E + 3010031E + 3011112 Constraints13FinalShadow Constraint Allowable Allowable14CellNameValuePriceR.H. SideIncreaseDecrease$B$19 Product A Provided$B$20 Total Production Provided$B$23 Processing Time Hours Used152503501251251E + 301643501255017600-160010012518 Referring to Exhibit 1, if the right-hand side of the Total Production Provided constraint changes to 310, then the objective function value:will decrease by 160.O will decrease by 40.O will decrease by 4O will remain the same.

The range of feasibility of the 'Total production provided' constraint is 50 to 125. It means that…

Answered: Referring to Exhibit 1, if the…

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

BJ is the manager of a Grocery Store. She now needs to replenish her supply of strawberries. Her regular supplier can provide as many cases as she wants. However, because these strawberries already are very ripe, she will need to sell them tomorrow. BJ estimates that she will be able to sell 10, 11, 12, or 13 cases tomorrow. She can purchase the strawberries for $3 per case and sell them for $8 per case. However, any unsold case tomorrow will be sold to nearby Cafeterias at a flat price of $2 per case. BJ now needs to decide how many cases to purchase today to be offered for sale tomorrow. BJ has checked the store's records on daily sales of strawberries. On this basis, she estimates that the prior probabilities are 0.2, 0.4, 0.3, and 0.1 for being able to sell 10, 11, 12, and 13 cases of strawberries tomorrow. (a) Develop a decision analysis structured model of this problem using Excel formulas by identifying the decision alternatives, the states of nature, and the payoff table. (b)…
An orthopedic physician group practice uses 12cc syringes from Sherwood for their cortisone injections. During the each of last two years, 40000 of them were used in the office. Each syringe costs $1.50. The physician’s office annually discards, on average, 500 of the syringes that have became inoperable (broken, wrong injection material, lost). The syringes are stored in a room that occupies 2% of the storage area. The storage area constitutes 10% of the leased space. The annual office lease costs $60,000. The group practice can secure loans from a local bank at 6% interest to purchase the syringes. For each placed order, it takes about three hours for an office assistant (whose hourly wage is $9.00 and who receives $3.25 in fringe benefits) to prepare, and communicate the order, and place its shipment in storage. In addition, each order’s overhead share of equipment and supplies (phone, fax, computer, stationary paper) is approximately $4.50. In the past, the office assistant always…
1 ton of material 1 ton of material 2, and 11/13 3 10 The Kashif Corporation blends three raw materials to produce two products: a fuel additive and a solvent base. Each ton of fuel additive is a mixture of ton of material 1 and 3 ton of material 3. A ton of solvent base is a mixture of // Kashif's production is constrained by a limited availability of the three raw materials. For the current production period, Kashif has the following quantities of each raw material: material 1, 20 tons; material 2, 5 tons; material 3, 21 tons. Management wants to achieve the following P, priority level goals. Goal 1: Produce at least 30 tons of fuel additive. Goal 2: Produce at least 15 tons of solvent base. Assume there are no other goals. (a) Is it possible for management to achieve both P₁ level goals given the constraints on the amounts of each material available? If not, which constraint is the limiting factor? O Yes. It is possible to satisfy both P₁ level goals. O No. There is an insufficient…
help please
A chef must decide how many chocolate lava cakes to prepare for the upcoming Mother's Day Dinner special. The chef can either prepare 50, 100, or 150 lava cakes. Assume that demand for the lava cakes can be 50, 100, or 150. Each dish costs $5 to make and is priced at for $7 on the menu. Unsold cakes are donated to a nearby charity center. Assume that there is no opportunity cost for lost sales. Which alternative should be chosen based on the maximax criterion?
1. Write a linear program for the problem. 2. What is the optimal production mix among different coffee varieties and the profit associated with it? 3. What should be the per bag profit of Tarrazu which will make it beneficial to produce this variety? 4. One Cup is considering increasing the weekly bags to 150. If it costs One Cup $3.00 per bag to procure beans of any variety. Conduct sensitivity analysis and determine if One Cup should consider increasing the per week production. 5. Identify the range over which per bag profit of Sumatra and Kona may vary and still retain the current production plan as optimal for One Cup. 6. Once roasted the coffee beans must be preserved properly. To ensure that, One Cup Coffee is considering investing in a vacuum packaging machine for 24 hours/ week. It takes 10, 15 and 10 minutes to pack a bag of Sumatra, Kona and Tarazzu respectively. Identify if the current production plan will suit the installation of the new packaging scheme.
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 =…
Using Goal Seek for the following problem, how much is needed for John to deposit each year into an account to save $5,000 for his new Specialized Mountain bike. Assumes both deposit and withdrawal are at beg of each year Deposit = Interest= Yr 0 Yr 1 Yr 2 Beg Balance $0.00 $0.00 $0.00 Deposit $0.00 $0.00 -$5,000.00 Interest Earned 8% $0.00 $0.00 na End Balance $0.00 $0.00 -$5,000.00

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