DR Mission Operating Costs and KPIs - V2.2 [ Beta ]
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
MISSION OPERATING COSTS AND SUPPLY CHAIN PERFORMANCE - Nepal Earthquake 2015
2
3
Total In-CountryKathmandu DCDhading WhseBarbare WhseCharikot WhseDeurali Whse
4
OPERATING COSTS
5
Cost of Products Used$11,514,225$0$2,624,475$2,198,250$3,946,875$2,744,625
6
Facility Storage and Ops Cost870,000210,000165,000165,000165,000165,000
7
Transportation Cost51,002,84823,423,8488,994,60018,179,200210,000195,200
8
Cost of Products Delivered23,659,50511,787,9504,097,9551,308,3003,957,0502,508,250
9
Transport Pct of Prod Delivered216%199%219%1390%5%8%
10
Total Expenses $63,387,073$23,633,848$11,784,075$20,542,450$4,321,875$3,104,825
11
12
INVENTORY UTILIZATION
13
Beginning Inventory Value$10,448,790$3,859,105$1,716,585$1,685,950$1,306,125$1,881,025
14
Ending Inventory Value$11,103,965$3,911,950$3,190,065$1,041,000$1,316,300$1,644,650
15
Percent Change6.27%1.37%85.84%-38.25%0.78%-12.57%
16
17
STORAGE UTILIZATION
18
**Facility Storage Capacity (m3)50,00010,00010,00010,00010,00010,000
19
Average Inventory Volume (m3)
18,6917,1634,3822,0992,0682,980
20
Percent Utilization37%72%44%21%21%30%
21
22
SUPPLY DEPOT PERFORMANCE
23
24
Total DepotsKolkataBrindisiKuala LumpurShanghai
25
OPERATING COSTS
26
Cost of Products Shipped$13,879,475$4,013,900$2,892,500$4,444,075$2,529,000
27
Transportation Cost23,423,848870,4808,080,0008,633,3685,840,000
28
Transport Pct of Prod Shipped169%22%279%194%231%
29
Total Expenses $37,303,323$4,884,380$10,972,500$13,077,443$8,369,000
30
31
**Note - asterisks require user data entry
32
All other data is from simulation results
33
34
INVENTORY MANAGEMENT PERFORMANCE
35
[ Report sections are greyed out when there is no inventory demand for a particular product. Set print color to black when products in those sections are used.]
36
37
Kathmandu DCDhading WhseBarbare WhseCharikot WhseDeurali Whse
38
39
**Ordering Cost $35.00$35.00$35.00$35.00$35.00
40
**Pct.of Price for Holding Cost2020202020
41
42
Camp Mgmt EquipTotal In-CountryKathmandu DCDhading WhseBarbare WhseCharikot WhseDeurali Whse
43
Cost of Product$1,000
44
Beginning Inventory On-Hand2,028578315270360505
45
Ending Inventory On-Hand1,148207310310166155
46
Percent Change-43.39%-64.19%-1.59%14.81%-53.89%-69.31%
47
Product Delivered2,4571,036445245406325
48
Avg On-Hand Amount 1,600401314293262330
49
Avg On-Hand Value$1,600,188$401,188$314,375$292,500$262,125$330,000
50
Cost of Product Used (15 days)$2,175,000$0$450,000$450,000$600,000$675,000
51
Product Daily Demand145030304045
52
Inventory Days of Supply 11.0410.489.756.557.33
53
EOQ Delivery Amount12121415
54
EOQ Delivery Frequency (Hours)
101098
55
56
Construction MatlTotal In-CountryKathmandu DCDhading WhseBarbare WhseCharikot WhseDeurali Whse
57
Cost of Product$500
58
Beginning Inventory On-Hand2,385770515270245585
59
Ending Inventory On-Hand2,4254271058310145485
60
Percent Change1.68%-44.55%105.44%14.81%-40.82%-17.09%
61
Product Delivered6,2482,9401,218490725875
62
Avg On-Hand Amount 2,418609789293193535
63
Avg On-Hand Value$1,209,219$304,313$394,438$146,250$96,719$267,500
64
Cost of Product Used (15 days)$1,462,500$0$337,500$225,000$412,500$487,500
65
Product Daily Demand130045305565
66
Inventory Days of Supply 18.6017.539.753.528.23
67
EOQ Delivery Amount21182426
68
EOQ Delivery Frequency11141010
69
70
Education SuppliesTotal In-CountryKathmandu DCDhading WhseBarbare WhseCharikot WhseDeurali Whse
71
Cost of Product$300
72
Beginning Inventory On-Hand000000
73
Ending Inventory On-Hand000000
74
Percent Change#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
75
Product Delivered000000
76
Avg On-Hand Amount 000000
77
Avg On-Hand Value$0$0$0$0$0$0
78
Cost of Product Used (15 days)$0$0$0$0$0$0
79
Product Daily Demand000000
80
Inventory Days of Supply #DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
81
EOQ Delivery Amount0000
82
EOQ Delivery Frequency#DIV/0!#DIV/0!#DIV/0!#DIV/0!
83
84
Food (pallet)Total In-CountryKathmandu DCDhading WhseBarbare WhseCharikot WhseDeurali Whse
85
Cost of Product$450
86
Beginning Inventory On-Hand3,0771069715490293510
87
Ending Inventory On-Hand4,79915171524227646885
88
Percent Change55.96%41.91%113.15%-53.67%120.48%73.53%
89
Product Delivered10,5045,4501,7846371,5081,125
90
Avg On-Hand Amount 3,9841,3331,126362466698
91
Avg On-Hand Value1,792,884.4$599,681$506,728$162,788$209,813$313,875
92
Cost of Product Used (15 days)$1,701,000$0$438,750$405,000$519,750$337,500
93
Product Daily Demand202065607750
94
Inventory Days of Supply 19.7217.326.036.0613.95
95
EOQ Delivery Amount27263024
96
EOQ Delivery Frequency1010911
97
98
Health SuppliesTotal In-CountryKathmandu DCDhading WhseBarbare WhseCharikot WhseDeurali Whse
99
Cost of Product$1,200
100
Beginning Inventory On-Hand3,8901300600815530645
Loading...
 
 
 
Mission Costs & KPIs
Dashboard
Products
Data
 
 
Main menu