- Events
- 25
- Revenue
- $25,078.79
- Giveback
- $7,179.35
- COGS
- $201.98
- Labor
- $1,737.70
- Marketing
- $0.00
23 pending
Hours pending · Revenue split
Profit is not finished. Cup mix is still missing on 99 events, so those events deduct $0 of COGS. Where a tally is loaded, cash cups use the same mix as prepay. Labor hours are missing on 29 events, so labor stays at $0 instead of $15.50 per hour.
Same-day schools split labor by revenue. Hours are the Kona OS shift card for that calendar date, prep and close in one punch. Logan’s owner account is left out when staff clocked in. A day with one school keeps the full card. A day with more than one school gives each school a share of those hours in proportion to its revenue, so the crew is counted once. The split can still place hours on the wrong school until the match uses assigned staff and event time. 45 events in this view use a revenue split. Source: Kona OS Employee Shift Card exports 2023-08 through 2026-09; same-day multi-school allocated by revenue share.
Sales tax is missing on 13 events and counts as $0 in the profit bars.
By school
Open a school for each Kona Day. School-year marketing is on the school total and is not split across dates.
| Parkway Elementary75067 · 2023-24, 2024-25, 2025-26, 2026-27 · COGS pending on 23 · hours pending on 7 · revenue split on 13 | 25 | $25,078.79 | $7,179.35 | $201.9823 pending | $1,737.70Hours pending on 7Revenue split | $0.00 | $15,959.76 | |
| Degan Elementary75077 · 2024-25, 2025-26, 2026-27 · COGS pending on 19 · hours pending on 4 · revenue split on 10 | 20 | $19,537.88 | $5,339.57 | $101.5819 pending | $1,754.60Hours pending on 4Revenue split | $0.00 | $12,342.13 | |
| Vickery Elementary75028 · 2025-26, 2026-27 · COGS pending on 8 · hours pending on 3 · revenue split on 1 | 10 | $17,413.78 | $4,927.22 | $400.498 pending | $1,365.07Hours pending on 3Revenue split | $0.00 | $10,721.00 | |
| Morningside Elementary75056 · 2025-26, 2026-27 · COGS pending on 8 · hours pending on 3 · revenue split on 5 | 10 | $14,591.62 | $3,369.21 | $289.588 pending | $1,013.25Hours pending on 3Revenue split | $0.00 | $9,919.58 | |
| Rockbrook Elementary75067 · 2025-26, 2026-27 · COGS pending on 11 · hours pending on 1 · revenue split on 9 | 12 | $14,972.84 | $4,123.54 | $119.1411 pending | $885.53Hours pending on 1Revenue split | $0.00 | $9,844.63 | |
| DeLay Middle School75057 · 2024-25, 2025-26, 2026-27 · COGS pending · hours pending on 9 · revenue split on 2 | 16 | $8,723.69 | $2,451.31 | Pending | $1,177.23Hours pending on 9Revenue split | $0.00 | $5,095.15 | |
| BB Owen ElementaryInactive75056 · 2024-25 · COGS pending on 7 · hours pending on 2 · revenue split on 3 | 8 | $4,714.08 | $1,382.97 | $78.047 pending | $469.66Hours pending on 2Revenue split | $0.00 | $2,783.41 | |
| Universal AcademyInactive75019 · 2024-25 · COGS pending | 2 | $2,279.42 | $497.44 | Pending | $222.12 | $0.00 | $1,559.86 | |
| Lakeview Middle School75056 · 2025-26, 2026-27 · COGS pending · revenue split on 2 | 3 | $2,136.86 | $433.84 | Pending | $183.68Revenue split | $0.00 | $1,519.34 | |
| Central Elementary School2026-27 · COGS pending | 1 | $1,614.00 | $380.56 | Pending | $117.18 | $0.00 | $1,116.26 | |
| Lewisville Elementary75067 · 2026-27 · COGS pending | 1 | $1,627.17 | $375.81 | Pending | $201.03 | $0.00 | $1,050.33 | |
| Total | 108 | $112,690.13 | $30,460.82 | $1,190.8199 pending | $9,127.05 | $0.00 | $71,911.45 |
- Events
- 20
- Revenue
- $19,537.88
- Giveback
- $5,339.57
- COGS
- $101.58
- Labor
- $1,754.60
- Marketing
- $0.00
19 pending
Hours pending · Revenue split
- Events
- 10
- Revenue
- $17,413.78
- Giveback
- $4,927.22
- COGS
- $400.49
- Labor
- $1,365.07
- Marketing
- $0.00
8 pending
Hours pending · Revenue split
- Events
- 10
- Revenue
- $14,591.62
- Giveback
- $3,369.21
- COGS
- $289.58
- Labor
- $1,013.25
- Marketing
- $0.00
8 pending
Hours pending · Revenue split
- Events
- 12
- Revenue
- $14,972.84
- Giveback
- $4,123.54
- COGS
- $119.14
- Labor
- $885.53
- Marketing
- $0.00
11 pending
Hours pending · Revenue split
- Events
- 16
- Revenue
- $8,723.69
- Giveback
- $2,451.31
- COGS
- Pending
- Labor
- $1,177.23
- Marketing
- $0.00
16 pending
Hours pending · Revenue split
- Events
- 8
- Revenue
- $4,714.08
- Giveback
- $1,382.97
- COGS
- $78.04
- Labor
- $469.66
- Marketing
- $0.00
7 pending
Hours pending · Revenue split
- Events
- 2
- Revenue
- $2,279.42
- Giveback
- $497.44
- COGS
- Pending
- Labor
- $222.12
- Marketing
- $0.00
2 pending
- Events
- 3
- Revenue
- $2,136.86
- Giveback
- $433.84
- COGS
- Pending
- Labor
- $183.68
- Marketing
- $0.00
3 pending
Revenue split
- Events
- 1
- Revenue
- $1,614.00
- Giveback
- $380.56
- COGS
- Pending
- Labor
- $117.18
- Marketing
- $0.00
1 pending
- Events
- 1
- Revenue
- $1,627.17
- Giveback
- $375.81
- COGS
- Pending
- Labor
- $201.03
- Marketing
- $0.00
1 pending
Marketing costs
Coffee, treats, and anything else that should come out of Kona Day profit. Saved on this device. Export a copy before you switch browsers.
No marketing costs in this view yet.
Cost basis and labor hoursOut-the-window costs from Out the window 9.30.26. Staff labor already on an event is hours times $15.50. Paste hours here only to override the file for an event id.
| Cup | Size | Price | OTW cost | Inside the cost |
|---|---|---|---|---|
| Kiddie | 9 oz | $3.00 | $0.19 | Cup $0.08 · Ice $0.06 · Syrup $0.03 · Spoon $0.01 · Paper $0.01 |
| Klassic | 12 oz | $4.00 | $0.26 | Cup $0.11 · Ice $0.08 · Syrup $0.06 · Spoon $0.01 · Paper $0.01 |
| King | 16 oz | $5.00 | $0.32 | Cup $0.13 · Ice $0.10 · Syrup $0.07 · Spoon $0.01 · Paper $0.01 |
| Color Change | 17 oz | $6.00 | $0.90 | Cup $0.69 · Ice $0.11 · Syrup $0.08 · Spoon $0.01 · Paper $0.01 |
| Kollectible | 20 oz | $7.00 | $0.83 | Cup $0.59 · Ice $0.13 · Syrup $0.09 · Spoon $0.01 · Paper $0.01 |
| Refill Cup | 12 oz | $3.00 | $0.16 | Ice $0.08 · Syrup $0.06 · Spoon $0.01 · Paper $0.01 |
Cup carton costs updated from Veritiv 6.20.25; ice/paper/vitablend/sugar/concentrate/spoons carried from 6.29.24 per sheet header. OTW recomputed locally because Excel formulas were not cached in the xlsx download. Refill Cup is estimated: Klassic pour with the carton left off, sold at $3.
COGS is cups times the out-the-window cost. It is not a percent of sales. When prepaid cup counts are on an event, cash and Square sales take that same mix. A refill uses the Klassic pour with the carton left off. Events without a tally stay pending and profit does not deduct COGS for them.
Bring in labor hours
Staff labor already on an event is that school’s allocated hours times $$15.50. Same-day schools already have a revenue split in the file. Paste JSON of event id to hours only to override the file in this browser. Prep and close stay in the same punch. Putting laborHours on the event in data/events.json does the same thing for everyone who opens the board.