Warehouse Space Utilization Spreadsheet

M

Marla Diaz

#1
Hi. We'd like to add as performance indicator e.g. 90% warehouse space utilization aside from 100% inventory accuracy. Does anybody have an excel (maybe) file/doc which can be used to compute for warehouse space utilization?

Thanks,
Marla
 
Elsmar Forum Sponsor

Jim Wynne

Staff member
Admin
#2
Marla Diaz said:
Hi. We'd like to add as performance indicator e.g. 90% warehouse space utilization aside from 100% inventory accuracy. Does anybody have an excel (maybe) file/doc which can be used to compute for warehouse space utilization?

Thanks,
Marla
I'm a little thick when it comes to inventory issues, but it seems to me that the goal these days is to have as little inventory as possible of all kinds (parts, WIP, finished goods, etc.). Why would 90% warehouse utilization be considered a good thing, unless you're trying to reduce it? Also, and remember I'm not too sharp when it comes to these things, wouldn't you calculate space utilization just by dividing the space used by the space available?
 
M

Marla Diaz

#3
Warehuse space utilization spreadsheet

Dear JSW05,

Your right, we're after the 100% warehouse utilization and not 90%. Ok, will do that calculation and hopefully come up with a good presentation with charts.

Thanks!
 

Jim Wynne

Staff member
Admin
#4
Marla Diaz said:
Dear JSW05,

Your right, we're after the 100% warehouse utilization and not 90%. Ok, will do that calculation and hopefully come up with a good presentation with charts.

Thanks!
Marla,
Perhaps you misunderstood me. Why would you want your warehouse to be full all the time? Isn't it a better idea to carry as little inventory as possible?
 
N

nickh - 2011

#5
You know, I can see using this metric if your goal is to reduce the warehouse footprint as you reduce inventory. Or perhaps, if your utilization is over 100% (inventory overflow) and the goal is to reduce inventory to some preset target level, then that might make sense too. But if you're adding inventory just to fill up space, well ... I'm confused too.
 
M

Marla Diaz

#6
Daer JSW05, nickh,

We are operating a commercial and a customs bonded warehouse but only the commercial warehouse is included in the scope of our 9K2K certification (site specific). A 100% space utilization would mean revenue for us.

Thanks,
Marla
 
Thread starter Similar threads Forum Replies Date
J Warehouse Floorspace Utilization Manufacturing and Related Processes 3
R Product Recall - medical devices in the hospital warehouse Canada Medical Device Regulations 2
L Significant change notice for outsourced warehouse Medical Device and FDA Regulations and Standards News 2
M Pharmaceuticals Warehouse temperature control (room temperature) Pharmaceuticals (21 CFR Part 210, 21 CFR Part 211 and related Regulations) 3
B Software for setting up New Warehouse Manufacturing and Related Processes 0
R Is there a mandatory medical device warehouse standard for europe? EU Medical Device Regulations 3
R Warehouse and shipping/receiving activities need to be part of our scope? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 28
G How to cover another manufacturing "site" or warehouse into current ISO 13485 cert ISO 13485:2016 - Medical Device Quality Management Systems 7
P Non Conforming Material in the Warehouse..to tag or not? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
D AS9100 section for Warehouse/Preservation of materials? AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 4
R Brand New Warehouse - FMEA example wanted FMEA and Control Plans 9
B Fire Extinguisher Requirements for a Warehouse Vehicle Miscellaneous Environmental Standards and EMS Related Discussions 2
S Package Storage Direction in an I.T. Warehouse ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
M FDA Wall Clearance Requirements For Warehouse 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 9
M Critical Limits for CCP in a food storage warehouse Food Safety - ISO 22000, HACCP (21 CFR 120) 4
A Food Warehouse ISO 9001 Audit and Newbie Introduction ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
D Calibration in Warehouse Environment ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 1
M Movement of Final Product from One Warehouse to Another Manufacturing and Related Processes 2
R HACCP for Packaging, Labeling and Warehouse of Food Products Food Safety - ISO 22000, HACCP (21 CFR 120) 13
S Building and Warehouse requirements of OHSAS 18001 Occupational Health & Safety Management Standards 8
S Single Warehouse used by two different companies - One is ISO 13485 registered Quality Manager and Management Related Issues 1
T Outsourcing Shipping Product directly from our Warehouse to the End Customer ISO 13485:2016 - Medical Device Quality Management Systems 2
J HACCP and ISO22000 - Brewery and Warehouse Food Safety - ISO 22000, HACCP (21 CFR 120) 13
M Kanban vs. Line Balancing - Process Engineering our Warehouse Process Lean in Manufacturing and Service Industries 3
M Internal Warehouse Handling - A Reverse Logistic Case! Process Maps, Process Mapping and Turtle Diagrams 6
N 100% Inspection in Retail Warehouse which Ships Products to Customers Inspection, Prints (Drawings), Testing, Sampling and Related Topics 3
B TS 16949 Upgrade for Distribution Warehouse IATF 16949 - Automotive Quality Systems Standard 4
L Writing a Shipping and Receiving Procedure - Designated Warehouse Locations ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
Q Electronic Process Examples (IT Data Warehouse) Human Factors and Ergonomics in Engineering 1
N Managing Subcontracting Process - Material Traceability from Warehouse to Processing ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
C Warehouse Layout Design Lean in Manufacturing and Service Industries 11
Q Control plans for Incoming, Warehouse and Shipping process FMEA and Control Plans 5
bgot62 Secondary Operations and an uncontrolled document in the warehouse ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 1
H Forklift Safety - Driver loses control in warehouse (Video) Occupational Health & Safety Management Standards 2
R VMP template for Temperature Data Loggers in a Pharma Warehouse Qualification and Validation (including 21 CFR Part 11) 4
P Warehouse Audit - Nonconformance or not - That is the question ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 24
A Rental Warehouse Audit required? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 14
G Manufacturing -> Warehouse -> Tier 1/OEM - Process flow, PFMEA, & Control Plan FMEA and Control Plans 9
D Should I put Warehouse under Manufacturing Department? Misc. Quality Assurance and Business Systems Related Topics 8
A Production Planning, Scheduling and Warehouse Management Manufacturing and Related Processes 8
I How to Balance a Warehouse System Lean in Manufacturing and Service Industries 2
I Time Analysis of Logistics in a Warehouse Lean in Manufacturing and Service Industries 3
C Requirements for Process Chemical Storage in a Warehouse Miscellaneous Environmental Standards and EMS Related Discussions 20
M Dock to Stock Template for Distributor/Warehouse of Industrial Metals Document Control Systems, Procedures, Forms and Templates 5
A Warehouse Internal Audit - Seeking Tips and Advice Internal Auditing 17
J Free Warehouse Layout & Planning Guide and Facilities & Workplace Design guide Design and Development of Products and Processes 10
M President of company wants ISO 17025 for testing - Warehouse distributor ISO 17025 related Discussions 3
L Warehouse Design Layout - FDA Regulated Medical Manufacturer Design and Development of Products and Processes 3
T Warehouse Fire: QMS Involvement? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 25
D Segregation of Product by Type and Production Week - Warehouse General Auditing Discussions 2

Similar threads

Top Bottom