Staffing Spreadsheet Analysis With Jolene.pro: Assignment Contribution, Utilization and Rate Changes
A staffing agency can bill more hours while earning less on each assignment. Overtime may be increasing, a pay-rate change may have taken effect before the corresponding bill-rate change, or a growing client may be taking a larger share of the business. Total weekly billings will not explain those movements.
For temporary and contract staffing teams, Jolene.pro can help analyze placement, timesheet, billing and cost exports in Excel or CSV format. Its source references and calculation steps let an analyst inspect which assignments and weeks support a finding before discussing it with account managers.
Connect the assignment week to its rates and costs
Bring assignment ID, client ID, role category, work date, regular and overtime hours, approval status, bill rate, pay rate and their effective dates. Include recorded employer costs, assignment expenses, billed values and credits where available. Use stable worker IDs; personal contact details are unnecessary for the calculations described here.
An assignment can have several rate periods and many timesheet lines. Identify the relevant rate for each work date rather than applying today’s rate to every historical week. State the currency, approval cutoff and treatment of corrections. Keep permanent-placement fees separate from hourly staffing revenue.
1. Explain assignment contribution and its movement
Ask: “For approved hours in these complete weeks, calculate assignment revenue using the applicable regular and overtime bill rates. Subtract recorded pay and included employer costs. Summarize contribution by client and role, showing missing rates and source records.”
Define exactly which costs are included. The bill-rate minus pay-rate spread alone excludes payroll burdens, benefits and other assignment costs. If those records are absent, label the result as a pay-rate spread rather than fully costed profit. Report contribution percentage against revenue and retain zero-revenue exceptions separately.
Compare both hours and contribution per hour. A client’s contribution can grow because it bought more hours even while the unit economics weakened. Ask Jolene.pro to identify the assignments contributing most to that change, rather than simply ranking the biggest totals.
2. Measure utilization with an explicit population
If the agency records paid available hours for an employed contractor pool, compare billable hours with eligible available hours over the same period. Ask for the numerator, denominator and excluded leave or training categories. Distinguish hours approved for billing from hours already invoiced.
If available hours are not recorded, do not manufacture a utilization percentage from worker headcount. Report approved billable hours, active assignments and unallocated recorded hours where supported. Compare role categories and assignment stages before interpreting differences. These are workload measures for planning, not an automatic assessment of an individual worker.
3. Examine rate changes and overtime exposure
Ask: “Identify assignment weeks where effective pay rates changed without an equivalent bill-rate change. Separate regular and overtime hours, compare the resulting contribution per hour and show the dated rate records.”
Specify the actual overtime billing rules from the assignment agreement. Some bill rates use a multiplier; others use a separately negotiated rate. Do not assume pay and billing follow the same multiplier. Where expected billing is compared with invoiced value, include credits and billing timing so a pending invoice is not automatically classified as a rate error.
4. Assess client concentration and assignment endings
Ask Jolene.pro to show each client’s share of billed revenue and recorded contribution over a defined period. Add contracted assignment end dates to summarize hours or value approaching an end in the next 30 or 60 days. Show missing end dates separately.
Keep that view as exposure based on recorded dates. An assignment end date is not proof the client will leave, and a possible extension is not committed revenue. Compare client concentration using the same cost coverage and period, then let account managers confirm renewals and relationship context.
Use the workbook to prepare a better account review
Inspect the source rows, save the recurring calculations and pin charts useful to finance and account teams. Re-run them with the next comparable export after reviewing rate and structure changes. Start with one client and several complete weeks so the first conversation can name the assignments behind the movement.
Rate context: Bullhorn documents different overtime billing arrangements. Apply your recorded assignment terms rather than a universal multiplier.
For a checked next-assignment example, see Assign Tasks Fairly in Excel When Some Team Members Work Part-Time. It weights 24 similar assignments by 100%, 80% and 60% schedules and shows the exact source rows behind the 10, 8 and 6 split.