### Transportation Problem: Distribution SystemA company imports goods at two ports: Philadelphia and New Orleans. Shipments of one product are made to customers in Atlanta, Dallas, Columbus, and Boston. For the next planning period, the supplies at each port, customer demands, and shipping costs per case from each port to each customer are as follows:#### Shipping Cost Table| Port | Customers | | | | Port Supply ||--------------|-------------------|----------------|--------------|--------------|-------------|| | **Atlanta** | **Dallas** | **Columbus** | **Boston** | || **Philadelphia** | 2 | 6 | 6 | 2 | 5,000 || **New Orleans** | 1 | 2 | 5 | 7 | 3,000 || **Demand** | 1,400 | 3,200 | 2,000 | 1,400 | |- **Philadelphia:** Has a supply of 5,000 units.- **New Orleans:** Has a supply of 3,000 units.#### Shipping Costs (per case):- From Philadelphia to: - Atlanta: 2 - Dallas: 6 - Columbus: 6 - Boston: 2- From New Orleans to: - Atlanta: 1 - Dallas: 2 - Columbus: 5 - Boston: 7#### Customer Demands:- Atlanta: 1,400 units- Dallas: 3,200 units- Columbus: 2,000 units- Boston: 1,400 units### TaskDevelop a network representation of the distribution system (transportation problem). (Submit a file with a maximum size of 1 MB.)This entails creating a visual or mathematical model that reflects the shipping costs, supplies, and demands for efficient distribution planning.

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

Answered: Develop a network representation of the…

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 following network describes a transportation scenario in which there are four sources A, B, C, and D, and three destinations P, Q, and R. (The numbers next to each arrow represent the cost of transporting one unit from that particular source to the destination located at the other end of that arrow). Write the mathematical formulation of the problem. Use the Excel Solver to solve the problem. Generate the answer and sensitivity reports in Excel, and submit your Excel workbook as a separate attachment. Provide the solution obtained in the space provided. What is the optimal cost of transportation?
Farmers Groceries To You (FGTY) is a fast-growing company started by JMU alumni, which delivers fresh groceries collected in Virginia farms to families in the Shenandoah region. As part of an expansion plan, FGTY is considering approaching the northern Virginia market through printed product lists (PLs) containing deals, coupons and customers testimonies. The initial plan is to send 200,000 PLs to households in Fairfax and Arlington, expecting new customers to place orders. The company estimates to incur a fixed cost of $30,000 associated with design, printing setup and transportation contracting. Beyond this, the average transportation cost per PL is ¢20, while the printing cost per PL is ¢10. Also, FGTY incurs in an average cost of ¢25 for processing each order placed by a customer using the PL’s promotion codes. The expected size of an order is $50, and FGTY’s variable cost per order (mainly product costs labor) is close to 80% of the order’s average. You’ve been hired to help FGTY…
The ABC Hospital has a central laboratory which is located in the basement of OPD (Outpatient Department) block. The patient wards & Intensive care area are located from second floor onwards in IPD (In patient Department) block. The patient blood samples are collected by nursing team in respective ward & blood sample collection tube is labeled with bar-codes. The Hospital had installed fourteen stations Pneumatic chute system for transportation of bar codes blood samples from various patient wards, Intensive care units and operating room to laboratory. This has helped hospital to save transportation time from various places to laboratory so that blood samples reach lab sample collection area well in time. There is no dedicated staff assigned in each department for manual transportation of samples to laboratory. The laboratory design was such that sample collection station where pneumatic chute receiving station was installed was away from various functional areas like…
allons of deionized water from each wholesaler to each distribution center is shown in the following table: Question Viewer a. Which of the following statements regarding setting up the tableau for the optimal solution for this problem is true? B. The sum of supply capacities is greater than the sum of demands, so a dummy distribution center is needed. C. The sum of supply capacities is less than the sum of demands, so a dummy wholesaler is needed. b. What is the total cost of the solution? The optimal cost is $ ((Enter your response rounded to the nearest dollar.)
What exactly is meant by the abbreviation BIA (business impact analysis)? What are some functions that might be listed in the BIA for the network that you use at work or at home?
The metes and bounds system primarily relies on which of the following to describe land? section, lot, and block numbers within a subdivision a readily identifiable point of beginning and the boundaries of a property in terms of distances and compass directions checks, correction lines, and tiers meridians, base lines, townships, and ranges
Modern customers are keenly aware of how powerful today’s technology is. They expect organizations to leverage that power to provide them with the utmost in quality service and products. Leveraging modern business best practices and methodologies allows IT organizations to maintain a rapid speed of development that keeps up with customer demand. However, speed can only get an organization so far without the added component of quality. This is where TQM can help to fill in the gaps and aid organizations in maintaining a grip on quality while pushing their speed. TQM is a management approach that seeks to provide long-term success by providing unparalleled customer satisfaction through the constant delivery of quality services. To properly execute on TQM methods, the entire organization needs to operate as a single unit in the pursuit of excellence. Achieving this is accomplished with a laser-focus on the principles of TQM: Customer first. TQM’s first and foremost pillar of success is an…
John is travelling from home in Sydney to a hotel in Perth. Three stopovers on the way a number of choices of towns for each stop only one hotel to choose from in each town, except for Perth, where there are three hotels (J, K, and L) to choose from Each trip has a different distance resulting in a different cost (petrol) (cost is marked by each arc) Hotels have different costs (cost is marked by each node (town)) ● ● ● The goal is to select a route to and a hotel in Perth so that the overall cost of the trip is minimized. Use dynamic programming (forward recursion) to solve this problem by constructing the usual tables for each stage. Stage: 0 (Sydney) 1 Petrol cost start 22 8 12 Hotel cost 70 80 B 80 25 10 2 50 A E 70 30 10 18 8 7 3 50 F 70 70 H 60 8 10 10 4 (Perth) 50 13 K 10 15 L 60 70
PLS HELP ASAP

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