Skip to content

Future Demand Report Documentation

Menu Location: Reports > Orders > Future Demand

Access Level: Manager and above

Last Updated: 2026-03-01

Overview

The Future Demand Report forecasts upcoming order volume and product demand based on active subscriptions, scheduled orders, and historical patterns. This critical planning tool helps with inventory purchasing, staffing, and capacity management.

Primary Functions:

  • Forecast order volume for upcoming weeks
  • Project product quantities needed
  • Plan inventory purchases
  • Schedule fulfillment staff
  • Identify capacity constraints
  • Anticipate revenue

Page Layout

Header Section

  • Report Title: "Future Demand Forecast"
  • Forecast Period Selector: Choose how many weeks ahead
  • Refresh Button: Recalculate forecast with latest data
  • Export Button: Download forecast data

Forecast Summary

  • Next Week Orders: Projected order count
  • Next 4 Weeks Total: Extended forecast
  • Peak Day: Highest volume delivery day
  • Total Revenue Forecast: Projected sales

Weekly Forecast Table

Week Starting Date Projected Orders Projected Revenue Change vs. Current Status
Next Week Mar 8 245 $18,350 +5% On Track
Week 2 Mar 15 238 $17,820 +2% On Track
Week 3 Mar 22 250 $18,750 +8% High Demand
Week 4 Mar 29 240 $18,000 +3% On Track

Product Demand Forecast

  • Top Products Needed: Quantities required by product
  • Category Breakdown: Demand by product category
  • Inventory Alerts: Products needing purchase orders

Understanding Forecast Data

How Forecast is Calculated

Data Sources:

  1. Active Subscriptions: Customers with recurring orders
  2. Scheduled Additions: Products scheduled for specific dates
  3. Historical Patterns: Average add-ons and customizations
  4. Seasonal Adjustments: Time-of-year demand changes
  5. Growth Trends: Account for subscriber growth rate

Calculation Example:

  • 200 active weekly subscriptions
  • 50 bi-weekly subscriptions (25 this week, 25 next)
  • 20 monthly subscriptions (5 per week average)
  • Base forecast: 230 orders
  • Historical pattern: +10% from one-time adds
  • Final forecast: 253 orders

Forecast Accuracy

Accuracy Levels:

  • Next Week: 90-95% accuracy
  • 2 Weeks Out: 85-90% accuracy
  • 3-4 Weeks Out: 75-85% accuracy
  • 5+ Weeks Out: 60-75% accuracy

Factors Affecting Accuracy:

  • Customer pause/cancel rates
  • Seasonal demand changes
  • Promotional campaigns
  • New customer acquisition
  • Economic factors

Forecast Period Options

Select Forecast Period

Quick Select:

  • Next Week: 1 week ahead
  • Next 4 Weeks: Standard planning horizon
  • Next 8 Weeks: Extended forecast
  • Next 12 Weeks: Quarterly planning
  • Custom: Specify exact date range

Week-by-Week Breakdown

Click on any week to expand:

  • Daily order breakdown
  • Delivery route distribution
  • Product category mix
  • Revenue projection by day
  • Staffing requirements

Product Demand Analysis

Projected Product Quantities

Product Forecast Table:

Product Next Week Qty 4-Week Total Current Stock Order Needed Priority
Organic Bananas 450 lbs 1,800 lbs 200 lbs 250 lbs High
Ground Beef 180 lbs 720 lbs 100 lbs 80 lbs Medium
Tomatoes 300 lbs 1,200 lbs 400 lbs 0 lbs Good

Inventory Planning

Purchase Order Suggestions:

  • System calculates needed inventory
  • Accounts for current stock levels
  • Considers lead times
  • Suggests order quantities
  • Flags critical shortages

Priority Levels:

  • Critical: Stock out imminent, order immediately
  • High: Order within 48 hours
  • Medium: Order this week
  • Low: Sufficient stock, monitor

Staffing Planning

Fulfillment Capacity

Projected Staff Needs:

Calculation:

  • Average 20 orders per staff per day
  • Next week: 245 orders ÷ 20 = 13 staff needed
  • Current team: 10 staff
  • Need: 3 additional staff or overtime

Report Shows:

  • Daily staffing requirements
  • Peak days needing extra help
  • Suggested shift schedules
  • Overtime projections

Common Use Cases

Use Case 1: Weekly Inventory Purchasing

Goal: Determine what to order from suppliers

Steps:

  1. Open Future Demand Report
  2. Select "Next Week" period
  3. Review Product Demand Forecast section
  4. Export product quantities to CSV
  5. Compare to current inventory levels
  6. Generate purchase orders for needed items
  7. Consider lead times (order 2-3 days early)
  8. Submit orders to suppliers

Result: Adequate inventory without over-ordering

Use Case 2: Staffing Next Week

Goal: Schedule fulfillment team for upcoming week

Steps:

  1. View Future Demand for next week
  2. Note projected order counts by day
  3. Review peak days (typically Wed-Fri)
  4. Calculate staff needed (orders ÷ 20 per staff)
  5. Compare to scheduled staff
  6. Adjust schedule or approve overtime
  7. Communicate schedule to team

Result: Properly staffed to meet demand

Use Case 3: Identify Capacity Issues

Goal: Determine if demand exceeds capacity

Steps:

  1. Review 4-week forecast
  2. Note any weeks with "High Demand" status
  3. Check if projected orders > current capacity
  4. Calculate gap: projected - capacity
  5. Determine solutions:
    • Hire temporary staff
    • Extend hours
    • Limit new subscriptions temporarily
  6. Implement capacity solution
  7. Monitor actual vs. forecast

