Monday, November 28, 2011

Locked Cabinet Space

As Madeline pointed out in a comment on my posting "Shelf Space Utilization", we have to determine how much product we can store in the locked cabinets. This will give us a better idea of how much we can have on hand and it will also confirm the hope that we will not need to store any product in the back room.

Here we go:

  • In the 12, 10ft x 1ft 3 sided shelves (360sq ft), we will have a 3ft tall locked cabinet underneath, that will have a volume of 30 cubic feet available for product storage. If we assume the average product is 3"long x 3"tall x 3"wide, we can conclude that each product will take up 27 cubic inches. 27 cubic inches is 0.0156 cubic feet. 30 cubic ft/0.0156 cubic feet = 1923 products that can be stored in the 3 sided shelf's locked cabinet. That's a total of 23,076 stored products in the locked cabinets of the 12, 3 sided shelves.
  • In the 6, 3ft x 3ft 4 sided shelves (54sq ft), we will have a 3ft tall locked cabinet underneath, that will have a volume of 27 cubic feet available for product storage. If we assume the average product is 3"long x 3"tall x 3"wide, we can conclude that each product will take up 27 cubic inches. 27 cubic inches is 0.0156 cubic feet. 27 cubic feet/0.0156 cubic feet = 1730 products that can be stored in the 4 sided shelf's locked cabinet. That's a total of 10,380 stored products in the locked cabinets of the 6, 4 sided shelves.
  • In the 3, 4ft x 4ft tables (48sq ft), we will have a 3ft tall locked cabinet underneath, that will have a volume of 48 cubic feet. If we assume the average product is 3"long x 3"tall x 3"wide, we can conclude that each product will take up 27 cubic inches. 27 cubic inches is 0.0156 cubic feet. 48 cubic feet/0.0156 cubic feet = 3077 products that can be stored in the 4 sided shelf's locked cabinet. That's a total of 9231 stored products in the locked cabinets of the 3 tables.



All together, we can store 36,533 products in the locked cabinets among our store. WOW. I triple checked the math, and I am quite sure that I'm right. Does it seem right to you guys?

I think it's fair to say that we don't need to store any product in the backroom....

2 comments:

Lane K. said...

Nice job Pat, you did a great job on the numbers.
It sounds like a whole lot to keep on hand at any given time, but I don't think it is unrealistic. Our products are small and hopefully demand will be high so we will need to keep many products in store to keep up with the demand.

pbruns said...

Please see "Revised Locked Cabinet Space" post for the revised version of this posting.

Post a Comment