Tutorvo

Tenure & Extensions: Planned End Dates, Months on Assignment and the Cost of Extending

Lesson 6 of 815 minLab

This lesson is part of the course

In this lesson

You calculate planned end dates with EDATE, count the months each assignment has run, total the cost of all extensions and highlight assignments that exceed the company's review guideline.

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

  1. Hourly, Daily, Monthly: Turning Every Rate into One Comparable Hourly RateLab15 min Locked
  2. Agency Temps: Pay Rate × Markup = Bill Rate, and the Loaded Cost of an EmployeeLab16 min Locked
  3. Rate-Card Compliance: Card Rates by Role and Level, Overpayments and SavingsLab16 min Locked
  4. Fixed-Fee Statements of Work vs Time and Materials: Estimates, Change Requests and OverrunsLab16 min Locked
  5. Temp-to-Perm Conversion Fees: Fee Scales by Weeks Worked and the Break-Even PointLab16 min Locked
  6. Tenure & Extensions: Planned End Dates, Months on Assignment and the Cost of ExtendingLab15 min Locked
  7. Contingent Spend Reporting: By Category, Department and Supplier, and the Share of Workforce CostLab16 min Locked
  8. Workforce Mix Dashboard: Employees vs Contingent FTE and Cost, a Conversion Scenario and a ChartLab18 min Locked