ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
DOWNLOAD A COPY of this spreadsheet to your computer by clicking on the word "File" in top left corner of this screen. Then click "Download as" and select format
2
This reporting template is set up for Nepal Earthquake DR supply chain, but look at how report tabs read product and simulation data – make changes to downloaded spreadsheet as needed
3
4
OPERATING COSTS AND SUPPLY CHAIN PERFORMANCE - Nepal Earthquake 2015 Ver2
5
6
OPERATING COSTSTotal MissionKathmandu DCDhading WhseBarbare WhseCharikot WhseDeurali Whse
7
 Cost of Products Used$11,514,225$0$2,624,475$2,198,250$3,946,875$2,744,625
8
 Facility Storage and Ops Cost870,000210,000165,000165,000165,000165,000
9
 Delivery Cost by DC & Whse51,002,84823,423,8488,994,60018,179,200210,000195,200
10
 Cost of Products Delivered (In)23,659,50511,787,9504,097,9551,308,3003,957,0502,508,250
11
 Transport Pct of Prod Delivered216%199%219%1390%5%8%
12
 Total Expenses $63,387,073$23,633,848$11,784,075$20,542,450$4,321,875$3,104,825
13
14
INVENTORY UTILIZATION
15
 Beginning Inventory Value$10,448,790$3,859,105$1,716,585$1,685,950$1,306,125$1,881,025
16
 Ending Inventory Value$11,103,965$3,911,950$3,190,065$1,041,000$1,316,300$1,644,650
17
 Percent Change6.27%1.37%85.84%-38.25%0.78%-12.57%
18
19
STORAGE UTILIZATION
20
**Facility Storage Capacity (m3)50,00010,00010,00010,00010,00010,000
21
 Average Inventory Volume (m3)18,6917,1634,3822,0992,0682,980
22
 Percent Utilization37%72%44%21%21%30%
23
24
SUPPLY DEPOT PERFORMANCE
25
26
PERFORMANCE MEASURESTotal DepotsKolkataBrindisiKuala LumpurShanghai
27
 Cost of Products Shipped (Out)$13,879,475$4,013,900$2,892,500$4,444,075$2,529,000
28
 Supply Depot Transport Cost23,423,848870,4808,080,0008,633,3685,840,000
29
 Transport Pct of Prod Shipped169%22%279%194%231%
30
 Total Expenses $37,303,323$4,884,380$10,972,500$13,077,443$8,369,000
31
32
**Accept default numbers or enter other numbers manually in cells outlined in orange
33
All other data is from simulation results
34
35
INVENTORY MANAGEMENT PERFORMANCE
36
37
38
PRODUCT SUPPLY CATEGORYKathmandu DCDhading WhseBarbare WhseCharikot WhseDeurali Whse
39
**Ordering Cost $35.00$35.00$35.00$35.00$35.00
40
**Pct.of Price for Holding Cost2020202020
41
42
1. Camp Mgmt EquipTotal MissionKathmandu 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
 Total 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
2. Construction MatlTotal MissionKathmandu 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
 Total 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
3. Education SuppliesTotal MissionKathmandu 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
 Total 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
4. Food (pallet)Total MissionKathmandu 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
 Total 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
5. Health SuppliesTotal MissionKathmandu DCDhading WhseBarbare WhseCharikot WhseDeurali Whse
99
 **Cost of Product$1,200
100
 Beginning Inventory On-Hand3,8901300600815530645