Hansen Controls has been awarded a contract for a large number of control panels. To meet this demand, it will use itsexisting plants in Houston and Tulsa, and consider new plants in Portland, St. Louis and Lexington. Finished control panelsare to be shipped to Denver, Kansas City and Seattle. Pertinent information is given in the table.Denver11-2-3-Sources4-5-HoustonTulsaPortlandConstructionSt. LouisCostKansas City2----1Shipping Cost to Destination: CapacitySeattle366500,000450,000Lexington 400,000Demand14,00013,00018,000We develop a transportation model as an LP that includes provisions for the fixed costs (construction costs in this case) forthe three new plants. The solution of this model would reveal which plants to build and the optimal shipping schedule.Let xij = the number of panels shipped from source i to destination jy₁ = 1 if plant i is built, = 0 otherwise (i = 3, 4, 5)The constraint x21 + x22+x23 <= 13,000*y3 represents which of the following?Group of answer choicesSupply from TulsaDemand at Kansas CityNone of the others.Supply from HoustonSupply from Portland118810983761351016,00013,0001413,00010,0009,000

The transportation problem is a classic optimization problem in operations research that deals with…

Answered: Hansen Controls has been awarded a…

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

A manufacturing firm has four plants and wants to find the most efficient means of meeting the requirements of its four customers. The relevant information for the plants and customers, along with shipping costs in dollars per unit, are shown in the table below: Customer (requirement) Factory (capacity) Customer 1 (125) Customer 2 (150) Customer 3 (175) Customer 4 (75) A (100) $ 15 $ 10 $ 20 $ 17 B (75) $ 20 $ 12 $ 19 $ 20 C (100) $ 22 $ 20 $ 25 $ 14 D (250) $ 21 $ 15 $ 28 $ 12 How many supply nodes are present in this problem? Multiple Choice: 4 3 1 8 16
Please answer the following in an organized way and showing steps. 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…
The Johnny Ho Manufacturing Company inColumbus, Ohio, is putting out four new electronic components. Each of Ho’s four plants has the capacity to add one more prod-uct to its current line of electronic parts. The unit-manufacturing costs for producing the different parts at the four plants areshown in the accompanying table. How should Ho assign the newproducts to the plants to minimize manufacturing costs?ELECTRONICCOMPONENT PLANT123 4C53 $0.10 $0.12 $0.13 $0.11C81 0.05 0.06 0.04 0.08D5 0.32 0.40 0.31 0.30D44 0.17 0.14 0.19 0.15
Refer to the Factory-to-Six-Customers problem and start with the original information. Each customer increases demand by 1000 units. This increased demand has to be met. Re-calculate the optimal solution. At the new solution, which of the following statements is true? A. The total shipping costs are $252,900 B. Quantity shipped from Factory 1 to Customer 1 declines by 6000 units C. Both A and B D. Neither A nor
1. Evaluate the current China/Taiwan logistics costs. Assume a current total volume of 190,000CBM and that 89 percent is shipped direct from the supplier plants in containers. Use the datafrom the case and assume that the supplier-loaded containers are 85 percent full. Assume thatconsolidation centers are run at each of the four port locations. The consolidation centers useonly 40-foot containers and fill them to 96 percent capacity. Assume that it costs $480 to ship a20-foot container and $600 to ship a 40-foot container. What is the total cost to get thecontainers to the United States? Do not include U.S. port costs in this part of the analysis.2. Evaluate an alternative that involves consolidating all 20-foot container volumes and using onlya single consolidation center in Shanghai/Ningbo. Assume that all the existing 20-foot containerUU- SCM-1200 Introduction to Supply Chain Management Page 2volumes and the existing consolidation center volumes are sent to this single…
Lenka's Fresh Snacks (LFS), the producer of the Lenka Bar, is a granola bar manufacturer based in Yoe, Pennsylvania. LFS produces a number of granola bars for its 450 retail partners across the eastern seaboard, manufacturing them in its 4,000-square-foot facility. According to Steve Rasovsky, CEO, the best-selling flavors for Lenka Bar are peanut butter, and nuts and berries. 8 As LFS continues to expand, it has decided to add a new flavor to its product line: chia seeds and almonds. These ingredients have different order quantities and storage requirements than other ingredients already used in manufacturing. As it considers how to move forward, LFS must consider a number of issues regardingwarehousing and storage. What are some of the key priorities that it must consider?
I need a detailed explanation and assistance to solve this problem: Wineco produces wine cooler as a blend of wine, grape juice and apple juice ingredients, which it sells for $4 per gallon. The costs of ingredients are given in the following table: Cooler Ingredient Price per Gallon ($) wines 1.20 grape juice 1.40 Apple juice 0.60 Wineco owns a blending plant with a production capacity of 200 gallons per day. Because the plant is fully automated, all other production costs are negligible by comparison to the cost of ingredients, and can be ignored. Government regulations mandate that wine cooler products must satisfy the following guidelines: At least 10% of the blend produced must be grape juice. The ratio of apple juice to grape juice in the blend produced must be 2.5:1 The blend produced must contain between 20% and 25% wine. Wineco wishes to use LP in order to determine the quantities of ingredients to buy for a day’s production of wine cooler, so…
The Pampered Pet Kennels Company provides room and board for dogs and cats. The manager must mix up pet food everyday for the animals; the food must meet the following standards: Protein At least 6% Fat At most 10% Upon checking the supplies, one day, the manager found that he has the following quantities on hand: Protein Fat Cost/ kilogram Beef stock 10% 20% P 6.00 Flour 5% 5% P 2.00 Formulate the linear programming model to determine how much of each ingredient the manager should mix up to feed the guests today.
In normal circumstances the airline industry creates value, a portion of which the airlines capture for themselves. Explain what we mean by value capture and how increased competition in the industry might impact the ability of airlines to capture value.
A retail has 8 stores supplied from 4 suppliers, where each supplier supplies different goods. Delivery from the Supplier is in trucks with a capacity of 40,000 units at a cost of $1100 per load plus $100 per delivery to the store. Inventory costs are $0.2 per unit per year. The Supply Chain Manager is considering whether to use direct shipping or Milk Run delivery for 4 stores for each truck in one shipment a) if annual sales in each store are 1000,000 units, which shipping method provides the lower cost b) if the annual sales in each store are 200,000 units, which shipping method provides the lower cost
Wine Accessories Inc. (WAI) produces two models of corkscrews, the standard model and a deluxe model. WAI follows a level aggregate plan, producing 20,000 corkscrews per month, or 5000 corkscrews per week. Th e MPS is developed in weekly time periods. Th e forecasts for each model and the projected available are shown in the next two tables. Th e replenishment order quantity is 2000 units for the standard model and 1000 units for the deluxe model. Note that you can place multipleorders if a single order is insuffi cient to cover the forecast (you can produce 4000 units of the standard model if necessary, or 2000 or 3000 units of the deluxe model). Remember that total weekly production is limited to 5000 corkscrews. Develop an MPS for each of the products.
As the manager of Speedy Supermarket, answer the following questions. (Round dollars to the nearest cent and percents to the nearest tenth of a percent.) An advertisement has two 2 liter bottles and a 12 pack of "Bubbly-Cola". The top says "Speedy Supermarket." Moving down are the 2 liter bottles. Text around them is as follows. Sale 4/$5 2 Liter Bubbly-Cola Products Below the bottles is the 12 pack. Text around it is as follows. Sale $13/3 12 Pack Bubbly-Cola Products (a) If 2 liter Bubbly-Cola products cost Speedy $16.20 per case of 24 bottles, what is the amount of the markup (in $) and what is the percent markup on selling price per case? amount of the markup$ percent markup on selling price % (b) If 12 pack Bubbly-Cola products have a markup of $8.65 per case of six 12 packs at Speedy, what are the cost (in $) and the percent markup on selling price per case? cost$percent markup on selling price % (c) Why has Speedy Supermarket chosen to use markup based on…

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