CostPilot

CostPilot

Manufacturing & Agricultural Cost Analysis Platform

Understand your true per-unit costs, track price volatility, and optimize your production economics

Manufacturing

Agriculture

Cost Optimization

Upload Data Files

Upload your transaction data and optionally revenue data for comprehensive cost analysis, profitability assessment, and per-unit costing by product line.

Select Your Industry *

This selection will customize terminology and metrics throughout the application

How do you measure your production output? *

Select the unit type you use to measure production. This will be shown consistently throughout all analytics and "per unit" calculations.

Measurement Type

Unit Label

Examples: Farms might use "kg" or "tons" for crops, "square meters" for coverage area. Manufacturers might use "units" for discrete products or "kg" for bulk materials.

Transaction Data File *

Sample Format:

Date	Product Line	Cost Type	Category	Amount (EUR)	Vendor Name	Location	Cost Center
2024-01-15	Tomatoes - Roma	OpEx	Fertilizer	1,250.50	ABC Fertilizers	Greenhouse 1	Production
2024-01-18	Strawberries - Elsanta	CapEx	Equipment	850.75	XYZ Equipment	Farm A	Operations

Key Fields: Date, Product Line, Cost Type (CapEx/OpEx), Amount (EUR), Vendor Name, Location, Cost Center

All company spending data including OpEx (operational expenses), CapEx (capital expenditures), manufacturing overhead, direct materials, labor costs, vendor payments, and other business expenses

Revenue Data File *

Sample Format:

Month	Product Line	Units Sold	Price per Unit (EUR)	Revenue (EUR)	Sales Channel	Customer Region
2024-01	Strawberries - Elsanta	15,000	5.00	75,000.00	Wholesale	EU West
2024-01	Tomatoes - Roma	12,000	4.00	48,000.00	Retail	Local

Key Fields: Month (YYYY-MM), Product Line, Units Sold, Price per Unit (EUR), Revenue (EUR), Sales Channel, Customer Region

Sales data showing what you sold to customers: product lines, quantities sold, selling prices, total revenue, and sales channels for profitability analysis

Labor Costs File (Optional)

Sample Format:

Date	Employee Role	Product Line Supported	Location	Labor Type	Hours Worked	Total Cost (EUR)
2024-01-15	Harvester	Strawberries - Elsanta	Greenhouse 1	Direct	40	800.00
2024-01-20	Supervisor	All Crops	Farm A	Indirect	40	1,200.00

Key Fields: Date, Employee Role, Product Line Supported, Location, Labor Type (Direct/Indirect), Hours Worked, Total Cost (EUR)

Monthly direct and indirect labor costs by product line for enhanced cost allocation accuracy

Production Data File (Recommended for Per-Unit Costing)

Sample Format:

Product Line	Month	Units Produced	Production Line	Shift	Quality Grade
eBike - Commuter	2025-04	1,200	Assembly Line A	Day Shift	A Grade
Strawberries - Elsanta	2025-04	15,500	Greenhouse 1	Harvest	Premium

Required Fields: Product Line, Month (YYYY-MM), Units Produced | Optional: Production Line, Shift, Quality Grade

Monthly production volumes by product line - essential for accurate per-unit cost calculations using Units Produced vs Units Sold

Date Range Consistency

Important: All data files must cover the same date range for accurate analysis. Mismatched periods will result in incorrect cost allocations and per-unit calculations.

File Requirements: CSV, Excel (.xlsx, .xls) • Maximum size: 50MB each

Vendor	Amount	PO	Delivery Date	Project
ABC Corp	$25,000	PO-001	2024-01-15	Office Renovation
XYZ Ltd	$15,500	PO-002	2024-02-01	Equipment Purchase

Vendor

Amount

Delivery Date

Project

ABC Corp

$25,000

PO-001

2024-01-15

Office Renovation

XYZ Ltd

$15,500

PO-002

2024-02-01

Equipment Purchase

Field Name	Description	Required
Date	Transaction date (YYYY-MM-DD format preferred)	Yes
Product Line	Specific variety or crop (e.g. "Tomatoes - Roma") or "All Crops" for shared costs	Yes
Cost Type	"CapEx" (Capital Expenditure), "OpEx" (Operating Expenditure), or "Cost of Revenue"	Recommended
Category	e.g., Fertilizer, Packaging, Labor, Utilities, Equipment	Recommended
Amount (EUR)	Raw amount, numeric only (currency symbols automatically removed)	Yes
Vendor Name	Supplier or contractor name	Recommended
Location	Site, greenhouse, or building name/ID (e.g., "Greenhouse 1", "Farm A")	Optional
Cost Center	Department or operational area (e.g., Production, Operations, Maintenance)	Optional

