(b) Solve the linear program formulated in part (a). How many service facilities are required?Where should they be located? (Select all that apply.)BostonNew YorkPhiladelphiaBaltimoreWashingtonRichmondRaleighFlorenceSavannahJacksonvilleTampaMiami(c) Suppose that each service facility can only provide service to regional offices within 300 miles. How many service facilities are required?Where should they be located? (Select all that apply.)BostonU New YorkO PhiladelphiaBaltimoreWashingtonRichmondRaleighFlorenceSavannahJacksonvilleTampaO Miami

Prepare an excel sheet as shown below:Note that in excel the colored values represents the cities…

Answered: (b) Solve the linear program formulated…

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

Dennison Manufacturing makes large helical springs used in aircraft landing gear. The company has narrowed its potential choices for its new manufacturing facility to four cities. The following information is known about the manufacturing and shipping costs of locating in each of these four cities: Fixed Costsper Year Variable ManufacturingCosts per Unit Variable ShippingCosts per Unit Phoenix Buffalo Seattle Atlanta $300,000 $600,000 $1,500,000 $1,750,000 $70.00 $56.00 $36.00 $42.00 $5.00 $4.00 $2.00 $5.00 a. Use break-even point analysis to determine where Dennison should locate.b. Based solely on break-even quantity, if Dennison’s manufacturing forecast for the foreseeable future is 40,000 units annually, where should he locate?
For the linear program Max 2A + 3Bs.t. 1A + 2B <= 6 5A +3B <= 15 A, B >= 0 find the optimal solution using excel. What is the value of theobjective function at the optimal solution?
Compute the objective function value for the following problem: Min 30X + 150Y subject to : 2X>=0 ;2X + 10Y = 20; X+Y>=0 a. 0 b. 54 c. infeasible d. 300 e. unbounded
n operations manager wants to use cost-profit-volume (CPV) analysis to decide the location of a new production facility. The total cost functions of the two alternative, Location A and Location B, are presented below. Given that the target production quantity (volume) is 10,000 units, which location the operations manager should choose and what is the corresponding total cost of this location Tca=260,000 +10Q Tcb=90,000 + 30Q Location B, $390,000 There is no difference between the two locations Location B, $360,000 Location A, $360,000 Location A, $390,000
#1- Maxwell Manufacturing makes two models of felt tip marking pens. Requirements and available resources for each lot of pens are given in the following table: Fliptop Model Tiptop Model Available Plastic 3 4 36 Ink Assembly 5 4 40 Molding Time 5 2 30 The profit for either model is $1,000 per lot. a) What is the linear programming model for this problem? b) Using Microsoft Excel's Solver, find the optimal solution. How many Fliptop models and how many Tiptop models should be produced? What is the maximum profit? c) Will there be excess capacity in any resource? Use Excel's Solver and run a sensitivity report to answer the following questions. d) Over which range can the objective function coefficient for Fliptop Models change without affecting the original optimal solution? What is this range called? e) What is the shadow price (dual price) for the plastic constraint and how would you interpret it? f) What is the shadow price (dual price)…
SUBJECT : OPERATION RESEARCH 1. When problem become unrestricted after changing primal to dual simplex Method justify your statement with valid example. 2. Solve the following problem after finding its dual. Min z = x1 - 3x2 + 3x3 s.t. 3x1 - x2 + 2 x3 ≤ 7 2x1 + 4x2 ≥ -12 -4x1 + 3x2 + 8x3 ≤ 10 x1, x2, x3 ≥ 0
3. Two poultry farms supply companies with chicken feeds. The unit costs of shipping from the farms to the companies are given in the table below. The farm's goal is to minimize the cost of meeting customers' demands. a) Generate a mathematical model for finding the least cost way of shipping chicken feeds from the farms to the companies.(b) if the demand of company number 2 increased by 3 units. By how much would the costs increase? Show your solution. (c). Solve the total cost using the solver add-in in excel. From Company 1 Company 2 Company 3 Supply Farm A 55 65 80 35 Farm B 10 15 25 50 Demand 10 10 10
Modify the warehouse location model as suggested inModeling Issue 2. Specifically, assume that the samefour customers have the same annual shipments, butnow, there are only two possible warehouse locations,each with distances to the various customers. (Thesedistances, along with other inputs, are in the fileP07_27.xlsx.) The company can build either or bothof these warehouses. The cost to build a warehouseis $50,000. (You can assume that this cost has beenannualized. That is, the company incurs a buildingcost that is equivalent to $50,000 per year.) If onlyone warehouse is built, it will ship to all customers. However, if both warehouses are built, then the com-pany must decide which warehouse will ship to each customer. There is a traveling cost of $1 per mile.a. Develop an appropriate model to minimize totalannual cost, and then use Solver to optimize it.Is this model an NLP or an IP model (or both)?b. Use SolverTable with a single input, the traveling costper mile, to see how large…
Quality Air Conditioning manufactures three home air conditioners: an economy model, a standard model, and a deluxe model. The profits per unit are $67, $95, and $133, respectively. The production requirements per unit are as follows: Number ofFans Number ofCooling Coils ManufacturingTime (hours) Economy 1 1 8 Standard 1 2 12 Deluxe 1 4 14 For the coming production period, the company has 300 fan motors, 340 cooling coils, and 2000 hours of manufacturing time available. How many economy models (E), standard models (S), and deluxe models (D) should the company produce in order to maximize profit? The linear programming model for the problem is as follows: Max 67E + 95S + 133D s.t. 1E + 1S + 1D ≤ 300 Fan motors 1E + 2S + 4D ≤ 340 Cooling coils 8E + 12S + 14D ≤ 2000 Manufacturing time E, S, D ≥ 0 The computer solution is shown in the figure below. Optimal Objective Value = 17380.00000 Variable Value…
Direction: Analyze the given problem and show your complete solution. The GEM maker of jewelry makes two bracelet designs, heart design and flower design. The bracelets are made of gold and platinum. The store has 28 ounces of gold and 20 ounces of platinum. Each heart design bracelet requires 3 ounces of gold and 2.5 ounces of platinum and makes a profit of P2500, while each flower design bracelet requires 4.5 ounces of gold and 3 ounces of platinum and makes a profit of P3400. How many heart design bracelets and flower design bracelets should be produced to maximize the profit? Decision variables Tabulation Objective function and constraints Graph and solution Optimum solution Decision
For a table manufacturing company, selling price for a table is $183.00 per Unit, Variable cost is $25.00 per Unit, rent is $3,380.00 per month and insurance is $296.00 per month. Company wants to expand its business and improve the table quality, it wants to increase the selling price for a table to $254.00 per Unit, Variable cost to $43.00 per Unit, bigger area will have rent $5,235.00 per month and insurance is $362.00 per month At what point will the company be indifferent between the current mode of operation and the new option?
Instructions: Solve using Excel Solver. Create the linear programming model and get the optimal solution to the problem. (Follow the steps and format in the photo below) 1. A company manufactures two products X1 and X2 on three machines A, B, and C. X1 requires 1 hour on machine A and 1hour on machine B and yields a revenue of Php 30. Product X2 requires 2 hours on machine A and 1 hour on machine B and 1 hour on machine C and yields revenue of PhP 50. In the coming planning period the available time of three machines A, B, and C are 2000 hours, 1500 hours and 600 hours respectively. Find the optimal product mix.

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