Capability template for supply chain and inventory

Kit component availability check

The stock or online-store lead gets every kit beside the quantity actually sellable, the component that limits it, the stock records that disagree and the listings that promise more than can be built. Nothing is changed until a person decides.

Put this on your planBuild this in a sprint

Add it to a workflow in the Fully Powered Planner, beside the teams and roles that will run it. Book a fit call

The outcome

A kit is only as available as its scarcest part. A gift box can show forty in stock on the store while one of its three components is down to six, or sit in the other warehouse, or already be promised to open orders. The total on the screen hides it until a customer has paid for a kit nobody can pack.

This capability puts each kit beside what can actually be built. For every kit it works out the number sellable at each location from what is on hand less what is reserved, names the component that limits it, and shows the figure to rely on. Where two stock records disagree about a component, it works the kit out both ways and relies on the lower number until someone settles the difference. It then sets that number against what each sales channel is currently offering and shows where a listing promises more than can be built.

It also catches a trap that no single kit shows: two kits drawing on the same component. Each looks fine alone; sold together they need more than the shelf holds. Those are listed, with the shortfall, for the planner to decide.

The stock lead corrects the records and the listings. This capability changes no stock figure and no listing.

Who starts the work, and when

The stock lead, or the online-store lead who sells kits and bundles built from separate items, starts it. Typical moments are before a promotion or a gift season, after a delivery or a count, when a customer is told a kit is out although the shelves look full, or on a regular day each week. The inventory planner reviews the draft and confirms the quantities before any promise to customers or any listing changes.

What they supply

  • Kit definitions: for each kit, its components and how many of each go into one kit.
  • A stock export: each component by location, with the quantity on hand and the quantity reserved.
  • A second stock record, if the business keeps one, such as the sales platform's own figures. This is how conflicting records are found.
  • A listing export, if the kits are sold on one or more channels: the quantity each channel currently shows for each kit.
  • The settings: which locations can pack kits, when each export was taken, and how old a record may be before it is not trusted.

Each file's column headers are checked first. If one does not match, the work stops and asks which column is which.

What comes out

One page in a fixed order: the basis of the check, a summary, any problems found in the files, then each kit on its own line with the sellable quantity by location, the limiting component, the figure to rely on and how it compares with each listing. After that come the stock records that disagree, the components that more than one kit depends on, the listings a person should correct, and numbered questions. An empty section says "None." Every figure traces to a row in a supplied file, and the arithmetic is simple enough to recheck by hand.

An invented example

Illustrative example with invented data. The business, the kits, the components, the quantities and every date below are invented. The business is an invented online gift shop, called the Shop here, with two places that can pack kits, Main and Annex. It keeps its stock in a stock system and also has a second stock record on its web shop platform, and it sells kits on its own web shop and on one marketplace. People are referred to by role.

The inputs come first, in full, so the template can be run on them. The check follows. Labels are set in bold and sections as lists here for reading; the template prints them as plain text.

The inputs

1. Settings (typed by the stock lead)

Business: the Shop
Today: Tuesday 10 November 2026
Locations that can pack kits: Main, Annex
Parts from different locations may be combined: not given
Export dates: kit definitions, stock export, second stock record and
  listing export were all taken on 10 November 2026
Stale limit: not given
Stock lead: the stock lead
Approver: the inventory planner

2. Kit definitions

kit_code,kit_name,component_code,qty_per_kit
GFT-SPA,Spa gift box,SOAP-1,2
GFT-SPA,Spa gift box,CAND-1,1
GFT-SPA,Spa gift box,BOX-L,1
GFT-HOME,Home set,CAND-1,2
GFT-HOME,Home set,MUG-1,2
GFT-HOME,Home set,BOX-L,1
GFT-TEA,Tea sampler,TEA-A,3
GFT-TEA,Tea sampler,TEA-B,3
GFT-TEA,Tea sampler,BOX-S,1
GFT-TEAP,Tea duo,TEA-A,2
GFT-TEAP,Tea duo,BOX-S,1
GFT-NEW,Winter tin set,TIN-9,1
GFT-NEW,Winter tin set,CAND-1,1

3. Stock export

