Skip to content

Dealer Group Marketing Budget Planner

Alternative to marketing budget spreadsheet, dealer marketing budget template, co-op tracker

Plan monthly marketing spend by store and vendor, compare actual results, and model a budget shift in one workbook.

Instant downloadby RedlineWorksSource code, source code download
Read-onlyNo customer data
Harborview Auto Group's synthetic January to June summary shows $796,320 planned, $812,662 actual and store-level variances.
The Plan preview shows Harborview Kia's first nine monthly Listing partner budgets with editable amounts highlighted in amber.
A $500 vendor shift for Harborview Kia shows trailing evidence, unchanged combined budget and projected lead and sales changes.
A bar chart compares planned and actual January to June marketing spend for four fictional Harborview Auto Group stores.

TL;DR

  • Monthly budgets by store, vendor and category
  • Group and store rollups with clear variance and efficiency measures
  • Co-op estimates and a vendor budget shift model
  • Example and blank Excel workbooks with optional local import tools
  • $149 once for one dealer group, including any number of its stores

Quick facts

Alternative to
marketing budget spreadsheet, dealer marketing budget template, co-op tracker
Works with
Microsoft Excel, Google Sheets, Claude Code, OpenAI Codex
Best for
Dealer group marketing directors preparing monthly spend reviews, GMs comparing planned spend with store results, Agencies managing budgets for the licensed dealer group
Delivery
Source code download

Bring store plans and monthly vendor results into a shared budget review. This downloadable Excel workbook rolls up planned spend, actual spend and variance for the group and each store. It also calculates cost per lead, cost per attributed sale, spend per unique unit sold, and budget as a percent of gross profit when gross is entered.

Set up stores and vendors, enter budgets, and paste monthly actuals. Estimate co-op reimbursement with your own shares, rates and caps. Use What-if to move dollars between two vendors and compare projected leads and sales using their trailing efficiency. Projections assume that efficiency continues. They do not establish causal lift or promise results.

The $149 one-time purchase includes a synthetic Harborview Auto Group example, a blank workbook, a reproducible generator, a validated CSV importer, and instructions for Claude Code and OpenAI Codex. One license covers one dealer group and any number of its stores. The included files have four stores and nine vendors; the generator can create a different size. Standard formulas were recalculated with LibreOffice. Native Google Sheets import and Excel desktop behavior were not directly tested.

What it does

  • Twelve-month fiscal calendar with configurable store, brand and vendor lists
  • Plan grid and paste-friendly monthly Actuals inputs
  • Matching-period planned versus actual totals and overspend formatting
  • Separate attributed sales and unique store units to keep cost measures distinct
  • Gross profit ratios that require complete selected-period gross inputs
  • Co-op eligible spend, expected reimbursement and optional row caps
  • What-if comparison using trailing cost per sale and leads per sale
  • Editable charts, dropdowns, frozen headers, print settings and protected formula cells
  • CSV validation, duplicate checks, new-file imports and input-based variance reports

What you get

  • Synthetic example and blank .xlsx workbooks
  • Python workbook generator and example group configuration
  • CSV importer, workbook reader and synthetic example export
  • Optional LibreOffice recalculation script and zip builder
  • Claude Code skill, Codex AGENTS.md, setup guide and formula definitions
  • Single dealer group license and release verification notes

How you get started

Buy once. Enter one dealer at checkout for setup help.

  1. 1

    Download the zip

    YouAt signup

    Find it in Purchases right after checkout.

  2. 2

    Open the workbook

    YouAt signup

    Open the blank workbook in Excel or import it into Google Sheets.

  3. 3

    Set up your group

    YouAt signup

    Fill in Setup, then build your plan.

Setup

What you need

  • Excel with XLSX and SUMIFS support, or Google Sheets for importing the file
  • Monthly aggregate spend, leads and attributed sales with consistent store and vendor names
  • Unique monthly store units sold, plus gross profit if you want gross-based ratios
  • Python 3.10+ and openpyxl for the optional generator, importer and reader
  • LibreOffice for optional headless recalculation. Node.js 20+ only for rebuilding the zip
  • Your own Claude Code or OpenAI Codex access if using an agent. Neither is required to edit the workbook

Steps

  1. 1Open the example
  2. 2Configure a working copy
  3. 3Enter the plan and actuals
  4. 4Review the same period
  5. 5Compare a shift

Follow the setup guide in your account after purchase.

How it connects

Connection and access details provided by the publisher.

How this tool connects to each system
SystemConnection
Your spend and lead exportsYour own export

You paste or import your own exports. No connections.

Security review

The publisher has not provided a security review.

Dealer reviews

Write a review

Only dealers that piloted or bought this tool can review it.

No reviews yet. Finish a pilot or buy this tool to leave a dealer review.

Questions

The builder answers pre-sale questions in public.

No questions yet.

Ask a public question

Common questions

Why does a ratio show n.a.?

Its denominator is zero or required store-month units or gross are missing. Enter complete values for the selected period. Known zero and missing are different.

Why was my CSV rejected?

Use the exact six-column header in the example, month-start dates, Setup names, complete nonnegative numeric fields and unique monthly keys. Counts must be whole numbers.

Can I correct an imported month?

Yes. Use a reviewed correction file and --mode replace-key with a new output path. Matching records are replaced. Unmentioned records are preserved.

Why is the What-if result unavailable?

Check the scenario status. It needs two vendors, complete trailing monthly history with positive totals, a trailing end before the target month, and a shift within the source budget.

Can I use Google Sheets?

The workbook uses common formulas and can be imported as XLSX. Check the example totals after import and reapply range protection. Native import, chart formatting and protection behavior were not directly tested for this release.

Why are calculated cells empty after a script import?

The importer preserves formulas but does not calculate them. Open in Excel or Sheets, or run the included LibreOffice recalculation command. The reader can still calculate its report from input cells.

Changelog

1.0.0

Initial release. Includes example and blank workbooks, nine sheets, native charts, co-op estimates, vendor shift modeling, reproducible generation, validated CSV import and shared agent instructions.

Dealer Group Marketing Budget Planner

$149one-time
Checkout opens soon