Variable CellsModelVariableWMConstraintsConstraintNumber123NameWestem Foods SalsaMexico City SalsaNameWhole tomatoesTomato sauceTomato pasteFinalValue560.000240.000Reduced ObjectiveCostCoefficient0.0001.0000.0001.250ShadowPriceFinalValue4480,0001920,0001600,000 0.1880.1250,000ConstraintR.H. Side4480.0002080.0001600,000AllowableIncrease0.2500.150AllowableIncrease1120.0001E+3040,000AllowableDecrease0.1070.250AllowableDecrease160.000160,000320.000Analyze the sensitivity report shown above-a. What is the optimal solution and what are the optimal production quantities?b. Specify the objective coefficient ranges.c. What are the shadow prices for each constraint? Interpret each.d. Identify each of the right-hand-side ranges

Answered: Variable Cells Model Variable W M…

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

Please Solve With Excel
Problem 1Human visual inspection is necessary in many quality engineering contexts and is naturallysubject to subjectivity. This is especially true for the inspection of solder joints on circuit boards,as there are numerous types of solder defects, as well as a degree to which a joint possessesone or more defect. Consequently, even highly trained inspectors can disagree on the status ofa particular joint. In a batch of 10,000 such joints, inspector A found 724 to be defective,inspect B found 751 to be defective, and 1159 of the joints were judged to be defective by atleast one of the inspectors. Suppose that one of the 10,000 joints is randomly selected.a. What is the probability that the selected joint was judged to be defective by neither ofthe two inspectors?b. What is the probability that the selected joint was judged to be defective by inspector Bbut not by inspector A?
Please do not give solution in image formate thanku.
Q1/ One of the dairy canning companies wants to set up a special program for the production of cheese, as it decided to produce two types of cheese, each of which consists of a mixture of ingredients that are manufactured in special machines to become ready for use. The cost of the first type of cheese is 41 dinars, and the cost of the second type is 35 dinars. Each of the two types of cheese contains four components. The manufacture of cheese of the first type requires a mixture of (2, 1, 5, 0.6) and the second type (3, 1, 3, 0.25) units of the components (D, C, B, A). on the sequence. The weekly needs of foodstuffs (D, C, B, A) that are supposed to be provided for the cheese industry are (1250, 250, 900, 232.5) kg, respectively. Required: 1- Formulate a mathematical model for this problem. 2- The quantity of cheese production of the first and second types to obtain .the highest return using the graph method
Please do not give solution in image format thanku
30) The frequency for Booking control level of revenue management decision is A. Daily or weekly B. Real time C. Quarterly or annually D. All of the above
Problem 11-11 (Algo) Famous Albert prldes himself on being the Cookle King of the West. Small, freshly baked cookles are the specialty of his shop. Famous Albert has asked for help to determine the number of cookles he should make each day. From an analysis of past demand, he estimates demand for cookles as VROBARTLITY OF DENAND 0.04 DEEAND 1,800 dosen 2,000 2,200 0.10 0.20 2,400 2,600 2,000 3,000 0.26 0.15 0.03 0.14 ces Each dozen sells for $0.65 and costs $0.49, which includes handling and transportation. Cookles that are not sold at the end of the day are reduced to $0.30 and sold the following day as day-old merchandise. a. Compute the expected profit or loss for each cookie making decislon quantity. (Round your answer to the nearest whole number. Enter expected losses with a negative sign.) Cookles Baked (Dozen) Probability of Demand Expected Profit/Loss 1,800 0.04 2,000 0.10 2,200 0.28 2,400 0.26 2,600 0.15
5.20
Ultimately, _________ was replaced by the _________ on January 1st 1995. Question 2Answer a. GATS, WTO b. WTO, GATT c. IMF, GATT d. GATT, WTO
1. 1.Alabama llc collected sales dara for four months, janurary through april. the data is janurary-17, feburary -24, march -25 and april -26. usung a three month moving average. the forcaste calue of may is a. 21 b.22 c.23 d.24 2. a decision tree branch has an expectrd monrtary value of 108. the probability of success is .6 with an outcome value of 200. what is the outcome value of failure?
A B 6 Variable Cells 7 8 9 10 11 12 Constraints 13 14 Cell Name $B$4 Acres allotted Soybean $C$4 Acres allotted Corn 15 16 C Cell Name $D$2 Workers Amt used $D$3 Fertilizer Amt used 17 $D$4 Acres allotted Amt used 2500 3100 166.67 1166.67 D Final Value 166.6666667 1166.666667 Final Value 1500 5000 1333.333333 E Reduced Cost 0 0 Shadow Price 633.3333333 616.6666667 0 F 2500 3100 G Objective Allowable Allowable Coefficient Increase Decrease 1500 5000 1500 H 3700 1900 950 1850 Constraint Allowable Allowable R.H. Side Increase Decrease 500 1000 1E+30 166.6666667 250 3500 Kinkaid grows soybeans and corn on his land about 12 miles outside of Hartington in northeast Nebraska. He needs to figure out how many acres of the land to allot to each crop to maximize his profit. After solving the problem using Excel, the following sensitivity report is generated. What is the profit margin of Corn?
Please do not give solution in image formate thanku.

SEE MORE QUESTIONS

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