Call Center Staffing Model

This staffing model in Excel helps estimate the number of agents you need to answer the phones. Plan your your staffing model to balance agent utilization against the average waiting time for a caller.

This model considers the amount of calls by hour, the number of agents, and the length of a phone call. You can adjust these inputs to see impact on average waiting time and agent utilization.

For more background about call center staffing and operations research consider reading this entry on Wikipedia. This Excel staffing model is designed to be more simple and easy to use for estimating staffing levels and call center service levels. If your call center demands are more sophisticated (such as mixing inbound and outbound calls, using predictive dialers, or more than 30 agents simultaneously) we suggest hiring a specialist to analyze your call center operations.

What’s Included

  • Full unlocked model in Excel: save, update, customize, and more
  • Instant access link
  • 100% satisfaction guaranteed or receive a full refund
  • Free lifetime upgrades for this model

Requirements: Microsoft Excel 2007 and above

Rent Roll

This rent roll dashboard in Excel was built for a client who owns commercial property. The property owner sublets to multiple tenants who pay weekly rent. This rent roll is used as a simple dashboard to manage the business with the on-site property manager.

What Is A Rent Roll?
A rent roll (definition) is a document to manage leased property. It shows a list of units, the tenants, the rent charged for each unit, and lease expiration date. A rent roll can be used for residential or commercial properties. Uses for residential rent rolls could include duplexes, fourplexes, or apartment complexes. Commercial rent roll uses could include retail subletting, storage facilities, or office space rentals.

How The Rent Roll Excel Model Is Used To Manage Client’s Business

  • Property manager tracks rent paid each week
  • Tenants receive printed receipts with history of rent payments
  • Property manager monitors expiring leases and professional licenses
  • Owner compares rent paid by week to bank deposits
  • Owner monitors occupancy levels for any risk*

What You Get

  • Full unlocked model in Excel — save, update, customize, and more
  • Instant access link
  • 100% satisfaction guaranteed or receive a full refund
  • Free lifetime upgrades for this model

*Bonus Tip: The owner found staggering leases reduced risk substantially. He found the easiest way to stagger leases is to offer a renewal discount on the tenant’s birthday.