The supplies, demands, and transportation costs per unit are shown on the network. What is the optimal (cost minimizing) distribution plan?Jefferson City-Des MoinesJefferson City-Kansas CityJefferson City-St. LouisOmaha-Des MoinesOmaha-Kansas CityOmaha-St. LouisTotal15AmountX 301994Costx Consider the following network representation of a transportation problem.4035SuppliesJeffersonCityOmaha1510,81126Des MoinesKansasCitySt. LouisThe cunnlige demande and tranenortation cnete nar tinit are shown on the not30indi1530DemandsWhat in

For this transportation problem/question, I will prepare the spreadsheet model, then, I will solve…

Answered: The supplies, demands, and…

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

The owner of Tidye Food restaurant has exclusive rights to operate in Lilongwe city. The owner currently has a single outlet open, which has proved to be very popular, and there are often waiting lines of customers. The owner is therefore considering opening one or more outlets in the city. What are the key factors that the owner should investigate before making a final decision? What trade-offs would there be in opening one additional site versus opening several additional sites?
1. Huawei decided to expand in Africa. Three possible factory sites are available: Nairobi, Cape Town, and Accra. Factory building costs and transport costs to major customer zones from each site are given below. Production Cost/unit 60 Factory Site Building Cost (per million unit capacity) Cape Town Nairobi Accra 560,000 75 340,000 45 310,000 Customer Zone Demand/yr Transport Costs/unit Cape Town Nairobi Accra #1 # 2 18 million 12 15 million #3 7 9 million 26 million 16 #4 22 Huawei has a building budget of 40 million USD next year. Huawei does not wish annual logistics costs to exceed 40% of total production costs. Write a model that decides which factories will be built in what capacity while meeting annual demand and minimizing all costs. USE PARAMETERS BELOW! Parameters: TRC(ij): transport cost; D(j): demand for zone j; B(i): building cost per million capacity for site i; pr(i): production cost for site i Variables: Model:
A&B Transport Co. is a company that manages a food supply chain. The problem involves the delivery of cargo (canned peas) from four canneries (loading ports) to three destination ports, using tankers. Since the shipping costs are a major expense for the company, management is initiating a study to reduce them as much as possible. For the upcoming season, has come up with an estimation of the available output from each cannery. Furthermore, each destination port has also specific requirements for the total supply of peas that have to be satisfied. This information (in units of tanker loads), along with the shipping cost per tanker load for each loading - destination port combination, is given in Tables 1 and 2. The problem for the A&B Transport Co. is to determine the shipping strategy given the various loading - destination port combinations, so that the total shipping costs are minimised. Question 1 . A&B Transport Co is thinking of including in its strategy the shipment…
Case: The Yellowstone Story Home Country as Largest Production Country Monstansa is Yellowstone's most important location. It is where the company was founded in 1949, it is the location of the headquarters and it is also Yellowstone's biggest manufacturing site. More than one third of all Yellowstone products are produced in Monstansa (577,000 products in 2013). It has all the major components of manufacturing production process: a farm, an agro processing facility, an assembly line and even a label print shop. The factory builds some of the company's most important products (A3, A4, A5 and Q5). For many of the products, Monstansa serves almost as a world market factory, supplying most countries with their respective products, and having a high level of value added for these lines. The Monstansa factory even has an in-house tool-making department, which develops and builds meta-forming tools and assembly-line systems for the factory but also for other factories in the Yellowstone and…
This is about Operations Management problems. I want to know these problem's solutions. (No. 14- 19) I attached images of those Thank you.
Case: The Yellowstone Story Home Country as Largest Production Country Monstansa is Yellowstone's most important location. It is where the company was founded in 1949, it is the location of the headquarters and it is also Yellowstone's biggest manufacturing site. More than one third of all Yellowstone products are produced in Monstansa (577,000 products in 2013). It has all the major components of manufacturing production process: a farm, an agro processing facility, an assembly line and even a label print shop. The factory builds some of the company's most important products (A3, A4, A5 and Q5). For many of the products, Monstansa serves almost as a world market factory, supplying most countries with their respective products, and having a high level of value added for these lines. The Monstansa factory even has an in-house tool-making department, which develops and builds meta-forming tools and assembly-line systems for the factory but also for other factories in the Yellowstone and…
Bindley Corporation has a one-year contract to supply motors for all washing machines produced by Rinso Ltd. Rinso manufactures the washers at four locations around the country. New York City, Fort Worth, San Diego, and Minneapolis. Plans call for the following numbers of washing machines to be produced at each location: New York City Fort Worth San Diego Minneapolis Bindley has three plants that can produce the motors. The plants and production capacities are Boulder Macon Gary Due to varying production and transportation costs, the profit Bindley earns on each 1,000 units depends on where they were produced and where they were shipped. The following table gives the accounting department estimates of the dollar profit per unit. (Shipment will be made in lots of 1,000.) Macon Gary PRODUCED AT NEW YORK CITY Boulder 12 From/To Boulder Macon Gary Requirements 75,000 45,000 60,000 50,000 100,000 145,000 65,000 Candidate Solution Boulder Macon Gary Total supplied Profit 24 11 Boulder Macon…
The Skulls, a student social organization, has two different locations underconsideration for constructing a new chapter house. Skull's president, a POM student, estimates that due to differing land costs, utility rates, etc., both fixed and variable costs would be different for each of the proposed sites, as follows: Location Annual Fixed Variable Alpha Ave $5000 $200 per person Beta Blvd $8000 $150 per person If it is estimated that thirty persons will be living in this new chapter house, which location should the Skulls select?
Required information The Childfair Company has three plants producing child push chairs that are to be shipped to four distribution centers. Plants 1, 2, and 3 produce 12, 17, and 11 shipments per month, respec- tively. Each distribution center heeds to receive 10 shipments per month. The distance from each plant to the respective distributing centers is given below: Distance Plant 1 2 3 1 1450 1750 1250 Distribution Center 3 1050 1250 1450 Obtain an optimal solution, and determine the total cost. Total Cost = $ 2 1950 2050 1850 The freight cost for each shipment is $100 plus 50 cents per mile. 4 1350 1650 1550
SOLVE USING EXCEL Metal Fabricators, Inc. manufactures gas grill tanks, Model # 1420, for four original equipment manufacturers (OEMs). Demand is forecast to be as follows: Quarter 1 = 2,800 tanks, Quarter 2 = 3,400, Quarter 3 = 3,600, and Quarter 4 = 2,900. Due to a hedging program for sheet steel and increases in international tariffs, production cost per quarter vary as follows: Quarter 1 = $23.50 per tank, Quarter 2 = $28.00, Quarter 3 = $25.90, and Quarter 4 = $29.00. Due to production contracts with the OEMs, no shortages are allowed. Beginning inventory for Quarter 1 is 300 tanks. At the end of each quarter, inventory holding costs are $4.25 per tank. a. Formulate the problem as a linear programming model (see Supplement D). b. Solve the model in (a) using Excel Solver.
Scenario 14.1 — Vidalia OnionsWhen Vidalia onions are ready, the entire 13 county (plus parts of seven other counties) area in Georgia where they are grown is devoted to the harvest, packaging and shipping of this delicacy. The Onion Shack currently purchases 120,000 bags of onions each year at a price of $100 per bag (a bag is ten pounds). Onion Shack has historically purchased in lots of 3000 bags. Transit time and capacity vary as indicated in the table (lead time is 2 days more than transit time). The safety inventory that Onion Shack requires is 30% of lead time demand and the holding cost for a bag is 15% of cost. Carrier Quantity Shipped (cwt) Quantity shipped (bags) Shipping cost ($/cwt) Transit time (days) Mashburn Rail 200+ 2000+ $2.10 5 Sylvia Express 100+ 1000+ $2.35 3 Anita Enterprises 250+ 2500+ $1.35 3 Smith Trucking 250+ 2500+ $1.00 3 Use Scenario 14.1 to determine the least expensive option if the Onion Shack continues to purchase 120,000 bags of Vidalia…
6.- Comfort Zone Furniture has plants in Boston, Dallas and Seattle, which ship their production to four demand centers, with the transportation costs indicated in the following table. Using the northwest corner method and stepping stone find the optimal solution. Boston Dallas Seattle Demand 1 $3 $6 $1 20 2 $5 $8 $9 60 3 $7 $5 $7 30 4 $4 $2 $3 40 Capacity 50 50 50 150

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

The supplies, demands, and transportation costs per unit are shown on the network. What is the optimal (Cost Jefferson City-Des Moines Jefferson City-Kansas City Jefferson City-St. Louis Omaha-Des Moines Omaha-Kansas City Omaha-St. Louis Total 15 Amount x 30 1994 Cost x x