Scribd
Upload
10 views11 pages

P&T Co. Distribution Cost Analysis

The document presents a distribution problem for P&T Co. involving transportation costs from various sources to multiple destinations, with specific demands and supplies outlined. It includes a cost matrix for assigning jobs to workers and production requirements for different plants. The total transportation cost is calculated, but there are sections with missing or incomplete data.

Uploaded by

Shivanshu Kumar Chaurasiya
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
10 views11 pages

P&T Co. Distribution Cost Analysis

The document presents a distribution problem for P&T Co. involving transportation costs from various sources to multiple destinations, with specific demands and supplies outlined. It includes a cost matrix for assigning jobs to workers and production requirements for different plants. The total transportation cost is calculated, but there are sections with missing or incomplete data.

Uploaded by

Shivanshu Kumar Chaurasiya
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

P&T Co.

Distribution Problem

Unit Cost Destination(Warehouse)


Salt
SacramentoLakeCity Rapid City Albuquerque Supply
Source Bellinguham 464.00 513.00 654.00 867.00 75.00
(Cannery) Eugene 352.00 416.00 690.00 791.00 125.00
Albert Lea 995.00 682.00 388.00 685.00 100.00
Demand 80.00 65.00 70.00 85.00

Unit Cost Destination(Warehouse)


Salt Lake
SacramentoCity Rapid City Albuquerque Total Shipped Supply
Source Bellinguham 0.00 20.00 0.00 55.00 75.00 75.00
(Cannery) Eugene 80.00 45.00 0.00 0.00 125.00 125.00
Albert Lea 0.00 0.00 70.00 30.00 100.00 100.00
Total Receive 80.00 65.00 70.00 85.00 300.00
Demand 80.00 65.00 70.00 85.00
Total Transportation Cost 152535.00
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
P&T [Link] Problem

Unit Cost Destination(Warehouse)

Sacramento Salt LakeCity Rapid City Albuquerque Supply


Source Bellinguham 464.00 513.00 654.00 867.00 75.00
(Cannery) Eugene 352.00 416.00 690.00 791.00 125.00
Albert Lea 995.00 682.00 388.00 685.00 100.00
Demand 80.00 65.00 70.00 85.00

Unit Cost Destination(Warehouse)

Sacramento Salt LakeCity Rapid City Albuquerque Total Ship


Source Bellinguham 0.00
(Cannery) Eugene 0.00
Albert Lea 0.00
Total Received 0.00 0.00 0.00 0.00
Demand 80.00 65.00 70.00 85.00
Supply
75.00
125.00
100.00

Total Transpotation Cost 0


#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
Assignment Problem

Cost Matrix
Jobs
J1 J2 J3 J4
W1 2 10 9 7
W2 15 4 14 8
Workers
W3 13 14 16 11
W4 4 15 13 9

Decision Variables
J1 J2 J3 J4 Row Sum Supply
W1 0 0 1 0 1 1
W2 0 1 0 0 1 1
Workers
W3 0 0 0 1 1 1
W4 1 0 0 0 1 1
Column Su 1 1 1 1

Demand 1 1 1 1 Objective Function(Z Min)


Objective Function(Z Min) 28
0.000001
1
0
0.01
0.0001
1
100
#NAME?
0.075
30
1
1
2
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
Assignment Problem

Unit Cost matrix


Jobs
Product 1 Product 2 Product 3 Product 4
Plant 1 41 27 28 24
Plant 2 40 29 - 23
Workers
Plant 3 37 30 27 21

Required Production 20 30 30 40

Cost (per day) matrix


Jobs
Product 1 Product 2 Product 3 Product 4
Plant 1 820 810 840 960
Plant 2 800 870 - 920
Workers
Plant 3 740 900 810 840

Assignment
Jobs
Product 1 Product 2 Product 3 Product 4 Total AssignmenSupply
Plant 1 0 2
Plant 2 0 2
Workers
Plant 3 0 1

Total Assignment 0 0 0 0
Demand 1 1 1 1
Total Cost 0

You might also like