(d) Which warehouse will experience shortage? How much is the shortage?(e) Is there an alternative optimal solution? Why?(c) Calculate the minimum transportation cost.(b) Determine the quantity of wheels that should be shipped from each plantto each warehouse to minimise the total transportation cost.CHAPTER 5 TRANSPORTATION MODELToDistribution CentreFromNP.Сарacity8.6.1013150B.116.9.12120Demand50806060(a) Find an initial solution.(b) Determine an optimal solution and the minimum transportation cost.(c) Which factory will have the surplus? How much is the surplus?(d) Is there an alternative optimal solution?6. A manufacturer produces sport wheels at three plants located at towns A, B,and C. The wheels are sent to three warehouses located at T, X, Y, and Z. Theplant in Town A has 400 units available each month, Town B has 300 units,and Town C has 300 units. The requirements of warehouses at T, X, Y, andZ are 300, 300, 240, and 200 respectively. The transportation costs (in RM)for various routes are given in the table below. The company would like todetermine the least-cost way to meet the demand at each of the warehouses.WarehouseFactoryZYA54.4.B.3.4.6.4.9.4.(a) Find an initial solution.ution problem to

Hello thank you for the question. As per guidelines, we would provide only one answer at a time.…

Answered: (a) Find an initial solution. (b)…

(a) Find an initial solution. (b) Determine an optimal solution and the minimum transportation cost. (c) Which factory will have the surplus? How much is the surplus?

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

Related questions

Q: a) Using the weighted factor-rating method, which country would you select? in the following table,…

A: I have been given multiple selection criteria, Each criterion has a specific weight, Then, I will…

Q: Superior Wire, Inc. produces and sells special types of wire used in a variety of telecommunication…

A: Superior Wire, Inc. manufactures and sells wires of special types which are used in a number of…

Q: (a) Reformulate this problem as a general linear programming problem, and then solve it manually by…

A: The transportation model is used to calculate the minimum cost of the route by selecting different…

Q: a. Minimin b. Minimax C. Equal likelihood

A: Mathematic models of decision-making help businesses take the correct decision for their operational…

Q: Keislss Inc produces refinery glass products and is about to expand its operations in sweden , where…

A: Given: Fixed Cost = $ 9,00,000 Variable cost = $ 92 Unit price = $ 150 Demand = 10,000 units per…

Q: 2. Distances between factory and its warehouses and demand at each warehouse given in the table.…

A: Here, I would use the least cost method to solve the given transportation problem and I would also…

Q: 8.- The Donna Mosier clothing store has plants in three cities (W, Y and Z), which they distribute…

A: The transportation model is used to calculate the minimum cost of the route by selecting different…

Q: Ashley’s Auto Top Carriers currently maintains plants in Atlanta and Tulsa that supply major…

A: Linear programming helps us to find the optimal solution/best outcome, with the given…

Q: our job as an industrial engineer is to come up with the location of the distribution center (to the…

A: MINIMUM WEEKLY COST = 0.5*DISTANCE*QUANTITY

Q: In representing qualitative data, we might use a) Histograms b) Scatter plots c) Pie charts d)…

A: Qualitative data can be stated as the descriptive and conceptual knowledge or data gathered through…

Q: Monthly Demand 50 abi 120 280 guarantee supplies from de to sign a contract wit rom the roaster to…

A: Based on the given information we have to minimize the total monthly cost of coffee supply from the…

Q: OPTIMUM solution for the transportation problem detailed in the table belo 2228 sss 555 2448

A: ABCSupplyX301210100Y10201550Z101625200Demand5050100200/350

Q: A company has three plants producing a certain product that is to be shipped to four distribution…

A: Given data, Plant v. DC 1 2 3 4 1 800 1300 400 700 2 1100 1400 600 1000 3 600 1200 800…

Q: According to the Path-Goal theory, why is Daniel an effective leader? ii. How does Daniel’s…

A: Daniel is the manager of a small business called The copy Centre .Total 18 employees working at his…

Q: for the following table. Find a. least cost solution b. According to your answer in a, find the…

A: Find the Given details below: Given details: From/To A B C Supply 1 6 7 4 100 2 5 3 6 180…

Q: Draw a diagram by showing factories, warehouses, and connecting arcs. Define variables, write the…

A: The transportation model is used to calculate the minimum cost of the route by selecting different…

Q: please write a clear answer for each part of the question

A: Decision Variable: Suppose-xij represents the units shipped from node i to node j

Q: Converse, Dr. Pepper, Vans and wheat. (b) Assume that in Queentucky the GDP deflator/CPI…

A: Note :- As mentioned in the question, only asked question (C). That's why I have answered only…

Concept explainers

Optimization Models

Optimization models are mathematical models that help organizations determine the best way to allocate scarce resources to achieve specific objectives. These models can be used to solve a wide variety of problems, from finding the most efficient route for a delivery truck to determining the optimal mix of products to stock in a store.

Question