Field Name

Description

Required

Date

Transaction date (YYYY-MM-DD format preferred)

Yes

Product Line

Specific variety or crop (e.g. "Tomatoes - Roma") or "All Crops" for shared costs

Yes

Cost Type

"CapEx" (Capital Expenditure), "OpEx" (Operating Expenditure), or "Cost of Revenue"

Recommended

Category

e.g., Fertilizer, Packaging, Labor, Utilities, Equipment

Recommended

Amount (EUR)

Raw amount, numeric only (currency symbols automatically removed)

Yes

Vendor Name

Supplier or contractor name

Recommended

Location

Site, greenhouse, or building name/ID (e.g., "Greenhouse 1", "Farm A")

Optional

Cost Center

Department or operational area (e.g., Production, Operations, Maintenance)

Optional

Field Name	Description	Required
Month	Format: YYYY-MM (e.g., "2024-01") or date field	Yes
Product Line	Must match product lines in transaction file (e.g., "Strawberries - Elsanta")	Yes
Units Sold	Total units sold (define unit: kg, boxes, crates, etc.)	Yes
Revenue (EUR)	Total revenue (units × price)	Yes
Price per Unit (EUR)	Sales price per unit	Recommended
Sales Channel	e.g., wholesale, retail, online	Optional
Customer Region	Helps understand market segmentation (e.g., "EU West", "Local")	Optional

Field Name	Description	Required
Date	Payroll or work date (YYYY-MM-DD format preferred)	Yes
Employee Role	e.g., Harvester, Supervisor, Packer, Manager	Recommended
Product Line Supported	If role is dedicated to one crop, specify; use "All Crops" for shared roles	Recommended
Labor Type	"Direct" (product-specific work) vs. "Indirect" (supervisory, shared tasks)	Yes
Total Cost (EUR)	Can be calculated if not input directly (hours × rate)	Yes
Location	Facility, greenhouse, or work area (e.g., "Greenhouse 1", "Farm A")	Optional
Hours Worked	Per day/week/month (specify in your data)	Optional

Field Name

Description

Required

Date

Payroll or work date (YYYY-MM-DD format preferred)

Yes

Employee Role

e.g., Harvester, Supervisor, Packer, Manager

Recommended

Product Line Supported

If role is dedicated to one crop, specify; use "All Crops" for shared roles

Recommended

Labor Type

"Direct" (product-specific work) vs. "Indirect" (supervisory, shared tasks)

Yes

Total Cost (EUR)

Can be calculated if not input directly (hours × rate)

Yes

Location

Facility, greenhouse, or work area (e.g., "Greenhouse 1", "Farm A")

Optional

Hours Worked

Per day/week/month (specify in your data)

Optional

Field Name	Description	Required
Product Line	Must match product lines from transaction and revenue files (e.g., "eBike - Commuter", "Strawberries - Elsanta")	Yes
Month	Production month in YYYY-MM format (e.g., "2025-04")	Yes
Units Produced	Total units manufactured/harvested in that month (numeric value)	Yes
Production Line	Manufacturing line, greenhouse, or production facility (e.g., "Assembly Line A", "Greenhouse 1")	Optional
Shift	Production shift or time period (e.g., "Day Shift", "Night Shift", "Harvest")	Optional
Quality Grade	Product quality classification (e.g., "A Grade", "Premium", "Standard")	Optional

Field Name

Description

Required

Product Line

Must match product lines from transaction and revenue files (e.g., "eBike - Commuter", "Strawberries - Elsanta")

Yes

Month

Production month in YYYY-MM format (e.g., "2025-04")

Yes

Units Produced

Total units manufactured/harvested in that month (numeric value)

Yes

Production Line

Manufacturing line, greenhouse, or production facility (e.g., "Assembly Line A", "Greenhouse 1")

Optional

Shift

Production shift or time period (e.g., "Day Shift", "Night Shift", "Harvest")

Optional

Quality Grade

Product quality classification (e.g., "A Grade", "Premium", "Standard")

Optional

Upload Data Files

Date Range Consistency

Manufacturing & Farm Cost Intelligence

Per-Unit Cost Analysis

Price Volatility Tracking

Monthly Cost Trends

Recent Sessions

1_Bike_Cost_Data.csv

1_Bike_Cost_Data.csv

1_Bike_Cost_Data.csv

1_Bike_Cost_Data.csv

1_Bike_Cost_Data.csv

Expected Data Format