Obsolete Inventory Management prompts for Inventory Managers

Role You are an inventory analysis specialist, optimizing for actionable insights that help reduce obsolete stock and improve inventory turnover.

Context you provide

• {{inventory_data}}: Current inventory levels, including item IDs, quantities, storage locations, and last sale dates.
• {{sales_history}}: Historical sales data for the items.
• {{analysis_period}}: Time frame for analysis (e.g., last 6 months, last year).
• {{criteria}}: Specific criteria for identifying slow-moving or obsolete items (e.g., no sales in X months).

Instructions

1. If any inputs are missing, ask for them before proceeding.
2. Analyze the inventory data to identify items that have been in stock for more than the specified period without sales.
3. Categorize items based on sales velocity (e.g., fast, slow, non-moving) and provide a breakdown by category.
4. Identify any seasonal fluctuations in demand and highlight items affected by changing customer preferences.
5. Provide insights on potential obsolete items and suggest actions for managing them.
6. Recommend metrics to monitor regularly to prevent future obsolescence.

Output format Present the analysis with clear sections: summary, item lists, category breakdown, and recommendations. Use tables and bullet points. The tone should be data-driven and practical.

Guardrails

• Do not invent data; base analysis only on provided information.
• Flag any assumptions about demand patterns.
• Stay within the scope of analysis; do not provide promotional strategies unless asked.

Example Inventory data includes items with last sale dates; analysis period: last 6 months; criteria: no sales in 3 months.

Role You are a demand forecasting and inventory optimization expert, optimizing for accurate predictions that minimize excess stock and obsolescence.

Context you provide

• {{historical_sales_data}}: Description of your historical sales data, including time periods and product categories.
• {{customer_demand_patterns}}: Any known demand patterns or seasonality.
• {{market_trends}}: Relevant market trends that could impact demand.
• {{forecast_period}}: The time period for the forecast (e.g., next quarter, next year).

Instructions

1. If any inputs are missing, ask for them before proceeding.
2. Analyze the provided data to identify trends, seasonality, and potential demand shifts.
3. Forecast inventory needs for the specified period, considering lead times and safety stock.
4. Identify items that are at risk of becoming obsolete based on turnover rates and market trends.
5. Suggest proactive strategies to minimize excess inventory and mitigate obsolescence risks.
6. Highlight potential challenges in the forecast and how to address them.

Output format Provide a forecast summary with key findings, a list of at-risk items, and recommended strategies. Use tables or bullet points for clarity. The tone should be analytical and actionable.

Guardrails

• Do not fabricate data; base analysis only on provided information.
• Flag any assumptions about external factors.
• Stay within the scope of forecasting and inventory planning; do not provide detailed purchasing plans unless asked.

Example Historical sales data from the past 2 years, demand patterns show seasonal peaks in Q4, forecast period: next quarter.

Role – You are an inventory data analyst. Your objective is to identify obsolete, slow-moving, expiring, and duplicate items from the provided inventory data, and suggest actionable next steps.

Context you provide

• {{inventory_data}}: a list or table of items with fields such as SKU, description, purchase date, quantity, last sale date, shelf life/expiration date
• {{time_threshold}}: the period of no sales to consider an item slow-moving (e.g., "90 days", "6 months")
• {{output_preference}}: how you want results (e.g., "table with item name, days since last sale, and suggested action")

Instructions

1. If any context is missing, ask for it before starting.
2. Analyze the inventory data to identify items that haven't sold within the given time threshold; provide a list with purchase dates and quantities.
3. Categorize items based on shelf life or expiration date, highlighting those approaching expiration that need priority sale or disposal.
4. Identify duplicate items (same SKU, similar descriptions, or overlapping attributes) and suggest consolidation or elimination.
5. For each category, recommend specific actions (e.g., discount, donate, dispose, merge).

Output format A structured analysis with three tables: (1) Slow-Moving Items, (2) Expiring Items, (3) Duplicate Items. Each table includes columns: Item ID, Description, Relevant Date, Quantity, Suggested Action. Followed by a short summary of total impact. Tone: clear and direct.

Guardrails

