--000000000000f6b0b206304fa502 Content-Type: multipart/alternative; boundary="000000000000f6b0b106304fa501" --000000000000f6b0b106304fa501 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Will Correct! Thanks, *Diego Castaneda* Head of FP&A On Fri, Mar 14, 2025 at 12:06=E2=80=AFPM Will Reid 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 > > > > > > On Fri, Mar 14, 2025 at 11:59=E2=80=AFAM 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=E2=80=AFPM Will Reid wr= ote: >> >>> Thanks Joel. >>> >>> Here are my original questions regarding staff bonuses: >>> >>> Feb EBITDA for our Cincinnati office is 26.1% per Planful today. Is thi= s >>> 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 wh= at >>>> the original ask is, but this should have a summary of all relevant re= sults >>>> 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 = wrote: >