MBA Key Metrics Spreadsheet Project

For those of you who are new to practice metrics, the Management & Business Academy’s (MBA) Key Metrics: Assessing Optometric Practice Performance guide is your primary resource to help obtain performance indicators of your practice.   You can register and download the latest 2015 guide HERE.
Link updated 2016.02.17. DISCLAIMER: I am not affiliated with the Management & Business Academy.
If you have a physical copy of the guide, there is a worksheet that is included in the centerfold.  This worksheet is pretty straight-forward to follow, but requires some experience running reports in your practice management software (Officemate, Revolution, CrystalPM, Maximeyes, etc…), financial software (Quickbooks), payroll/time-clock records (Paychex, Intuit Payroll, ADP, HRforHealth, Time-in-a-box), etc.


If you are comfortable obtaining information from the necessary reports, what I have done is taken the guesswork out of the calculations and I have created an easy to fill spreadsheet that will auto-calculate your Key Metrics.  I originally created this spreadsheet in 2013 and have refined it dozens of times to help visualize and easily obtain these metrics.
Key Metrics Worksheet
  • If you have the included worksheet and you have completely filled it out on paper, you can simply enter your values for the past three years and it will obtain your conversion rates automatically.   
  • If you don’t have the worksheet, don’t worry- you can enter the values directly into the spreadsheet.

Automatically Generated Report
The auto report will take the worksheet figures and automatically calculate your Key Metrics and allow you to compare them from year to year.
Automatically Generated Charts
In addition to the reports, I have created two automatically generated charts which will help you compare and visualize your office performance.
Additional Worksheet Options
I have also included extra figures in the spreadsheet, which are not necessary to complete the worksheet, but will allow you to view other figures discussed about in the MBA Key Metrics Guide.
Future features
  • Automatically Generated Recommended Actions: The MBA Key Metrics guide has recommended actions for certain combination of figures.  I am in the process of incorporating those recommended actions to automatically calculate.
  • Additional Charts: At the moment, I only have charts for: Gross Revenue per Complete Exam and Chair Cost per Complete Exam.  I don’t plan on creating all the charts listed on the MBA Key Metrics guide, but will add about three to five more important charts.
Interested?
The current spreadsheet is in Google Sheets format and is currently under development.  Once completed, I will be offering the final spreadsheet for FREE and will post it here.
I would like your help and suggestions on making a better Key Metrics Spreadsheet before I release it.  If you are interested in obtaining an early version of the spreadsheet, please fill out this FORM.  
What you need:
  • You will need a Gmail or Google Apps email account to access the Google Sheet
  • Fill out interest form here
  • Basic Excel, Google Sheets, and/or Spreadsheet knowledge
  • Copy the main spreadsheet.  Once you have access, please Make a Copy.  You are free to use this spreadsheet for whatever you want.  
    • I am offering this spreadsheet without any guarantee or support (I will not respond to basic spreadsheet support requests).  I do have plans on creating step-by-step guides on editing and running reports to assist filling out the worksheet in the future.
  • Provide feedback.  The Key Metrics Project spreadsheet will be shared as Comment-Only.  If you would like to report an issue/glitch/error/fix, please highlight the field(s) in question and click on Comment, on the upper right hand corner.

Comments

Post a Comment

Popular posts from this blog

4 Steps to Creating your Procedure Manual in Google Docs

Image
Looking to create your own Procedure Manual? In my last article, A "Clickable" Procedure Manual ,  I showed you how a clickable manual could be used in your office.  This guide will show you how you can make a procedure manual from scratch using Google Documents. It is a fairly simple (but lengthy) process and you will need to be familiar with my previous Guide on Making a Guide on Google Docs  before proceeding. Click to Download or Print your FREE Guide: 4 Steps to Creating Your Procedure Manual in Google Docs
Read more

A "Clickable" Procedure Manual

Image
***Update April 18,2016*** Learn how to make your own! A new post on 4 Steps to Creating your Procedure Manual in Google Docs I recently read an article by Neil B. Gailmard, OD on Your Office Procedure Manual (2010) which has a lot of good tips on: Why you should have a procedure manual How to Start a Manual What to Exclude What you might Include However, I did not agree with the line in his last paragraph where he states that, “every office is so different that I strongly recommend that you write your own from scratch.”  It’s true, every office has their own unique workflow- but every office shares the ability to categorize duties by either patient workflow and/or department . Think about all the duties in your practice.  They can either involve interaction with a patient or a specialized duty performed by a department in your practice.  Although these duties may coincide in both patient workflow and department, categorizing them in this manner will force yo
Read more

Metrics - Patient Response Button Fix

Image
A Patient Response Button (aka "The Clicker") for our Zeiss FDT went out again at our office and I decided to see what the problem was.   When I took it apart, I found that it was a very simple fix.  In this post, I will show a quick fix to get your Patient Response Button back up and running.  A quick fix if you’re waiting for the replacement from Zeiss ($35 plus shipping).  Disclaimer:  Although this is a VERY simple electronic fix, please do so at your own risk.  I will not be held responsible for any damage caused by using this fix. The Problem: the most common failure of the button is caused from normal wear and tear and occurs when the rubber end-piece separates and causes the jumper to separate from the jumper cable (displayed below). What you need Heatshrink (works wonders on temporary frame repairs also) - a half inch piece of the second from the biggest size should be perfect Super glue Lighter or other heatsource A Phillips Screwdriver
Read more

A Guide On Making A Guide in Google Docs

Image
I love making guides.  I make guides at work in order to provide step by step instructions on how to perform new tasks on new features.  I have over 50 guides that cover most departments in our office. I like to show exactly where to click, what fields need to be filled out and in which order they need to be done.  Making guides are not only informative for the individuals they are intended for, but are very helpful for those creating them to further evaluate the system into a well-thought-out, streamlined process. A Skitch Screenshot What You Need To create a guide you will need three things: A Word Processor  (i.e. Microsoft Word , Google Docs , LibreOffice ) A Method to take a Screenshot  (i.e.   Skitch , Greenshot , PrintScreen Button, or Windows Snipping Tool) A Method to Annotate Your Screenshot (i.e. Skitch , Greenshot , or Microsoft Paint) For this article, I will use Google Docs, Skitch, and the PrintScreen Button.  The reason I love this trio is bec
Read more