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 · $19.99

See what is inside 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: October 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