--00000000000012681606304f8711 Content-Type: multipart/alternative; boundary="00000000000012681506304f8710" --00000000000012681506304f8710 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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=E2=80=AFPM Will Reid 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 > > > > > > On Thu, Mar 13, 2025 at 8:19=E2=80=AFPM Joel Reyes 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 resu= lts >> 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=E2=80=AFPM w= rote: >> >>> 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 corr= ect >>> in NetSuite, I am copying FP&A to reply from the Planful side. @FPA >>> , please note this is an urgent request. >>> >>> >>> >>> *Thank you,* >>> >>> >>> >>> *Jamie Laurinovics* >>> >>> Assistant Accounting Manager | *TheKey* >>> >>> >>> >>> >>> >>> >>> >>> *From:* Will Reid >>> *Sent:* Thursday, March 13, 2025 1:52 PM >>> *To:* Laszlo Kovacs >>> *Cc:* jamie.laurinovics@thekey.com; Steve Sudberry ; >>> Geraldine Nath ; Timothy Thomas >> tt@thekey.com> >>> *Subject:* Re: Feb bonus >>> >>> >>> >>> Thanks Las