Projected Billing question
This is from Hyperfine Architecture.
Let's say Sandra's Utilization Rate gets reduced from 70% to 65%. How do I reflect/calculate this change in the Billing Rate and Projected Billing columns?

Hourly rate = 32.75 x 52 x 40 = $68,120.00 = 100%
Utilization rate = 75%:
Total labor: $68,120.00
Direct labor: $68,120.00 x 0.75= $51,090
Indirect labor: $68,120 – 51,090 = $17,030
Projected billing: $163,488
Utilization rate = 65%:
Total labor: $68,120.00
Direct labor: $68,120.00 x 0.65 = $44,278
Indirect labor: $68,120 – 44,278 = $23,842
Projected billing: $141,690

Sandra's hourly rate: $32.75
Net multiplier: 3.2 (a constant number)
32.75 x 3.2 = $104.80 (billing rate)
$104.80 x 2,080 x 0.75 = $163,488
$105.00 x 2,080 x 0.75 = $163,800
$163,800  $163,488 = $312.00
There's $312.00 difference because Hyperfine used different net multiplier number for Sandra's calculations (not a constant of 3.2).
Net multiplier for Sandra:
105.00 / 32.75 = 3.2061068702
0.20 x 2,080 x 0.75 = $312.00
Please sign in to leave a comment.
Comments
12 comments