Kevin L. Boyle, Consulting

Integrated Products Profiles can be used to mirror the product portfolio of a company or a geographic market.  IPP demonstrate the integrated margins that are realized within the selected value chain by feeding monomer, like ethylene, into a variety of selected products — polyethylene, MEG and Styrene monomer, for example.

Example:

1. Feedstock mix yields Ethylene, benzene and propylene

2. Ethylene and benzene are fed into ethylbenzene at cost.  Ethylene fed into HDPD and LLDPE at cost.  Propylene fed into polypropylene at cost.

3. Ethylbenzene converted to styrene at cost.

4. Products sold at market; margin totaled.

Each custom built Integrated Products Profiles Excel® Workbook contains:

· Separate worksheet for each product with detailed information on

· Inputs

· Variable costs —  Itemized

· Fixed costs — Itemized

· Reference prices page for products and input prices  —  feeds all worksheets in the workbook

· Historical Data page with macro button to create a history of costs and margins of selected products and reference prices

· Summary page with current costs and margins of selected products