component_code,description,location,on_hand,reserved
SOAP-1,Lavender soap bar,Main,40,6
SOAP-1,Lavender soap bar,Annex,10,0
CAND-1,Soy candle,Main,25,5
CAND-1,Soy candle,Annex,4,0
BOX-L,Large gift box,Main,30,10
BOX-L,Large gift box,Annex,12,2
MUG-1,Stoneware mug,Main,20,0
MUG-1,Stoneware mug,Annex,0,0
TEA-A,Tea blend A,Main,30,0
TEA-B,Tea blend B,Main,8,2
BOX-S,Small gift box,Main,50,0

4. Second stock record (web shop platform)

component_code,location,on_hand
SOAP-1,Main,36
SOAP-1,Annex,10
CAND-1,Main,25
CAND-1,Annex,4
BOX-L,Main,30
BOX-L,Annex,12
MUG-1,Main,17
MUG-1,Annex,0
TEA-A,Main,30
TEA-B,Main,8
BOX-S,Main,50

5. Listing export

kit_code,channel,listed_qty
GFT-SPA,Web shop,25
GFT-HOME,Web shop,8
GFT-TEA,Web shop,12
GFT-TEA,Marketplace,6
GFT-TEAP,Web shop,15
GFT-NEW,Web shop,5
GFT-OLD,Web shop,3

The output

KIT COMPONENT AVAILABILITY CHECK: the Shop, stock as of Tuesday 10 November 2026

  • For: the stock lead and the inventory planner. Prepared Tuesday 10 November 2026 from: kit definitions (13 rows, 5 kits), stock export (11 rows, exported 10 November 2026), second stock record (11 rows, web shop platform, exported 10 November 2026), listing export (7 rows, exported 10 November 2026), settings.
  • Column check: all headers matched.
  • Basis: packing locations Main and Annex; stock at other locations ignored. Available is on hand less reserved; a component with no row for a location counts as 0 there. Each kit is built at one location from the parts held there. Incoming stock is not counted. Freshness: all files within 3 days.
  • Settings: stale limit 3 days; approver the inventory planner. Defaults used: stale limit, parts from different locations.
  • Summary: 5 kits defined. Sellable 1. Conflict 3. Zero 0. Unresolved 1. Component clashes between kits 2. Stock records in conflict 2. Listings to correct 2.

Record checks

  • GFT-NEW: component TIN-9 has no row in the stock export. See question 1.
  • GFT-OLD is in the listing export (Web shop, 3) and has no kit definition. See question 2.

Kit by kit

  • GFT-NEW Winter tin set. Unresolved: TIN-9 has no row in the stock export. Sellable: cannot be stated. Listed: Web shop 5, total 5; not compared.
  • GFT-HOME Home set. Conflict: the two stock records disagree on MUG-1 at Main. Sellable to rely on 8. By location: Main 8 (limit MUG-1), Annex 0 (limit MUG-1). On the stock export 10; on the lower of the two records 8. Listed: Web shop 8, total 8; matches.
  • GFT-SPA Spa gift box. Conflict: the two stock records disagree on SOAP-1 at Main; the listing is above the figure to rely on and above the stock export's figure. Sellable to rely on 19. By location: Main 15 (limit SOAP-1), Annex 4 (limit CAND-1). On the stock export 21; on the lower of the two records 19. Pooled across locations 20; needs parts moved between locations. Listed: Web shop 25, total 25; over by 6.
  • GFT-TEA Tea sampler. Conflict: the listing is above what can be built. Sellable to rely on 2. By location: Main 2 (limit TEA-B), Annex 0 (limit TEA-A, TEA-B and BOX-S, tied at 0). Listed: Web shop 12, Marketplace 6, total 18; over by 16.
  • GFT-TEAP Tea duo. Sellable. Sellable to rely on 15. By location: Main 15 (limit TEA-A), Annex 0 (limit TEA-A and BOX-S, tied at 0). Listed: Web shop 15, total 15; matches.

Conflicting stock records

  • SOAP-1 Lavender soap bar, Main: stock export 40 on hand, 6 reserved; second record 36. Lower figure used: 36, available 30. Affects GFT-SPA. Check: count the shelf at Main; the stock lead decides which record is right.
  • MUG-1 Stoneware mug, Main: stock export 20 on hand, 0 reserved; second record 17. Lower figure used: 17, available 17. Affects GFT-HOME. Check: count the shelf at Main; the stock lead decides which record is right.