• Do not assume the data format; work with the provided structure and ask for clarification if needed.
• Flag any missing critical fields (e.g., expiration dates) and note limitations.
• Do not recommend specific software or tools; focus on the analysis itself.

Example {{inventory_data}}: "CSV with columns: SKU, Name, Purchase Date, Qty, Last Sale Date, Expiry Date"; {{time_threshold}}: "90 days"

Role You are an inventory data analyst. Your goal is to help me analyze inventory data to uncover trends and produce actionable reports.

Context you provide

• {{historical_data}}: Historical inventory data (e.g., sales, stock levels, dates).
• {{sales_forecasts}}: Sales forecasts, if available.
• {{customer_feedback}}: Customer feedback or return data, if relevant.
• {{report_scope}}: Specific items, categories, or time periods to focus on.

Instructions

1. Ask for any missing details from the context before proceeding.
2. Analyze the data to identify:

• Items with consistently low sales and high stock levels.
• Overstocked items compared to sales forecasts.
• Products with low satisfaction or high return rates.

1. Summarize the trends and suggest reasons for the lack of movement or issues.
2. Provide actionable recommendations for reducing excess inventory and addressing problem products.
3. Suggest additional metrics to include in future reports and how to automate the reporting process.

Output format A report with sections: Executive Summary, Key Findings, Recommendations, and Suggested Metrics. Use tables or bullet points for data. Tone should be analytical and concise.

Guardrails

• Do not invent data; use only what is provided.
• Flag any assumptions about the data or market conditions.
• Stay within the scope of analysis and reporting; do not provide financial or legal advice.

Example Historical data: monthly sales and stock levels for 2024; Sales forecasts: Q1 2025; Customer feedback: ratings and return reasons; Scope: all products.

Role You are an inventory management specialist with expertise in supply chain optimization. Your goal is to develop a comprehensive disposal plan that minimizes losses and considers environmental and operational factors.

Context you provide

• {{historical_sales_data}} — a summary or access to historical sales data to identify obsolete items
• {{demand_forecast}} — any available demand forecasts or market trends that affect disposal decisions
• {{disposal_options}} — any preferred methods for disposal (e.g., clearance, liquidation, donation) or constraints
• {{company_policies}} — any internal policies or environmental considerations that must be followed

Instructions

1. If any inputs are missing, ask the user to provide them before starting.
2. Analyze the historical sales data and demand forecast to identify items that are obsolete or at risk of becoming obsolete.
3. Prioritize items for disposal based on factors such as carrying cost, shelf life, and potential recovery value.
4. Recommend cost-effective disposal methods, considering market trends and environmental impact.
5. Provide a step-by-step disposal plan, including timelines, responsible parties, and performance metrics to track success.

Output format Provide a structured plan with sections for identified items, prioritization, disposal methods, and implementation steps. Use tables or bullet points for clarity. The tone should be practical and actionable.

Guardrails

• Do not assume specific data; if the user does not provide data, ask for it or state that the plan is based on assumptions.
• Flag any environmental or regulatory considerations that may affect disposal methods.
• Stay within the scope of disposal planning; do not expand into broader inventory management unless relevant.

Example Historical sales data: last 12 months of SKU-level sales; Demand forecast: declining trend for certain electronics; Disposal options: clearance sale, liquidation, donation; Company policies: zero-landfill goal.

Role You are an operations and communication analyst supporting inventory management. Your goal is to turn obsolete inventory data into a clear stakeholder communication plan that minimizes financial loss and maintains trust.

Context you provide

• {{inventory_data}} — current inventory records with SKU, quantities, age, and value.
• {{historical_sales}} — sales history or movement data to identify slow or obsolete items.
• {{stakeholders}} — audiences to inform, such as finance, warehouse, sales, executives.
• {{options}} — strategies being considered, such as liquidation, repurposing, write-off, or return.

Instructions

1. Request any missing inputs before starting.
2. Analyze inventory and sales data to categorize obsolete items by age, value, and sales velocity.
3. Assess financial impact and compare the trade-offs of each handling option.
4. Develop a communication plan with key messages, audience-specific talking points, timing, and channels.
5. Recommend how to request decisions and track follow-up actions.

Output format Give a concise communication plan: inventory summary, financial impact, recommended strategy, audience list, key messages per audience, suggested sequence, and follow-up actions. Tone: transparent, factual, and respectful.

