Re: Feb bonus
- From
- Will Reid <wreid@thekey.com>
- To
- Diego Castaneda <diego.castaneda@thekey.com>
- CC
- Joel Reyes <joel.reyes@thekey.com>, jamie.laurinovics@thekey.com, Laszlo Kovacs <laszlo.kovacs@thekey.com>, FPA <fpa@thekey.com>, Steve Sudberry <ssudberry@thekey.com>, Geraldine Nath <geraldine.nath@thekey.com>, Timothy Thomas <tt@thekey.com>, sara.stuhlsatz@thekey.com
- Date
- Mon, 17 Mar 2025 10:59:53 -0400
- Folder
- INBOX
📎 image001.png
Diego, Would you please confirm the following? February closed on 3-12 Planful Caregiver Margin for Cincinnati was 50% on 3-14 *(based on your confirmation below this was final)* Planful Caregiver Margin for Cincinnati is 49.9% on 3-17 - If true this changes the bonus payment. Tableau Caregiver Margin for Cincinnati is 49.9 on 3-17 - If true this changes the bonus payment. Planful EBITDA for Cincinnati was 26.1 on 3-14 *(based on your confirmation below this was final)* Planful EBITDA for Cincinnati is 26.9 on 3-17 Are the 3-17 numbers wrong? *Will Reid* Partner | TheKey Mobile: 513.707.2304 <http://www.thekey.com> On Fri, Mar 14, 2025 at 12:08 PM Diego Castaneda <diego.castaneda@thekey.com> wrote: > Hi Will > Correct! > > > Thanks, > *Diego Castaneda* > Head of FP&A > > > On Fri, Mar 14, 2025 at 12:06 PM Will Reid <wreid@thekey.com> wrote: > >> 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 >>>>> >>>>