Event Workspace · Deal 39978412845
APHSA - ISM 2026
9/27/2026 · John Meredith · APHSA · Spokane Convention Center · Active
✅Workbook — APHSA - ISM 2026 (Spokane)✅Sales quote — 11 areas✅Vendor quotes — PRG
✅Workbook
APHSA - ISM 2026 (Spokane) · linked by John Meredith on 08/31/2026 6:30 PM
Unlink this workbook
Stops this event reading crew, times and budget from APHSA - ISM 2026 (Spokane), and takes the sales push's quoted gear and shipping back off ROY. The workbook itself is not touched; the master Bookings and Conflicts tabs are rebuilt without it straight away. Link the right one afterwards.
✅Sales quote
Pushed — 406 charge lines across 11 areas.
✅Vendor quotes
1 vendor current: PRG
Vendor quote runs (current runs only)
| Vendor | Run date | Grand total | Overcharged | Saved | Matched / unmatched | Reaching margins |
|---|---|---|---|---|---|---|
| PRG | 08/31/2026 | $75,891 | $760 | $886 | 72 / 21 | $62,915 |
Reaching margins is this event's spend on that vendor's current Category Breakdown rows (16 rows in total). A dash means the run recorded none.
Sales quote by area (Clarity Charge History, 406 lines)
| Area | Last push | Gear (Clarity Charge History) | Whole quote (event tab, labor in) | No cost recorded | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Items | Charged | Cost | Gear GP | Revenue | Cost | Labor sold | Quote GP | |||
| General Session | 2026-08-31 | 128 | $336,770 | $69,045 | 79.5% | $227,844 | $166,845 | $133,557 | 26.8% | 2 items · $870 |
| Breakout | 2026-08-18 | 95 | $80,275 | $16,921 | 78.9% | — | — | — | — | 5 items · $98 |
| Breakouts | 2026-08-31 | 47 | $45,741 | $10,416 | 77.2% | $188,725 | $105,060 | $105,125 | 44.3% | — |
| Emerging Leaders | 2026-08-31 | 38 | $34,684 | $7,208 | 79.2% | — | — | — | — | 1 item · $39 |
| Exhibit Hall | 2026-08-31 | 19 | $12,015 | $2,926 | 75.6% | — | — | — | — | 1 item · $59 |
| Demo Theater | 2026-08-31 | 16 | $10,005 | $1,682 | 83.2% | $12,460 | $9,660 | $6,000 | 22.5% | 8 items · $4,550 |
| Speaker Ready Room | 2026-08-31 | 17 | $9,533 | $2,394 | 74.9% | — | — | — | — | — |
| i3 Stage | 2026-08-31 | 16 | $9,455 | $1,682 | 82.2% | — | — | — | — | 8 items · $4,000 |
| State & Local Forum | 2026-08-31 | 10 | $7,001 | $2,064 | 70.5% | — | — | — | — | — |
| HSITAG Luncheon | 2026-08-31 | 10 | $5,670 | $2,064 | 63.6% | — | — | — | — | — |
| Elevating Women in Human Services | 2026-08-31 | 10 | $5,670 | $2,064 | 63.6% | — | — | — | — | — |
| 08 26 26 APHSA ISM Exhibits (event tab only) | — | — | — | — | — | $25,386 | $16,294 | $18,039 | 35.8% | — |
| Whole show | 4 columns on the tab | — | — | — | — | $454,415 | $297,859 | $262,721 | 34.5% | — |
Blended GP of the whole show: 34.5% — $156,556 gross profit on $454,415 sold, with labor, cable and delivery in. Gross profit over revenue across the show, which is not the average of the areas' percentages. From the APHSA - ISM 2026 (Spokane) tab on the master Budget Builder.
Two questions. Gear GP is Clarity Charge History — equipment lines only, what each was charged against what it costs — so it says whether the gear is marked up enough. Quote GP is the quote's own forecast summary with labor, cable and delivery in, so it says what the area, and the show, actually earn.
6 areas with line items quoted at no cost
Cost here is Total Cost on Clarity Charge History, written by the sales push from the Quote tab's cost column — one row per line item. A line with no cost on the Quote tab can still be costed on that quote's Forecast tab: the Quote cost column above carries the Forecast tab's total, so the area is not necessarily short a cost. These are the lines to check against the rate card.
| Item | Lines | Revenue with no cost |
|---|---|---|
| 10 CH Corp Elite Headphones | 6 | $3,850 |
| Corporate Elite Headphone Single-Channel Transmitter | 2 | $700 |
| Item | Lines | Revenue with no cost |
|---|---|---|
| 10 CH Corp Elite Headphones | 6 | $3,300 |
| Corporate Elite Headphone Single-Channel Transmitter | 2 | $700 |
| Item | Lines | Revenue with no cost |
|---|---|---|
| Consumable Package | 2 | $870 |
| Item | Lines | Revenue with no cost |
|---|---|---|
| Spandex - Speaker Stand Cover - Black | 5 | $98 |
| Item | Lines | Revenue with no cost |
|---|---|---|
| Spandex - Speaker Stand Cover - Black | 1 | $59 |
| Item | Lines | Revenue with no cost |
|---|---|---|
| Spandex - Speaker Stand Cover - Black | 1 | $39 |
Sales quote pushes (Budget Paste WS)
| Area | Revenue | Cost | Gross profit | Sold-at GP % | Forecast GP % |
|---|---|---|---|---|---|
| $2,020.00 | $94,800.00 | $32,801.10 | $2,900.00 | 451898.0% | — |
| $30.30 | $18,039.00 | $2,933.45 | $15,105.55 | 385350.0% | — |
| $414.55 | $6,000.00 | $2,880.12 | $3,119.88 | 45000.0% | — |
| $353.50 | — | — | — | — | — |
| Whole show | $118,839.00 | $38,614.67 | $21,125.43 | 17.8% | 40.1% |
Forecast GP % is the producer's forecast for the whole show — the PRODUCER ESTIMATE block at the top of the Budget tab, every cost centre they have entered, labor included. A show figure, so it is on the show row only.
re-read just now