The company wants to come up with an optimal shipping strategy that will allow it tominimize its total shipping cost.Sensitivity ReportAdjustable CellsCell$B$9$C$9$D$9$B$10$C$10$D$10$B$11$C$11$D$11ConstraintsCell$E$9$E$10$E$11$B$12$C$12$D$12Final Reduced Objective Allowable AllowableCoefficientIncreaseDecreaseName Value CostX1250X20X30X450X5100X6200X70X8 400X90F1F2F3R1R2R301200FinalShadowName Value Price2503504003005002000103-20-234213234222311E+301E+301121E+3011E+30ConstraintAllowableR.H. Side Increase2503504003005002005001000001E+3012111E+3011E+303AllowableDecrease01E+30050100200Use the Sensitivity Report to answer the following questions:(A) Please formulate the linear programming model.(B) Will any of the retail outlets experience any shortages in meeting their demand re-quirements if we implement the optimal solution?(C) Will any of the factories have any remaining quantities of the product if we imple-ment the optimal solution?(D) What is the total minimal shipping cost?(E) Suppose that the shipping cost per unit for variable X₁ (i.e., route F1-R1) increases to$2.00. What impact will this have on the current optimal solution and the objectivefunction value?(F) Suppose that the shipping cost per unit for variable X6 (i.e., route F2-R3) increasesby $2.00 to $5.00. What impact will this have on the current optimal solution andthe objective function value?(G) Suppose that the factory constraints and the retail outlet constraints become "<".What would the optimal solution and the objective function coefficient be? (Hint:The answer to this question is not given in the Sensitivity Report.) E Modeling and Analysis1. A company can ship its product from any of its three factories, F1, F2, and F3, to anyof its retail outlets, R1, R2, and R3. The capacity, demand, and shipping cost informationis provided as follows:Demand and CapacityDemand (units)R1: 300R2: 500R3: 200Capacity (units)F1: 250F2: 350F3: 400Shipping Cost/unit ($)R1 R2 R3F1 1 3F2 3 4F322223

“Since you have posted a question with multiple sub parts, we will provide the solution only to the…

Answered: The company wants to come up with an…

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

Alvarez Incorporated can purchase component X from 3 potential suppliers. Supplier A charges a fee of $6.50 per component. Supplier B charges $2100 per order plus $2.50 per component ordered. Supplier C charges $4.00 per component, and requires the buyer to pay for at least 300 components (even if the order size is less than 300). 4. What is the full range of order sizes where each supplier is optimal? 5. Alvarez decided to buy 1000 units of component X from supplier B. How much money could the company have saved if it purchased the 1000 units from supplier C instead of supplier B? 6. Next week supplier B will be running a 18% off special. What equation represents the new Total Cost for supplier B during the sale? Hint: plug the same number of units into both the new and the original Total Cost equations. The new equation should provide a value that is 18% less than the original.
What is the impact of lead times on the implementation of the Wilson approach in supply chain management?
12. Determine the planned purchases for January (a) at retail and (b) at cost for the lingerie department when the seasonal merchandise plan indicates the following planned figures: Round to the nearest dollar. Sales $88,000 Markdowns 8% BOM Stock $81,000 EOM Stock $66,000 Markup 49%
After applying the NWC Rule for the initial tableau of the given transportation model, evaluate the vacant cells. What is the cell which has the most negative evaluation value and what is the cell evaluation value? DESTINATION SOURCE DEMAND X Y N OX-R; 1 OY-S; -1 OX-S; -1 OY-S; -2 P 75 8 12 EI 11 Q 80 5 8 11 R 120 7 10 10 S 50 11 13 14 SUPPLY 100 125 100 325
Please do not give solution in image format thanku
What is the distinction between simulated and projected average demand:
Put this in other words. Analyze and elaborate this one. In the intricate orchestration of supply chain management, predictive analytics emerges as an indispensable conductor. Drawing upon colossal datasets from multifarious sources, predictive analytics unfurls a tapestry of precise supply and demand prognostications, meticulous inventory optimization, seamless logistics orchestration for punctual deliveries, anticipation of equipment maintenance exigencies, and the nimble adaptation to unforeseen contingencies. In this ever-evolving landscape, predictive analytics has metamorphosed into a critical lever for cultivating an agile and resilient supply chain, warding off disruptions, and laying the foundations for sustainable success.
Explain the Purchasing Portfolio that is being used in KFC with a diagram
Below are the market prices and historical prices that your company has been paying for three different purchasing teams. Which of the purchasing teams is performing the BEST? Steel Paper Fuel a) Steel Ob) Paper PPI (Market) Oct-19 173.7 176.3 166.8 Oct-20 191.7 186.5 187.6 O) Fuel O d) None of the teams are performing well Oe) There is not enough information to make a determination Actual (Historical) Oct-19 2.25 27 132.75 Oct-20 3 28.8 145
[8] United States. Your harvest has just come in and you picked 795,000 pounds of apples. You need to distribute the harvest to the appropriate warchouse locations. You manage an apple orchard that distributes fruit throughout the southeast part of the [A] Using the following warchouse information, allocate the apples to their appropriate locations. DEMAND STANDARD DESIRED WARE CURRENT STOCK DEVIATION OF DEMAND HOUSE INVENTORY FORECAST AVAIL- ABILITY Atlanta 35,000 lbs 190,000 lbs 20,000 lbs 95% Miami 10,000 Ibs 170,000 lbs 18,000 lbs 95% Columbia 45,000 lbs 155,000 Ibs 10,000 lbs 85% Memphis 5,000 lbs 145,000 Ibs 25,000 lbs 80% [B] Discuss two additional methods to push inventory into a network.
Chris Sandvig Irrigation, Inc., has summarized the price list from four potential suppliers of an underground control valve. See the table below. Annual usage is 1,100 valves; order cost is $10 per order; and annual inventory holding costs are $7.55 per unit. D D Vendor A Quantity 1-14 15-24 25-99 100-199 200-399 400+ Price $35.00 34.75 33.55 32.35 31.15 30.75 Vendor C Vendor D Vendor A D Vendor B Vendor B Which vendor should be selected and what order quantity is best if Sandvig Irrigation wants to minimize total cost? Chris Sandvig Irrigation should order units at a time from (enter your response as a whole number). Quantity 1-24 25-99 100-199 200-399 400+ Price $34.75 34.00 32.80 31.60 30.50 MacBook Air O Vendor C Quantity 1-49 50-149 150-299 300+ Price $34.50 33.75 32.50 31.10 Vendor D Quantity 1-149 150-299 300+ Price $34.25 33.00 31.00 Next
Eight Flags operates several amusement parks in the Midwest. The company stocks machine oil to service the machinery for the many rides at the parks. Eight Flags needs 30,000 gallons (D) of oil annually; the parks operate 50 weeks a year. Management is unsatisfied with the current supplier of oil and has obtained two bids from other suppliers. The data are contained in the following table. D i Annual Freight Costs Shipping Quantity (Q) (wks) Cost Supplier Sharps Winkler 5,000 $5,200 $5,400 Price/Unit Annual Holding Lead Time (L) Annual Administrative 10,000 15,000 (P) Cost/Unit (H) $3,600 $3,200 $3.70 $3.700 $3,400 $0.74 5 $4,000 $5,000 $3.90 $0.78 6 Which supplier and which shipping quantity will provide the lowest costs for Eight Flags? Using and a shipping quantity of is the lowest cost alternative, with annual total costs to Eight Flags of $. (Enter your response as an integer.)

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