Re: Feb bonus

Diego,
So going forward, once a month is closed, EBITDA and Caregiver margin in
Planful are the *final* numbers for bonus calculations.

Thanks for the clarification. I will pass this on to GMs


*Will Reid*

Partner | TheKey

Mobile: 513.707.2304

<http://www.thekey.com>



On Fri, Mar 14, 2025 at 11:59 AM Diego Castaneda <diego.castaneda@thekey.com>
wrote:

> Hi
> I just pulled the numbers in Planful and they tie back to the P&L that
> Joel included in the emails below.
>
> For bonus calculations the team used the GL, which are the numbers in
> Planful.
>
>
> Thanks,
> *Diego Castaneda*
> Head of FP&A
>
>
> On Thu, Mar 13, 2025 at 10:08 PM Will Reid <wreid@thekey.com> wrote:
>
>> Thanks Joel.
>>
>> Here are my original questions regarding staff bonuses:
>>
>> Feb EBITDA for our Cincinnati office is 26.1% per Planful today. Is this
>> the final number for bonus calculations?
>>
>> The OFFICIAL caregiver margin in Tableau is not populated in Tableau.
>> Planful shows 50% Is this the final number for bonus calculations?
>>
>> Thanks
>>
>>
>> *Will Reid*
>>
>> Partner | TheKey
>>
>> Mobile: 513.707.2304
>>
>> <http://www.thekey.com>
>>
>>
>>
>> On Thu, Mar 13, 2025 at 8:19 PM Joel Reyes <joel.reyes@thekey.com> wrote:
>>
>>> Hello All,
>>>
>>> below is a snip from our planful reporting for cincinnati for February
>>> results, please let me know if you have any questions, i'm not sure what
>>> the original ask is, but this should have a summary of all relevant results
>>> for Feb
>>>
>>>  Cincinnati
>>> Account Actual          MoM
>>> Dec-24  Jan-25  Feb-25    Var  Var %
>>>
>>> Caregiver Revenue             718             740             678
>>> (61)    (8.3)%
>>> Surcharge Revenue                 5                 7                 8
>>>               1 8.2%
>>> Revenue             723             747             686           (61)
>>> (8.1)%
>>>
>>> Cost of Sales:
>>> Caregiver Wages             368             370             340
>>> 30 8.0%
>>> Other Caregiver Costs               58               69
>>> 61               8 11.1%
>>> Total Cost of Sales             425             438             401
>>> 37 8.5%
>>>
>>> Gross Profit             297  $308  $285           (23)     (7.6)%
>>> Caregiver Margin       48.8%       50.0%       49.9%     (0.1)%
>>> Gross Profit Margin       41.1%       41.3%       41.6%   0.2%
>>>
>>> Total Operating Expenses  $107  $120  $100            19 16.2%
>>>
>>> AEBITDA  $190  $189  $185             (4)     (2.1)%
>>> AEBITDA Margin         26.3%         25.3%         26.9%   1.7%
>>>
>>> Monthly Stats:
>>> Client Count               93               94               90
>>> (4)    (4.3)%
>>> Billed Hours       19,036       19,995       18,398     (1,597)
>>> (8.0)%
>>> Billed Hours Per Day             614             645             657
>>> 12 1.9%
>>> Billed Revenue Per Day       23,157       23,863       24,231
>>> 369 1.5%
>>> Paid Wages Per Day       11,864       11,922       12,139        (217)
>>> (1.8)%
>>> Billed Rate  $37.7  $37.0  $36.9       (0.12)    (0.3)%
>>> CG Paid Rate  $19.3  $18.5  $18.5         0.01 0.1%
>>>
>>> On Thu, Mar 13, 2025 at 4:10 PM <jamie.laurinovics@thekey.com> wrote:
>>>
>>>> Good evening, Will,
>>>>
>>>>   My apologies for the delay as I just returned from a doctor
>>>> appointment. While I can confirm these percentages for February as correct
>>>> in NetSuite, I am copying FP&A to reply from the Planful side. @FPA
>>>> <fpa@thekey.com>, please note this is an urgent request.
>>>>
>>>>
>>>>
>>>> *Thank you,*
>>>>
>>>>
>>>>
>>>> *Jamie Laurinovics*
>>>>
>>>> Assistant Accounting Manager | *TheKey*
>>>>
>>>>
>>>>
>>>> <http://www.thekey.com/>
>>>>
>>>>
>>>>
>>>> *From:* Will Reid <wreid@thekey.com>
>>>> *Sent:* Thursday, March 13, 2025 1:52 PM
>>>> *To:* Laszlo Kovacs <laszlo.kovacs@thekey.com>
>>>> *Cc:* jamie.laurinovics@thekey.com; Steve Sudberry <
>>>> ssudberry@thekey.com>; Geraldine Nath <geraldine.nath@thekey.com>;
>>>> Timothy Thomas <tt@thekey.com>
>>>> *Subject:* Re: Feb bonus
>>>>
>>>>
>>>>
>>>> Thanks Laszlo.
>>>>
>>>>
>>>>
>>>> Jamie, please confirm asap. I have a lot of people standing by.
>>>>
>>>>
>>>>
>>>> Thank you!
>>>>
>>>>
>>>>
>>>>
>>>> *Will Reid*
>>>>
>>>> Partner | *TheKey*
>>>>
>>>> Mobile: 513.707.2304
>>>>
>>>>
>>>>
>>>> <http://www.thekey.com/>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> On Thu, Mar 13, 2025 at 4:20 PM Laszlo Kovacs <laszlo.kovacs@thekey.com>
>>>> wrote:
>>>>
>>>> Hi Will,
>>>>
>>>>
>>>>
>>>> Looping in Jamie to speak to your question.
>>>>
>>>>
>>>>
>>>> Thanks!
>>>>
>>>>
>>>>
>>>> *From:* Will Reid <wreid@thekey.com>
>>>> *Sent:* Thursday, March 13, 2025 1:52 PM
>>>> *To:* Timothy Thomas <tt@thekey.com>; Laszlo Kovacs <
>>>> laszlo.kovacs@thekey.com>
>>>> *Cc:* Steve Sudberry <ssudberry@thekey.com>
>>>> *Subject:* Feb bonus
>>>>
>>>>
>>>>
>>>> Laszlo,
>>>>
>>>> I received your message that Feb is closed. Feb EBITDA for our
>>>> Cincinnati office is 26.1% per Planful today. Is this the final number for
>>>> bonus calculations?  The OFFICIAL caregiver margin in Tableau is not
>>>> populated in Tableau. Planful shows 50% Is this the final number for bonus
>>>> calculations? How do I get confirmation today?
>>>>
>>>>
>>>>
>>>> Thanks,
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> *Will Reid*
>>>>
>>>> Partner | *TheKey*
>>>>
>>>> Mobile: 513.707.2304
>>>>
>>>>
>>>>
>>>> [image: Image removed by sender.] <http://www.thekey.com/>
>>>>
>>>>
>>>>
>>>>
>>>
>>> --
>>>
>>> Thanks,
>>> *Joel Reyes*
>>> Senior Financial Analyst
>>>
>>