Materials and Packaging Databases

Organize Materials and Packaging in Connected Databases

Centralize supplier details, pack information, pricing, units, categories, conversions, and Cost per Unit while keeping Materials and Packaging clearly separated.

One structured source for the items used to make and package Products.

Materials
Aluminum Bracket
$2.40 / EA
Foam Sheet
$0.52 / SF
Adhesive
$8.30 / GAL
Packaging
Retail Box
$1.30 / EA
Label
$0.08 / EA
Insert
$0.15 / EA

Cost accuracy depends on clean source data

When supplier details, pack sizes, units, and prices are scattered across spreadsheets, every downstream calculation becomes harder to trust.

Scattered Supplier Information

Names, SKUs, brands, and prices may be stored in different files.

Inconsistent Pack Data

Pack descriptions may not be entered the same way across suppliers.

Mixed Units

Materials may use weight, volume, count, or custom measurements.

Packaging Hidden in Material Cost

Combining Packaging with Materials makes cost analysis less clear.

Keep production inputs organized at the source

CostFoundry uses separate but connected databases for Materials and Packaging, so supplier details, pack information, units, prices, and cost calculations are always structured and consistent.

Separating Materials and Packaging makes cost breakdowns, reporting, and purchasing easier to understand.

How Materials and Packaging support the workspace

1

Add or Import Records

Create records manually or through Smart Import.

2

Confirm Supplier and Pack Data

Review supplier, item number, brand, pack, unit, and price.

3

Calculate Cost per Unit

Convert the purchase price into a usable costing value.

4

Add Conversions and Yield

Use standard, custom, or Material-specific conversions.

5

Connect Records

Add Materials and Packaging to Recipes, Builds, and Products.

6

Track Changes

Preserve price history and review downstream cost impact.

Build a complete Material record

Each Material record captures the full context needed for accurate costing—from supplier details to pack information, yield, and price history.

Material NameSupplierSupplier Item NumberBrandCategoryOriginal Pack DescriptionPack NumberPack WeightUnitCase SizePurchase PriceCost per UnitYield %Preferred SupplierLast Price UpdatePrice HistoryNotes
app.costfoundry.com
ListDetailsPrice History

Materials Database

Material records with supplier and pack details

costfoundry-materials-database.webp

Track Packaging as its own cost source

Packaging records are maintained separately from Materials, so boxes, labels, containers, and other packaging costs are always visible and never hidden inside Material costs.

Packaging NameSupplierSupplier Item NumberBrandPackaging TypeCase QuantityPurchase UnitPurchase PriceCost per UnitLinked ProductsLast Price UpdateNotes

Packaging may be linked directly to a Product or, where appropriate, to a Recipe or Build.

app.costfoundry.com
ListDetailsLinked

Packaging Database

Packaging records with supplier and cost details

costfoundry-packaging-database.webp

Turn supplier packs into usable Cost per Unit

CostFoundry parses supplier pack descriptions and converts purchase prices into the Cost per Unit used throughout the workspace.

Example 14/5/LB
Pack Number4
Pack Weight5 LB
Case Size20 LB
Case Cost$86.00
Cost per LB$4.30
Example 210/100/EA
Pack Number10
Pack Quantity100 EA
Case Size1,000 EA
Case Cost$135.00
Cost per EA$0.135
Example 3Packaging case
Case Size250 EA
Case Cost$82.50
Cost per EA$0.33

Structured records for more reliable costing

Supplier Details

Store supplier and supplier item number for each record.

Pack Information

Track pack quantity, pack weight, and case size.

Purchase Price

Store the cost paid for the supplier pack or case.

Cost per Unit

Calculate the cost in a usable measurement unit.

Units and Conversions

Support Metric, Imperial, custom, and Material-specific units.

Yield

Account for usable Material percentage after process loss.

Categories

Organize Materials and Packaging by category.

Search and Filters

Find records by name, supplier, SKU, brand, or category.

Price History

Track previous and current pricing over time.

Linked Records

See which Recipes, Builds, and Products use the item.

Smart Import

Create or update structured records from supplier files.

Bulk Replacement

Replace Materials across affected records.

From supplier record to finished Product cost

An industry-neutral example showing how a Material and a Packaging item combine into Product cost.

Material
Aluminum Bracket
SupplierSummit Components
Item NumberAB-4402
Case Size100 EA
Case Cost$240.00
Cost per EA$2.40
Packaging
Retail Box
SupplierAtlas Packaging
Case Size50 EA
Case Cost$65.00
Cost per EA$1.30
Premium Hardware Kit
Material Cost
$24.00
10 × $2.40
Packaging Cost
$1.30
1 × $1.30
Total Before Other Costs
$25.30

Manage the source data behind every cost calculation

Browse the Materials database with supplier, pack, and cost information.

app.costfoundry.com

Materials

CostFoundry interface preview

costfoundry-materials-list.webp

Create a stronger foundation for every calculation

Centralize supplier and item data

Standardize pack and unit information

Calculate reliable Cost per Unit

Separate Material and Packaging costs

Track pricing history

Connect source data to Recipes, Builds, and Products

Materials and Packaging Databases FAQ

The Materials database includes raw Materials, components, purchased parts, consumables, and other inputs used in Recipes and Builds. If an item is used to make or build a Product, it belongs in the Materials database.

Ready to organize the source data behind your costs?

Centralize supplier, pack, price, unit, Material, and Packaging information in one connected workspace.