| Carlene Hatcher | |||||||||||||
| Capability Examples | |||||||||||||
| AP Payment Planner | |||||||||||||
| Outstanding Accounts Payable Payment Planner | |||||||||||||
| SUMMARY of SCENARIOS | |||||||||||||
| IF ALL UNPAID INVOICES ARE TO BE PAID AND ALL DISCOUNTS ARE TO BE TAKEN | IF ONLY MARKED INVOICES (COLUMN A) ARE TO BE PAID AND ONLY MARKED DISCOUNTS (COLUMN B) ARE TO BE TAKEN | ||||||||||||
| Total # of Unpaid Invoices: | 4 | # of invoices MARKED to pay: | 2 | ||||||||||
| Undiscounted Total: | $1,600.00 | Total of UnDiscounted Invoice Payments: | $400.00 | ||||||||||
| Discounted Total: | $1,565.00 | Total of Discounted Invoice Payments: | $396.00 | ||||||||||
| SAVINGS with all discounts: | $35.00 | SAVINGS with discounts on marked invoices: | $4.00 | ||||||||||
| PAY INVOICE | TAKE DISCOUNT | Supplier ID | Supplier Name | Inv # | Inv Status | Inv Date | Inv Total | Disc Due Date | Net Due Date | Potential Disc % | Potential Disc Amt | Discounted Invoice Total | |
| Y | Y | 1 | Supplier1 | 10 | Unpaid | 7/2/01 | $100.00 | 7/12/01 | 7/22/01 | 1% | $1.00 | $99.00 | |
| Y | Y | 1 | Supplier1 | 30 | Unpaid | 9/10/01 | $300.00 | 9/20/01 | 9/30/01 | 1% | $3.00 | $297.00 | |
| N | na | 2 | Supplier2 | 20 | Unpaid | 4/11/00 | $500.00 | 4/26/00 | 5/11/00 | 2% | $10.00 | $490.00 | |
| N | N | 3 | Supplier3 | 20 | ON HOLD | 11/10/02 | $700.00 | 11/30/02 | 12/25/02 | 3% | $21.00 | $679.00 | |