Hi Teresa,
I ended up creating it long hand. I found a template for a budget in Google forms that did some of the math for me and made adjustments to some of the formulas if they didn't quite fit my needs. It saved me some time. Then I used some things in articles I found online about mobile clinic costs (these were mostly for general practice mobile units) and revenues, I compared that to the itemized inventory I had created for the supplies I would have on the unit. I projected how many cases I could get through of various types to figure out a rough guess of how often I would reorder and what, keeping in mind the space restrictions on the unit. Factored in the salary/ fringe for tech(s), etc. I got a maintenance quote from the manufacturer of the unit for that budget item. Fuel was calculated based on the MPG of the specific unit from the manufacturer and the projected monthly mileage based on the areas that I would be taking the unit, and then current cost of fuel at the time I wrote the budget. I projected these costs a little generously to give myself some room for error.
For the revenues part, it was a little harder to project because I have no historic client numbers to pull from. I used US 2020 Census data and AVMA demographic data to project my potential clientele by county (total population, then pet owning households in my area, dog and cat owning households that use low cost / mobile service, etc.) I am specifically looking to provide low to no cost services so I did a search for my region as far as what the pricing range is for other low cost practices in this area when I was setting prices to project potential revenue. Pricing was also based on the costs for the inventory I had created. Lots of organizations post their prices on their websites for their clients so I could see if I was in line with the area. Bottom line is that it was all projected since I have no historic data to pull from. I guess we will see how close I am after it all comes together for the next budget year.
I can't share my actual documents because they belong to my employer but that was my process. Hope this helps, you can email me if this just created more questions. :)
------------------------------
Kirsten White, DVM
Clinical Assistant Professor, Shelter Medicine
School of Veterinary Medicine of Rowan University
Mullica Hill, NJ 08062
856-256-5986
whitekk@rowan.edu------------------------------
Original Message:
Sent: 02-09-2023 02:10 PM
From: Teresa McKernan
Subject: Mobile Clinic Operational Budget
Dear Kirsten,
Did you get any information? Would you be able to share what you learned?
Thanks
Teresa
------------------------------
Teresa McKernan
Senior Direction, Veterinary Services
BC SPCA
------------------------------