The annual procurement plan
Listen to this lesson
Nigerian voice narration
Fictional training case. All departments submitted wishlist requests for next year, and the procurement unit must merge them into one coherent annual plan. Some requests look suspiciously similar, raising concern that a department is splitting one large need into smaller requests to dodge the open-tender threshold. Work through the example, identify the evidence needed and practise the method with cleared or synthetic inputs. Any additional figures in the explanation are separate practice examples, not claimed rows in a downloadable file.
Worked example
Paste all departmental requests and ask AI to group them by category (ICT, furniture, consumables, etc.), remove exact duplicates, and specifically flag any requests that look like a single larger need split into smaller amounts — for example, three separate ₦2m laptop requests from one department within weeks of each other. Verify any flagged split-purchase pattern against the department's actual need and the applicable procurement threshold table, since crossing that threshold wrongly triggers the wrong procurement method. Ask AI to propose a quarterly schedule with a suggested procurement method per lot, then check every suggested method against your unit's official threshold table before finalising — AI's suggestion is a starting point, not policy.
The method
Group-flag-verify: use AI to do the mechanical grouping and duplicate/split-pattern detection across a large dataset, but independently verify any flagged split-purchase and every suggested procurement method against the fixed threshold table, which AI does not reliably know.
Worked practice and common mistakes
Identical descriptions from two departments may be separate needs rather than duplicate records. Confirm request IDs, quantities and delivery locations before deleting anything. Three fictional ₦2m requests total ₦6m; the appropriate method still depends on current approved rules and circumstances. Consolidation is analysis, not authority to award or declare a split purchase unlawful without review.
Review before using the result
Pick one flagged 'possible split' and confirm manually whether the combined value crosses a procurement method threshold before merging or escalating it.
Your workplace practice
Use the recommended free assistant with this lesson's fictional example. Consolidate these departmental requests into an annual procurement plan: group by category, remove duplicates, flag likely split requests, and suggest a quarterly schedule with a procurement method per lot. Keep a copy of the input and draft. Compare the result with the verification steps above, record any correction, and retain placeholders where evidence is missing. The expected result is a checked draft for human review, not an automatically approved decision. Course examples and practice responses are fictional; amounts, dates, rules and thresholds are not official guidance or supplier quotations.
Open ChatGPT (free tier) and paste this prompt there. Strong at structuring a full plan with timelines and tables.
Consolidate these departmental requests into an annual procurement plan: group by category, remove duplicates, flag likely split requests, and suggest a quarterly schedule with a procurement method per lot.
Why this tool: Strong at structuring a full plan with timelines and tables.
Hit a free limit? Switch to ChatGPT or Gemini and continue — the prompt works in any assistant.