Content:
    Kim Coffman

 Pagemasters:
    OMM Web Team

Additional Information for OCS Economic Impact Models Upgrade Contract

The files at this site are available for download, primarily for bidders responding to Solicitation No. 0103RP72470, for a contract to upgrade the MMS Outer Continental Shelf (OCS) Economic Impact Models (EIM) for the Gulf of Mexico (GOM) and the Alaska OCS.    

As stated in the RFQ and the RFP, the OCS EIM have 2 conceptual steps, the first estimating the level of spending (by sector and location) and the second converting the spending into estimates of employment, personal income, etc.  The sample model for the Gulf of Mexico is a full 2-step model.  There are three sample models for the Alaska OCS.  The first two are 1^st-step models.  The third, consisting of four linked files, would normally be a full version of Sub-Arctic IMPAK.  However, the links would have to be re-established for the model to work.  (See document no. 4 below.)  The first three Alaska files are “final” versions of first-step models recently received from the contractor, and they are under MMS review. 

Some of the models, especially those with IMPLAN multipliers, contain proprietary or confidential data.  Therefore, they are for examination only and are not to be used for work unrelated to this contract without specific permission.

Documentation and Labor Needs survey files are in Adobe’s Portable Document Format (pdf).  Excel files are in Excel 2002 (Office XP) xls format.  Access files are in Access 2002 (Office XP) format.

If the models do not open correctly, save them to your own hard drive or network, then open them. You must “Enable Macros” for the Alaska Excel models to work properly. Also note that the 3 documents linked to the Documentation worksheets in the Arctic files are provided on this site.

 Documentation:

1. The New Regional Economic Impact Modeling Approach for the U.S. Minerals Management Service (Article describing the OCS EIM in general)
2. Modeling the Economic Impacts of Offshore Oil and Gas Activities in the Gulf of Mexico:  Methods and Applications (0.6Mb)  (Draft Final report on data underlying cost functions for GOM models)
3. Description of Sample OCS EIM (GOM)  (One page description and instructions, sample GOM model)
4. Basic Directions for Use of Sample OCS EIM (Arctic)
5. Reports:
   1. Arctic Economic Impact Model for Petroleum Activities in Alaska (Arctic IMPAK) (2.2Mb)
   2. Report:  Sub-Arctic Economic Impact Model for Petroleum Activities in Alaska (Sub-Arctic IMPAK) (1.1Mb)
6. Model Documentation
   1. Arctic IMPAK Model Documentation
   2. Sub-Arctic IMPAK Model Documentation
7. Modeling the Economic Impacts of Offshore Activities in the Alaska Arctic (Article describing approach to 1^st-step Arctic model)

Sample models:

8. OCSEIM.sample.GOM.XP.mdb (0.8Mb)
9. Arctic_IMPAK.xls (3.6Mb)
10. OCSEIM.sample.Arctic.E&D.xls
11. OCSEIM.sample.Arctic.Link.xls (Correction made to Overview worksheet, lines 25 & 26, on 27 Jun 2003)
12. OCSEIM.sample.Arctic.IMPAK-2.mdb
13. Arctic_IMPAK_Local_Gas.xls (3.2Mb)
14. Sub-Arctic_IMPAK.xls (5.7Mb)

General information about models and planning area maps.

15. List and Description of Features of each Model
16. List of Onshore Areas
17. Lists of IMPLAN sectors in Current Models
18. Map of Lower 48 OCS Planning Areas
19. Map of Alaska OCS Planning Areas

Documents from study “Deepwater Program:  Assessing and Monitoring Industry Labor Needs”

20. List of Survey Variables (preliminary results to be available by contract kick-off in September)
21. Contractor Survey Forms
22. Operator Survey Forms
23. Pipeline Company Survey Forms
24. Platforms/Rig Construction Company Survey Forms
25. Pre-Sale Expenditures Survey Forms
26. Seismic Company Survey Forms
27. Transportation Company Survey Forms
28. Employee Survey Forms:  Operators
29. Employee Survey Forms:  Pipeline Companies
30. Employee Survey Forms:  Platform/Rig Construction Companies
31. Employee Survey Forms:  Seismic Companies
32. Employee Survey Forms:  Transportation Companies