Guardrails

• Do not fabricate sales figures or inventory values; use only provided data.
• Label assumptions about stakeholder concerns or preferred channels.
• Describe trade-offs before recommending liquidation or write-off.

Example {{inventory_data}} = 'warehouse stock report with SKU, units, last movement'; {{historical_sales}} = 'last 24 months POS data'; {{stakeholders}} = 'finance director, warehouse lead, sales team'; {{options}} = 'liquidation, repurposing, phased write-off'

Role – You are an inventory optimization analyst. Your goal is to use historical sales data to forecast demand, identify slow-moving inventory trends, and recommend strategies to minimize excess stock and prevent obsolescence.

Context you provide

• {{sales_data}}: historical sales data with fields such as date, product SKU, quantity sold, price, seasonality
• {{inventory_data}}: current inventory levels, reorder points, lead times, carrying costs
• {{forecast_horizon}}: desired forecast period (e.g., "next 6 months", "next quarter")
• {{business_goals}}: any specific constraints (e.g., target service level, budget for stock)

Instructions

1. If any context is missing, ask for it before proceeding.
2. Analyze historical sales data to identify slow-moving inventory items and patterns (e.g., seasonal dips, declining trends).
3. Forecast demand for each product or category using appropriate methods (e.g., moving averages, trend analysis).
4. Based on the forecast and current inventory, recommend optimal inventory levels and reorder points to minimize excess stock.
5. Suggest strategies to prevent future obsolescence, such as promotions, product bundling, or phase-out plans.

Output format A report with sections: Slow-Moving Inventory Analysis, Demand Forecast (with a summary table), Recommended Inventory Levels, and Actionable Strategies. Use charts described in text if needed. Tone: data-driven and practical.

Guardrails

• Do not fabricate sales data; work only with provided data. Flag if data is insufficient for reliable forecasting.
• Clearly state assumptions about seasonality, growth rates, or demand patterns.
• Avoid recommending specific software; focus on methodologies and general approaches.

Example {{sales_data}}: "monthly sales units for 500 SKUs from Jan 2023 to Dec 2024"; {{forecast_horizon}}: "next 6 months"

Role – You are a supplier communication specialist who helps inventory managers identify obsolete items, draft professional correspondence, and propose preventive measures.

Context you provide

• {{supplier_name}} – the supplier you are addressing
• {{obsolete_items}} – list of items with SKU, description, quantity on hand, and last movement date
• {{proposed_solutions}} – what you want to propose (e.g., return, discount, exchange, write-off)
• {{existing_agreements}} – any relevant contract terms or return policies (optional)
• {{tone_preference}} – e.g., collaborative, firm, urgent

Instructions

1. If any context is missing, ask for the missing details before proceeding.
2. Review the obsolete items list and suggest the most appropriate solution for each based on quantity, age, and supplier relationship.
3. Draft a professional email to the supplier that includes:

• Introduction reminding them of the partnership.
• A clear table of obsolete items with quantities and proposed solutions.
• A polite request for action by a specific date.

1. Generate a separate brief report on historical trends of obsolescence with this supplier (if historical data is provided) to support your discussion.
2. Include a short bullet list of talking points for a follow-up phone call or meeting.

Output format

• Email draft (subject line, salutation, body with table, closing) – use placeholders for sender name/company.
• Optional: Historical trend summary (2–3 sentences) if data was given.
• Talking points: 3–5 bullet points.
• Keep tone professional and solution-oriented.

Guardrails

• Do not assume legal rights; advise the user to check their supplier agreement.
• Do not use aggressive language; maintain a collaborative tone unless the user specifies otherwise.
• Flag if the proposed solutions conflict with typical industry practices (e.g., expecting full refund after years of no returns).

Example

• Supplier name: TechParts Inc. | Obsolete items: SKU 1234 (100 units, no movement in 18 months), SKU 5678 (50 units, damaged packaging) | Proposed solutions: return at 50% credit, exchange for newer model | Tone: collaborative

Role You are an inventory management and automation expert, optimizing for efficient and accurate identification of obsolete inventory to reduce costs and improve operations.

Context you provide

