Base forecast 11 Sep 2026
Forecast of 11 Sep 2026 vs actual cash movements through 16 Oct 2026 · 5 complete week(s) compared
Receipts MAPE (customer x week)55.3%
Closing cash variance, last week-18,48,718
Weekly variance
| Week | Receipts fcst | Receipts actual | Disb. fcst | Disb. actual | Closing fcst | Closing actual | Closing var. | MAPE |
|---|---|---|---|---|---|---|---|---|
| 1 11 Sep | 1,08,24,408 | 1,57,57,373 | 65,88,826 | 74,09,489 | 1,02,46,884 | 1,43,59,186 | 41,12,302 | 57.3% |
| 2 18 Sep | 80,16,869 | 38,13,761 | 64,74,692 | 59,36,695 | 1,17,89,061 | 1,22,36,252 | 4,47,191 | 61.6% |
| 3 25 Sep | 1,32,39,342 | 1,31,73,122 | 92,31,136 | 90,57,662 | 1,57,97,267 | 1,63,51,712 | 5,54,445 | 43.9% |
| 4 2 Oct | 40,31,367 | 46,83,398 | 76,83,818 | 85,88,458 | 1,21,44,816 | 1,24,46,653 | 3,01,837 | 65.3% |
| 5 9 Oct | 36,09,973 | 16,42,435 | 8,49,937 | 10,32,954 | 1,49,04,852 | 1,30,56,134 | -18,48,718 | 45.8% |
Forecast accuracy by customer
| Customer | Forecast | Actual | Variance | MAPE |
|---|---|---|---|---|
| Apex Retail Holdings | 1,53,61,209 | 1,59,49,622 | 5,88,413 | 27.0% |
| Chola Supermarkets | 20,00,458 | 18,50,285 | -1,50,173 | 46.9% |
| Kesari Provisions | 19,70,976 | 16,91,242 | -2,79,734 | 59.5% |
| Zenith Retail Group | 10,96,053 | 14,66,000 | 3,69,947 | 74.7% |
| Mandovi Traders | 8,09,471 | 12,47,683 | 4,38,212 | 54.5% |
| Deccan Institutional | 12,41,155 | 11,93,996 | -47,159 | 92.2% |
| Vardhman Traders | 9,39,167 | 10,13,775 | 74,608 | 53.8% |
| Himalaya Stores | 9,04,124 | 9,97,570 | 93,446 | 44.7% |
| Ganga Retail Chain | 8,79,595 | 9,53,053 | 73,459 | 62.9% |
| Navjeevan Hospitals | 8,26,039 | 8,69,283 | 43,244 | 21.0% |
| Eastern Grocers Co-op | 8,25,226 | 8,35,585 | 10,358 | 54.4% |
| Jaipur Bulk Traders | 7,82,476 | 8,19,611 | 37,135 | 63.4% |
| Udaan Distribution | 5,59,861 | 7,47,014 | 1,87,153 | 61.7% |
| Quick Mart India | 7,53,255 | 7,37,423 | -15,832 | 90.4% |
| Orchid Hotels Pvt Ltd | 13,12,015 | 7,27,443 | -5,84,572 | 6.0% |
| Tamil Nadu Cooperative | 6,84,307 | 6,77,464 | -6,843 | 32.7% |
| Harbour Exports Ltd | 5,97,936 | 6,41,937 | 44,000 | 36.1% |
| Western Edge Exports | 5,67,942 | 6,20,288 | 52,346 | 59.7% |
| Falcon Wholesale | 4,00,581 | 4,38,482 | 37,901 | 33.0% |
| Fresh Basket Retail | 2,75,061 | 4,23,468 | 1,48,407 | 86.6% |
| Nilgiri Stores | 6,29,930 | 3,85,983 | -2,43,947 | 85.6% |
| Rajdhani Foods | 0 | 3,75,428 | 3,75,428 | 100.0% |
| Ivory Hotels | 4,25,059 | 3,60,836 | -64,222 | 76.0% |
| Jupiter Mart | 8,18,746 | 3,60,761 | -4,57,984 | 68.2% |
| Anand Kirana Network | 3,29,182 | 3,57,707 | 28,525 | 62.2% |
Disbursements by category
| Category | Forecast | Actual | Variance |
|---|---|---|---|
| Accounts payable | 1,85,28,410 | 1,97,25,257 | 11,96,847 |
| Debt service | 12,50,000 | 12,50,000 | 0 |
| Payroll | 62,00,000 | 62,00,000 | 0 |
| Rent & facilities | 5,50,000 | 5,50,000 | 0 |
| Taxes | 43,00,000 | 43,00,000 | 0 |
Largest receipt variances
| Cash & carry counter sales | -16,00,000 |
| Apex Retail Holdings | 5,88,413 |
| Orchid Hotels Pvt Ltd | -5,84,572 |
| Jupiter Mart | -4,57,984 |
| Mandovi Traders | 4,38,212 |
| Rajdhani Foods | 3,75,428 |
| Zenith Retail Group | 3,69,947 |
| Kesari Provisions | -2,79,734 |
| Nilgiri Stores | -2,43,947 |
| Omkar Wholesale | 1,99,811 |
| Udaan Distribution | 1,87,153 |
| Chola Supermarkets | -1,50,173 |
| Fresh Basket Retail | 1,48,407 |
| Delta Wholesale Mart | 1,39,628 |
| Lotus Institutional Supply | -1,30,621 |