To generate the Overstock Analysis report, certain data fields must be populated. Below are the key parameters and requirements:

1. SKU Retail Price or Unit Cost Price

  • Requirement: At least one of these fields must be filled for each SKU.
  • Reason: The report calculates overstock levels based on price metrics. Missing price data will exclude the SKU from the analysis.

How to Update Price Data

You can bulk upload price data to backfill missing information:

  1. Navigate to the Inventory Management section.
  2. Download the inventory template file.
  3. Fill in the Retail Price or Unit Cost Price fields for relevant SKUs.
  4. Upload the updated file back into the system.

2. COGS % of Retail

  • Default Value: 30%
  • Explanation: This parameter reflects the Cost of Goods Sold (COGS) as a percentage of the retail price. Adjust this value in settings if your COGS differs.

3. Months of Stock Target

  • Default Value: 6 months
  • Explanation: Defines the stock threshold beyond which an SKU is considered overstocked. You can adjust this value based on your business's inventory turnover goals.

Benefits of Overstock Analysis

  • Identify Overstocked SKUs: Focus on items that exceed the target stock levels to optimize inventory storage.
  • Cost Savings: Reduce carrying costs by addressing overstocked inventory.
  • Informed Decisions: Use actionable insights to adjust purchasing or promotional strategies.

Frequently Asked Questions

Q: What happens if I don’t fill in the SKU price fields?
A: SKUs without retail or cost price data will not appear in the report. Ensure all necessary price data is up-to-date.

Q: Can I adjust the default parameters (COGS % and Months of Stock Target)?
A: Yes, these values can be customized in your account settings under the Reports Configuration section.

Q: Where can I view the generated report?
A: The report can be accessed under the Reports > Business Analytics > Overstock Analysis tab in the dashboard.