WB WorkbookBarn All workbooks

Free calculator · nothing to download

Agent Production Planner

Type in the blue cells. The chain on the right rebuilds itself as you go.

WHAT YOU WANT TO EARN
LISTING SIDE
BUYER SIDE
HOW YOU ACTUALLY WORK

THE GOAL

Gross commission you must earn
...of which comes from listings
...of which comes from buyers

LISTING SIDE, WORKED BACKWARDS

You keep this much per listing sold
Listings that must close
Listings you must sign
Listing appointments you must hold
Listing leads you must generate

BUYER SIDE, WORKED BACKWARDS

You keep this much per buyer closing
Buyer sides that must close
Buyer agreements you must sign
Buyer appointments you must hold
Buyer leads you must generate

THE WEEK IN FRONT OF YOU

Closings for the year
Closings per month
Average gross commission per closing
New leads to generate each week
Appointments to hold each week
CONVERSATIONS EACH WEEK
Spare capacity each week
Conversations per working day (5-day week)

Weekly Plan

One row per week. Log what you actually did. Target and gap fill themselves in.

Week startingConversationsNew leadsAppts setAppts heldAgreements signedUnder contractClosingsCommission bankedConversation targetAhead / behindWhat happened this week
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

Where that leaves you

Want it as a spreadsheet you own?

The full workbook adds the tabs this page cannot: a monthly log, a dashboard with charts, and your own copy that works offline in Google Sheets or Excel. One purchase, no subscription.

Get the workbook

Keep it

Agent Production Planner — the full workbook

Same formulas as this calculator, plus the tabs, the charts and a 12-month history that this page cannot hold. Google Sheets and Excel. One purchase, no subscription.

Buy on Etsy · $19.99What is inside →

Email me these results

We'll send this result plus the matching worksheet. No spam, unsubscribe anytime.

Last updated: August 2026

Educational estimates only. These calculators and workbooks do the arithmetic on the figures you enter; they are general-purpose tools, not financial, investment, tax, legal, lending, insurance or construction advice, and no result is a quote, an offer, or a guarantee of any outcome. Results depend entirely on your inputs and assumptions. Verify anything you intend to rely on with a licensed professional — a CPA, attorney, lender, licensed contractor, or your own agent. WorkbookBarn and Marcos Gil accept no liability for decisions made using these tools. Marcos Gil is a licensed Kentucky real estate agent (License No. 296259) and is not a lender, CPA or attorney.

WorkbookBarn · All free calculators · Workbooks