| # | Line | How it is worked out | Share | As filed | Live | Variance |
|---|---|---|---|---|---|---|
| Income | ||||||
| 1 | Show incomeeditableThe file’s SUM(D6:D48) stops at row 48 — eight shows short | 32 shows × $10,853.18 | $268,362.81 | $347,301.87 | ▲ $78,939 | |
| 2 | Production buyout | 32 × $500 per show | $16,000.00 | $16,000.00 | ||
| 3 | VIP / Artist Arrival | $25,000 scaled to 32 shows | $25,000.00 | $25,000.00 | ||
| 4 | Merch grosseditableMerch appears nowhere in the budget | confirmed by Robby | — | $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 × 47 days | — | $67,142.86 | ||
| 7 | Per-show bumps | 14 shows × $100 | — | $1,400.00 | ||
| 8 | Tour manager | $1,500/wk ÷ 7 × 47 + $2,000 advance | — | $12,071.43 | ||
| 9 | Production assistantRobby confirmed David at $1,750/wk — the file says $1,550 | $1,550/wk ÷ 7 × 47 days | — | $10,407.14 | ||
| 10 | FOH engineer | $2,000/wk ÷ 7 × 47 days | — | $13,428.57 | ||
| 11 | Rehearsals | 6 days × $1,000 | — | $6,000.00 | ||
| 12 | Crew payroll | sum of the six lines above | $110,450.00 | $110,450.00 | ||
| Travel & lodging | ||||||
| 13 | Per diems | 47 days × 9 heads × $30 | $12,690.00 | $12,690.00 | ||
| 14 | Hotels | (47−2 + 47) nights × $189.75 inc. 15% tax | $17,457.00 | $17,457.00 | ||
| 15 | Ground — bus, fuel, parking | bus $73,452 + fuel $13,000 scaled, + 47 × $30 + rideshare | $93,862.00 | $93,862.00 | ||
| 16 | Airfare & baggage | $9,340 + $2,000 | $11,340.00 | $11,340.00 | ||
| Production & other | ||||||
| 17 | Production | 47 × $85 supplies + backdrop + 47 × $115 + freight | $16,600.00 | $16,600.00 | ||
| 18 | State withholding23 of 32 shows have no withholding entered | 1.1819% of show income (blended) | — | $4,104.93 | ||
| 19 | Misc — withholding, marketing, meals | withholding + $1,000 + 47 × $130 | $11,214.90 | $11,214.93 | ||
| 20 | Contingency | 5% of payroll, per diems, hotels, ground, airfare | $12,289.95 | $12,289.95 | ||
| Commissions | ||||||
| 21 | Management — Brad | 15% of show income + VIP | $44,004.42 | $55,845.28 | ▲ $11,841 | |
| 22 | Agent | 10% of show income | $26,836.28 | $34,730.19 | ▲ $7,894 | |
| 23 | Business manager — Cam | 4% of show income + VIP | $11,734.51 | $14,892.07 | ▲ $3,158 | |
| 24 | Commissions | management + agent + business manager | $82,575.21 | $105,467.54 | ▲ $22,892 | |
| Merch | ||||||
| 25 | Cost of goodseditable | confirmed by Robby | — | $50,000.00 | ||
| 26 | Merch net | gross − COGS | — | $30,000.00 | ||
| Where it lands | ||||||
| 27 | Total expenses | every expense line above, excluding merch COGS | $368,479.07 | $391,371.43 | ▲ $22,892 | |
| 28 | Net on the shows alone | total income (ex merch) − total expenses | −$59,116.26 | −$3,069.56 | ▲ $56,047 | |
| 29 | True net, merch included | show net + merch net | −$59,116.26 | $26,930.44 | ▲ $86,047 | |
| 30 | Per principal, after player points | (true net − 7% × 2 players) ÷ 3 | — | $7,720.06 | ||
Every figure in the Live column is solved from rules, not pasted — crew payroll, per diems, hotels, ground, airfare, production and contingency all reproduce your own spreadsheet to the cent. As filed is what Tour Budget MCH 2026 Winter v3.xlsx itself reported. The two disagree in three places: the income total stops eight shows short of the run, merch appears nowhere, and the PA is carried at the old weekly rate. Change a number in the bar above and every dependent line re-solves the way your formulas would.