Staff Costing Workbook

Staff Costing Workbook is an Excel workbook for UAE owners who know the salary on the contract but not what the person costs. It adds the costs that sit around a salary, shows the true monthly and annual cost and the uplift over pay, and turns the result into a minimum hourly and day rate or a 12-month hiring cost.

What is inside:

• Seven sheets: Instructions, Assumptions, Visa and Fees, Employee Cost (30 people), Job Pricing (20 lines), Hiring Planner (10 hires) and a Worked Example
• Per employee: gross pay, end-of-service gratuity accrual, health insurance, air tickets, visa and government fees, equipment, recruitment fee, overheads per head and other costs, giving true monthly cost, true annual cost and cost per available hour
• A Visa and Fees fill-in table: rows for the usual permit, visa, medical, Emirates ID, PRO and renewal items, each with an amount you type and how often it recurs. One-off fees are spread over the months the person is expected to stay; recurring fees become a monthly equivalent
• Job Pricing: cost per billable hour from your leave, holiday and billable-share assumptions, a minimum rate at your target margin, a day rate and a flag when your current rate is below cost or below target margin
• Hiring Planner: recurring monthly cost, one-off costs in the start month and a 12-month cash grid for planned hires
• A filled example with six fictional employees and a live one-employee worked example

Who it is for: owners, finance managers and service businesses that charge by the hour or day and need to know a safe minimum rate.

What it does not do: the blank file contains NO visa or government fee amounts. Fees depend on your emirate or free zone, the permit type and the date, and they change, so you fill the table from a written quote from your PRO. The example file uses round illustrative numbers that are not real fees. Gratuity uses the published tiers (21 and 30 days of basic wage) with the daily rate basic x 12 / 365, which the law does not define; it is an accrual that ignores the cap and the one-year minimum. Raises, bonuses, overtime, social security for UAE and GCC nationals and tax or VAT effects are not included. Leave days, billable share and margin are your own planning figures.

Verified by recalculating the filled example with an independent engine and comparing Employee Cost, Job Pricing and Hiring Planner with a separate calculation. Not opened in Microsoft Excel itself.

Requirements: Microsoft Excel 2016 or later, or Google Sheets.