The personal protective equipment (PPE) burn rate calculator excel icon[XLS – 39 KB] is a spreadsheet-based model that provides information for healthcare facilities to plan and optimize the use of PPE for response to coronavirus disease 2019 (COVID-19). Similarly, non-healthcare facilities (e.g., correctional facilities) may find this tool useful for planning and optimizing PPE use as part of the response to COVID-19. This tool can also be used for planning PPE use outside the context of COVID-19, where PPE shortages may also occur due to supply chain issues related to the COVID-19 response (e.g. manufacturing facilities).
To use the calculator, you enter the number of full boxes of each type of PPE that you have in stock (e.g., gowns, gloves, surgical masks, respirators, and face shields). This tool then calculates the average consumption rate, also referred to as a “burn rate,” for each type of PPE entered in the spreadsheet. This information can then be used to estimate the remaining supply of PPE based on the average consumption rate. The spreadsheet is open-ended and can also be used to calculate the use of other types of PPE as well.
Please check out this CDC website for more information.