Result: Proactive capacity management

Use Case 4: Revenue Forecasting

Goal: Project revenue for financial planning

Steps:

  1. Select 12-week forecast period
  2. Review weekly revenue projections
  3. Sum total projected revenue
  4. Compare to revenue goals
  5. Identify weeks below target
  6. Plan promotional campaigns for low weeks
  7. Adjust sales targets if needed

Result: Realistic revenue expectations

Use Case 5: Seasonal Preparation

Goal: Prepare for holiday season surge

Steps:

  1. In September, run 12-week forecast
  2. Covers through Thanksgiving/December
  3. Identify peak weeks (Thanksgiving week)
  4. Note projected demand increase (e.g., +40%)
  5. Plan 8 weeks ahead:
    • Hire seasonal staff
    • Increase inventory orders
    • Secure additional warehouse space
    • Coordinate with suppliers
  6. Monitor weekly, adjust as needed

Result: Smooth holiday season fulfillment

Adjusting Forecasts

Manual Adjustments

When to Adjust:

  • Planned promotional campaign
  • Expected subscriber growth
  • Known pause period (holidays)
  • Anticipated cancellations
  • New partnership launching

How to Adjust:

  1. Click "Adjust Forecast" button
  2. Select week to modify
  3. Enter adjustment percentage or fixed number
  4. Add note explaining adjustment
  5. Save modified forecast
  6. Adjusted forecast used for planning

Example:

  • Base forecast: 250 orders
  • Black Friday promo: +20% expected
  • Adjusted forecast: 300 orders

Troubleshooting

Forecast Seems Inaccurate

Check:

  1. When was forecast last refreshed?
  2. Has there been recent subscriber growth/churn?
  3. Are paused subscriptions accounted for?
  4. Seasonal adjustments enabled?

Solutions:

  1. Click "Refresh" to recalculate with latest data
  2. Verify active subscription counts
  3. Review pause/cancel rates
  4. Enable seasonal adjustment in Settings

Product Quantities Wrong

Check:

  1. Are all product subscriptions included?
  2. Scheduled additions counted?
  3. Recurring items factored in?
  4. Box contents up to date?

Solutions:

  1. Verify all subscription box default contents
  2. Check scheduled additions report
  3. Update recurring item lists
  4. Refresh forecast

Revenue Projection Doesn't Match

Check:

  1. Current pricing used?
  2. Discounts factored in?
  3. Cancelled subscriptions removed?
  4. Delivery fees included?

Solutions:

  1. Ensure latest pricing in system
  2. Account for active discount codes
  3. Remove cancelled accounts
  4. Include/exclude fees based on preference
  • Subscriptions Schedule Totals - Current subscription counts
  • Box Count Breakdown Over Time - Historical subscription trends
  • Bestselling Results - Product demand history
  • Inventory Management - Current stock levels
  • Weekly Open to Closed Comparison - Fulfillment capacity

Best Practices

Planning Workflow

  1. Review Monday morning - check upcoming week
  2. Order inventory Tuesday - based on forecast
  3. Schedule staff Wednesday - confirm headcount
  4. Monitor Friday - actual vs. forecast accuracy
  5. Adjust next week - learn from variances

Inventory Management

  1. Order 2-3 days ahead - account for supplier lead time
  2. Buffer stock 10-15% - cushion for forecast variance
  3. Track forecast accuracy - improve over time
  4. Communicate with suppliers - share forecasts
  5. Have backup suppliers - for critical items

Capacity Planning

  1. Set capacity limits - know maximum orders you can handle
  2. Alert at 90% capacity - proactively manage
  3. Plan 4 weeks ahead - hiring takes time
  4. Cross-train staff - flexible capacity
  5. Document peak staffing - repeat successful strategies

Quick Reference Card

Task Action/Location
View next week forecast Select "Next Week" period
Check product quantities needed Product Demand Forecast section
Calculate staff needed Projected Orders ÷ 20 per staff
Export for purchasing Export button > CSV
Adjust forecast Adjust Forecast button > Enter changes
View revenue projection Forecast Summary > Total Revenue
Check accuracy Compare actual to previous forecasts
Identify peak days Weekly breakdown > highest order days

FAQs

How accurate is the forecast?

Next week forecasts are typically 90-95% accurate. Accuracy decreases further out, to about 75-85% for 3-4 weeks ahead.

Can I adjust the forecast manually?

Yes, you can make manual adjustments for known events (promotions, holidays) that the system can't predict.

How often should I check this report?

Recommended: At least once per week (typically Monday) to plan the upcoming week. Daily during high-growth or volatile periods.

Does the forecast account for new signups?

The forecast is based on current subscriptions. Manual adjustment or growth trend settings can account for expected new signups.

What if actual orders are very different from forecast?

Investigate why: unexpected cancellations, promotional campaign, seasonal shift, or system calculation error. Adjust future forecasts accordingly.

Can I forecast by delivery route?

Yes, most systems allow filtering or expanding forecast by specific routes, useful for route-specific capacity planning.

How far ahead should I plan?

Inventory: 2-3 weeks minimum, Staffing: 4 weeks, Strategic planning: 8-12 weeks.

Does it account for customer pauses?

Yes, if customers have set pause/stop dates, these are typically factored into the forecast.

Can I forecast by product category?

Yes, the Product Demand Forecast can usually be filtered or grouped by category.

What if I'm growing rapidly?

Use manual adjustments to increase forecast by expected growth percentage, or configure growth trend settings if available.

Change Log

2026-03-01

  • Initial documentation created
  • All sections completed following template structure

End of Documentation

For additional help, contact your system administrator or Kiva Logic support.