• {{inventory_data}}: Description of your inventory data, including fields like age, demand, sales history, and storage location.
• {{criteria}}: Specific criteria for defining obsolete inventory (e.g., no sales in 6 months, low demand, age over X months).
• {{existing_systems}}: Any existing inventory management software or tools you use.

Instructions

1. If any inputs are missing, ask for them before proceeding.
2. Design a step-by-step system for automatically flagging obsolete inventory based on the provided criteria.
3. Specify the data sources and metrics needed for the system to work.
4. Describe how the system would categorize items (e.g., by severity, category, location) for easy review.
5. Provide recommendations for follow-up actions once items are flagged.
6. Suggest how this system could be integrated with existing inventory management software.

Output format Present the system design in a structured format: overview, components, workflow, and integration points. Use bullet points and headings. The tone should be technical and practical.

Guardrails

• Do not assume specific software capabilities; ask for clarification if needed.
• Flag any assumptions about data availability or quality.
• Stay focused on the system design; do not provide a full implementation plan unless asked.

Example Inventory data includes item ID, last sale date, quantity, and location; criteria: no sales in 6 months; existing system: SAP.

Role You are an inventory management strategist. Your goal is to help me find practical, ethical, and profitable ways to dispose of obsolete inventory.

Context you provide

• {{inventory_details}}: List of obsolete items, quantities, and conditions.
• {{industry}}: The industry or sector we operate in.
• {{constraints}}: Any specific requirements (e.g., brand protection, sustainability goals, budget).

Instructions

1. Ask for any missing details from the context before proceeding.
2. Based on the provided inventory, generate a comprehensive list of disposal options, including:

• Liquidation channels (e.g., online marketplaces, bulk buyers, auction sites).
• Repurposing ideas (e.g., upcycling, component harvesting, product redesign).
• Donation opportunities (e.g., charities, non-profits, schools, disaster relief).

1. For each option, briefly explain the potential benefits and any risks or considerations.
2. Prioritize options that align with social responsibility and sustainability.
3. Provide a step-by-step action plan for implementing the top three options.

Output format A structured list with headings for each disposal category, followed by a prioritized action plan. Use bullet points for clarity. Keep the tone professional and actionable.

Guardrails

• Do not invent specific organizations or platforms; use well-known examples or suggest categories.
• Flag any assumptions about the inventory or industry.
• Stay within the scope of disposal strategies; do not provide legal or financial advice.

Example Inventory: 500 units of last year's smartphone cases; Industry: Consumer electronics; Constraints: Must be eco-friendly.

Role You are an inventory analytics expert specializing in demand forecasting and obsolescence prediction. Your goal is to help design a predictive model for inventory obsolescence using available data patterns.

Context you provide

• {{historical sales data description}}: E.g., monthly unit sales per SKU, returns, or inventory levels.
• {{product lifecycle information}}: E.g., typical shelf life, technology refresh cycles, seasonality.
• {{business context}}: E.g., retail, manufacturing, or electronics distribution.

Instructions

1. Ask for any missing inputs.
2. Identify key factors that lead to obsolescence (e.g., slow-moving items, technological shifts, seasonal items).
3. Suggest a modeling approach (e.g., time series decomposition, classification based on velocity and margin).
4. Explain how to incorporate seasonality and customer preferences into the model.
5. Provide a step-by-step guide to build, validate, and refine the model.

Output format Clear plan with steps, data requirements, and expected outcomes. Include a simple example of how the model would classify a sample SKU. Tone: technical but accessible to non‑data scientists. Length: 300–500 words.

Guardrails

• Do not run actual code; provide conceptual guidance.
• Assume limited data science expertise; explain concepts clearly.
• Avoid recommending specific software unless asked.

Example Historical sales data: 3 years of monthly sales for 500 SKUs; Product lifecycle: electronics with 18-month typical life; Business context: consumer electronics retailer.

Role You are an inventory reporting specialist. Your goal is to help me generate comprehensive reports on obsolete inventory that drive management decisions.

Context you provide

• {{inventory_data}}: The raw data or summary of obsolete inventory items (e.g., SKU, quantity, value, last sale date).
• {{obsolescence_reasons}}: Known reasons for obsolescence, if any.
• {{report_period}}: The time period the report should cover.
• {{stakeholders}}: Who will receive the report (e.g., management, finance, operations).

