Allocation Dashboard: Unallocated Cash, Check Totals, Exceptions & a Chart
This lesson is part of the course
In this lesson
You close the month for six fictional customers: allocated amounts, unallocated cash and still-open balances, a check column that must show 0, a count of the exceptions and a stacked column chart of every payment.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Running Totals as the Engine: Cumulative Amounts, What Is Left & Where It Runs Out Locked
- FIFO Payments to Invoices: Oldest First, Allocated Amounts, Open Balances & Part-Paid Flags Locked
- Several Payments, Several Invoices: Running Totals on Both Sides & the Allocation Matrix Locked
- Stock to Orders by Priority: Rank by Two Keys, Demand Ahead & Filled, Part or Zero Locked
- Fair-Share Rationing: Proportional Shares, Whole Units & the Largest-Remainder Rule Locked
- Capacity Allocation: Jobs into Days in Sequence, Finish Days, Dates & Overflow Locked
- Matching Two Lists: Exact Keys, Amount & Date Tolerances and First-Match Rules Locked
- Allocation Dashboard: Unallocated Cash, Check Totals, Exceptions & a Chart Locked