RE: MeBr Calculation

King, Heidi R. to: Jeremy Arling 04/15/2010 03:58 PM

Cc: Ross Brennan

Thank you Jeremy, this is very helpful.

Best,

heidi

-----Original Message-----

From: Arling.Jeremy@epamail.epa.gov

[mailto:Arling.Jeremy@epamail.epa.gov]

Sent: Thursday, April 15, 2010 3:39 PM

To: King, Heidi R.

Cc: Brennan.Ross@epamail.epa.gov

Subject: MeBr Calculation

Heidi

Here is an annotated version of the spreadsheet that shows the

calculation of Stocks and New Production allocations.

(See attached file: 2010 Allocation calculation.xls) I was looking at

the wrong line on a different spreadsheet open when I said the change in

the CSA between the proposed and the final was only 17,000 kg. That is

the sum of the changes due to the revised carryover and the new decision

by the Parties (cells E6 and E27 in the version Im attaching here)

Let me know if you have any additional questions.

Jeremy Arling

U.S. EPA

Stratospheric Protection Division

Office of Atmospheric Programs

Mail Code: 6205J

1200 Pennsylvania Avenue, NW

Washington, D.C. 20460-0001

202-343-9055

arling.jeremy@epa.gov
U.S. authorization from Decision XX/5 3,233,456 12.7% 3,233,456 12.7% Changes between proposed and final

U.S. authorization from Decision XXI/11 NA NA 2,018 0.0% additional authorization for SE strawberry nurseries

(1) Total US Authorization 3,233,456 12.7% 3,235,474 12.7%

(2) - Maximum allowable new production/import 2,763,456 10.8% 2,765,474 10.8%

(3) = Minimum allowable CSA 470,000 1.8% 470,000 1.8%

U.S. authorization (1) 3,233,456 12.7% 3,235,474 12.7%

(4) - Reduction for uptake of alternatives 0.0% 0.0%

(6) = One year's CUE need 3,233,456 12.7% 3,235,474 12.7%

x Percentage of year's production to recover 62.940% 62.936%

(6) = SCF to meet that need 2,035,000 2,036,000 additional authorization has slight effect on SCF value

(7) Existing pre-phaseout inv on 1/1/09 ("ES") 4,271,226 4,271,226

(8) - Estimated/actual drawdown of ES during 2009 ("D") 2,834,226 1,207,118 received actual end of year data which allowed use of existing 

(9) - SCF (6) 2,035,000 2,036,000 framework for calculating available stocks

(10) = Available stocks ("AS") -598,000 1,028,108 4.0%

(11) Reported as produced/imported in 2008 3,036,130 3,036,130

(12) - Reported as sold in 2008 2,768,853 2,784,539

(13) = Unsold carryover 267,277 251,591 1.0% carryover was not correctly applied in proposal

Total U.S. authorization (1) 3,233,456 12.7% 3,235,474 12.7%

- Minimum Allowable CSA (3) / CSA (10) 470,000 1.8% 1,028,108 4.0%

- Carryover (13) 267,277 1.0% 251,591 1.0%

- Research 0 0.0% 0 0.0%

- Uptake of alternatives 0 0.0% 0 0.0%

= Gross new production (14) 2,496,179 9.8% 1,955,775 7.7%

(14) Gross new production 2,496,179 NA did not finalize the proposed approach to ensure new

- New Production in 2009 2,275,715 production does not increase

(15) = Increase in CUA 220,464 0.9%

Minimum Allowable CSA (3) 470,000 1.8%

+ Increase in CUA (15) 220,464 0.9%

(16) = Critical Stock Allowance (CSA) 690,464 2.7%

Gross New Production (14) 2,496,179 9.8%

- No increase in CUA (15) 220,464 0.9%

(17) = Net New Production (CUA) 2,275,715 8.9%

CUA (17) 2,275,715 8.9% 1,955,775 7.7%

 + CSA (16) 690,464 2.7% 1,028,108 4.0%

= Total 2,966,179 11.6% 2,983,883 11.7%

Calculate "available stocks"

Proposed Rule

Calculate New Production (=CUA) in Proposed Rule

Calculate total amount allocated

Calculate carryover

Calculate gross new production

Calculate increase in year to year new production

Calculate CSA In Proposed Rule

Final Rule New

2010 authorizations from the Parties

Calculate supply chain factor

2010 CUE Calculations (proposed and final)