The tour budget, the merch, the VIP packages and what the company actually earns. Nothing here is pasted: change the show count or the guarantee and all four re-solve, commissions included.
| # | Line | How it is worked out | Share | As filed | Value | Variance |
|---|---|---|---|---|---|---|
| Income | ||||||
| 1 | Show incomeeditable | 32 × $10,853.18 | $268,362.81 | $347,301.87 | ▲ $78,939 | |
| 2 | Production buyout | 32 × $500 | $16,000.00 | $16,000.00 | ||
| 3 | VIP | $25,000 at 32 shows | $25,000.00 | $25,000.00 | ||
| 4 | Merch grosseditable | entered by the band, not in the file | — | $80,000.00 | ||
| 5 | Total income | shows + buyout + VIP + merch | $309,362.81 | $468,301.87 | ▲ $158,939 | |
| Payroll | ||||||
| 6 | Band wages | 5 × $2,000/wk ÷ 7 × 47d | — | $67,142.86 | ||
| 7 | Per-show bumps | 14 × $100 | — | $1,400.00 | ||
| 8 | Tour manager | $1,500/wk ÷ 7 × 47d + advance | — | $12,071.43 | ||
| 9 | Production assistant | $1,550/wk ÷ 7 × 47d | — | $10,407.14 | ||
| 10 | FOH engineer | $2,000/wk ÷ 7 × 47d | — | $13,428.57 | ||
| 11 | Rehearsals | 6 × $1,000 | — | $6,000.00 | ||
| 12 | Crew payroll | sum of the six above | $110,450.00 | $110,450.00 | ||
| Travel & lodging | ||||||
| 13 | Per diems | 47d × 9 × $30 | $12,690.00 | $12,690.00 | ||
| 14 | Hotels | 92 nights × $189.75 inc. tax | $17,457.00 | $17,457.00 | ||
| 15 | Ground transport | bus + fuel scaled + 47d parking + rideshare | $93,862.00 | $93,862.00 | ||
| 16 | Airfare & baggage | $9,340 + $2,000 bags | $11,340.00 | $11,340.00 | ||
| Production & other | ||||||
| 17 | Production | $85/d supplies + gear + freight | $16,600.00 | $16,600.00 | ||
| 18 | State withholding | 1.182% of show income | — | $4,104.93 | ||
| 19 | Misc & withholding | withholding + marketing + meals | $11,214.90 | $11,214.93 | ||
| 20 | Contingency | 5% of payroll + travel | $12,289.95 | $12,289.95 | ||
| Commissions | ||||||
| 21 | Management | 15% of shows + VIP | $44,004.42 | $55,845.28 | ▲ $11,841 | |
| 22 | Agent | 10% of shows | $26,836.28 | $34,730.19 | ▲ $7,894 | |
| 23 | Business manager | 4% of shows + VIP | $11,734.51 | $14,892.07 | ▲ $3,158 | |
| 24 | Commissions | management + agent + BM | $82,575.21 | $105,467.54 | ▲ $22,892 | |
| Merch | ||||||
| 25 | Cost of goodseditable | entered by the band, not in the file | — | $50,000.00 | ||
| 26 | Merch net | gross − COGS | — | $30,000.00 | ||
| Where it lands | ||||||
| 27 | Total expenses | every expense above, ex merch COGS | $368,479.07 | $391,371.43 | ▲ $22,892 | |
| 28 | Net on shows | income ex merch − expenses | −$59,116.26 | −$3,069.56 | ▲ $56,047 | |
| 29 | True net, with merch | show net + merch net | −$59,116.26 | $26,930.44 | ▲ $86,047 | |
| 30 | Per principal | (true net − 7% × 2) ÷ 3 | — | $7,720.06 | ||
| # | Line | How it is worked out | Share | Cost | Value | Margin |
|---|---|---|---|---|---|---|
| What sold | ||||||
| 1 | Tee — black logo | 900 × $35.00 | $8,550.00 | $31,500.00 | ▲ $22,950 | |
| 2 | Tee — tour dates, washed | 380 × $40.00 | $4,180.00 | $15,200.00 | ▲ $11,020 | |
| 3 | Hoodie — embroidered | 150 × $75.00 | $3,900.00 | $11,250.00 | ▲ $7,350 | |
| 4 | Crewneck | 55 × $65.00 | $1,210.00 | $3,575.00 | ▲ $2,365 | |
| 5 | Cap — low profile | 120 × $30.00 | $1,020.00 | $3,600.00 | ▲ $2,580 | |
| 6 | Tote | 80 × $25.00 | $440.00 | $2,000.00 | ▲ $1,560 | |
| 7 | Poster — screenprint | 220 × $25.00 | $935.00 | $5,500.00 | ▲ $4,565 | |
| 8 | Vinyl LP | 120 × $35.00 | $1,440.00 | $4,200.00 | ▲ $2,760 | |
| 9 | Sticker pack | 180 × $8.00 | $198.00 | $1,440.00 | ▲ $1,242 | |
| 10 | Koozie | 95 × $12.00 | $209.00 | $1,140.00 | ▲ $931 | |
| 11 | Keychain | 85 × $7.00 | $119.00 | $595.00 | ▲ $476 | |
| 12 | Gross merch sales | 2385 units across 32 shows | $22,201.00 | $80,000.00 | ▲ $57,799 | |
| What it cost | ||||||
| 13 | Product cost | what the goods cost to make | — | $22,201.00 | ||
| 14 | Venue merch cuts | 12% of gross | — | $9,600.00 | ||
| 15 | Merch seller | 32 shows × $150 | — | $4,800.00 | ||
| 16 | Merch manager | 10% of gross | — | $8,000.00 | ||
| 17 | Freight & fulfilment | print runs, shipping, restocks | — | $3,079.00 | ||
| 18 | Card processing | 2.9000000000000004% of gross | — | $2,320.00 | ||
| 19 | Total cost of goods | product + selling costs | — | $50,000.00 | ||
| What is left | ||||||
| 20 | Merch net | gross − cost of goods · 37.5% margin | — | $30,000.00 | ||
| 21 | Per show | merch net ÷ 32 shows | — | $937.50 | ||
| 22 | Per head | gross ÷ 400 heads × 32 | — | $6.25 | ||
| # | Line | How it is worked out | Share | Value | ||
|---|---|---|---|---|---|---|
| What sold | ||||||
| 1 | VIP packages | 15/show × 32 × $100 | $48,000.00 | |||
| 2 | Packages sold | 15 per show | 480 across the run | |||
| What the room took back | ||||||
| 3 | Venue VIP room fee | 32 × $150 | $4,800.00 | |||
| 4 | Security & extra staff | 32 × $120 | $3,840.00 | |||
| 5 | VIP host / runner | 32 × $100 | $3,200.00 | |||
| 6 | Laminate & print | 480 × $9.50 | $4,560.00 | |||
| 7 | Signed poster | 480 × $4.25 | $2,040.00 | |||
| 8 | Drink ticket | 480 × $3.50 | $1,680.00 | |||
| 9 | Ticketing platform | 6% of gross | $2,880.00 | |||
| 10 | Total VIP costs | venue, staff, package contents, platform | $23,000.00 | |||
| What is left | ||||||
| 11 | VIP net | gross − costs · 52.1% margin | $25,000.00 | |||
| 12 | Per show | VIP net ÷ 32 shows | $781.25 | |||
| 13 | Per package | VIP net ÷ 480 packages | $52.08 | |||
| # | Line | How it is worked out | Share | Value | ||
|---|---|---|---|---|---|---|
| The road | ||||||
| 1 | Show income | 32 shows | $347,301.87 | |||
| 2 | Production buyout | 32 × $500 | $16,000.00 | |||
| 3 | VIP, net | from the VIP sheet | $25,000.00 | |||
| 4 | Merch, net | from the merch sheet | $30,000.00 | |||
| 5 | Tour costs | crew, travel, production, contingency | −$391,371.43 | |||
| 6 | Tour earnings | what the run actually made | $26,930.44 | |||
| 7 | Player points | 7% × 2 touring players | −$3,770.26 | |||
| 8 | Road, to the company | tour earnings − player points | $23,160.18 | |||
| The catalogue, a year of it | ||||||
| 9 | Distributor — recorded | $6,000/mo × 12 | $72,000.00 | |||
| 10 | Label services — recorded | $5,000/mo × 12 | $60,000.00 | |||
| 11 | Publishing admin — publishing | awaiting a statement | quarterly, not yet entered | |||
| 12 | Management on royalties | 15% of all gross, touring or not | −$19,800.00 | |||
| 13 | Catalogue, net | royalties − management | $112,200.00 | |||
| Running the company | ||||||
| 14 | Studio rent | $500/mo × 12 | −$6,000.00 | |||
| Everything, together | ||||||
| 15 | Company earnings | road + catalogue − overhead | $129,360.18 | |||
| 16 | Per principal | three equal owners | $43,120.06 | |||
| 17 | Draws already taken | 3 × $2,000/mo × 12 | −$72,000.00 | |||
| 18 | Left in the company | after the monthly draw | $57,360.18 | |||
This is an example budget — a real 32-show winter run, held as four sheets. The merch and VIP sheets are not summaries of the tour sheet; they feed it. Every figure is solved from rules rather than pasted, so changing the show count or the guarantee re-solves all four at once, commissions included. On the tour sheet, As filed is what the original spreadsheet reported — where it disagrees, the gap is shown rather than hidden: the filed income total stops eight shows short of the run, and merch is missing from it altogether.