Orders
User-managedOrder book drives all downstream planning.
Records: 18
Data Sources
5
Total Records
74
Last Refresh
Today
Data Quality
Good
User-Managed Data
Uploadable planning inputs
Full Kit
User-managedMaterial readiness information.
Records: 18
Capacity
User-managedFactory capacity and combo assignments.
Records: 15 Combos
Buyers
User-managedBuyer master data and payment terms.
Records: 8
Factory Structure
User-managedFactory layout and capacity assumptions.
Records: 15 Combos
System-Generated Data
Generated outputs, no uploads allowed
Cash Events
System-generatedGenerated from orders, payment terms and lead times.
Records: Generated
Cash Projection
System-generatedCalculated cash balance over time.
Records: Generated
Capacity Projection
System-generatedGenerated capacity loading and utilization forecast.
Records: Generated
Workbook Structure
One workbook, seven sheets
| Sheet | Purpose |
|---|---|
| Instructions | Purpose, mandatory fields, upload process, common mistakes, examples |
| Orders | Order No, Buyer, Style, Quantity, Order Value, Ship Date |
| Full Kit | Order No, Fabric %, Trim %, Packaging %, Full Kit % |
| Capacity | Combo, Style Allocation, Available Capacity |
| Buyers | Buyer, Payment Terms, Credit Terms |
| Factory Structure | Combo, Lines, Weekly Capacity |
| Validation Rules | Read-only allowed values and validation instructions |
View Data
Orders
| Order | Buyer | Qty | Ship Date | Value |
|---|---|---|---|---|
| K-1 | Wrangler | 42,000 | 12-Aug-2026 | Rs 1.05 Cr |
| K-2 | Cross Trunk | 60,000 | 18-Aug-2026 | Rs 0.96 Cr |
| K-3 | Swiss Trunk | 38,000 | 22-Aug-2026 | Rs 0.91 Cr |
| K-4 | Wrangler | 48,000 | 26-Aug-2026 | Rs 1.35 Cr |
| K-5 | Cross Trunk | 35,000 | 02-Sep-2026 | Rs 0.80 Cr |
| K-6 | Swiss Trunk | 28,000 | 05-Sep-2026 | Rs 0.90 Cr |
| K-7 | Cross Trunk | 44,000 | 10-Sep-2026 | Rs 1.20 Cr |
| K-8 | Wrangler | 40,000 | 18-Sep-2026 | Rs 0.92 Cr |
| K-9 | Swiss Trunk | 55,000 | 20-Sep-2026 | Rs 0.75 Cr |
| K-10 | Cross Trunk | 46,000 | 24-Sep-2026 | Rs 1.15 Cr |
| K-11 | Swiss Trunk | 30,000 | 30-Aug-2026 | Rs 0.95 Cr |
| K-12 | Wrangler | 52,000 | 28-Sep-2026 | Rs 1.42 Cr |
| K-13 | Wrangler | 26,000 | 05-Sep-2026 | Rs 0.75 Cr |
| K-14 | Cross Trunk | 110,000 | 01-Oct-2026 | Rs 1.05 Cr |
| K-15 | Swiss Trunk | 22,000 | 04-Oct-2026 | Rs 0.88 Cr |
| K-16 | Wrangler | 24,000 | 08-Oct-2026 | Rs 0.82 Cr |
| K-17 | Cross Trunk | 36,000 | 10-Oct-2026 | Rs 0.58 Cr |
| K-18 | Swiss Trunk | 18,000 | 12-Oct-2026 | Rs 0.72 Cr |