Scribd
Upload
29 views3 pages

Supply Chain (AutoRecovered)

The document contains transportation data between various cities, including supply quantities, demand, and cost calculations for different routes. It also lists production capacities and costs for several plants, along with market demand and pricing for different regions. Overall, it provides a comprehensive overview of logistics and production metrics for effective planning.

Uploaded by

Sankalpa Rout
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
29 views3 pages

Supply Chain (AutoRecovered)

The document contains transportation data between various cities, including supply quantities, demand, and cost calculations for different routes. It also lists production capacities and costs for several plants, along with market demand and pricing for different regions. Overall, it provides a comprehensive overview of logistics and production metrics for effective planning.

Uploaded by

Sankalpa Rout
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
You are on page 1/ 3

From/to Indore Kochi Jaipur Pune Capacity

Delhi 25 35 36 60 15
Kanpur 55 30 25 25 6
Nagpur 40 50 80 90 14
Guwahati 30 40 66 75 11
Demand 10 12 15 9

Supply Quantity
Indore Kochi Jaipur Pune Capacity
Delhi 0 0 15 0 15
Kanpur 0 0 0 6 6
Nagpur 10 4 0 0 14
Guwahati 0 8 0 3 11
10 12 15 9

cost calculation
Indore Kochi Jaipur Pune Capacity
Delhi 0 0 540 0 225
Kanpur 0 0 0 150 36
Nagpur 400 200 0 0 196
Guwahati 0 320 0 225 121
400 520 540 375 1835
From/to Indore Kochi Jaipur Pune Capacity
Delhi 25 35 36 60 15
Kanpur 55 30 25 25 6
Nagpur 40 50 80 90 14
Guwahati 30 40 66 75 11
Demand 10 12 15 9

Supply Quantity
Indore Kochi Jaipur Pune Capacity
Delhi 0 2 13 0 15
Kanpur 0 6 0 0 6
Nagpur 10 4 0 0 14
Guwahati 0 0 2 9 11
10 12 15 9

Cost calculation
Indore Kochi Jaipur Pune Capacity
Delhi 0 70 468 0 0
Kanpur 0 180 0 0 0
Nagpur 400 200 0 0 0
Guwahati 0 0 0 0 0
400 450 468 0 225
Plant Capacity Fixed faciliUnit variable production cost
Ahmedabad 350 78000 675
Baddi 400 42000 525
Hubli 450 36000 650
Nagpur 300 38000 625
Vishakapatnam 400 34000 675

Market Bangalore Chennai Delhi Mumbai Lucknow Kolkata


Quarterly Deman 165 135 280 200 125 155
Price per unit 1030 950 1000 975 900 850

Bangalore Chennai Delhi Mumbai Lucknow Kolkata


Ahmedabad 235 278 100 65 189 261
Baddi 511 558 97 328 216 305
Hubli 77 138 327 105 372 326
Nagpur 165 160 183 117 148 235
Vishakapatam 163 107 328 217 303 203

You might also like