Create a solver model to assign the shipment of blood

Assignment Help Operation Management

Reference no: EM131803442

The Red Cross owns four blood banks in a large metropolitan area and makes weekly shipments of blood containers to five area hospitals.

You need to help them develop a sourcing plan which minimizes transportation costs.

The tables below show (1) how many containers of blood can be supplied be each bank, (2) the weekly demand for each hospital, and (3) the cost per container of transporting from each bank to each hospital.

Source	Supply
Bank 1	80
Bank 2	80
Bank 3	110
Bank 4	100

Hospital 1	Hospital 2	Hospital 3	Hospital 4	Hospital 5
95	65	75	80	45

From \ To	Hospital 1	Hospital 2	Hospital 3	Hospital 4	Hospital 5
Bank 1	23	29	40	30	38
Bank 2	34	44	26	25	39
Bank 3	26	43	24	35	35
Bank 4	38	26	41	44	43

Create a Solver model to assign the shipment of blood to the hospitals. What is the lowest cost for transporting blood to the four hospitals?

Reference no: EM131803442

Questions Cloud

Discuss what is total average cost per unit : A companys costs are shown below. What is total average cost per unit

How to do patent with a ten year life in consolidation : How to do patent with a ten year life in consolidation? Does it get amortisation from the first date of acquisition?

Was it morally permissible for mary to get her copy : Recording companies make money by selling copies of recordings they made. They often make digital versions of a recording that can be downloaded.

How can critical thinking improve return on investment : What is critical thinking and how can it improve "Return on Investment" in a business setting. Critical thinking skills needed to be developed and why.

Create a solver model to assign the shipment of blood : Create a Solver model to assign the shipment of blood to the hospitals. What is the lowest cost for transporting blood to the four hospitals?

Prepare journal entries to record the transactions above : Prepare journal entries to record the transactions above. Prepare journal entries to record the 2016 amortization expense.

Discuss a perpetual inventory system on a fifo basis : Logan Company uses a perpetual inventory system on a FIFO basis. Assuming inventory on January 1 was 1,160 units at $7.70 each

What factors shape an organizations external competitivenes : What is external competitiveness? What factors shape an organization's external competitiveness? Why is external competitiveness so important?

Calculate the mse for four-week moving average : Compute the MSE for the four-week and five-week moving average forecasts. Round your intermediate calculations and final answers to two decimal places.

User Account

All Pages