Executive Commercial Summary

Current Fiscal Period Performance Overview

Ordered Pounds

1,245k

+12%
vs Budget +8%
vs Forecast -3%

Shipped Pounds

1,120k

+8%
vs Budget +5%
vs Forecast +2%

Produced Pounds

1,180k

-2%
vs Budget -4%
vs Forecast -1%

Finished Goods

320k

+15%
vs Budget +10%
vs Forecast +5%

Production Backlog

125k

-5%
vs Budget +2%
vs Forecast -3%

Margin %

22.5%

+1.2%
vs Prior Period +0.8%
vs Budget -0.5%

Median Days to Ship

3.2

+0.5
vs Prior Period +0.3
vs Budget -0.2

Performance vs Forecast & Budget

Financial Performance Breakdown

Inventory vs Order Backlog

Product Balance Watchlist (Next 5 Days)

Product FG Inventory Backlog Scheduled Prod Projected Shortfall
Premium 12,500 18,200 4,800 800
Custom 8,700 11,500 3,200 400

Order Lifecycle Analysis

Customer Order Pipeline Summary

Customer Open Shipped Invoiced Cancelled % Open
Acme Corp 25 18 15 2 42%
Beta LLC 12 22 18 1 23%

At-Risk Orders

Order # Customer Promise Date Days Late Status Pounds Branch
ORD-1001 Acme Corp 2023-06-05 3 Open 5,200 North
ORD-1002 Beta LLC 2023-06-03 5 Processing 8,400 South
ORD-1003 Gamma Inc 2023-05-30 9 Open 12,700 West
Date Orders (lbs) Shipped (lbs) Produced (lbs) Inventory (lbs) Sales ($) Margin (%)
2023-06-01 45,200 42,500 43,800 12,400 $125,400 22.5%