Purchase Planning

Turn Production Targets Into a Consolidated Purchase Plan

Combine Material and Packaging requirements across multiple Recipes, Builds, and Products, calculate purchasing quantities, apply case-rounding rules, and export one organized purchase list.

app.costfoundry.com/app/scaling
Consolidated Purchase List
Shipping BoxesPackCo
2,000 EA2 cs$3,400
ResinAcme Supply
400 LB4 cs$1,720
LabelsLabelPro
4,800 EA3src5 cs$144
FastenersFastener Inc
16,000 EA16 cs$2,240
Adj. Purchase Cost$11,824

Production requirements are only useful when they become a clear purchasing plan

When several Recipes, Builds, and Products use the same Material, calculating each requirement separately can lead to duplicate orders, inaccurate case counts, and unnecessary cost.

Duplicate Material Requirements

The same Material may appear in several selected records.

Incompatible Units

Requirements may be expressed in ounces, pounds, kilograms, eaches, or other units.

Incorrect Case Rounding

Rounding each Recipe or Build separately can overstate purchasing needs.

Missing Source Visibility

A combined quantity is difficult to verify without knowing which Recipes, Builds, or Products created it.

Calculate individually, consolidate intelligently

CostFoundry calculates each selected item first, normalizes compatible quantities, and then consolidates matching Material and Packaging requirements. Case rounding is applied after compatible requirements are consolidated, helping reduce unnecessary over-purchasing.

Rows consolidate only when they represent the same purchasable record — matching on Material ID, supplier, supplier item number, brand, pack size, and purchase unit. The same Material from two different suppliers stays as separate rows.

How Purchase Planning works

1

Create a Production Plan

Add the Recipes, Builds, and Products you plan to make.

2

Calculate Individual Requirements

Expand each record and determine the required Material and Packaging quantities.

3

Normalize Units

Convert compatible requirements into a shared base or purchase unit.

4

Consolidate Matching Records

Combine quantities based on Material identity, supplier, supplier item number, pack size, and purchase unit.

5

Apply Purchasing Rules

Calculate required cases, rounded cases, purchase quantities, and Adj. Purchase Cost.

6

Review and Export

Review the source breakdown and export the purchase plan.

Consolidation without losing traceability

Rows consolidate only when they represent the same purchasable record. Matching factors include Material ID, Supplier, Supplier Item Number, Brand, Pack Size, and Purchase Unit. Rows are never consolidated solely by Material name.

Material ID
Supplier
Supplier Item Number
Brand
Pack Size
Purchase Unit

Example: The same fastener from two different suppliers remains as separate purchase rows when the supplier item numbers or case packs differ. Consolidation is never based on Material name alone.

See where every requirement came from

Every consolidated Material can be expanded to show a source breakdown. This traceability helps you verify totals, identify the main Material users, review unusual quantities, and understand production demand.

  • Verify totals against individual records
  • Identify the main Material users
  • Review unusual quantities
  • Understand production demand
Source Breakdown Example
Adhesive Resin312 LB
Total Required
Storage Box Product180 LB · 58%
Protective Insert Build82 LB · 26%
Hardware Kit Product50 LB · 16%

Built for practical purchasing decisions

Consolidated Materials

Combine matching Material requirements across selected records.

Consolidated Packaging

Combine boxes, labels, inserts, containers, and other Packaging.

Supplier Details

Display supplier, supplier item number, brand, and purchase information.

Unit Normalization

Convert compatible requirements before consolidation.

Case Calculations

Calculate required and rounded case quantities.

Configurable Rounding

Use approved rounding rules such as whole case or nearest half case where supported.

Adj. Purchase Cost

Estimate purchasing cost using case and unit prices.

Source-Level Traceability

Expand each Material to see the contributing Recipes, Builds, and Products.

Separate Item Requirements

Review individual requirements before the consolidated list.

Export Support

Generate an Excel or web-based purchase report.

One purchasing view across multiple production targets

When multiple Products, Recipes, and Builds are produced together, Purchase Planning calculates each item's requirements individually and then consolidates matching Materials into a single purchase list.

P

Storage Box Product

3 requirements

Shipping Boxes
2,000 EA
Resin
400 LB
Labels
2,000 EA
P

Hardware Kit Product

3 requirements

Kit Boxes
800 EA
Fasteners
16,000 EA
Labels
800 EA
F

Protective Insert Build

3 requirements

Foam Inserts
2,000 EA
Adhesive
120 LB
Labels
2,000 EA

Combined Purchase Requirements
Shipping Boxes
2,000 EA
Kit Boxes
800 EA
Resin
400 LB
Fasteners
16,000 EA
Foam Inserts
2,000 EA
Adhesive
120 LB
Labels (consolidated)
4,800 EA

Buy in the units your suppliers actually sell

Case rounding is applied after consolidation, so you purchase in whole cases from your supplier without over-ordering on each individual Recipe or Build.

Label Requirement
4,800 EA
Supplier Case Size
1,000 EA
Required Cases
4.8
Whole-Case Rounding
5 cases
Purchase Quantity
5,000 EA
Estimated Overage
200 EA
Adj. Purchase Cost$144.00

Export a purchase-ready report

Generate an Excel or web report with individual requirements, consolidated purchase lists, source breakdowns, and Packaging purchase lists.

Individual Requirements by Recipe, Build, or Product

MaterialParentScaled QuantityUnitAdjusted QuantityCostCases

Consolidated Purchase List

MaterialSupplierSupplier Item NumberTotal Required QuantityPurchase QuantityCase SizeRounded CasesAdj. Purchase CostSource Count

Material Source Breakdown

MaterialSource Recipe, Build, or ProductParentRequired QuantityUnit

Packaging Purchase List

Packaging recordSupplierQuantityCasesAdj. Purchase Cost

Review purchasing from summary to source detail

Review Material requirements for each Recipe, Build, or Product before consolidation.

app.costfoundry.com
ParentMaterialQtyCost
Storage Box ProductShipping Boxes2,000 EA$3,400
Storage Box ProductResin400 LB$1,720
Storage Box ProductLabels2,000 EA$60
Hardware Kit ProductKit Boxes800 EA$1,360
Hardware Kit ProductFasteners16,000 EA$2,240
Protective Insert FormulationFoam Inserts2,000 EA$1,000
Protective Insert FormulationAdhesive120 LB$480

Purchase with more confidence

Reduce duplicate purchasing calculations

Consolidate shared Material requirements

Apply case rounding consistently

Preserve supplier and SKU details

Verify every quantity through source breakdowns

Export a purchase-ready report

Purchase Planning FAQ

Materials are consolidated when they represent the same purchasable record. Matching factors include Material ID, Supplier, Supplier Item Number, Brand, Pack Size, and Purchase Unit. Compatible quantities are normalized and then combined.

Ready to turn production targets into a purchase list?

Consolidate Material and Packaging requirements and export a purchase-ready plan.