Salary to Hourly Calculator

Let $A$ be the entered gross salary, $n$ the salary periods per year, $h$ regular weekly hours, $e$ additional weekly hours, $D$ scheduled workdays per week, $W$ scheduled weeks, $P$ paid leave days, $U$ unpaid days and $B$ separate annual cash. The salary amount covers the full modeled annual arrangement; weeks describe the work covered by it rather than a second salary multiplier. Leave days must be distinct and fit within $DW$ scheduled workdays.

The retention fraction $k$ is $1$ when optional proration is off. When proration is enabled and $DW>0$, use $k=1-U/(DW)$. A zero-week schedule requires zero leave and keeps the entered annual salary, but it has no worked-hour comparison. Paid leave has no salary reduction. These rules describe this worksheet's explicit planning model, not a determination of permitted payroll deductions.

The scheduled rate $r_s$ excludes extra hours and separate cash. The worked-hour salary rate $r_b$ excludes separate cash, while $r_c$ includes it. Each quotient requires its own positive denominator. An average payment with $m$ periods per year is $C/m$. A target $t$ per worked hour gives $A_{\min}=\max(0,tH_w-B)/(kn)$ when worked hours and retention are positive; if additional cash already funds the target, the minimum salary is zero.

1. Annualize the salary and define the scheduled hours

   Consider a monthly gross salary of $6000$, with $40$ regular weekly hours across $4$ workdays and $50$ scheduled weeks. The annual base is $S=6000\times12=72000$, and regular scheduled hours are $H_s=40\times50=2000$. Each scheduled day therefore carries $10$ regular hours. A shorter work year changes the hours covered by the stated salary without automatically reducing the salary again.

2. Separate paid leave, unpaid leave and additional work

   Enter $12$ paid leave days, $8$ unpaid days and $5$ additional hours per worked week. The worked-week equivalent is $W_w=50-(12+8)/4=45$. Paid leave contains $120$ regular hours and unpaid leave contains $80$ regular hours. Additional work contributes $5\times45=225$ hours. Total actual work is $H_w=(40+5)\times45=2025$ hours, with no automatic extra salary for those additional hours.

3. Apply only the chosen salary adjustment and annual cash

   For this example, explicitly enable proportional unpaid-leave proration and add $3000$ of separate annual cash. Salary retention is $k=1-8/(4\times50)=0.96$. Modeled base salary is $69120$, so the signed reduction is $-2880$. Gross annual cash becomes $C=69120+3000=72120$. The reconciliation is $72000-2880+3000=72120$; paid leave causes no additional salary deduction.

4. Compare the hourly meanings and a target salary

   Scheduled base salary gives $r_s=72000/2000=36$ per regular scheduled hour. Salary per actual worked hour is $r_b=69120/2025\approx34.13$, while all cash gives $r_c=72120/2025\approx35.61$. For an all-cash worked-hour target of $40$, required annual base salary is $(40\times2025-3000)/0.96=81250$. The monthly minimum is $81250/12\approx6770.833333$, so an upward quote in hundredths is $6770.84$, keeping the target from being underfunded by display rounding.