Home › Forums › Users › General User's Discussion ›

Benchmarking

Submitted by garry edgar on Tue, 18/06/2013 - 21:03
in

I thought some of you Open users might wish to run some benchmarking of financials.

I initially thought the people in WA might want to share.  The project I am working on uses the Species Sales report and the Patient Marketing Export Report. We wanted to investigate how well or poorly the different species(cats and dogs essentially) were going in our practice. In particular, whether there was any effect of having a cat shelter so close by too.

To get a good picture to compare, practices need to have a similar philosophy about how you bill items, eg surgery patients get billed hospital charges, theatre fees, drug fees, surgery fees etc, and not just lump charges that include all these things.

From there, you can compare the percentage of visits for cats or dogs, versus total. Then compare the different department categories(eg surgery, anaesthetic, vaccination etc) between the species too.

If the reporting is all done on a spreadsheet and kept in terms of percentages, then no sensitive financial data needs to be shared!

 

Happy to hear everyone's thoughts and also happy to hear from others interstate.

‹ Letters to clients Product Price List report ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: Benchmarking

Submitted by Ralph Hudson on Sat, 22/06/2013 - 14:54.

Hi Garry,

I would be happy to share info and compare benchmarks, sounds very useful,

Ralph

Re: Benchmarking

Submitted by garry edgar on Wed, 26/06/2013 - 11:26.

Here is the chart of what we ended up with. I can email anyone who wants it, the spreadsheet, but it appears I can not attach it here, pity. I have removed the $$ amounts and a few other items from the spreadsheet, but we were particularly looking for the sales as $ percentages for cats, campared to dogs. Once people had logged all the numbers into it, we could simply share the final percentage collumns.














2011/2012 Canine     Feline     Total     Cats    
  Times Units $ Times Units $ Times Units $ % of Times % of $$  
No Product Type 7 7   22 22   29 29   75.9% 42.9% No Product Type
Anaesthesia                       Anaesthesia
Boarding                       Boarding
Dentistry 228 893   81 340   309 1233   26.2% 21.2% Dentistry
Desex                       Desex
Drugs                   17.8% 14.8% Drugs
Euthanasia 162 162   68 68   230 230   29.6% 23.8% Euthanasia
Examination                       Examination
Flea products 329 332   172 172   501 504   34.3% 29.0% Flea products
Food                       Food
Groom- Groomer                   0.0% 0.0% Grooming-Groomer
Groom - Nurses 582 537.5   72 71.5   654 609   11.0% 19.0% Grooming - Nurses
Hospitalisation                   21.7% 19.8% Hospitalisation
Injections                   23.9% 22.4% Injections
Lab External 191 191   81 81   272 272   29.8% 24.7% Laboratory External
Lab Inhouse 494 549.5   222 254.5   716 804   31.0% 31.5% Laboratory Inhouse
Materials 1089 1600.2   276 1681   1365 3281.2   20.2% 16.4% Materials
Medical 3 3   1 1   4 4   25.0% 15.6% Medical
Merchandise 374 395.5   149 173   523 568.5   28.5% 29.1% Merchandise
Microchipping 33 33   72 72   105 105   68.6% 63.8% Microchipping
Normal 3 3         3 3   0.0% 0.0% Normal
Other 6 11         6 11   0.0% 0.0% Other
Proheart             533 533   0.0% 0.0% Proheart
puppy class 120 122.5         120 122.5   0.0% 0.0% puppy class
Surgery 289 288.15   69 100   358 388.15   19.3% 10.9% Surgery
Theatre 167 166.5   37 37   204 203.5   18.1% 12.4% Theatre
Ultrasound 23 23         23 23   0.0% 0.0% Ultrasound
Vaccination                   33.6% 35.4% Vaccination
Xray 184 221   48 53   232 274   20.7% 17.6% Xray
TOTAL 21035 69371.44   5838 15626.26   26194 87478.1   22.3% 22.9% TOTAL
                         
No of Patients                   31.3% 31.3% No of Patients
Syndicate content