Heartland Ag Parts Co. is a mid-size Make to Stock manufacturer of agricultural replacement parts headquartered in Lohrville, Iowa. With 20+ employees across stamping, machining, welding, heat treating, powder coat, and assembly departments, Heartland supplies wear parts and service kits to ag equipment dealers and co-ops across the Corn Belt. Demand is highly seasonal - driven by planting season in spring and harvest in fall.
Heartland runs Epicor Kinetic ERP on-premises at their Lohrville facility with a secondary distribution center in Ames. Their data spans three years of journal entries, production jobs, inventory transactions, and AR/AP cycles - all with the seasonal pattern characteristic of ag parts. The Tailored.BI warehouse connects via the SQL Server ETL lane, using SysRevChangedDate watermark-based incremental refresh.
Epicor Kinetic represents a $500K–$2M+ investment for a manufacturer like Heartland. Tailored.BI exists to make that investment visible — turning years of ERP data into the decisions that run the business.
Built on the Tailored.BI Fabric data warehouse, connected directly to Heartland's Epicor Kinetic data. All reports share the same semantic model - one set of DAX measures, one dim.Date table, one source of truth across Finance, Sales, Operations, and Supply Chain.
| Account | Actual | Var % |
|---|---|---|
| Revenue | $9.8M | +6.2% |
| COGS | $5.8M | +1.8% |
| Labor | $1.27M | -2.1% |
| SG&A | $920K | -0.8% |
| Part | On Hand | Turns |
|---|---|---|
| TIL-DB-22 | 2,841 | 8.2x |
| CMB-TB-STD | 1,104 | 7.4x |
| PLT-FP-STD | 2,209 | 6.1x |
| KIT-COMB-HV | 318 | 4.5x |
| Carrier | Shpmts | On-Time |
|---|---|---|
| UPS Ground | 118 | 97.5% |
| SAIA LTL | 52 | 94.2% |
| FedEx | 38 | 98.1% |
| Co. Truck | 18 | 100% |
How your data flows
Every morning before your team arrives, Heartland's Epicor data moves through a secure managed pipeline — inventory transactions, AR balances, purchase orders, GL entries — shaped into clean reporting tables and delivered to Power BI. No Excel. No manual pulls. No waiting.
Inventory transactions, sales orders, AR invoices, purchase orders, GL journal entries, labor time, and production jobs — all sitting in Epicor's on-premises database in Lohrville.
Only changed records move each morning — watermark-driven incremental refresh means Epicor is never slowed down. Data lands in a purpose-built Microsoft Fabric warehouse isolated to Heartland's account. Clean star-schema tables: inventory status, seasonal demand, AR aging, purchase spend, GL by account and period.
Heartland's team opens a browser, logs in, and sees this morning's numbers — revenue by dealer, seasonal inventory position, AR aging by customer, purchase spend by vendor. Before planting season, before harvest, before Monday morning — the data is already there.
Make to Stock · Powered by Tailored.BI
Heartland Ag Parts is a fictional make-to-stock manufacturer — but every table, every pipeline, and every report you just explored is built on real Epicor architecture.
If you run a make-to-stock operation on Epicor Kinetic — seasonal inventory, dealer AR, purchasing cycles — this is exactly what your subscription delivers. Live data, every morning, in your brand. Starting at $1,500/month.