Capacity Allocation: Jobs into Days in Sequence, Finish Days, Dates & Overflow
This lesson is part of the course
In this lesson
You load seven engraving jobs into days of 7.5 hours in sequence, find the hours before each job, its finish day and its finish date with WORKDAY, and spread every job over the days with one overlap formula.
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