---
id: post/olofsimren-com/3630
type: post
title: Copilot in Planning Parameter Worksheet
summary: A custom extension called Planning Parameter Worksheet uses Copilot powered by Azure OpenAI to suggest inventory planning parameters for items based on ABC classification and usage data. The AI evaluates one item at a time, applies established economic formulas, and explains its parameter recommendations.
tier: community
language: en
tags:
  - copilot
  - planning parameters
  - abc classification
  - eoq
  - safety stock
  - azure openai
  - extension
  - ai explanation
system: copilot
review:
  state: reviewed
  by: opus
  at: "2026-10-08T01:58:34.242Z"
  flags: []
generated:
  at: "2026-10-08T01:26:53.141Z"
  pipeline: 0.2.0
  prompts:
    extract-post: 1
  input_hash: c6c39f355bffe35800e3dec6689ed2548077ba3116c7d243b1ebfab5f14d5f51
evidence:
  - kind: blog
    url: https://www.olofsimren.com/copilot-in-planning-parameter-worksheet/
    title: Copilot in Planning Parameter Worksheet
    date: "2025-10-31"
    commit: null
    t: null
    quote: null
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
post_id: "3630"
source_id: olofsimren-com
source_name: Olof Simren
url: https://www.olofsimren.com/copilot-in-planning-parameter-worksheet/
published_at: "2025-10-31T12:15:17.000Z"
author: Olof Simren
full_text: false
words: 1588
quotes: []
code_objects_mentioned:
  - other Planning Parameter Worksheet
  - other Copilot Inventory Queries extension
systems:
  - copilot
  - inventory
versions_mentioned: []
preview:
  embeddable: true
  frame_url: https://www.olofsimren.com/copilot-in-planning-parameter-worksheet/embed/
  image: null
  image_alt: null
  image_w: null
  image_h: null
  site_name: null
  favicon: https://i0.wp.com/www.olofsimren.com/wp-content/uploads/2026/03/OlofSimren_512x512.png?fit=32%2C32&ssl=1
  probed_at: "2026-10-07T11:50:51.918Z"
---

# Copilot in Planning Parameter Worksheet

[Read the post](https://www.olofsimren.com/copilot-in-planning-parameter-worksheet/) · Olof Simren (Olof Simren) · 2025-10-31 · 1588 words · tier community · reviewed (checked by Opus)

> A custom extension called Planning Parameter Worksheet uses Copilot powered by Azure OpenAI to suggest inventory planning parameters for items based on ABC classification and usage data. The AI evaluates one item at a time, applies established economic formulas, and explains its parameter recommendations.

## Key points

- The extension performs double ABC classification of items by transaction frequency and value, then applies rules for safety stock and reorder settings
- Business Central pre-calculates metrics like average monthly usage, standard deviation, and lead time demand before sending them to Copilot to avoid excessive data
- Copilot receives a predefined prompt instructing it to return results in JSON format with Business Central-specific period notations like '2W' or '1M'
- The AI explains its suggestions using established theories such as economic order quantity (EOQ) formulas and service level calculations based on ABC classifications
- Processing takes about 5-7 seconds per item with a gpt-5-chat model, making bulk analysis of thousands of items time-consuming but practical

## AL objects mentioned

As named in the post. A name that matches one object page by exact type and name links to it; the others stay as named.

- other "Planning Parameter Worksheet"
- other "Copilot Inventory Queries extension"

## Context

- Features: Copilot-powered parameter suggestions, ABC classification (double classification), Economic order quantity calculation, Safety stock calculation, Lead time demand evaluation, Reordering policy recommendations, Automated explanation generation, JSON formatted responses

Source: Olof Simren, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.