Capstone: The Assignment Budget Tracker
This lesson is part of the course
In this lesson
You track actual cost postings against the assignment budget: actual cost per type up to a cut-off date with SUMIFS, remaining budget, the share of the year's budget used, and a column chart of budget against actual.
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
- The Assignment Timeline: Dates, Days per Year & Months Locked
- Spendable Income & the Cost-of-Living Allowance Locked
- Housing, Utilities & Transport Allowances Locked
- One-Off Costs: Relocation, Temporary Housing & Home Leave Locked
- Split Pay & Exchange Rates Locked
- Tax Equalisation & Gross-Up (Simplified) Locked
- Total Assignment Cost vs a Local Hire Locked
- Capstone: The Assignment Budget Tracker Locked