---
title: AI prompts for inventory and production managers | DataAutomation
url: https://dataautomation.com/prompts/inventory-production/
description: 10 free copy-paste AI prompts for inventory and production managers at product businesses and manufacturers.
---

# AI prompts for inventory and production managers.

For the people who decide what gets made, when, and from what. Works whether you run Katana, another MRP, or spreadsheets. 10 copy-paste prompts for Claude, ChatGPT, or any AI assistant, written from patterns we see in client work.

[See use cases for your role](https://dataautomation.com/for/inventory-production/) [All prompt packs](https://dataautomation.com/prompts/)

## How to use these

### Fill in the brackets.

Each prompt has [bracketed] spots. Replace them with your real numbers and context. The more specific you are, the better the answer.

### Use a project.

In Claude or ChatGPT, put your policies, product list, and chart of accounts in a project once, so every prompt starts with your context.

### Leave customer data out.

AI tools and vendors leak regularly ([see the latest incidents](https://dataautomation.com/ai-security/)). Remove customer names, addresses, emails, and messages before pasting. Card numbers and passwords never go into a chat. Amazon buyer data, including personalization text, has extra rules.

### Check the math.

AI is good at structure and explanation and can still get arithmetic wrong. Spot-check any number you will act on.

## Planning production

Build next week's production plan from demand.

You are a production planner. Here is our data:

[paste open sales orders, forecast, finished goods on hand, materials on hand, lead times, and capacity per day]

Build a production plan for next week: what to make, how many, in what order, and why. Flag orders we cannot fill on time and which materials will run short. Show your reasoning so I can check it. Copy prompt

Find the bottleneck in your production line.

Here are our production steps with time per unit, people or machines per step, and typical queue at each step:

[paste operations and times]

Identify the bottleneck, calculate our real daily capacity, and suggest three ways to raise it, from cheapest to most expensive. Say what each change would add per day. Copy prompt

## Inventory accuracy

Investigate why stock counts do not match.

Our system says we have [X] of [item] but the shelf count is [Y]. Here is the item's recent history:

[paste receipts, production usage, sales, adjustments, and returns for the period]

Walk through the history and list every place the difference could have come from, most likely first. For each, say how to confirm it. Then suggest one process change that would stop it recurring. Copy prompt

Set reorder points that reflect reality.

For each item below I have average daily usage, usage variability, supplier lead time, and lead time variability:

[paste item data]

Calculate a reorder point and safety stock for each at a [95%] service level, show the formula you used, and flag items where the numbers suggest something is wrong with the data. Copy prompt

## Recipes, BOMs, and costing

Find which product costs you cannot trust.

Here is what I know about how we cost our products today:

[describe where costs come from, how often they are updated, and which products feel wrong]

Act as a skeptical controller. List the warning signs that our product costs are unreliable, which products are most likely affected, and what each one could be doing to margin and pricing decisions. Then list the questions I should be able to answer about our costs, and mark the ones I cannot answer today. Copy prompt

Work out true cost per unit.

Here is what goes into [product]:

[paste materials with quantity and cost, labor steps with minutes and hourly cost, overhead rate, packaging, and expected waste percentage]

Calculate the full cost per unit, broken down by materials, labor, overhead, packaging, and waste. Then show margin at our prices of [list prices by channel]. Point out which cost line moves margin the most. Copy prompt

## Choosing and preparing for an MRP

Decide if you have outgrown spreadsheets.

Here is how we plan production and track inventory today:

[describe the spreadsheets or tools, who updates them, how often, and what goes wrong]

Tell me honestly whether we have outgrown this setup. Give the signs that we have, the signs that we have not, what it is likely costing us each month in time and mistakes, and what we should know before choosing a system. Copy prompt

Write the questions to ask before an MRP implementation.

We are about to implement [Katana or another MRP]. Our business: [what we make, how many products and variants, sales channels, accounting system].

Write the questions we should ask any implementation partner, and the questions they should ask us. Group them by products, recipes, inventory, purchasing, connections, and training. Flag which answers change the price or timeline most. Copy prompt

## Waste and quality

Estimate what waste is costing you.

We lose material in production at these steps: [describe each step, roughly how much is lost, and the material cost].

Estimate what waste costs us per month and per year, and how much it distorts our cost per unit. Show your math, say which assumptions matter most, and list what we would need to measure to know for sure. Copy prompt

Write a quality check for a recurring problem.

We keep seeing [defect] on [product]. Here is what we know about when it happens:

[paste notes, batches, operators, materials, and dates]

Suggest the likely causes, a short inspection checklist for the step where it starts, and what to record so we can confirm the cause within two weeks. Copy prompt

## Make them yours

These prompts work best once your AI knows your business. Put your product list, policies, and chart of accounts in a project once, and every prompt starts from your context. When a prompt becomes something you run every week, that is usually the sign it should become a workflow that runs on its own.

That is what we build. [See how we work with inventory and production managers ->](https://dataautomation.com/for/inventory-production/)

## Start on your own

Free skills that teach Claude how we set up the platforms our clients run on.

[Free Katana readiness skillFind out whether Katana MRP fits how you run, size your data, and get a one-page brief ready before you start a software setup.Get the skill ->](https://dataautomation.com/skills/#katana-readiness)

## More prompt packs

[Owner and CEO](https://dataautomation.com/prompts/owner-ceo/), [Operations](https://dataautomation.com/prompts/operations/), [Purchasing and suppliers](https://dataautomation.com/prompts/purchasing/), [Fulfillment and shipping](https://dataautomation.com/prompts/fulfillment/), [Finance and accounting](https://dataautomation.com/prompts/finance/), [Sales and ecommerce](https://dataautomation.com/prompts/sales-ecommerce/), and [Customer service](https://dataautomation.com/prompts/customer-service/).

## Audited every year.

Deloitte and Amazon SP-API audits in 2026. PwC and Amazon SP-API in 2025. Shadow AI was involved in 43% of the breaches [IBM studied for its 2026 report](https://www.ibm.com/reports/data-breach); we keep your data out of it. And if something we run goes wrong, we own the fix.

[See the latest AI incidents](https://dataautomation.com/ai-security/) [See our audits](https://dataautomation.com/audits/)

## Bring us the complicated part.

[See what changed for our clients ->](https://dataautomation.com/case-studies/)

[Book a free call](https://meet.dataautomation.com/ai) [Describe your setup](https://dataautomation.com/#describe)
