# Kitting Shortage List Template > Source: https://netray.co/tools/kitting-shortage-list-template > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer A shortage board for kit orders: what is required, what is allocated, what is short, who is chasing it and when it arrives. ## Category supply-chain ## Audience - Production planner - Kitting lead - Buyer - Warehouse supervisor ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Kit or work order **Key:** kit **Type:** text #### Part number **Key:** part **Type:** text #### Required **Key:** required **Type:** number **Unit:** units #### Allocated or picked **Key:** allocated **Type:** number **Unit:** units #### Short **Key:** short **Type:** number **Expr:** max(0, required - allocated) **Unit:** units #### Fill rate **Key:** fill **Type:** number **Expr:** if(gt(required, 0), min(100, allocated / required * 100), 100) **Format:** percent #### Unit cost **Key:** unit_cost **Type:** number **Format:** currency #### Value short **Key:** short_value **Type:** number **Expr:** short * unit_cost **Format:** currency #### Promised receipt **Key:** eta **Type:** date #### Action **Key:** action **Type:** select **Options:** - Expedite PO - Substitute part - Transfer from other plant - Partial kit and build - Waiting on inspection - Order not yet placed #### Owner **Key:** owner **Type:** text **Rows:** **Kit:** WO-77120 **Part:** BRK-1001 **Required:** 400 **Allocated:** 250 **Unit cost:** 4.15 **Eta:** 2026-10-28 **Action:** Expedite PO **Owner:** J. Singh **Kit:** WO-77120 **Part:** FST-M6x20 **Required:** 3200 **Allocated:** 3200 **Unit cost:** 0.09 **Action:** Partial kit and build **Kit:** WO-77133 **Part:** CBL-0442 **Required:** 120 **Allocated:** 0 **Unit cost:** 11.8 **Eta:** 2026-11-05 **Action:** Order not yet placed **Owner:** A. Rao **Kit:** WO-77133 **Part:** PCB-8800 **Required:** 120 **Allocated:** 90 **Unit cost:** 38.5 **Eta:** 2026-10-30 **Action:** Waiting on inspection **Owner:** Receiving QC **Kit:** WO-77141 **Part:** SHF-3100 **Required:** 60 **Allocated:** 40 **Unit cost:** 26.75 **Eta:** 2026-10-26 **Action:** Transfer from other plant **Owner:** M. Khan **Totals:** #### Total units short **Key:** short **Agg:** sum **Format:** integer #### Total value short **Key:** short_value **Agg:** sum **Format:** currency #### Largest single shortage **Key:** short **Agg:** max **Format:** integer **Notes:** Review at the start of each shift. A kit is clear to build only when every line has fill rate 100 percent, or when production has agreed to a partial kit. Remove lines once the shortage is closed in the ERP so the list stays short. ## Content **Intro:** Kits stall when one part is missing, and the shortage list is how planners, buyers and the floor agree what to chase. This template tracks each line's required and allocated quantity and calculates the shortage and its value. **Sections:** #### How to use the template **Body:** Add a row for every kit line that is short or at risk. Enter the required quantity from the work order or kit pick list, the allocated or picked quantity, and the unit cost. The sheet calculates the shortage, the fill rate and the value short. Add the promised receipt date from the supplier and an owner. Sort by promised date to see which kits can start and which cannot. #### Why it works **Body:** A shortage list is a daily management tool, not a report. The key fields are the real quantity short, the date the part will really arrive, and one named owner. The value short column helps decide where to spend expediting money. The action column keeps decisions explicit: expedite, substitute, transfer, build partial or wait for inspection. **Bullets:** - Fill rate shows how close each line is to complete. - Value short supports expedite decisions. - Owner and date prevent lines from being forgotten. #### Reading the example **Body:** In the sample, WO-77120 is short 150 bearings with a promised date of 28 October, so the kit cannot complete before then unless a partial build is agreed. WO-77133 has two problems: a cable not yet ordered, which is a planning failure, and a PCB sitting in inspection, which is a quality queue issue and may release sooner than the supplier date suggests. #### Common mistakes **Body:** The usual failures are stale promise dates, shortages recorded only as a part number with no quantity, and different lists kept by planning and the floor. Another is treating on hand as available when it is reserved for another order. Allocate in the ERP first, then record the leftover shortage here. **Cta:** Netray can generate a live shortage view from your ERP's work order and inventory data so the list updates itself instead of being maintained by hand. **Faq:** #### What is a kitting shortage list? **Answer:** It is a list of kit components that cannot be picked in full for a work order, showing quantity short, expected arrival and who is resolving each line. It tells production which kits are clear to build. #### What does clear to build mean? **Answer:** A work order is clear to build when all required components are available, allocated and, where needed, inspected. Some plants allow a partial kit if the missing parts are not needed until later operations. #### How often should the shortage list be updated? **Answer:** At least once per shift for the next several days of production, and when receipts are posted. A list that is updated weekly is usually out of date by the time anyone acts on it. #### Should shortages be tracked in Excel or the ERP? **Answer:** The ERP is the source of truth for quantities, and most have a shortage report. Excel is useful for adding promise dates, owners and actions that the ERP does not hold. Use both without double entry of quantities. ## Search terms kitting shortage list, shortage report template excel, kit shortage tracking, kitting list template, material shortage list manufacturing, production shortage report, clear to build kit list --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json