Components shared by kits

  • CAND-1 Soy candle: available 24 (Main 20, Annex 4). GFT-SPA 19 × 1 = 19 and GFT-HOME 8 × 2 = 16 need 35; short by 11. Left out: GFT-NEW, unresolved, also uses it; the shortfall may be larger. The planner decides how the stock is shared.
  • TEA-A Tea blend A: available 30 (Main 30, Annex 0). GFT-TEA 2 × 3 = 6 and GFT-TEAP 15 × 2 = 30 need 36; short by 6. The planner decides how the stock is shared.

Listings to correct

  • GFT-SPA, Web shop: listed 25; sellable 19, the lower of two stock records. Reduce the total to no more than 19, or hold the listing. Approved: ______________ Date: ________
  • GFT-TEA, Web shop 12 and Marketplace 6: listed 18; sellable 2. Reduce the total to no more than 2, or hold the listing. Approved: ______________ Date: ________

Questions for the stock lead

  1. GFT-NEW Winter tin set: component TIN-9 has no row in the stock export, and the kit is listed on the Web shop at 5. Is the code wrong in the definition, or has the tin not yet been set up in the stock system?
  2. GFT-OLD is listed on the Web shop at 3 and has no kit definition. Is it a retired kit whose listing was left up, or a live kit whose definition is missing?

Draft for the inventory planner's decision. Nothing has been changed in the stock system, the store or any listing, and no customer has been told anything. Quantities are worked out from the files supplied, as of 10 November 2026.

Where it fits

It is not a count reconciliation; for that, use stock count reconciliation, which settles the books against the shelf. It does not decide what to order; the inventory reorder plan does. Slow-moving stock and markdown plan covers the opposite problem, components that sit unsold.

What has to change for your company

  • Your export headers, set once so the column check passes without a question.
  • Which locations can pack kits, and whether a kit may be built from parts held in two places.
  • How old a record may be, before the kits that depend on it are left unresolved.
  • What counts as reserved: open orders, held stock, display units or anything else you set aside.
  • Who confirms the quantities and who corrects listings on each channel.
  • Your AI product. It runs in ChatGPT, Claude, Copilot or Gemini from the files you supply. It needs no connection to your store or stock system, changes nothing in them and never asks for a password.

What has been checked

Fully Powered AI wrote this capability template in its own words, from its own published map of the work, with no third-party text. It was editorially reviewed on 10 November 2026. It was tried once on its invented example in Claude on 10 November 2026. That run was not blind, because the example's published output was on screen when it was made, and it found gaps in the instructions. They were fixed afterward and the template was run on the example again; the record of that second run is published with it. Only the success path has been run: the stop conditions and the acceptance tests have not. It has not yet been tested in a client environment. It has not yet been tested as a packaged version in ChatGPT, Claude, Copilot or Gemini.

Testing in your environment means running it on one or two kits your stock lead knows well, with hard cases written in advance: a component with no stock row, two records that disagree, a reservation larger than the stock, a listing above what can be built, and two kits that share a part. The stock lead checks every line against the exports before anyone relies on it. Pilot acceptance-test preparation sets those cases up, and what we test before we call an AI workflow ready describes the record we keep.

The full capability template

Everything above is the outline. The complete capability template is the working version: the roles, the inputs, the procedure, the exceptions and stop conditions, the output format, the reviewer checklist, the acceptance tests, the instructions for an AI assistant and what to customize for your company. It comes with a download and the link to its folder in Fully Powered’s public repository.

View the full template

Free with an account. Sign in by email: no password and no card.

Next step

Put this capability to work for your team: on your plan, or built with you in a sprint.

Put this on your plan

Add it to a workflow in the Fully Powered Planner, beside the teams and roles that will run it.

Build this in a sprint

In a sprint, Fully Powered adapts this capability template to your rules, proves it on your own work and puts it in the hands of the roles that own it.

Two ways to begin:

Rather talk it through first? Book a fit callDiscuss adapting this