Skip to main content
These demo samples are a free 10-task slice of the APEX Agent dataset. For the complete dataset — its scale, difficulty profile, and benchmark results — see the Full Dataset page. The samples below showcase the management consulting cases — Project Terrace (Floor & Decor retail strategy) and Project Roku (CTV platform analysis) — where the agent must reason over store-level spreadsheets, SEC filings, industry research, customer surveys, and competitor benchmarks.

Overview

Environment

The demo showcases two management consulting environments: Project Terrace (Floor & Decor retail optimization, 104 files) and Project Roku (CTV/streaming platform strategy). The sample below uses Project Terrace:
Project Admin (5 DOCX): Engagement charter, kickoff meeting notes, project timeline, scope & work plan, and team roster for Project Terrace.Company Filings (21 PDFs): 10-K annual filings for 7 comparable companies — Floor & Decor (FND), Home Depot (HD), LL Flooring (LL), Lowe’s (LOW), Mohawk Industries (MHK), MSC Industrial (MSM), and Tile Shop Holdings (TTS), covering 2021–2025.Industry Research (14 files): Government and academic data sources — BLS employment, consumer expenditures, CPI shelter, JOLTS, occupational wage surveys (OEWS); Census construction spending, retail sales, e-commerce; FRED housing starts, retail sales; Harvard JCHS state housing reports.Analysis Models (30+ XLSX + 2 CSV): Store-level and company-level analysis spreadsheets including:
  • FND_Installed_Sales_Economics.xlsx — 250 stores with margin, callback, and revenue data
  • FND_Store_Performance_v3.xlsx — store productivity metrics by region
  • FND_Inventory_Analysis.xlsx — inventory turns, aging, slow-moving SKU analysis
  • FND_Competitor_Benchmarking.xlsx — peer comparison across key metrics
  • FND_Customer_Cohort_Analysis.xlsx, FND_Gross_Margin_Bridge.xlsx, FND_Scenario_Sensitivity_Model.xlsx, and 20+ more
  • Company financial extracts for HD, LL, LOW, MHK, MSM, TTS
Surveys & Research Notes (10 files): Analyst notes for each peer company, customer survey data and column guide, expert call notes on the flooring industry.Deliverables (5 files): Competitive landscape analysis (PPTX), executive summary memo, implementation playbook, SteerCo presentation, and store productivity deep dive.Reference & Frameworks (7 DOCX): Benchmarking methodology, connected customer analysis framework, industry glossary, pro customer economics, renovation ROI framework, SG&A efficiency analysis, and store classification framework.

Data

Sample

Prompt:
Which stores have the best and worst economics on installed sales? Rank all stores by net installation margin, then give me these key highlights: the #1 store and its margin, the lowest-margin store and its margin, the portfolio average net installation margin, and the gap in percentage points between the best and worst store. Also report the installed revenue for FND-194 and FND-144 specifically, and the callback rate for FND-307. Round percentages to one decimal place and revenue to the nearest dollar. Reply here.
Expected output:
  • Top store: FND-109 with net installation margin of 12.0%
  • Lowest store: FND-180 with net installation margin of 5.0%
  • Portfolio avg net installation margin: 8.7%
  • Gap between best and worst: 7.0pp
  • FND-194 installed revenue: $5,223,275
  • FND-144 installed revenue: $4,933,729
  • FND-307 callback rate: 7.4%
Rubric criteria:
  1. States that FND-109 is the top-ranked store with net installation margin of 12.0%
  2. States that FND-180 is among the lowest net installation margin stores at 5.0%
  3. States that portfolio average net installation margin is 8.7%
  4. States that the gap between best and worst store is 7.0pp
  5. States that FND-194 has installed revenue of $5,223,275
  6. States that FND-307 has a callback rate of 7.4%
  7. States that FND-144 has installed revenue of $4,933,729
Each assistant message includes reasoning_content (chain-of-thought) showing the agent’s step-by-step analytical reasoning. Reasoning is shown in italics below.System:
You are an AI assistant with access to Code Execution, Excel/Spreadsheets, Filesystem, and Word/Documents. You MUST use tools to explore files and data before answering. NEVER assume. Keep full precision through intermediate calculations and only round final reported values.
User:
Which stores have the best and worst economics on installed sales? Rank all stores by net installation margin, then give me these key highlights: the #1 store and its margin, the lowest-margin store and its margin, the portfolio average net installation margin, and the gap in percentage points between the best and worst store. Also report the installed revenue for FND-194 and FND-144 specifically, and the callback rate for FND-307. Round percentages to one decimal place and revenue to the nearest dollar. Reply here.
Assistant:Step 1 — Explore directory tree:The user is asking about installed sales economics across stores — specifically ranking all stores by net installation margin, identifying best/worst, computing the portfolio average, finding the gap, plus specific revenue figures for FND-194 and FND-144, and the callback rate for FND-307. I need to locate the relevant data file(s) first…
I’ll start by exploring the filesystem to find relevant files, then thoroughly analyze the data.
Tool result:
Step 2 — List spreadsheet tabs:The directory tree reveals a file that’s an exact match for the user’s question: /4. Analysis Models/FND_Installed_Sales_Economics.xlsx. “Installed Sales Economics” maps directly to the request for net installation margins, callback rates, and installed revenue by store…
The key file is FND_Installed_Sales_Economics.xlsx. Let me explore it.
Tool result:
Step 3 — Read the full spreadsheet:Single tab called ‘Installed_Sales_Econ’ with 251 rows and 11 columns. That’s 1 header row + 250 data rows — a manageable size to read in full. With 11 columns, the data likely has all the metrics I need in one consolidated table…
Tool result:
Step 4 — Execute Python computation:Now I have the full dataset: 250 stores (FND-101 through FND-350) with 11 columns. The columns relevant to the user’s question are: column B (Installed_Revenue), column F (Net_Installation_Margin_%), and column G (Callback_Rate_%). I need to rank all 250 stores by column F…
Now I have all the data. Let me run a Python script to compute the rankings and extract the specific values requested.
Tool result:
Step 5 — Verify tied stores and callback rate (6 parallel reads):The code found a three-way tie at the top: FND-109, FND-144, and FND-153 all at 0.12 (12.0%), and a two-way tie at the bottom: FND-180 and FND-293 both at 0.05 (5.0%). But these margin values were stored as rounded decimals. Let me verify the exact stored values to confirm tie-breaking…
There’s a three-way tie at the top (12.0%) and a two-way tie at the bottom (5.0%). Let me verify the exact stored values to confirm the tie-breaking and also double-check the callback rate for FND-307.
Tool results:
Step 6 — Final answer:All six verification reads confirm the stored values exactly match the computation. The three top-margin stores all show F = 0.12 with no hidden precision differences — FND-109, FND-144, and FND-153 are genuinely tied. The two bottom stores both show F = 0.05 — FND-180 and FND-293 are also a true tie.

Installed Sales Economics — Store Ranking Highlights

The 7.0 pp spread from best to worst signals meaningful variation in subcontractor cost management and installation markup discipline across the portfolio, suggesting room for margin improvement at the bottom of the distribution. FND-307 ranks near the bottom of the margin table (5.1%) and carries a 7.4% callback rate, which is roughly in line with the portfolio but paired with weak margin economics.
Each rubric criterion is independently verified with a detailed rationale:

Download

Browse on Hugging Face

View APEX Agent files
For the complete APEX Agent corpus — its difficulty profile, benchmark results, and commercial licensing — see the Full Dataset page.