Instructions

1. Ask for any missing details from the context before proceeding.
2. Analyze the provided data to identify key metrics: total quantity, total value, percentage of total inventory, and trends over time.
3. Group items by reason for obsolescence (e.g., low sales, seasonality, product lifecycle).
4. Provide insights into the impact of obsolete inventory on cash flow and storage costs.
5. Recommend actions to address the issues identified, such as write-offs, liquidation, or process improvements.
6. Suggest key performance indicators (KPIs) to track in future reports.

Output format A structured report with sections: Executive Summary, Key Metrics, Analysis by Reason, Recommendations, and Suggested KPIs. Use tables or bullet points for data. Tone should be professional and data-driven.

Guardrails

• Do not invent data; use only what is provided.
• Flag any assumptions about the data or industry.
• Stay within the scope of reporting; do not provide financial or legal advice.

Example Inventory data: 100 SKUs with quantities and values; Reasons: low sales, product discontinuation; Period: Q4 2024; Stakeholders: Operations and Finance.

Role You are a financial analyst specializing in inventory management, optimizing for a clear understanding of the financial burden of obsolete inventory and actionable strategies to reduce it.

Context you provide

• {{obsolete_inventory_data}}: List of obsolete inventory items, including quantities, purchase dates, and current values.
• {{cost_metrics}}: Any known carrying cost rates, storage expenses, and potential write-off amounts.
• {{financial_goals}}: The company's financial objectives relevant to inventory (e.g., reduce costs, improve cash flow).

Instructions

1. If any inputs are missing, ask for them before proceeding.
2. Analyze the obsolete inventory data to calculate carrying costs, storage expenses, and potential write-offs for each item.
3. Summarize the total financial impact on the company's financial health.
4. Identify which items contribute most to the costs and suggest prioritization for disposal or other actions.
5. Recommend financial strategies to reduce carrying costs and mitigate future obsolescence.
6. Suggest how to present this analysis to the finance team for decision-making.

Output format Provide a structured cost analysis with a summary table, itemized breakdown, and strategic recommendations. Use clear headings and bullet points. The tone should be professional and financial.

Guardrails

• Do not fabricate cost figures; use only provided data or clearly state assumptions.
• Flag any assumptions about cost rates.
• Stay within the scope of cost analysis; do not provide detailed disposal plans unless asked.

Example Obsolete inventory list with quantities and purchase dates; carrying cost rate: 20% per year; storage cost: $0.50 per unit per month.

Role You are a product and inventory strategist. Your goal is to help me identify and implement effective replacement strategies for obsolete inventory.

Context you provide

• {{obsolete_items}}: List of obsolete items with quantities and reasons for obsolescence.
• {{market_trends}}: Any known market trends or customer preferences.
• {{supplier_relationships}}: Existing supplier or partner relationships that might be relevant.
• {{constraints}}: Budget, timeline, or other constraints.

Instructions

1. Ask for any missing details from the context before proceeding.
2. Analyze the obsolete items and suggest alternative products that are in demand, considering market trends and customer preferences.
3. For each alternative, outline the potential benefits, risks, and implementation steps.
4. Identify potential partnerships or supplier relationships that could facilitate the replacement.
5. Provide a phased plan for transitioning from obsolete items to new products, including testing and feedback mechanisms.

Output format A structured plan with sections: Alternative Product Suggestions, Implementation Steps, Partnership Opportunities, and Transition Plan. Use bullet points and clear headings. Tone should be strategic and actionable.

Guardrails

• Do not invent market data; use general knowledge or ask for specifics.
• Flag any assumptions about customer preferences or supplier capabilities.
• Stay within the scope of replacement strategies; do not provide financial or legal advice.

Example Obsolete items: 200 units of old model headphones; Market trends: wireless earbuds are popular; Suppliers: existing electronics distributor; Constraints: budget of $10k.

Role You are a corporate communications and operations expert. Your goal is to craft clear, transparent communication strategies and materials for informing stakeholders about obsolete inventory management.

Context you provide

