Chapter 24
Cost Optimization & Calculators
Cost optimization transforms a formulation from a recipe into a viable commercial product. Without systematic cost control, even the highest-performing formula can price itself out of its target market. This chapter provides the quantitative tools and decision frameworks required to calculate formulation costs accurately, optimize across product tiers, and respond to raw material price volatility through substitution analysis. Every manufacturer must answer three questions: What does each kilogram cost? Where can cost be reduced without unacceptable performance loss? And what is the precise financial impact of any ingredient change? The sections that follow answer each question with worked examples, calculator templates, and a comprehensive cost-index table for more than thirty raw materials.
24.1Cost Calculation Fundamentals
24.1.1Procedure: Cost-per-kg Calculation
The cost-per-kilogram of a finished detergent product is determined by summing the contribution of every ingredient, then adding manufacturing overheads, labor, and packaging. The procedure follows a strictly additive model.
Step 1 — Ingredient contribution. For each ingredient , multiply its mass fraction (expressed as a decimal) by its unit cost (USD per kg):
Step 2 — Raw material sum. Sum all ingredient contributions:
Step 3 — Add overhead, labor, and packaging. Manufacturing overhead (energy, water, equipment depreciation, maintenance), direct labor, and primary packaging are each expressed as a cost per kilogram of finished product. These are added to the raw material sum:
Typical overhead rates for liquid detergent production range from – USD/kg depending on plant scale and energy costs . Labor adds – USD/kg for automated batching systems. Primary packaging (HDPE bottle, cap, label) for a ,L laundry liquid container ranges from – USD/unit depending on decoration and sourcing region .
Worked Example 1: Premium-Tier Laundry Liquid (1{,}000 kg batch)
| Ingredient | % (w/w) | kg/1{,}000 kg | ) | |
|---|---|---|---|---|
| Water (deionized) | 58.0 | 580.0 | 0.001 | 0.58 |
| LABSA (96% active) | 14.0 | 140.0 | 1.05 | 147.00 |
| SLES (70% active) | 8.0 | 80.0 | 1.45 | 116.00 |
| Coconut diethanolamide | 3.0 | 30.0 | 2.10 | 63.00 |
| Sodium chloride | 1.2 | 12.0 | 0.12 | 1.44 |
| Citric acid (anhydrous) | 0.5 | 5.0 | 1.35 | 6.75 |
| Sodium hydroxide (50%) | 0.8 | 8.0 | 0.55 | 4.40 |
| Fragrance | 0.3 | 3.0 | 8.50 | 25.50 |
| Colorant (1% solution) | 0.2 | 2.0 | 3.00 | 6.00 |
| Preservative | 0.15 | 1.5 | 12.00 | 18.00 |
| CMC (thickener) | 0.5 | 5.0 | 2.20 | 11.00 |
| Optical brightener | 0.05 | 0.5 | 18.00 | 9.00 |
| Sub-total: Raw materials | 86.7 | 867.0 | — | 408.67 |
| Manufacturing overhead | — | — | 0.08 | 80.00 |
| Direct labor | — | — | 0.06 | 60.00 |
| Packaging (bottle + label + cap) | — | — | 0.22 | 220.00 |
| Total cost per 1{,}000 kg batch | — | — | — | 768.67 |
| Cost per kg (finished product) | — | — | — | 0.769 |
The premium-tier laundry liquid carries a raw material cost of ,USD/kg and a total finished cost of ,USD/kg when overhead, labor, and packaging are included. Packaging represents % of the total — the single largest non-formulation expense. For manufacturers selling through retail channels, this packaging cost is inescapable; for bulk institutional sales, its removal reduces the effective cost to ,USD/kg, a % reduction.
24.1.2Active Matter Cost Analysis
Comparing surfactant costs on a per-kilogram basis is misleading because commercial surfactants are supplied at different active-matter concentrations. The correct metric is cost per kilogram of % active material, defined as:
where is the active-matter fraction (e.g., for LABSA %, for SLES %).
Worked Example 2: Equal-Active Comparison of Four Surfactants
| Surfactant | Commercial grade | Active matter (%) | Price (/kg 100% active) | Relative index (LABSA = 100) | |
|---|---|---|---|---|---|
| LABSA | Acid slurry, 96% | 96 | 1.05 | 1.09 | 100 |
| SLES | Paste, 70% | 70 | 1.45 | 2.07 | 190 |
| AOS | Powder, 92% | 92 | 1.65 | 1.79 | 164 |
| APG | Liquid, 50% | 50 | 3.50 | 7.00 | 642 |
On an equal-active basis, APG (alkyl polyglucoside) costs approximately times more than LABSA, reflecting its bio-based feedstock (fatty alcohols from palm or coconut oil plus glucose) and complex multi-step synthesis . This premium limits APG use to premium-tier and natural-positioned products where consumer willingness to pay offsets the ingredient cost. AOS, by contrast, offers a moderate premium of only % over LABSA while providing superior foaming and mildness — a favorable trade-off for medium-tier and personal-care-adjacent formulations. SLES occupies a middle position at the LABSA cost, justified by its excellent flash foam and compatibility with other anionic and amphoteric surfactants. These indices guide substitution decisions: when LABSA prices rise, AOS becomes the economically optimal substitute far sooner than SLES on a cost-per-active basis, even though SLES has a lower commercial price per kilogram.
24.1.3Raw Material Cost Indices
The following table presents relative cost indices for more than thirty raw materials used across the ten product categories covered in Chapters 5–14. LABSA % is assigned an index of . All other values are derived from representative Asian-market bulk prices (FOB, $>$20,tonne lots) collected during 2024–2025 .
Table 1: Raw Material Cost Indices (LABSA 96% = 100)
| No. | Material | Grade / Concentration | Index | Typical active (%) | Source basis |
|---|---|---|---|---|---|
| 1 | Linear alkyl benzene sulfonic acid (LABSA) | 96% | 100 | 96 | FOB China, bulk |
| 2 | Linear alkyl benzene sulfonic acid (LABSA) | 90% (acid slurry) | 90 | 90 | FOB China, bulk |
| 3 | Sodium lauryl ether sulfate (SLES) | 70% paste | 138 | 70 | FOB China, bulk |
| 4 | Sodium lauryl sulfate (SLS) | 95% needle | 120 | 95 | FOB China, bulk |
| 5 | Alpha olefin sulfonate (AOS) | 92% powder | 157 | 92 | India domestic |
| 6 | Alpha olefin sulfonate (AOS) | 38% liquid | 68 | 38 | India domestic |
| 7 | Alkyl polyglucoside (APG) | 50% liquid | 333 | 50 | SE Asia, industrial |
| 8 | Alkyl polyglucoside (APG) | 70% liquid | 476 | 70 | SE Asia, industrial |
| 9 | Fatty alcohol ethoxylate (AE-7) | 100% | 151 | 100 | FOB China, bulk |
| 10 | Fatty alcohol ethoxylate (AE-9) | 100% | 155 | 100 | FOB China, bulk |
| 11 | Coconut diethanolamide (CDEA) | 85% | 200 | 85 | FOB China, bulk |
| 12 | Cocamidopropyl betaine (CAPB) | 30% | 73 | 30 | FOB China, bulk |
| 13 | Cocamidopropyl betaine (CAPB) | 35% | 88 | 35 | FOB China, bulk |
| 14 | Sodium tripolyphosphate (STPP) | 94% | 88 | 94 | FOB China, bulk |
| 15 | Sodium carbonate (soda ash) | Dense, 99% | 20 | 99 | FOB China, bulk |
| 16 | Sodium sulfate (anhydrous) | 99% | 9 | 99 | FOB China, bulk |
| 17 | Sodium metasilicate | Anhydrous | 45 | 100 | FOB China, bulk |
| 18 | Sodium hydroxide | 50% solution | 52 | 50 | FOB China, bulk |
| 19 | Sodium hydroxide | 99% pearl | 58 | 99 | FOB China, bulk |
| 20 | Sodium chloride | Refined | 11 | 99 | FOB China, bulk |
| 21 | Citric acid (anhydrous) | BP/USP | 129 | 100 | FOB China, bulk |
| 22 | Carboxymethyl cellulose (CMC) | Industrial | 210 | 99 | India domestic |
| 23 | Polyacrylate thickener | 30% | 286 | 30 | FOB EU, bulk |
| 24 | Optical brightener (CBS-X) | 100% | 1{,}714 | 100 | FOB China, drum |
| 25 | Enzyme (protease) | Liquid conc. | 2{,}381 | 100 | FOB EU, drum |
| 26 | Enzyme (lipase) | Liquid conc. | 2{,}857 | 100 | FOB EU, drum |
| 27 | Enzyme (amylase) | Liquid conc. | 2{,}619 | 100 | FOB EU, drum |
| 28 | Perfume / fragrance compound | Oil-soluble | 810 | 100 | India domestic |
| 29 | Colorant (dye, 1% solution) | Water-soluble | 286 | 1 | India domestic |
| 30 | Preservative (MIT/CMIT) | 1.5% active | 952 | 1.5 | FOB China, drum |
| 31 | Distilled water | Deionized | <1 | 100 | On-site generation |
| 32 | Ethanol | 96% | 71 | 96 | FOB Brazil, bulk |
| 33 | Isopropyl alcohol (IPA) | 99% | 96 | 99 | FOB China, bulk |
| 34 | Glycerin | 99.5% | 95 | 99.5 | FOB SE Asia, bulk |
| 35 | Tetrasodium EDTA | 99% | 300 | 99 | FOB China, drum |
The index spread is enormous: optical brighteners and enzymes command indices exceeding , while water and sodium sulfate sit below . This three-order-of-magnitude range explains why cost optimization strategies focus almost exclusively on the high-index ingredients. A % price increase in LABSA (index ) raises a typical laundry liquid’s raw material cost by approximately %; the same % increase in fragrance (index ) raises it by only % because fragrance dosage is typically –% versus –% for LABSA. Volume matters as much as unit price. Sodium sulfate, despite its extremely low index of , can become the largest single cost contributor in powder detergent formulations where it constitutes –% of the formula. Any across-the-board raw material price increase therefore requires a per-ingredient impact calculation rather than a simple average.
24.2Formulation Cost Optimization
24.2.1Cost Reduction Strategies
Four primary levers reduce formulation cost while maintaining acceptable performance. Each lever carries trade-offs that must be evaluated against the target product tier.
Filler adjustment. In powder detergents, sodium sulfate and water serve as the principal fillers. Increasing filler content reduces surfactant concentration dollar-for-dollar, but excessive filler dilution degrades cleaning performance below acceptable thresholds. For liquid detergents, water adjustment is similarly direct: each % increase in water content reduces raw material cost by approximately –% in a premium formulation, but active matter drops proportionally.
Surfactant substitution maintaining active matter. The goal is to replace a higher-cost surfactant with a lower-cost alternative at equal total active-matter content. From Table 1, the hierarchy on an equal-active basis is: LABSA () AOS () SLES () APG (). Substituting SLES with LABSA while adjusting for the mildness deficit through a small addition of CAPB is a standard cost-reduction pathway. The active-matter equivalence constraint requires:
where is mass fraction and is the active-matter fraction of the respective surfactant.
Builder optimization. STPP (index ) is partially replaceable by soda ash (index ) and sodium citrate in phosphate-restricted markets, but at reduced water-softening performance. Zeolite A and polycarboxylates offer alternatives but at higher indices (–), making builder optimization region-dependent.
Water content adjustment. For liquid products, increasing water content is the simplest cost-reduction method. A premium laundry liquid at % total solids can be diluted to % total solids for an economical tier, reducing active matter from % to % and raw material cost by approximately %.
24.2.2Tier-Down Optimization
Tier-down optimization takes a premium formulation and systematically reduces cost while preserving the minimum viable performance profile for the target market segment. The procedure follows a priority-ordered sequence.
Step 1 — Reduce or eliminate performance additives. Enzymes, optical brighteners, and specialty polymers are removed first. These carry the highest indices and typically contribute –% of raw material cost while representing % of formula weight.
Step 2 — Substitute surfactants. Replace higher-cost surfactants (SLES, APG) with lower-cost alternatives (LABSA, AOS) while maintaining total active matter above the tier minimum. The mildness and foaming characteristics will shift; compensating additions of foam boosters or amphoteric surfactants may be needed.
Step 3 — Adjust builder and filler levels. Reduce expensive builders (STPP, zeolites) and increase soda ash or water as appropriate for the product form (powder vs. liquid).
Step 4 — Reduce fragrance and colorant levels. Cut fragrance from % to % and colorant from % to %, achieving a –% reduction in these sensory-input costs.
Step 5 — Optimize packaging. Switch from decorated bottles to direct-print or shrink-label alternatives; reduce bottle weight through thin-wall design.
Worked Example 3: Tier-Down Laundry Liquid
| Ingredient | Premium (%) | Medium (%) | Economy (%) | Change rationale |
|---|---|---|---|---|
| Water | 58.0 | 65.0 | 72.0 | Increased dilution for lower tier |
| LABSA (96%) | 14.0 | 14.0 | 12.0 | Reduced but maintained as primary surfactant |
| SLES (70%) | 8.0 | 5.0 | 3.0 | Partially replaced by lower-cost alternatives |
| AOS (38% liquid) | — | 4.0 | 6.0 | Added for cost-effective foaming boost |
| Coconut diethanolamide | 3.0 | 2.5 | 1.5 | Reduced foam stabilizer |
| Sodium chloride | 1.2 | 1.0 | 0.8 | Viscosity adjustment for lower solids |
| Citric acid | 0.5 | 0.4 | 0.3 | pH adjustment |
| Sodium hydroxide (50%) | 0.8 | 0.7 | 0.6 | Neutralization demand reduced |
| Enzyme blend | 0.3 | — | — | Removed for medium and economy tiers |
| Optical brightener | 0.05 | — | — | Removed |
| CMC | 0.5 | 0.3 | 0.15 | Reduced thickener need at lower solids |
| Fragrance | 0.3 | 0.15 | 0.08 | Reduced sensory loading |
| Colorant | 0.2 | 0.1 | 0.04 | Reduced visual intensity |
| Preservative | 0.15 | 0.15 | 0.13 | Maintained for shelf-life stability |
| Total | 87.0 | 93.3 | 96.6 | Balance to % with water |
| Raw material cost ($/kg) | 0.409 | 0.298 | 0.218 | — |
| Cost reduction vs. premium | — | 27.1% | 46.7% | — |
The tier-down example demonstrates that a % cost reduction is achievable by sequentially removing premium additives (enzymes, brighteners), substituting surfactants toward lower-cost options, and increasing water content. Performance testing on the economy-tier formula would show reduced stain removal on oil and protein soils (due to eliminated lipase and protease), lower foaming volume, and less vibrant visual appearance — all acceptable trade-offs for the economy segment where price sensitivity dominates purchase decisions. The medium tier preserves % of the premium formula’s surfactant loading while cutting cost by %, representing the most efficient cost-performance compromise and typically the highest-volume SKU in a multi-tier portfolio.
24.2.3Side-by-Side Cost Comparison: Five Products Across Three Tiers
Table 2: Cost-per-kg Summary for Five Products (Three Tiers)
| Product | Premium (/kg) | Economy ($/kg) | Max reduction (Premium → Economy) | |
|---|---|---|---|---|
| Laundry liquid | 0.769 | 0.562 | 0.418 | 45.6% |
| Dishwashing liquid | 0.712 | 0.518 | 0.382 | 46.3% |
| Fabric softener | 0.652 | 0.482 | 0.352 | 46.0% |
| Bathroom cleaner | 0.598 | 0.432 | 0.314 | 47.5% |
| Car shampoo | 0.868 | 0.642 | 0.478 | 44.9% |
Cost-per-kg comparison across product tiers
The cost reduction range of –% from premium to economy tier is remarkably consistent across all five product categories. This consistency emerges because the same optimization strategies — additive elimination, surfactant substitution, and water adjustment — apply universally. The bathroom cleaner shows the largest reduction (%) because its premium tier relies heavily on specialty solvents and acids that are easily diluted or replaced. Car shampoo shows the smallest reduction (%) because even the economy tier must maintain adequate foam stability and paint-safe surfactant selection, which limits aggressive cost cutting. For a manufacturer operating across all five product lines, the medium tier represents the optimal balance: it captures approximately % of the maximum possible cost reduction while retaining sufficient performance differentiation from the economy tier to justify a meaningful price premium.
24.3Calculators and Worksheets
24.3.1Percentage-to-kg Calculator
Converting formulation percentages to kilogram weights for a production batch is the most frequently performed calculation in manufacturing. The formula is:
where is the mass of ingredient (kg), is its percentage in the formulation (%), and is the total batch mass (kg).
Worked Example 4: 1{,}000 kg Batch Conversion
| Ingredient | % (w/w) | Calculation | kg/1{,}000 kg |
|---|---|---|---|
| Water | 62.0 | 620.0 | |
| LABSA (96%) | 12.0 | 120.0 | |
| SLES (70%) | 10.0 | 100.0 | |
| CDEA | 3.0 | 30.0 | |
| Sodium chloride | 1.2 | 12.0 | |
| Citric acid | 0.5 | 5.0 | |
| Sodium hydroxide (50%) | 0.8 | 8.0 | |
| Fragrance | 0.3 | 3.0 | |
| Colorant | 0.2 | 2.0 | |
| Total | 90.0 | — | 900.0 |
Verification step: The sum of all kg values (,kg) equals the sum of all percentages expressed as a decimal fraction () multiplied by the batch size (,kg). The balance to % (,kg of water) is added during the dilution step after the concentrate is prepared. This two-stage approach — producing a ,kg concentrate and diluting to ,kg — is standard practice to ensure complete solubilization of surfactants and uniform distribution of minor ingredients before final water addition.
24.3.2Active Matter Calculator
Total active matter is the sum of each surfactant’s contribution, calculated as its mass fraction multiplied by its active-matter fraction:
where the summation runs over all surfactants in the formulation. Non-surfactant ingredients (builders, fillers, water) do not contribute to active matter.
Worked Example 5: Active Matter Calculation for Dishwashing Liquid
| Surfactant | Mass fraction (%) | Active fraction | AM contribution (%) |
|---|---|---|---|
| LABSA (96%) | 12.0 | 0.96 | 11.52 |
| SLES (70%) | 8.0 | 0.70 | 5.60 |
| Cocamidopropyl betaine (30%) | 3.0 | 0.30 | 0.90 |
| Coconut diethanolamide (85%) | 2.0 | 0.85 | 1.70 |
| Total active matter | — | — | 19.72 |
The dishwashing liquid contains % total active matter, well above the % minimum typically required for effective grease cutting in hand dishwashing applications. For a premium positioning, this could be increased to –% through higher SLES loading; for an economy tier, it could be reduced to –% with partial LABSA replacement by AOS. The active matter calculator thus serves as both a quality control and a cost-optimization tool: any proposed formulation change is first screened for its impact on total active matter before proceeding to performance testing.
24.3.3Density Prediction
Finished product density is required for converting between mass-based formulations and volume-based packaging specifications. Density is estimated from component densities using volume additivity:
where is the density of component (kg/L or g/mL) and is its mass fraction. This equation assumes ideal volume additivity — an approximation that introduces errors of –% for surfactant solutions due to molecular packing effects, but remains sufficiently accurate for packaging design and batch volume estimation .
Table 3: Component Densities for Density Prediction
| Material | Density (g/mL at 25°C) | Temperature coefficient (g/mL/°C) |
|---|---|---|
| Water (deionized) | 0.997 | −0.00021 |
| LABSA (96%) | 1.050 | −0.00045 |
| SLES (70% paste) | 1.030 | −0.00038 |
| AOS (38% liquid) | 1.040 | −0.00035 |
| APG (50% liquid) | 1.080 | −0.00040 |
| Coconut diethanolamide | 1.040 | −0.00042 |
| Cocamidopropyl betaine (30%) | 1.040 | −0.00035 |
| Fatty alcohol ethoxylate (AE-7) | 0.970 | −0.00055 |
| Sodium chloride | 2.165 | negligible |
| Citric acid (anhydrous) | 1.665 | negligible |
| Sodium hydroxide (50%) | 1.530 | −0.00050 |
| Sodium carbonate (dense) | 2.533 | negligible |
| Sodium sulfate (anhydrous) | 2.660 | negligible |
| STPP | 2.620 | negligible |
| Glycerin (99.5%) | 1.261 | −0.00061 |
| Ethanol (96%) | 0.810 | −0.00110 |
| Isopropyl alcohol (99%) | 0.786 | −0.00102 |
| Fragrance (typical) | 0.950 | −0.00070 |
| CMC (dry powder) | 1.500 | negligible |
Density prediction chart for laundry liquid components
The density prediction for the premium laundry liquid from Section 24.1.1 proceeds as follows:
At ,g/mL, the product is only slightly denser than water. A ,L bottle therefore holds ,kg of product. For packaging procurement, this density determines that a ,mL bottle (with headspace) is required to nominally contain “,L” of product. Temperature effects are modest: cooling from °C to °C increases density by approximately ,g/mL, a negligible change for packaging volume calculations but relevant for mass-based quality control checks conducted at varying ambient temperatures.
24.3.4Cost Impact of Raw Material Substitution
When a key raw material experiences a price increase, the formulation must be re-optimized. This section presents a decision framework for LABSA price escalation and substitution to AOS.
Table 4: Cost Impact Analysis — LABSA Price Increase and Optimal Substitution
| Scenario | LABSA (/kg) | Optimal choice | Cost impact on typical laundry liquid | |
|---|---|---|---|---|
| Baseline (Q1 2024) | 1.05 | 0.72 | LABSA | — |
| Moderate increase (Q2 2024) | 1.20 | 0.72 | LABSA | +$0.021/kg (+5.1%) |
| Severe increase (Q3 2024) | 1.40 | 0.72 | LABSA | +$0.049/kg (+12.0%) |
| Crossover threshold | 1.55 | 0.72 | Indifferent | +$0.070/kg (+17.1%) |
| Post-crossover | 1.70 | 0.72 | AOS 38% | −$0.012/kg (−2.9% vs. LABSA at $1.70) |
| AOS increase (parallel) | 1.70 | 0.85 | AOS 38% | −$0.001/kg (near indifferent) |
The crossover threshold analysis reveals that LABSA remains the lower-cost surfactant even after a % price increase (from to /kg) because AOS % liquid, despite its lower unit price, requires more mass to deliver the same active matter (). Only when LABSA exceeds approximately /kg does AOS % become the economically optimal choice on an equal-active basis. However, substitution to AOS also changes product properties: AOS provides better foam stability and mildness but lower detergency on particulate soils. The decision to substitute must therefore incorporate performance constraints alongside pure cost minimization.
Table 5: Complete Substitution Worksheet
| Parameter | Current (LABSA-based) | Alternative (AOS-based) | Difference |
|---|---|---|---|
| Primary surfactant dosage (%) | 14.0 | 35.4 | +21.4% |
| Primary surfactant active matter (%) | 13.44 | 13.44 | 0% |
| Primary surfactant cost contribution ($/kg product) | 0.147 | 0.255 | +/kg product) |
| Foam profile | Moderate, stable | High, very stable | — |
| Detergency (OECD 404) | Baseline | −8% on particulate soils | — |
| Mildness (zein test) | Baseline | +15% improved | — |
| Biodegradability | >90% | >95% | +5% |
The complete substitution worksheet demonstrates that replacing LABSA with AOS at equal active matter increases the surfactant subsystem cost by % () under baseline pricing. This increase is only justified if the resulting performance improvements (foam, mildness, biodegradability) command a higher selling price or if LABSA prices have risen above the crossover threshold. The worksheet format — showing current, alternative, and difference columns — should be completed for every proposed substitution before pilot-scale validation.
24.3.5Formulation Comparison Worksheet Template
The following table provides a reusable template for comparing any current formulation against proposed alternatives. Each row captures ingredient-level cost data, enabling side-by-side evaluation of total cost, active matter content, and potential savings.
Table 6: Formulation Comparison Worksheet (Template)
Ingredient | % (w/w) | kg/1{,}000 kg | ) | Alternative | Alt. ) | Savings ($) |
|:—|:—:|:—:|:—:|:—:|:—|:—:|:—:|:—:| | Example: Surfactant 1 | 12.0 | 120.0 | 1.05 | 126.00 | AOS 38% | 0.72 | 252.00 | −126.00 | | Example: Surfactant 2 | 8.0 | 80.0 | 1.45 | 116.00 | SLES 70% | 1.45 | 116.00 | 0.00 | | (1) | | | | | | | | | | (2) | | | | | | | | | | (3) | | | | | | | | | | (4) | | | | | | | | | | (5) | | | | | | | | | | (6) | | | | | | | | | | (7) | | | | | | | | | | (8) | | | | | | | | | | (9) | | | | | | | | | | (10) | | | | | | | | | | Sub-total: Raw materials | Σ% | Σkg | — | Σ$ | — | — | Σ alt. $ | Σ savings | | Manufacturing overhead | — | — | $/kg | | — | — | | | | Direct labor | — | — | $/kg | | — | — | | | | Packaging | — | — | /kg** | | — | Alt. $/kg | | Net savings | | Total active matter (%) | — | — | — | % | — | — | % | Δ% |
Table 7: Tier-Down Optimization Checklist for Five Products
| Optimization step | Laundry liquid | Dishwashing liquid | Fabric softener | Bathroom cleaner | Car shampoo |
|---|---|---|---|---|---|
| Remove enzymes | ✓ | ✓ | N/A | N/A | ✓ |
| Remove optical brightener | ✓ | N/A | N/A | N/A | N/A |
| Reduce fragrance 50% | ✓ | ✓ | ✓ | ✓ | ✓ |
| Reduce colorant 50% | ✓ | ✓ | ✓ | ✓ | ✓ |
| Substitute primary surfactant | LABSA → AOS | SLES → LABSA | Quat → diester | Acid → citric | SLES → AOS |
| Reduce specialty polymers | CMC → salt | N/A | Polymer → base | Thickener → salt | CAPB → betaine |
| Increase water/filler | +14% water | +12% water | +10% water | +15% water | +10% water |
| Packaging downgrade | Shrink label | Shrink label | Direct print | Trigger → flip | Trigger → flip |
| Expected cost reduction | 45.6% | 46.3% | 46.0% | 47.5% | 44.9% |
Table 8: Summary of Key Formulas and Calculator Equations
| Calculator | Formula | Variables | Typical use |
|---|---|---|---|
| Cost-per-kg | = mass fraction, = unit cost, OH = overhead, = labor, = packaging | Batch costing, pricing decisions | |
| Percentage-to-kg | = percentage, = total batch mass | Production batch sheets | |
| Active matter | = surfactant mass fraction, = active fraction | Quality control, tier verification | |
| Equal-active substitution | Subscripts denote old and new surfactant | Surfactant swap calculations | |
| Density prediction | = component density | Packaging volume design | |
| Crossover price | = alternative price, = active fractions | Substitution timing | |
| Cost impact | = mass fraction, = price change | Raw material escalation response | |
| Active cost index | Commercial price and active fraction | True surfactant cost ranking |
The eight formulas in Table 8 constitute the complete mathematical toolkit for formulation cost management. The cost-per-kg equation (first row) is applied daily for production batches and monthly for raw material variance analysis. The active matter calculator (third row) is the gatekeeper for any formulation modification: a proposed change that reduces active matter below the tier minimum is rejected before pilot testing regardless of its cost benefit. The crossover price formula (sixth row) determines the trigger point for surfactant substitution in response to commodity price volatility. Used together, these calculators transform cost optimization from a reactive, spreadsheet-intensive exercise into a structured, reproducible decision process that can be executed rapidly in response to market conditions. -e
ewpage