Stock to Orders by Priority: Rank by Two Keys, Demand Ahead & Filled, Part or Zero
This lesson is part of the course
In this lesson
You rank seven unsorted orders by priority and then by date with COUNTIFS, add up the demand ahead of each order with SUMIFS, allocate 600 pans and mark every order as Filled, Part or Zero.
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