1. Draw the network that represents the companys distribution network. 2. What is the transportation strategy (number...
Fantastic news! We've Found the answer you've been seeking!
Question:
1. Draw the network that represents the company’s distribution network.
2. What is the transportation strategy (number of each product shipped from each plant to each warehouse, and from each warehouse to each retailer) that minimizes the total cost? Mathematically formulate this problem (indicating sets, parameters, decision variables, objective function, and constraints) and solve it using Excel or Gurobi. Show your results clearly and discuss.
Transcribed Image Text:
Problem 1 (100 points): Supply chain transportation - Multicommodity Problem Transportation plays a significant role in a supply chain and its efficiency. In particular, reducing the transportation costs between the manufacturers, warehouses, and retailers helps to provide more affordable product prices for customers. A major manufacturing company, MC Inc., produces its star product, Product A, to be sold at five retailers across the state. First, the products are manufactured in one of two plants, then distributed to three warehouses for storage, and finally are distributed to each of the retailers. Each retailer sends a separate order to the manufacture's head office, which is then dispatched from the appropriate warehouse to the retailer. The company has collected data regarding weekly orders and production and would like to find a way to minimize the costs of the entire operation. To expand their market share, the company decided to fabricate a second product, Product B. To fabricate Product B, not only Plants 1 and 2 were adapted accordingly, but also a third plant, Plant 3, was constructed. Considering the degree of specialization and the difficulty associated with making each product, as well as the machines available at each plant, you have calculated the average number of units (of each product) that an average worker would be able to make in an hour. This information is given in Table 1. For example, Table 1 indicates that the average number of units of Product A that a worker can make in one hour in Plant 1 is 0.5. In other words, to produce one unit of Product A, you could have one worker to dedicate two hours of labor, or two workers to dedicate one hour. Table 1. Average number of units produced per person per hour Production Facility Plant 1 Plant 2 Plant 3 Product A (units/hour-person)| Product B (units/hour-person) 0.5 0.1 0.5 0.1 0.2 0.4 Problem 1 (100 points): Supply chain transportation - Multicommodity Problem Transportation plays a significant role in a supply chain and its efficiency. In particular, reducing the transportation costs between the manufacturers, warehouses, and retailers helps to provide more affordable product prices for customers. A major manufacturing company, MC Inc., produces its star product, Product A, to be sold at five retailers across the state. First, the products are manufactured in one of two plants, then distributed to three warehouses for storage, and finally are distributed to each of the retailers. Each retailer sends a separate order to the manufacture's head office, which is then dispatched from the appropriate warehouse to the retailer. The company has collected data regarding weekly orders and production and would like to find a way to minimize the costs of the entire operation. To expand their market share, the company decided to fabricate a second product, Product B. To fabricate Product B, not only Plants 1 and 2 were adapted accordingly, but also a third plant, Plant 3, was constructed. Considering the degree of specialization and the difficulty associated with making each product, as well as the machines available at each plant, you have calculated the average number of units (of each product) that an average worker would be able to make in an hour. This information is given in Table 1. For example, Table 1 indicates that the average number of units of Product A that a worker can make in one hour in Plant 1 is 0.5. In other words, to produce one unit of Product A, you could have one worker to dedicate two hours of labor, or two workers to dedicate one hour. Table 1. Average number of units produced per person per hour Production Facility Plant 1 Plant 2 Plant 3 Product A (units/hour-person)| Product B (units/hour-person) 0.5 0.1 0.5 0.1 0.2 0.4
Expert Answer:
Answer rating: 100% (QA)
1 Network diagram showing companys distribution network ... View the full answer
Related Book For
Discovering Advanced Algebra An Investigative Approach
ISBN: 978-1559539845
1st edition
Authors: Jerald Murdock, Ellen Kamischke, Eric Kamischke
Posted Date:
Students also viewed these mathematics questions
-
1. (25 points) Consider a lake clean-up project which is expected to not only purify the lake, but also to help with the ecosystem over the next 30 years. Therefore, the total benefits (in NZ$) also...
-
Required (a) Using the data given in the table above, use MS Excel to: (i) Prepare a schedule to be presented to management. The schedule must show the following for 5000, 10000, 15000, 20000, 25000...
-
(a) Draw an AON network. (Hints: This is similar to Solved problem 3.1 of page 90. To draw the circle and arrow line, you should select from Microsoft Word: INSERT, SHAPES, SELECT CIRCLE SHAPE UNDER...
-
Freight and other handling charges on goods out on consignment are part of the cost of goods consigned. What is its appropriate account title in the income statement prepared by the consignor?...
-
An economy has a per-capita production function y = Akahl-a, where A and a are fixed parameters, y is per-worker output, k is the capital-labour ratio, and h is human capital per worker, a measure of...
-
For the cuboid drawn below: a. Draw two possible nets for the cuboid b. Calculate the total surface area of both nets, showing clearly the dimensions of each part of the net. 12 cm 3 cm 15 cm
-
The following are measurements of the total dissolved salts (TDS) and hardness index of 22 samples of water. (a) Calculate \(r\). (b) Find 95% confidence limits for \(ho\). TDS (ppm) Hardness Index...
-
A refinery blends four petroleum components into three grades of gasolineregular, premium, and diesel. The maximum quantities available of each component and the cost per barrel are as follows: To...
-
A bank wants to install an alarm system with 3 movement sensors. To prevent false alarms produced by a single sensor activation, the alarm will be triggered only when at least two sensors activate...
-
Wu Manufacturing produces two keyboards, one for laptop computers and the other for desktop computers. The production process is automated, and the company has found activity-based costing useful in...
-
In this exercise, you will calculate molar value of H (in kJ/mol) for dissolving NH 4 H 2 PO 4 in Part D of the Calorimetry lab. (a) What temperature change did you find for dissolving NH 4 H 2 PO 4...
-
If one DNA strand is 5GGCATTACACTAGGCCT3, what is the sequence of the complementary strand?
-
If a tRNA molecule carries a glutamic acid, what are the two possible anticodon sequences that it could contain? Be specific about the 5 and 3 ends.
-
Describe the mechanisms by which bacterial DNA becomes compacted.
-
If a eukaryotic chromosome has 25 origins of replication, how many replication forks does it have at the beginning of DNA replication?
-
What chemical group (phosphate group, hydroxyl group, or a nitrogenous base) is found at the 3 end of a DNA strand? What group is found at the 5 end?
-
The 2 , 5 0 0 people that visited the Adidas website as a result of the Google ads, 4 2 5 people made purchases. What was their conversion rate?
-
Wal-Mart is the second largest retailer in the world. The data file on the disk holds monthly data on Wal-Marts revenue, along with several possibly related economic variables. a) Using computer...
-
The Los Angeles Lakers won the 2002 National Basketball Association Championship. This table gives the total points scored by each player during that season. a. Find the mean, median, and mode for...
-
For each research finding, decide whether there is evidence of causation, correlation, or both. If it is only a correlation, name a possible lurking variable that may be the cause of the results. a....
-
Find the vertical distance between a point on the hyperbola (y + 1/2)2 - (x - 2/3)2 = 1 and its nearest asymptote for each x-value shown at right. x-value 5 10 20 40 Distance
-
The materials which exhibit the same elastic properties in all directions are known as: (a) Homogeneous (b) Isotropic (c) Isentropic (d) Inelastic
-
In a reaction steam turbine, steam expands: (a) In nozzle only (b) In moving blades only (c) Partly in nozzle partly in blades (d) None of the above
-
In impulse turbines, pressure on the two sides of the moving blades: (a) Increases (b) Decreases (c) Remains same (d) None of the above
Study smarter with the SolutionInn App