Skip to content

Excel Template Reference

Visual reference for the various Excel costing formats supported by CostEngine (MfgIQ).

Format 1: Multi-Sheet Projections (Standard)

This is the default format for long-term contracts (YoY projections) and complex BOMs.

Material & Conversion

Material & Conversion Costs

Operations Detail

Operations Detail

Packing & Tooling

Packing & Logistics

Format 2: Detailed Machining (Specialized)

Used for high-precision machined parts with integrated development costs and bin-based packing logic.

Complete Breakdown

Format 2 Breakdown

Key Features: - Integrated View: Material, Internal Ops (CC), and Packing on a single summary view. - Bin Logic: Sophisticated packing calculation based on bin life and capacity. - Development Costs: Tracking Gauge, Fixture, and Tooling setup costs separately.

View Format 2 Technical Mapping →

Field Mapping Summary

Excel Section System Fields Purpose
Material Info material_grade, gross_weight, net_weight, rm_rate Material cost calculation
Operations operation_name, setup_time, cycle_time, machine_rate Operations costing
Tooling tool_cost, tool_life, tool_cost_per_piece Tooling amortization
Packing packing_cost_per_piece, qty_per_box, bin_logic Packaging costs