
Badge Stock & Encoder Capacity Plan
N.B. Upload actuals from media platforms/CRM and the standard table; ensure consistent currency [Currency] and that timing aligns with [FiscalCalendar] cut-offs.
📄 Prompt Template
Build a capacity plan for access card stock and encoder utilisation. Starting with current inventory [CurrentInventory], monthly issue rate [MonthlyIssueRate], supplier lead time [LeadTime_Days] days, and safety stock target [SafetyStock_Days] days, produce a rolling forecast that accounts for [Seasonality_Factor] seasonality. Include encoder throughput assumptions and maintenance windows; propose reorder points by site and supplier [SupplierName] allocations.
Output format:
Forecast table for the next [Timeframe] (Markdown): Month | Forecast Demand | Opening Stock | Receipts | Closing Stock | Reorder Point | Encoder Hours Needed.
Purchase plan (Markdown): PO Date | Quantity | Supplier | Site | Expected Delivery.
Risks & mitigations list (bulleted).
Assumptions register (numbered).
Quantify stockout risk probability and propose contingency (temporary badges, reprint prioritisation).