How Many Employees Can I Afford to Pay Excel Model

January 8, 2020

Waiters working in a restaurant

Second Shutdown Labor Model

Our team has created a simple Excel model that calculates how many employees your business can afford based on your expenses during “normal times.” It is broken down month-by-month through the beginning of 2021 to allow you to be more flexible when assessing your situation. We have also provided a range of different revenue projections for these months, as we understand your revenue during the pandemic might not meet pre-pandemic expectations.

Keep in mind that the number of employees this model calculates is based on your average cost per employee — because of this, we also highlight the total amount available to spend on employees after accounting for expenses in case you have multiple pay scales.

Second Shutdown Labor Model screenshot

How to Download the Labor Model

  1. Access interactive Excel spreadsheet here.
  2. Go to File > Save As > Download a Copy to download your own copy of the Excel spreadsheet
  3. Follow along with the instructional video below and start inputting your data

Follow Along with Our Instructional Video