Material Shortage Tracker
Critical materials with days of cover, updated every morning.
- Excel or Sheets
- You get: A spreadsheet you can download and share
- Free, no sign-up
When to use it
Daily, for the 15 to 20 materials that can stop a line.
How to use it
- 01List critical materials once
- 02Update usable stock each morning
- 03Mark red when cover is below lead time
Material Shortage Tracker
Columns in the sheet
The row under the headings is an example.
| Material | Usable stock | Daily use | Days of cover | Lead time | On order | Due date | Status | Action |
|---|---|---|---|---|---|---|---|---|
| Example row: PP granules black | 900 | 360 | 2.5 | 7 | 2000 | 06-Oct | Red | Confirm dispatch |
Saving keeps a copy in this browser only. No account is needed and nothing is sent.
Use this with
- GuideHow to prevent material shortagesRead the guide →
- ProblemMaterial shortagesSee the problem guide →
- ProcessPurchase requirement to material receivedSee the full process →
- lamp
lamp could fill this from the tools you already use and keep it up to date.
Join the waitlist →See how lamp works →
Does this miss something you check?Suggest an addition →