(d) Which warehouse will experience shortage? How much is the shortage?
(e) Is there an alternative optimal solution? Why?
(c) Calculate the minimum transportation cost.
(b) Determine the quantity of wheels that should be shipped from each plant
to each warehouse to minimise the total transportation cost.
CHAPTER 5 TRANSPORTATION MODEL
To
Distribution Centre
From
N
P.
Сарacity
8.
6.
10
13
150
B.
11
6.
9.
12
120
Demand
50
80
60
60
(a) Find an initial solution.
(b) Determine an optimal solution and the minimum transportation cost.
(c) Which factory will have the surplus? How much is the surplus?
(d) Is there an alternative optimal solution?
6. A manufacturer produces sport wheels at three plants located at towns A, B,
and C. The wheels are sent to three warehouses located at T, X, Y, and Z. The
plant in Town A has 400 units available each month, Town B has 300 units,
and Town C has 300 units. The requirements of warehouses at T, X, Y, and
Z are 300, 300, 240, and 200 respectively. The transportation costs (in RM)
for various routes are given in the table below. The company would like to
determine the least-cost way to meet the demand at each of the warehouses.
Warehouse
Factory
Z
Y
A
5
4.
4.
B.
3.
4.
6.
4.
9.
4.
(a) Find an initial solution.
ution problem to

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.

Similar questions

Develop a LP model for the transportation problem (cost problem). Solve the LP model to find the optimal solution and the minimum total cost.
Given the following transportation tableau-where the numbers in each cell represent transportation costs from the specific source to the specific destination-with supply figures corresponding to each source and demand figures corresponding to each destination: Source A B Demand 1 $22 2.4 2.1 350 Destination 2 3.4 3.2 3.6 400 3 1.9 1.8 2.1 200 Supply 200 300 450 A. According to the Northwest Corner method, the initial solution would have a total transportation cost of B. According to the Northwest Corner method, the initial solution would give to cell B2 a loading of C. According to the Vogel's Approximation Method, the initial solution would give to cell B2 a loading of D. According to the Vogel's Approximation Method, the initial solution would have a total transportation cost of E. According to the minimum cell cost method, the initial solution would give to cell C1 a loading of F. According to the minimum cell cost method, the initial solution would have a total transportation cost…
2. By using the data below, use a transportation method to : COST in $ Assembly Plant Supply 210 Factory 2 A 8 9 400 10 6 12 8 190 Demand 120 620 60 A. Formulate this linear programming model B. If you are using VAM and NorthWest corner method, which solution is the best and how much is the best total cost ?
Answer the following question based on the image below: 1- state objective function 2- state the constraints
Consider the following transportation problem: Destination company A B C Supply 1 5 1 7 10 2 6 4 6 80 3 3 2 5 15 Demand 75 20 50 Since there is not enough supply, some of the demands at these destinations may not be satisfied. Suppose these are penalty costs for every unsatisfied demand unit which are given by 5, 3, and 2 for destination A, B, and C respectively. 1. Determine how many units and from which source needs to be shipped using the following methods: A) NWCB) LCMC) VAM2. Find the minimum distribution cost
Sourabh Gupta can purchase copper bottles for $ 34 per piece and can manufacture it in house where the fixed and variable cost are $ 51,000 and $ 19 respectively. If the market demand for the bottles is 4500 units for a month, ascertain that whether it would be economical to make the product in house rather than sourcing it .
2.) Your business provides technical support for very complex and specialized machinery used by companies throughout the country, and you currently have support centers at 5 locations. However, due to a poor market, you have been forced to close your centers in Houston and San Diego. You will have to relocate all of your technicians in these two centers to your other three centers in Cleveland, Seattle, and Charlotte. Due to the varying costs of living in each city, and travel and retraining times, the cost for relocating an employee varies depending on where the employee is moving. These costs are given in the following table: To: From: Cleveland Seattle Charlotte $5,000 | $7,000 $7,000 $4,000 $6,000 $8,000 Houston San Diego You currently have 40 employees in Houston and 55 employees in San Diego, which all need to be relocated. Cleveland is able to take in at most 35 relocated employees, Seattle can take in at most 32 employees, and Charlotte is able to take in at most 50 employees.…
: x v fx C DE в F G H K M Consider the linear distribution and the from-to diagram shown in the figure. Assuming that the goal is to minimize the total distance traveled, determine the final distribution recommended by CRAFT using the peer-to-peer trading method. 30 m 30 m from A A B A 2 6 B 3 A В 80 m 20 m
Wiebe Trucking, Inc., is planning a new warehouse to servethe western United States. Denver, Santa Fe, and Salt LakeCity are under consideration. For each location, annual fixedcosts (rent, equipment, and insurance) and average variablecosts per shipment (labor, transportation, and utilities) arelisted in the following table. Sales projections range from550,000 to 600,000 shipments per year.a. Plot the total cost curves for all the locations on a singlegraph.b. Which city provides the lowest overall costs?
Consider the transportation problem having the following parameter table: Source Demand 12 2 Destination 1 8 a6 6 3 2 5 4 3 Supply 4 2 (a) Use the transportation simplex method to solve the above problem
An auto compant currently maintains plants in Cincinnati and Tulsa to supply two distributioncenters in Boston and Phoenix. The production and distribution costs, distribution demands aswell as facility capacities are given in the table attached Using the northwest-corner method, determine the initial allocated quantity for eachshipping route as well as the overall cost.