23. A company imports goods at two ports: Philadelphia and New Orleans. Shipments of its products are made to customers in Atlanta, Dallas, Columbus and Boston. For the next planning period, the suppliers at each port, customer demands, and the shipping costs per case from each port to each customer are as follows: Customers Port Philadelphia Atlanta Dallas Columbus Boston Port Supply 2 6 6 5000 New Orleans 1 2 7 3000 Demand Develop a network model of the distribution system for this problem. 1400 3200 2000 1400

23. A company imports goods at two ports: Philadelphia and New Orleans. Shipments of its products are made to customers in Atlanta, Dallas, Columbus and Boston. For the next planning period, the suppliers at each port, customer demands, and the shipping costs per case from each port to each customer are as follows: Customers Port Philadelphia Atlanta Dallas Columbus Boston Port Supply 2 6 6 5000 New Orleans 1 2 7 3000 Demand Develop a network model of the distribution system for this problem. 1400 3200 2000 1400

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: Product Quality Delivery Speed Product Price Environmental Impact SUPPLIER RATING UNDER LOW,…

A: A company exploring a new service that entails the weekly delivery of grocery items to homes in the…

Q: Freight car loadings over an 18-week period at a busy port are as follows: Week Number Week…

A: Linear trend line can be identified using the given values. Here, y = a+bx x = wee y = Number of…

Q: What is the optimal order quantity for MBC? Q* = 20,000 How frequently should MBC order to…

A: Here, The given data, ordering cost for each order=300, lead time=10 days, holding cost per gallon…

Q: Consider the following network diagram showing Company RML's distribution network along with…

A: Network diagram of distribution

Q: A firm has established a distribution network for the supply of a raw material critical to its…

A: When supply is less than demand or vice versa, it is called as unbalanced problem. For unbalanced…

Q: Q3) )A firm has established a distribution network for the supply of a raw material critical to its…

A: The transportation problem is a linear programming problem that involves finding the optimal way to…

Q: Month Demand 1 45 2 48 3 43 4 48 5 49 6 54 7 47 8 50 9 46 10 47 Using the table above, calculate two…

A: (i) Exponentially smoothed forecasts were calculated using a smoothing constant of 0.4, yielding a…

Q: Lenovo uses the ZX-81 chip in some of its laptop computers. The prices for the chip during the last…

A: Given-

Q: 2. Develop an aggregate plan for the following forecast eriod 2 3 5 6 1 4 8 Total recast 1,200 1,200…

A: Consideration: Negative inventory in opening and ending inventory represent Backlogs.

Q: Actual sales data (in pounds) for roasted coffee beans at a grocery store are given in the table…

A: The spreadsheet calculations are shown below, Week Actual sales naïve forecast 1 201 2 227 201 3…

Q: Using the same data, insert the values using this format to find the same answer

A: The linear formulation stands same as the orginal answer.Assume:Decision variable:Objective…

Q: George Kyparisis owns a company that manufactures sailboats. Actual demand for George's sailboats…

A: Solution

Q: Using 2 Semester Weighted moving average compute the forecasted number of student for semester 16…

A: Forecasting is the process of estimating the future demand using the previous year's or month's…

Q: Company ABC produces and sells 4 types of computer monitors of different features. The following…

A: A moving average is a technical indicator that financial backers and traders use to decide the…

Q: Based on the highest weighted score, which supplier should be selected? Supplier should be selected,…

A: Here, for each supplier, the rating or scores are given against the criteria, each criterion has a…

Q: Kuala Langat Construction Supplies Sdn Bhd sells various hardware and supplies construction…

Q: how can the decision tree model be used in logistics management?

A: To ensure an effective flow of products and services from the point of origin to the point of…

Q: Yosemite Park Medical Services (YPMS) provides emergency health care for park visitors. Such health…

A: Statistical process control (SPC)is applying statistical techniques to determine whether a process…

Q: George Kypass owns a company that manufactures sailboats. Actual demand for George's sailboats…

A: Seasonal index uses for analysis the how particular season through cycle compare with average…

Q: As a supply chain manager for a company, you are tasked with forecasting the demand for a particular…

A: Mean Absolute Percent Error (MAPE) helps in identifying the proportion of forecast errors relative…

Q: Cargo Loading. You are in charge of loading cargo ships for International Cargo Company (ICC) at a…

A: Linear programming helps us to find the optimal solution/best outcome, given the constraints.We want…

Question

23. A company imports goods at two ports: Philadelphia and New Orleans. Shipments of its products
are made to customers in Atlanta, Dallas, Columbus and Boston. For the next planning period,
the suppliers at each port, customer demands, and the shipping costs per case from each port to
each customer are as follows:
Customers
Port
Atlanta
Dallas
Columbus
Boston
Port Supply
Philadelphia
2
6
5000
New Orleans
1
2
5
7
3000
Demand
1400
3200
2000
1400
Develop a network model of the distribution system for this problem.

Expert Solution

This question has been solved!

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

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 2 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

3. Answer the followings. a. Myanmar CP Live Stock Company Limited Shipped Sausage boxes around Myanmar. A manager wants to forecast shipments for the first four months of the next two years by using Linear equation method. The monthly forecast equation being used is: y= 402 + 3x and determine trend amounts for the first four months of the next two year: January, x=24, February, x=25; etc. b. A farm implements dealer is seeking a fourth warehouse location to complement three existing warehouses. There are three potential locations, N.C; Atlanta, Ga.; and Columbia, S.C. Charlotte would involve a fixed cost of $4,000 per month and a variable cost of $4 per unit. Atlanta would involve a fixed cost of $3,500 per month and a variable cost of $5 per unit; and Columbia would involve a fixed cost of $5,000 per month and a variable cost of $6 per unit. Use of the Charlotte location would increase system transportation costs by $19,000 per month. Atlanta by $22,000 per month, and Columbia by…
Tasty Bread Company has monthly demand for one of its products as follows: March= 520; April=490; May=550; June=580; July=600; August=420. Compute the three-month moving average for July.
Answer the following homework question
The actual number of patients at Providence Emergency Medical Clinic for the first six weeks of this year follows: Week Actual No. of Patients 1 65 68 77 59 66 75 23456 2 5 6 Clinic administrator Dana Schniederjans wants you to forecast patient numbers at the clinic for week 7 by using this data. You decide to use a weighted moving average method to find this forecast. Your method uses four actual demand levels, with weights of 0.500 on the present period, 0.250 one period ago, 0.125 two periods ago, and 0.125 three periods ago. a) What is the value of your forecast? The value of the forecast is patients (round your response to two decimal places). b) If instead the weights were 40, 20, 10, and 10, respectively, how would the forecast change? OA. The value of the forecast will decrease. B. The value of the forecast will remain the same. C. The value of the forecast will increase. c) What if the weights were 0.40, 0.30, 0.20, and 0.10, respectively? Now what is the forecast for week 7?…
What is the Y coordinate if we use the center of gravity method? Please keep 3 decimals in your final answer