ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Munder Difflin Scraper Company — Executive Data Workbook
2
3
⚠ 100% SYNTHETIC DATA. Every value is fabricated by a seeded generator (generate_workbook.py).
4
This dataset is NOT derived from, and is NOT attached to, any real company or any real data. Munder Difflin is a fictional sandbox company.
5
6
Window: 2026-01-01 to 2026-05-31 · 151 daily rows · Time zone: Central · RNG seed: 42
7
Re-run generate_workbook.py to regenerate. The script is the dynamic/updateable layer; cells hold computed values (no formulas).
8
9
Consistency guarantees (enforced by assertions):
10
 • Each day: total revenue = Σ channel revenue = Σ category revenue.
11
 • Each month: Daily Sales = Revenue by Channel = Revenue by Category = Finance P&L (Revenue Actual), to the penny.
12
 • KPI Snapshot (Revenue YTD / May MTD / Orders YTD) sums the daily data exactly.
13
 • Q1 2026 = $3,888,848 vs $4,400,000 plan (the canonical –11% miss).
14
 • 5-month revenue = $6,488,848. Blended gross margin = 39.2%.
15
 • 340 active SKUs; top-20 SKUs = 64% of revenue.
16
 • Orders by State: orders and revenue reconcile to company totals exactly.
17
 • Marketing 'Rev. Attributed' = DTC channel revenue per period (modeled as 100% last-touch coverage), so it ties to the ledger.
18
19
Tabs & suggested chart styles:
20
 KPI Snapshot ......... scorecards, sparklines, deltas
21
 Daily Sales .......... line / area; conversion & AOV trends
22
 Revenue by Channel ... stacked area, donut, channel margin
23
 Revenue by Category .. seasonal stacked area, category mix donut, heatmap
24
 SKU Performance ...... bubble scatter (margin vs units), top-15 bar, table
25
 Marketing ............ ROAS bars, spend stacked area, combo, SEO-decline line
26
 Funnel ............... funnel chart (sessions → views → cart → checkout → orders)
27
 CS Tickets ........... category bars, deflection line, CSAT gauge, channel split
28
 Warehouse Ops ........ throughput bars, on-time gauge, backlog line
29
 Finance P&L .......... budget-vs-actual bars, waterfall, margin line
30
 Cash Flow ............ area/line with tight-week marker (week of May 18)
31
 Suppliers ............ scorecard table, radar
32
 Orders by State ...... choropleth / geo map
33
 AI Initiatives ....... progress / bullet bars, status cards, KPI-vs-target
34
 Events ............... timeline annotations to layer onto any time series
35
36
Canon note: DTC storefront is WooCommerce (managed on WP Engine). The March 7 outage is a hosting/platform incident.
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100