Linear programming problem so as to minimize shipping costs

Assignment Help Operation Management

Reference no: EM131124626

NewTigerSports Company manufacturers treadmills in factories located in Pittsburgh andKansas City. These are shipped to regional distribution centers in Chicago, Phoenix, andPhiladelphia. Ultimately they are delivered to supply houses in New York and LosAngeles. The available supplies at the factories, demands at the final destinations, andshipping costs are illustrated in the table below.

Pittsburgh to Chicago: $4

Pittsburgh to Phoenix: $8

Pittsburgh to Philadelphia: $2

Pittsburgh Supply: 1500

Kansas City to Chicago: $3

Kansas City to Phoenix: $6

Kansas City to Philadelphia: $5

Kansas City Supply: 1000

Chicago to New York: $5

Chicago to Los Angeles: $7

Phoenix to New York: $8

Phoenix to Los Angeles: $3

Philadelphia to New York: $2

Philadelphia to Los Angeles: $9

New York Demand: 1200

Los Angeles Demand: 800

1) Formulate this problem as a linear programming problem so as to minimize the shipping costs

2) Using Excel, determine how many units should be shipped for all possible originand destination points (final or intermediate) in the distribution network in orderto minimize shipping costs.

Reference no: EM131124626

Questions Cloud

Country is target for nuclear warfare : Yesterday, the President of the United States announced that World War III broke out and the country is a target for nuclear warfare. There is hope however—there is a secret bomb shelter in the Mojave Desert. Brainstorm a list of all possible criteri..

What cycle time would match capacity-demand : What cycle time would match capacity and demand if demand is 146 units a day, there are two shifts of 527 minutes each, and workers are given three half-hour breaks during each shift, one of which is for lunch or dinner?

Standard containers are designed to hold four dozen parts : A JIT system uses kanban cards to authorize movement of incoming parts. In one portion of the system, a work center uses an average of 96 parts per hour while running. The manager has assigned an inefficiency factor of .25 to the center. Standard con..

Compute the takt time for a service system : Compute the takt time for a service system that intended to perform a standardized service. The system will have a total work time of 389 minutes per day, two 18-minute breaks, and an hour for lunch. The service system must process 70 jobs a day.

Linear programming problem so as to minimize shipping costs : NewTigerSports Company manufacturers treadmills in factories located in Pittsburgh andKansas City. These are shipped to regional distribution centers in Chicago, Phoenix, andPhiladelphia. Ultimately they are delivered to supply houses in New York and..

What is the expected loss per excursion : A charter fishing boat operating out of Port Aransas on the Gulf coast has recorded the no-show experience show below over the past 20 excursions. To avoid the opportunity of losing the $50 fee charged per fisherman, the boat captain is considering a..

What is the most appropriate conflict-handling style : Determine what is the most appropriate conflict-handling style(s). A radiologist on the staff of a large community hospital was stopped after a staff meeting by a colleague in internal medicine. How should the dean handle this conflict with the chair..

Consider some various health models out there : Consider some various health models out there. Which health system model would you recommend to low- and middle-income countries? Explain why; include both advantages and disadvantages.

Single-channel or multiple channel waiting line system : Ocala's customer service department has received complaints about long waiting times, so Ocala is thinking about adding another technical support consultant. Would the new system be single-channel or multiple channel waiting line system?

User Account

All Pages