Customer name

Location
Data Input Page Date prepared 27/7/22

This work book will calculate the estimated chemical and energy costs for the current process, the proposed
Atotech Paint Pretreatment System, and the net cost difference.
Please enter all data in the coloured fields provided in this sheet only
and in the format specified. Everything else will be automatically calculated. Gold, Silver and Bronze cells
are assigned based on their influence on the Energy Calculations.

Note. If the tank is not heated, please enter and type "ambient" as shown below.
Leave empty the stages that are not used.

Customer Information

Customer Name IPTI USD to IDR 15000

City, Country Karawang, Indonesia
Hours of operation/day 8
Days of operation/month 21
Days of operation/week 5
Days of operation/year 252
Energy: (Local Currency)/Therm
Energy: (Local Currency)/kWh
Please enter
Energy: (Local Currency)/CCF
one only Energy: (Local Currency)/MCF
Energy: (Local Currency)/BTU 0.3422888143 15900 IDR/kg LPG 46,452 kg LPG to BTU
Cost of Energy: (Local Currency)/kWh 1,168.221 Line Type and Conveyor Speed
Work Load (steel): kg/hour 2066 I Immersion Line
Work Load (Al): kg/hour S1.5 Spray Line <1.5 m/min
Area of substrate: m2/day 1410 S1.5to5 Spray Line >1.5m/min, <5m/min
Line Type and Conveyor Speed: m/min S1.5to5 S5 Spray Line >5m/min
Room temperature: °C 33.0

Current Process Information Pretreatment Cycle Proposed

*Note: Stage Type drop down list indicates stage type:

C = Cleaner R = Rinse P = Phosphate or Conditioner stage S = Seal

Stage 1 *Stage Type C Stage 1 *Stage Type C

Duta Kimia Concentration: % by volume 4.5% Concentration Part A: % by volume
Chemical Cost: (Local Currency)/L 30,000.00 Concentration Part B: % by volume
Operating Temperature: °C 40 Chemical Cost Part A: (Local Currency)/kg
Adjustment Factor 0.550 Chemical Cost Part B: (Local Currency)/kg
Chemical consumption: L/month 100 1200 Specific Gravity - Part A
Tank Volume: L 1780 Specific Gravity - Part B
Length Width Height Chemical Cost Part A: (Local Currency)/L 0.000
Tank Dimensions: m
2.60 1.00 0.80 Chemical Cost Part B: (Local Currency)/L 0.000
Pump flow rate: L/min 1152 69120 Operating Temperature: °C ambient
Dump frequency: remakes/year 6 Adjustment Factor 1.000
Dump frequency: remakes/year

Stage 2 *Stage Type C Stage 2 *Stage Type C

Duta Kimia Concentration: % by volume 4.5% Concentration Part A: % by volume 0.0%
Chemical Cost: (Local Currency)/L 30,000.00 Concentration Part B: % by volume
Operating Temperature: °C 40 Chemical Cost Part A: (Local Currency)/kg 0.000
Adjustment Factor 0.000 Chemical Cost Part B: (Local Currency)/kg
Chemical consumption: L/month 0 Specific Gravity - Part A 0.000
Tank Volume: L 15000 Specific Gravity - Part B
Length Width Height Chemical Cost Part A: (Local Currency)/L 0.000
Tank Dimensions: m
10.00 10.00 1.50 Chemical Cost Part B: (Local Currency)/L 0.000
Pump flow rate: L/min 288 17280 Operating Temperature: °C ambient
Dump frequency: remakes/year 1 Adjustment Factor 1.000
Dump frequency: remakes/year

Stage 3 *Stage Type P surface Stage 3 *Stage Type R

Duta Kimia Concentration: % by volume 0.4% Concentration Part A: % by volume
Chemical Cost: (Local Currency)/L 60,000.00 Concentration Part B: % by volume
Operating Temperature: °C ambient Chemical Cost Part A: (Local Currency)/kg
Adjustment Factor 0.600 Chemical Cost Part B: (Local Currency)/kg
Chemical consumption: L/month 11 132 Specific Gravity - Part A
Tank Volume: L 1000 Specific Gravity - Part B
Tank Dimensions: m Length Width Height Chemical Cost Part A: (Local Currency)/L 0.000
Length Width Height 1.70 1.00 0.60 Chemical Cost Part B: (Local Currency)/L 0.000
Pump flow rate: L/min 360 Operating Temperature: °C ambient
Dump frequency: remakes/year 52 Adjustment Factor 1.000
Dump frequency: remakes/year

Stage 4 *Stage Type P Stage 4 *Stage Type I5707

Duta Kimia Concentration: % by volume 2.2% Concentration Part A: % by volume
Chemical Cost: (Local Currency)/L 40,000.00 Concentration Part B: % by volume
Operating Temperature: °C 40 Chemical Cost Part A: (Local Currency)/kg
Adjustment Factor 4.800 Chemical Cost Part B: (Local Currency)/kg
Chemical consumption: L/month 500 6000 Specific Gravity - Part A
Tank Volume: L 2350 Specific Gravity - Part B 1.000
Tank Dimensions: m Length Width Height Chemical Cost Part A: (Local Currency)/L 0.000
Length Width Height 2.00 2.00 0.60 Chemical Cost Part B: (Local Currency)/L 0.000
Pump flow rate: L/min 1440 Operating Temperature: °C ambient
Dump frequency: remakes/year 4 Adjustment Factor 1.000
Dump frequency: remakes/year
 INDO PLATING TECHNOLOGY INDUSTRY
KARAWANG
The summary below compares the estimated chemical and energy costs associated with the current paint pretreatment system to the estimated
chemical and energy costs with the proposed Atotech paint pretreatment system.

Current Paint Pretreatment Process

Estimated annual chemical cost: 342,249,893 (Local Currency)
Estimated annual energy cost: 701,765,796 (Local Currency)
Estimated annual CO2 emissions: 108.84 (Metric Tonnes p.a.)
Total Costs: 1,044,015,688 (Local Currency)

Atotech's Paint Pretreatment System

Estimated annual chemical cost: 0 (Local Currency)
Estimated annual energy cost: 0 (Local Currency)
Estimated annual CO2 emissions: 0.00 (Metric Tonnes p.a.)
Total Costs: 0 (Local Currency)

Decrease in CO2 emissions: 108.8 Tonnes CO2 per year

Equivalent to: 23.7 Less Passenger Vehicle Emissions*

* https://www.epa.gov/greenvehicles/greenhouse-gas-emissions-typical-passenger-vehicle

Chemical savings available: 342,249,893 (Local Currency)

Energy savings available: 701,765,796 (Local Currency)
Total savings available: 1,044,015,688 (Local Currency)
Note: This cost summary does not take into account the potential labor savings resulting from reduced demand for sludge removal, nozzle cleaning, or
machine maintenance. The potential savings resulting from reduced waste treatment and disposal costs are also not included.