Inventory Forecasting Report

The Inventory Forecasting Report predicts upcoming shipment volumes by tracking subscription renewal items from their scheduled state through final fulfillment. While the Revenue Forecasting Report focuses on dollars, this report focuses on units — how many items need to be shipped, how many are likely to ship, and how accurate those predictions are. This is essential for warehouse planning, inventory procurement, and fulfillment capacity management.

What This Report Includes

This report tracks recurring subscription shipment items alongside new orders, providing both forecast projections and actual outcomes for shipment volume planning.

Shipment Items Included:

• All shipment items linked to scheduled shipments
• Includes items from recurring subscriptions, prepaid orders, and new orders
• Test orders are excluded
• Date range is based on Item Scheduled Date (when the shipment is scheduled to be fulfilled)

Why This Matters: Fulfillment operations need lead time. Knowing how many items will need to ship in the coming period — not just how many are scheduled — allows you to optimize inventory levels, staff warehouse shifts appropriately, and avoid both stockouts and excess inventory costs.

---

Report Metrics

Orders

The total count of orders associated with the shipment items in the selected period, providing a baseline for volume analysis.

Scheduled Recurring Items

The total count of all recurring and initial prepaid items scheduled to ship during the selected period. This is your top-of-funnel number — the sum of Pending, Cancelled, Skipped, Declined, and Queued items.

Pending Recurring Items

Count of scheduled recurring items that have not yet processed a charge, been skipped, or cancelled. These are awaiting their billing attempt.

Pending Recurring Item Rate

Percentage of scheduled recurring items still in pending state. This is calculated as Pending Recurring Items divided by Scheduled Recurring Items. Useful for gauging how far through the billing cycle you are.

Cancelled Recurring Items

Count of scheduled recurring items where the shipment was cancelled before the scheduled ship date.

Cancelled Recurring Item Rate

Percentage of scheduled items lost to cancellation. This is calculated as Cancelled Recurring Items divided by Scheduled Recurring Items.

Skipped Recurring Items

Count of scheduled recurring items where the customer or system skipped this cycle's shipment.

Skipped Recurring Item Rate

Percentage of scheduled items skipped. This is calculated as Skipped Recurring Items divided by Scheduled Recurring Items. Patterns here may indicate subscription frequency issues.

Declined Recurring Items

Count of scheduled recurring items where the transaction that would trigger the shipment was declined.

Declined Recurring Item Rate

Percentage of scheduled items lost to payment failure. This is calculated as Declined Recurring Items divided by Scheduled Recurring Items.

Queued Recurring Items

Count of recurring items that have been successfully charged and are ready to be shipped.

Queued Recurring Item Rate

Percentage of scheduled recurring items that have been successfully charged and are queued for fulfillment. This is calculated as Queued Recurring Items divided by Scheduled Recurring Items.

Queued Prepaid Items

Count of prepaid subscription items queued for shipment. These are from subscriptions paid in advance and ship on a set schedule regardless of billing cycle.

Forecasted Recurring Items

Projected total recurring items expected to reach fulfillment, based on scheduled items adjusted by historical performance data.

Pending Forecasted Recurring Items

Projected items from currently pending renewals, applying historical success rates to estimate how many pending items will convert to shipped.

Real Time Forecasted Recurring Items

A dynamically updated recurring forecast combining already-queued recurring items with predictions for still-pending renewals. This is calculated as Queued Recurring Items plus Pending Forecasted Recurring Items.

New Queued Items

Count of items from new orders (cycle 1) that were successfully charged and are ready to be shipped.

Total Queued Items

Combined count of all items ready to be shipped across recurring, prepaid, and new sources. This is calculated as Queued Recurring plus Queued Prepaid plus New Queued Items.

Real-Time Forecasted Items

The complete real-time forecast including queued, new, and remaining forecasted items — your best current estimate of total shipment volume. This is calculated as Total Queued Items plus Pending Forecasted Recurring Items. This becomes more accurate as the billing period progresses.

Item Shipped

Count of items that have actually been shipped.

Item Shipped Rate