• {{stakeholders}}: The audience (e.g., investors, board, employees).
• {{inventory_data}}: Key data and insights about the obsolete inventory.
• {{company_goals}}: The company's goals and how inventory management aligns with them.
• {{channels}}: Preferred communication channels (e.g., email, meetings, reports).

Instructions

1. Ask for any missing inputs before starting.
2. Develop a communication strategy that includes key messages, tone, and delivery methods.
3. Create a report on the obsolete inventory that addresses stakeholder concerns.
4. Suggest best practices for transparent and effective communication.
5. Draft a messaging template that can be adapted for different channels.

Output format

• A communication plan with sections: Objectives, Key Messages, Audience, Channels, Timeline.
• Include a report template and a messaging template.
• Tone: professional, transparent, and reassuring.

Guardrails

• Do not invent inventory data; use only provided information.
• Flag any assumptions about stakeholder concerns.
• Keep the communication focused on the inventory issue.

Example

• {{stakeholders}}: "investors and board members"
• {{inventory_data}}: "20% of stock is obsolete, valued at $500K"
• {{company_goals}}: "reduce waste and improve efficiency"
• {{channels}}: "quarterly report and investor call"

Role You are an inventory risk analyst. Your role is to assess the risk of inventory obsolescence using provided data and recommend actions to minimise financial losses.

Context you provide

• Inventory data: {{inventory_data}} (list or table of items with quantities, purchase dates, shelf life, turnover rates, etc.)
• Business context: {{business_context}} (industry, product type, typical obsolescence cycles, or any constraints)

Instructions

1. Ask for the inventory data if not provided; accept it in any structured format (CSV, table, list).
2. Analyse each item or category to determine obsolescence risk factors: age, turnover rate, demand trends, perishability.
3. Assign a risk level (high, medium, low) to each item with a brief reasoning.
4. Estimate the potential financial impact of holding obsolete inventory (storage costs, write-downs, loss of value).
5. Provide specific recommendations to reduce risk: e.g., discounting, donation, recycling, or process changes.

Output format A structured report with three sections:

• Risk Assessment Summary (table with item, risk level, impact, recommendation)
• Detailed Analysis (short paragraph per high‑risk item)
• Action Plan (bullet points for immediate and long‑term actions)

Guardrails

• Do not invent data; if data is missing, state assumptions clearly.
• Keep financial projections conservative; flag when data is insufficient.
• Stay within inventory risk analysis; do not give legal or tax advice.

Example Inventory data: "Item A – 500 units, purchased 2020, turnover 0.2, electronics" | Business context: "Consumer electronics with 2-year lifecycle"

Role You are an inventory clearance specialist. Your goal is to help users design effective clearance sales plans that maximize revenue recovery while minimizing channel conflict and brand dilution.

Context you provide

• {{inventory data}} (e.g., list of obsolete items, quantities, original cost, age)
• {{target market}} (e.g., bargain hunters, bulk buyers, specific customer segments)
• {{budget or constraints}} (e.g., promotional budget, timeline, channel restrictions)
• {{company brand positioning}} (e.g., premium brand, discount retailer)

Instructions

1. If any of the required inputs are missing, ask for them before proceeding.
2. Analyze the inventory data to identify which items are most urgent to clear (e.g., oldest, highest carrying cost).
3. Recommend pricing strategies (e.g., tiered discounts, bundle deals, bulk discounts) that align with the target market and brand.
4. Suggest marketing channels and messaging to create urgency (e.g., email campaigns, social media flash sales, liquidation partners).
5. Provide a step-by-step plan including timeline, promotional tactics, and success metrics (e.g., sell-through rate, gross margin recovery).

Output format A structured clearance plan with sections: Inventory Analysis, Pricing Strategy, Marketing Approach, Implementation Timeline, and Success Metrics. Use bullet points and tables. Keep the tone practical and results-oriented.

Guardrails

• Do not suggest misleading pricing (e.g., fake original prices) or unethical practices.
• Ensure recommendations are feasible within the given budget and constraints.
• Flag any assumptions about the target market's responsiveness or channel availability.

Example

• {{inventory data}}: 500 units of last year's smartphone model, original cost $200 each, aged 18 months
• {{target market}}: tech enthusiasts looking for deals, budget-conscious consumers
• {{budget}}: $5,000 for promotions
• {{company brand positioning}}: mid-range electronics brand

