Inventory Analysis — Schofield Sales
Date: 2026-06-11
Source: Schofield-Inventory REV2 06.01.26.xlsx
Prepared by: Robert Maefs Consulting
Overview
The inventory spreadsheet contains 34 part numbers across two sheets — a Current Inventory snapshot and an Updated Inventory Sheet reflecting pricing and stock adjustments. Products are industrial flexible packaging and containment solutions: liner bags, drum liners, and specialty covers.
Product Categories
| Category | Code Prefix | Examples | Count |
|---|---|---|---|
| Top-Insert Open-Head Liner Bags | RL-TIO* | RL-TIOBB-HECS, RL-TIOBB-LICS | 15 |
| Drum Liners | DL-* | DL-ASBOC-LIE, DL-YOBB-HECS | 7 |
| Cross-Over Liner Bags | RL-CRO* | RL-CROBB-LIE | 1 |
| Dumpster/Spill Liners | DSL-* | DSL-TIOBTHUDL/ORANGE, DSL-TIOOTHUDL/BLACK | 2 |
| Rear-Load / Open-Head Specialty | RL-TION* / RL-TIOF* | RL-TIONB-LICS, RL-TIOF-CMF | 6 |
| Miscellaneous / Top-Open XL | RL-TIOC* / RL-TIOCLI* | RL-TIOC-LICS, RL-TIOCLI-LIXE | 3 |
Key Observations
1. Pricing Changes (Current vs Updated)
Most items saw slight price reductions in the updated sheet:
| Part | Current Price | Updated Price | Change |
|---|---|---|---|
| RL-TIOBB-HECS | $11.21 | $9.74 | −13.1% |
| RL-TIOBB-LICS | $12.06 | $11.49 | −4.7% |
| RL-TIOBB-LIE | $13.00 | $11.56 | −11.1% |
| RL-TIOBB-BECS | $14.88 | $14.17 | −4.8% |
| RL-TIOBB-CCS | $25.24 | $20.33 | −19.5% |
| RL-CROBB-LIE | $14.29 | $12.40 | −13.2% |
| RL-TIONB-LICS | $16.47 | $13.03 | −20.9% |
This suggests a strategic repricing — likely to remain competitive or reflect updated manufacturing costs.
2. Stock Position
- Processed In Stock: Items with healthy stock (RL-TIOBB-HECS CORE: 1,300, RL-TIOBB-LICS updated: 981)
- To Process: Some items have significant backlogs (RL-TIOO-LIMF-KYM: 1,785 to process)
- Low/Zero Stock: RL-TIOBB-BEE has 0 in stock and 0 on P.O. — potential stockout risk
3. Lead Times
- Standard items: 4–7 weeks
- Specialty items (RL-TIONB, RL-TIOF, RL-TIONE*): 12 weeks
- Some items list Lisbon warehouse stock — international logistics dependency
4. Weight & Dimensions
- Weights range from 1,000 lbs to 1,710 lbs per unit
- Sizes vary from small 12.5’ × 6.5’ bags to large 50’ × 8’ × 10’ drum liners
- Material gauges: 2mil, 3mil, 4mil, 6mil, 8mil, 10mil EQ
Recommendations
- Ecommerce pricing: Use the Updated Inventory Sheet prices for the Shopify storefront — they reflect the latest cost basis
- Stockout alert: RL-TIOBB-BEE (4mil, 22’×8’×5.5’) has zero processed stock and zero on order — flag for replenishment
- Bundle opportunities: Group items by dimension cluster (e.g., all 22’×8’×5.5’ liners at 2/3/4/6/10mil) as a product family with variant selector
- Lead time transparency: Display 4–7 week lead times prominently on product pages — sets proper expectations for B2B buyers
- Data cleanup: Some columns in the spreadsheet have inconsistent data (N/A vs blank, mixed date formats) — standardize before importing to Shopify