Cross-Season KPIs
Always-on metrics · Cengage / Salesforce / Verbal
Out-of-Stock ISBNs (SIP)SIP = Short in Pool. An ISBN enters the SIP when Cengage cannot pick enough units to fill all open customer orders. True SIP = unplanned out-of-stocks with no reprint scheduled — the most critical category for leadership.
Owner: Mallory · Source: SIP 6.5.26.xlsx
Exec View:
31ISBNs short
↓9.3K QSIP units vs. yesterday (13.3K) · ISBNs flat at 31
3% of orders short · 3,087 orders in pool · True SIP: 0 / 0 ✓
| Summary | Today (6/5) | Yesterday (6/4) |
|---|---|---|
| All SIP ISBNs | 31 | 31 |
| QSIP Units | 4.0K | 13.3K |
| True SIPUnplanned out-of-stocks with no reprint scheduled — the most important gap for leadership. ISBNs | 0 ✓ | 0 ✓ |
| True SIP Units | 0 ✓ | 0 ✓ |
OMT Open Cases / Orders on HoldOMT = Order Management Team. Open cases represent customer orders requiring attention before they can be processed and shipped. Cases in "Sales Response Needed" are blocked until a sales rep responds.
Owner: Mike Gomes · Source: OMT Cases THIS WEEK_Claude-2026-06-05 · Meeting Notes
Exec View:
121open cases
↓16 vs. earlier today (137) · $8.6M total value
121 open cases / $8.6M (per Mike Gomes, today's call) · 6 large cases (≥$100K) this week: $1.29M
| Status | Cases | Amount |
|---|---|---|
| Sales Response Needed | 3 large | $691.9K |
| Sales Support Response Needed | 3 large | $594.8K |
| Customer Response Needed | 28 | $1.08M |
| In-Progress | 20 | $448K |
| Assigned | 9 | $373K |
| Revision Requested | 4 | $372K |
| Sales Tax Exempt Cert. | 2 | $7K |
| New | 2 | $7K |
| DNS / Vendor / Content | 12 | $619K |
| Total | 121 | $8.6M |
Warehousing & ShippingDaily Cengage warehouse and transportation metrics. Units Shipped = units physically shipped from Cengage today. Orders in LogPro = orders released to Cengage for fulfillment. OTIF = On-Time In-Full (carrier performance). Owners: David Blair (Warehousing), David Brown (Transportation).
Owners: David Blair / David Brown · Source: Executive_Weekly_Scorecard_Template 6.5.26
Exec View:
576,133units shipped today
↑182,220 vs. yesterday (393,913)
245 in process · 3,087 in LogPro · OTIF 82% ⚠ · Cost/lb $0.15
| Metric | Today (6/5) | Yesterday (6/4) | Target |
|---|---|---|---|
| Units Shipped | 576,133 | 393,913 | — |
| Orders in Process | 245 | 292 | — |
| Orders in LogPro | 3,087 | 3,187 | — |
| Units on Hand | ~49.3M | ~49.7M | — |
| Pallets on Hand | ~29,182 | ~29,284 | — |
| OTIF | 82% | 84% | 85% |
| Exceptions | 24 | 44 | ≤5 |
| OTD % | 99% | 99% | 90% |
| OTP % | 98% | 99% | 95% |
| Cost per lb | $0.15 | $0.13 | $0.16 |
| Parcel Shipments | 1,319 | 572 | — |
Ops Tech IssuesCross-functional technology and operational systems issues. Source: Ops Tech Tickets.xlsx — new daily source as of 5/29. Owner: Patty Smith / Angie Cox.
Owner: Patty Smith · Source: Ops Tech Tickets.xlsx · 6/5/2026
Exec View:
10active tickets
1 Needs Action · 2 In Progress · 1 Suggestion · 4 Backlog · 2 Complete
4 new carrier/shipment tickets opened 6/1 — EA Dev Team investigating
| Ticket | Owner | Status | Priority |
|---|---|---|---|
| Shipment Notifications Not Sending / Wrong Template (TSD-101117) | Angie Cox | In Progress | High |
| Shipping Notification — Second School Contact (IDEA-869) | Angie Cox, David Blair | In Progress | High |
| Agentforce — No JIRA ticket yet | Jess Yu, David Blair | Needs Action | High |
| CST LOM Report Updates (IDEA-930) | Dan Ambrosio, Charlotte | Complete ✓ | Medium |
| PowerBI Demand Planning (TSD-100119) | Matt B, Colin | In Progress | Medium |
| Power Automate XML→CSV (TSD-100785) | IT Team | Suggestion | Low |
| Tracking Failures (IDEA-1010) | EA Dev Team | Backlog | High |
| Invalid XML Carrier Desc (IDEA-1011) | EA Dev Team | Backlog | High |
| Mismatched ShipmentIDs (IDEA-1012) | EA Dev Team | Backlog | High |
| Coyote Mode Blank (IDEA-1013) | EA Dev Team | Backlog | High |
Early Season
Purchasing & Receiving · Math Kits · Order Processing
Purchasing & Receiving vs. PlanMeasures what percentage of the full-year inventory purchasing budget has been physically received to date. Split between GM (Great Minds–owned print titles) and Trade titles.
Owner: Jess Bothel · Source: PO Tracking_Rcv_Open - 2026-06-05.xlsx (local)
Exec View:
79%received to budget
↑1pt vs. yesterday · $60.6M received of $76.6M adj. budget
Trade ROY: -$163K (slightly over budget) · GM Print ROY: +$4.8M remaining
| Received POs YTD | Adj Budget | Rcv % to Budget | |
|---|---|---|---|
| GM Print | $37.3M | $51.2M | 73% |
| Trade | $23.3M | $25.4M | 92% |
| Purchases YTD | $60.6M | $76.6M | 79% |
Math Manipulative Kits — Pipeline SummaryH2M (Hand2Mind) inventory and pipeline for math manipulative kits. Available = net units after subtracting open fulfillment order commitments. Rem. Wtd Qty = probability-adjusted remaining demand. % Wtd Covered = Available ÷ Wtd Qty. Negative = short position (more committed than available).
Owner: Mallory · Source: H2M-GM Parent File - 06-05-2026.xlsx
Exec View:
| Product Line | Rem. Unwtd Qty | Rem. Wtd Qty | Available | % Wtd Covered |
|---|---|---|---|---|
| Bluebonnet K–5 | 4,330 | 2,728 | 5,000 | 183% |
| EM2 Complete Kits | 7,014 | 3,899 | 9,488 | 243% |
| EM2 Other (Pilot/Upgrade/Supp.) | 2,905 | 1,968 | 3,296 | 167% |
| Eureka Math (Legacy) | 256 | 145 | 1,154 | 796% |
Customer Orders Processed (OMT)OMT = Order Management Team. "Customer PO $ Processed" = the dollar value of fulfillment orders (FOs) sent to Cengage for picking and shipping. This is not recognized revenue — it is the order value released for fulfillment. Includes Amount + Shipping. Owner: Mike Gomes.
Owner: Mike Gomes · Source: OMT Scorecard + FOs 6/5 · Live
Exec View:
$59.6MMay 2026 processed ✓
↑9% vs. May 2025 ($54.1M) · June MTD: $10.2M (5 days in vs. $48.1M full LY)
May 2025 full month: $54.1M · 137 open cases ($8.3M) · week 1 of June peak
Top 5 Accounts — FOs This Week (5/31–6/6) ▼
| Account | State | # FOs | Amount |
|---|---|---|---|
| IDEA Public Schools | TX | 80 | $1,125K |
| Prior Lake-Savage Area Schools | MN | 6 | $313K |
| Aurora Public Schools | CO | 1 | $179K |
| Moore County Schools | NC | 17 | $159K |
| Archdiocese of Chicago | IL | 3 | $34K |
| All Accounts (Week Total) | — | 94 | $735K |
Mid Season
Shipment Issues & Carrier Performance · Customer Support
Shipment Issues & OTIFOTIF = On-Time In-Full. Measures carrier performance: did the shipment arrive on time AND complete? Shipment Exceptions = in-transit issues tracked via RXO/Coyote. OTD = On-Time Delivery %. OTP = On-Time Pickup %.
Owner: David Brown · Source: Executive Weekly Scorecard 6.5.26
Exec View:
82%OTIF
↓2pp vs. yesterday (84%) ⚠ · 24 exceptions in transit · 4 new backlog shipment issues
24 exceptions (↓20) · OTD 99% ✓ · OTP 98% ✓ · Cost/lb $0.15 ✓
| Metric | Today (6/5) | Yesterday (6/4) | Target |
|---|---|---|---|
| OTIF | 84% | 90% | 85% |
| Shipment Exceptions | 44 | 29 | ≤5 |
| OTD % | 99% | 97% | 90% |
| OTP % | 99% | 100% | 95% |
| Cost per lb | $0.13 | $0.12 | $0.16 |
| Parcel Shipments | 572 | 340 | — |
Customer Support Team (CST)CST metrics from the daily Cengage scorecard plus the Zoom call queue report. CSAT = Customer Satisfaction Score. SLA Compliance = % of cases resolved within SLA. FCR = First Contact Resolution rate. Aging Cases = cases past SLA. Owner: Jess Yu / CST team.
Owner: Jess Yu · Source: Executive Weekly Scorecard 6.5.26 + Zoom Call Queue 6/4
Exec View:
99%CSAT today
→ flat vs. yesterday (99%) · 45 inbound · 61 closed · 136% closure rate
SLA 100% ✓ · Aging Cases 34 ⚠ (target <15) · FCR 4% ⚠
| Metric | Today (6/5) | Yesterday (6/4) | Target |
|---|---|---|---|
| Inbound Cases | 45 | 51 | 41/day |
| CSAT | 99% | 99% | 96% |
| SLA Compliance | 100% | 100% | 97% |
| Case Closure Rate | 136% | 110% | 100% |
| FCR % | 4% | 22% | 20% |
| Aging Cases | 34 | 31 | <15 |
| 📞 Inbound Calls (6/3) | 8 | 6 | — |
| 📞 Abandon Rate | 0% | 0% | ≤5% |
| 📞 Overflowed (Voicemail) | 0 | — | — |
Special Focus
Trade Titles · Hand2Mind Open Orders · Cengage Open Orders · Print POs · Promotional Materials
Trade TitlesTrade book pipeline — third-party titles sold through GM's distribution channel. Tracks opportunities won and lost by week. Owners: Charles Park / Stacey Sweet.
Owners: Charles Park / Stacey Sweet · Source: Trade Ops files 6/5
Exec View:
$462.2Kwon this week (50 opps)
50 opps won this week (5/31–6/6) · 2-week Won total: 102 opps / $1.56M
Open pipeline: 1,100 opps · $30.2M unwtd / $15.4M wtd · Lost this wk: $4.6M (49 opps)
Opportunities Won — This Week & Last Week ▼
| Week | Amount Won | Opp Count |
|---|---|---|
| Last Week (5/24–5/30) | $1,093,812 | 52 |
| This Week (5/31–6/6) | $462,222 | 50 |
| 2-Week Total | $1.56M | 102 |
Opportunities Lost — This Week & Last Week ▼
| Week | Amount Lost | Opp Count |
|---|---|---|
| Last Week (5/24–5/30) | $1,578,010 | 35 |
| This Week (5/31–6/6) | $4,581,020 | 49 |
| 2-Week Total | $6.16M | 84 |
Hand2Mind Open OrdersOpen fulfillment orders at H2M (Hand2Mind) for physical classroom kit bundles. Shipment Status: 'Waved' = getting ready to pick; 'In Process' = currently picking; 'Open' = just released to warehouse; 'Loaded' = in routing process. Owner: Michael O'Hara.
Owner: Michael O'Hara · Source: GM Open Order Status 6.5.26.xlsx · Live
Exec View:
376total open orders
197 with active shipment status · 179 Future (not yet routed)
145 Loaded · 48 Waved/In Plan · 4 In Process · 179 Future (blank Shipment Status)
| Fulfillment Stage | Count (6/4) | What it means |
|---|---|---|
| 🔄 Waved/In Plan — preparing to pick | 48 | Getting ready to start the picking process |
| ⚙ In Process — actively picking | 4 | Currently in the picking process |
| ✓ Loaded — in routing / transit | 145 | In routing process with parcel or LTL pickup |
| 🔵 Future — not yet routed | 179 | Shipment Status is blank — waiting to be released |
| Total Open Orders | 376 | — |
Cengage Open OrdersOpen GM sales orders in D365 at Cengage's facility. Shows orders by fulfillment state: Shipping Today (allocated + picking + at carrier), Future (not yet due), and Short (cannot fill due to inventory gaps). Owner: David Blair.
Owner: David Blair · Source: SIP 6.5.26 Quick Summary · Open Order Report returned 406
Exec View:
103orders short
↓135 vs. yesterday (238) · 3% of pool
Pool: 3,087 orders · Short: 103 (3%) · 372 shipping today · 1,625 future orders
| Order Status | Count | % of Total |
|---|---|---|
| 🚚 Orders Shipping Today (Alloc + Picking + TC) | 372 | 12% |
| 🔵 Future Orders (not yet due) | 1,625 | 53% |
| ⚠ Orders Short (can't fill) | 103 | 3% |
| Total in Pool | 3,087 | — |
Bluebirds
Unexpected fast-moving wins · Creation-to-PO ≤30 days · No prior parent in Salesforce
Bluebirds: Volume & PipelineBluebird orders = customer orders where creation-to-close ≤30 days with no prior parent entry in Salesforce. These are unexpected fast-moving wins. Owner: Mallory.
Owner: Mallory · Source: Daily Bluebirds Report-2026-06-05-08-35-38 · Live
Exec View:
15bluebird orders today
$81.9K total · 6 PO Revisions Needed ⚠ ($62.9K at risk) · 8 Awaiting Fulfillment
~15 avg days creation-to-PO · PO Revisions blocking ~$62.9K ⚠
| Stage | Orders (6/5) |
|---|---|
| Awaiting Fulfillment | 8 |
| Awaiting Payment | 1 |
| PO Revision Needed | 6 ⚠ |
| Total | 15 |