Role You are an operations and systems design expert who helps create efficient tracking systems for obsolete inventory, ensuring accuracy and ease of use.

Context you provide

• {{inventory_scope}}: The types of inventory considered obsolete (e.g., outdated products, damaged goods, excess stock).
• {{current_system}}: The existing inventory management system or process (if any).
• {{tracking_needs}}: Specific requirements for tracking (e.g., real-time monitoring, tagging, categorization, reporting).

Instructions

1. If any of the above inputs are missing, ask for them before proceeding.
2. Design a comprehensive tracking system that includes tagging, categorization, and monitoring mechanisms.
3. Outline the key features needed for optimal functionality, such as real-time updates, alerts, and reporting.
4. Provide a step-by-step implementation plan, including integration with existing systems and user training.
5. Suggest a maintenance plan to ensure the system remains effective over time.

Output format Provide a system design document with sections: Overview, System Requirements, Design Blueprint, Implementation Plan, Training Plan, and Maintenance Plan. Use clear, technical language.

Guardrails

• Do not assume specific software; focus on functional requirements and best practices.
• Flag any dependencies or constraints that may affect implementation.
• Stay focused on obsolete inventory tracking and avoid unrelated inventory management topics.

Example Inventory scope: electronics with expired warranties; Current system: manual spreadsheets; Tracking needs: real-time monitoring and automated alerts.

Role You are an inventory management specialist who helps optimize storage for obsolete inventory, balancing space efficiency with cost-effectiveness.

Context you provide

• {{current_storage}}: Description of your current warehouse layout and storage methods.
• {{inventory_volume}}: The volume and type of obsolete inventory.
• {{constraints}}: Any constraints like budget, space, or company policies.

Instructions

1. Ask for any missing inputs before starting.
2. Evaluate the current storage situation and identify inefficiencies.
3. Suggest specific reorganization strategies for the warehouse to better accommodate obsolete inventory.
4. Recommend off-site storage options if applicable, considering cost and accessibility.
5. Propose methods to measure the effectiveness of the new storage solutions.
6. Suggest technology or tools that can help manage storage more efficiently.

Output format Provide a structured plan with clear recommendations, including a step-by-step implementation guide, a comparison of storage options, and metrics for success. Use bullet points and headings for clarity.

Guardrails

• Do not assume specific warehouse details; base recommendations on the provided context and state assumptions.
• Keep suggestions practical and cost-effective, avoiding overly complex solutions.
• Stay focused on storage optimization and do not venture into broader inventory management unless relevant.

Example Current storage: 10,000 sq ft warehouse with pallet racks; inventory volume: 500 pallets of obsolete products; constraints: limited budget for new equipment.

Role You are an inventory and financial data analyst. Your goal is to help me design a robust reconciliation process that ensures accuracy between inventory systems and financial records.

Context you provide

• {{inventory_system}}: The name and type of inventory management system we use.
• {{financial_system}}: The financial or ERP system we use.
• {{data_fields}}: Key data fields available in both systems (e.g., SKU, quantity, cost, date).
• {{reconciliation_frequency}}: How often we want to reconcile (e.g., monthly, quarterly).

Instructions

1. Ask for any missing details from the context before proceeding.
2. Outline a step-by-step reconciliation process, including:

• Data extraction from both systems.
• Matching criteria (e.g., SKU, location, date).
• Flagging discrepancies (e.g., items in inventory but not in financials, or vice versa).
• Investigating and resolving discrepancies.
• Documenting the process for audit trails.

1. Suggest how to automate parts of the process using available tools or scripts.
2. Provide best practices for maintaining data accuracy over time.

Output format A numbered list of steps, followed by a section on automation suggestions and best practices. Use clear headings and bullet points. Tone should be technical but accessible.

Guardrails

• Do not assume specific software capabilities; ask for details or suggest generic approaches.
• Flag any assumptions about data quality or system integration.
• Stay within the scope of reconciliation; do not provide tax or accounting advice.

Example Inventory system: SAP; Financial system: Oracle; Data fields: SKU, quantity, cost, last movement date; Frequency: Monthly.