Percentage of total queued items that have been shipped, indicating fulfillment progress. This is calculated as Item Shipped divided by Total Queued Items.

Total Shipments

Total count of completed shipments (a shipment may contain multiple items).

Forecast Accuracy

Measures how close the forecast was to actual shipped results, expressed as a percentage. This is calculated as Queued Recurring Items divided by Forecasted Recurring Items. Track this over time to understand the reliability of your inventory projections — accuracy improves as the system accumulates more historical data.

---

Available Dimensions

Use these dimensions to slice and filter your inventory forecasting data for deeper analysis.

Key Business Insights

1. Fulfillment Pipeline Visibility

Track the flow from Scheduled → Shipped to understand your shipment conversion funnel:

Scheduled Recurring Items:  5,000
  - Cancelled:              -400   (8%)
  - Skipped:                -150   (3%)
  - Declined:               -600   (12%)
  - Pending:                -250   (yet to be processed)
  = Queued Recurring:       3,600  (72%)
  + Prepaid:                +200
  + New:                    +500
  = Total Queued:           4,300
  → Shipped:                4,100  (95% of queued)

2. Inventory Planning Windows

Use the forecast at different points in the billing cycle:

• Start of period: Use Forecasted Items for procurement planning
• Mid-period: Use Real Time Forecasted Total for warehouse capacity adjustments
• End of period: Compare Forecast Accuracy to calibrate future planning

3. Fulfillment Capacity Planning

Track Total Queued Items trends to plan warehouse staffing:

• Monday–Friday queuing patterns help plan daily shift needs
• Monthly variation helps plan seasonal staffing
• Growth trends inform long-term warehouse capacity decisions

4. Source Mix Analysis

Break down total shipment volume by source to understand demand drivers:

• Queued Recurring Items → Predictable base volume from existing subscribers
• Queued Prepaid Items → Pre-committed volume that ships regardless of billing
• Queued New Items → Growth-driven volume tied to acquisition performance

---

Optimization Strategies

Optimize Inventory Levels

• Use forecasted items as the basis for reorder points, adding safety stock for forecast error margin
• Reduce excess inventory when forecasts consistently overshoot
• Increase safety stock for high-variance periods (seasonal peaks, promotional launches)

Reduce Fulfillment Friction

• Minimize the gap between Queued and Shipped by streamlining warehouse operations
• Track the Shipped Items Rate to identify fulfillment bottlenecks
• Correlate low ship rates with specific products or fulfillment centers

---

Pro Tips

1. Pair with Revenue Forecasting: This report tells you how many items ship; the Revenue Forecasting Report tells you the associated dollar value. Together, they give a complete operational and financial forecast
2. Prepaid Timing: Prepaid items follow their own shipment schedule independent of billing cycles. Watch Queued Prepaid Items to track this separate fulfillment stream
3. Shipped vs. Queued: A gap between Total Queued and Shipped Items usually indicates fulfillment processing time, backorders, or warehouse delays — not necessarily a problem, but worth monitoring if it grows
4. Rate Metrics: The rate columns (Cancelled Rate, Declined Rate, etc.) are useful for setting benchmarks and alerts — if any rate moves outside normal ranges, investigate immediately

---

Frequently Asked Questions

Q: What's the difference between items and shipments?

A: Items are individual line items (products) within an order. A shipment is a physical package that may contain multiple items. Total Shipments counts packages; other metrics count individual items within those packages.

Q: How is the forecast calculated?

A: Similar to the Revenue Forecasting Report, the system applies historical renewal success rates to scheduled items. The real-time forecast blends actual processed results with predictions for remaining pending items.

Q: Does this include one-time (non-subscription) orders?

A: The recurring metrics (Scheduled, Cancelled, Declined, etc.) are subscription-specific. New items from subscription orders are included. One-time non-recurring orders are not part of this report.

Q: Why might Queued Prepaid Items not follow the same pattern as Queued Recurring Items?

A: Prepaid subscriptions are paid in advance for multiple cycles, so their shipment timing is on a fixed schedule rather than tied to individual billing attempts. They don't go through the same pending/declined lifecycle as recurring renewals.