Warehouse Square Footage Calculator with Pie Chart
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
https://visichain.io/Go to "File" and "Make Copy" so you have a sheet you can edit. Orignal article about sheet here
2
Average Monthly Inventory Value on Hand (month-after-month) $ 325,000.00
3
Damaged and Ruined Inventory: Either scrapped or written off entirely. $ 22,000.00
4
Obsolete Inventory: Company either sells at a discounted rate or must continue to hold outdated offering indefinitely. $ 16,000.00
5
Financing: Yearly cost of financing is 7%. $ 22,750.00
6
Pilferage (Theft): When theft occurs, it's a complete loss. $ 3,000.00
7
Inbound Freight: Costs to get raw materials and goods into the warehouse. This includes expedite charges for out-of-stock (OOS) situations. $ 16,500.00
8
Outbound Freight: These are costs incurred to rush goods out to customers for either being late, having an out-of-stock (OOS) situation, and or needing to reclaim lost business. $ 7,500.00
9
Lost Business: When sales, profit and customers are lost due to not having inventory. $ 15,000.00
10
Electricity and Climate Control: Costs to keep lights on, electronic locks working and or costs to maintain certain temperature in the warehouse. $ 9,500.00
11
Insurance: Essential costs to insure the warehouse. $ 7,500.00
12
Warehouse Overtime: When employees are forced to stay late to receive incoming shipments or make sure outgoing shipments leave on time. $ 6,000.00
13
Yearly Inventory Carrying Costs $ 125,750.00
14
Monthly Inventory Carrying Costs $ 10,479.17
15
Yearly Inventory Carrying Costs Expressed as a Percentage39%
16
Monthly Inventory Carrying Costs Expressed as a Percentage3.224%
17
18
Average Monthly Inventory Value on Hand (month-after-month) $ 325,000.00
19
Damaged and Ruined Inventory: $ 22,000.00
20
Obsolete Inventory: $ 16,000.00
21
Financing: $ 22,750.00
22
Pilferage (Theft): $ 3,000.00
23
Inbound Freight: $ 16,500.00
24
Outbound Freight: $ 7,500.00
25
Lost Business: $ 15,000.00
26
Electricity and Climate Control: $ 9,500.00
27
Insurance: $ 7,500.00
28
Warehouse Overtime: $ 6,000.00
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...