Preliminary Planning -- Baseline Costs: In-house Data Call Instructions
Each command will complete and submit information for all in-house costs supporting the commercial activity identified for this data call using the data element definitions below and the transmittal memorandum with its instructions. Each command will submit its information to its Preliminary Planning Project Delivery Team (PP PDT) representative identified in the Data Call Instructions paragraph 7, Points-of-Contact. Each command's functional area point-of-contact (POC) will review its submission for consistency, accuracy, and adequacy prior to its submission to its PP PDT representative. The PP PDT representative will review the submission for consistency and completeness prior to forwarding the information to HQUSACE. For Divisions, the Division's PP PDT representative will review each District's submission for consistency and completeness prior to forwarding the information to HQUSACE. A FTE "cell" is "number." Other "cells" are "currency." Enter data without using dollar sign ($) or commas (,). Enter whole numbers only. The instructions and in-house template "rows" have been "color coded" for an easy "cross-walk" between them. In the In-house template, each major Cost Category has been given its own "color" and has been numbered to correspond to the number on the Standard Competition Form (SCF). Color Code: Color Code: Color Code: Color Code: Color Code: Color Code: equals equals equals equals equals equals Personal Costs Materials & Supplies Other Specifically Attributable Costs Overhead Additional Costs Grand Total
General Instructions:
The data call in-house template will not be modified for any reason. Any changes that need to be made will be done by the Strategic Sourcing Program Office (SSPO). IMPAC VISA Credit Card Purchases. The IMPAC card holder often uses his/her IMPAC card to purchase equipment (minor items), materials and supplies, services and support services needed to support the day-to-day activities performed and services provided for a commercial activity. Only the costs for equipment (minor items), services, and service support are captured in Special Instructions: IMPAC VISA Card Card Purchases. NOTE: The cost of materials and supplies purchased using an IMPAC card is captured in the Baseline Costs: Materials & Supplies data call template. The total for annual cost for In-house materials and supplies is the sum of all Annual Costs (column F) on the Baseline Costs: Materials & Supplies data call spreadsheet. That value is enter into the Materials and Supplies "cell" (F43) on the data call In-house template. Printing Instructions: DO NOT CHANGE Page Setup, Print Area, or Print settings. Settings made so Instructions and In-house "sheets" print properly. The Instructions "sheet" will print in "portrait" format and the In-house "sheet" will print in "landscape" format. Font set as Arial, size ten (10). Paper size for both is standard letter (8 1/2" x 11"). Data Definitions Example Definition Name of the competition. O&M of Navigation Locks and Dams Date this spreadsheet completed (DD-MMM-YY). 1-Jun-06 Enter using dashes (-). Name of the person to contact regarding this information. Duty phone number of POC. USACE District. Use alphabetic abbreviation that uniquely identifies the command; i.e., Division, District to its Division, Center, Lab, or FOA. The baseline period fo the data/information being collected. Minimum period is 12 months, and is typically last fiscal year if public announcement will be made prior the end of the current fiscal year. Jane Doe 703-123-4567 SAW (Wilmington District)
Data Element Competition As-of-Date POC Phone Number District
Baseline Period
FY2006
Additional Information For a "horizontal" line, add any additional information FTE is total number of authorized (filled or vacant), reviewable positions needed to help explain or clarify a Cost Category entry. in the O&M of Locks and Dams including the Maintenance and Repair facilities. FTE Total number of authorized positions (filled or vacant) Full-time permanent 7; Part-time permanent 2; Full or Part-time identified with the commercial activity functions for this temporary 0; Seasonal 3 competition, i.e., O&M of Locks and Dams including Maintenance and Repair facilities. The FTEs are divided into four different appointment categories - Fulltime permanent, Part-time permanent, Full or Part-time temporary, and Seasonal employees.
Competitive Sourcing Sensitive Information -- Limited Distribution/Sharing Page 1 of 7
Preliminary Planning -- Baseline Costs: In-house Data Call Instructions
Data Element 1. Personnel Costs
Data Definitions Example Definition O&M of Navigation Locks and Dams Calculated Field - summation of Labor Costs, Fringe Calculated field Benefits, Other Pay, and Other Pay Entitlements, and Administration & Surveillance of Contract and Fee-ForService Agreements as well as Performance Awards. Calculated field - summation for Direct and Indirect Labor. Calculated field
Labor Costs Direct Labor
Summation of current calendar year salaries, including Full-time permanent 1400000; Part-time permanent 400000; Full or Partlocality pay, of all positions identified with the time temporary 0; Seasonal 30000 commercial activity functions. Enter whole number without dollar sign ($) or commas (,). Summation of current calendar year salaries for supervision and management of Direct Labor. Enter whole number without dollar sign ($) or commas (,). Total cost for performance awards given to Direct Labor staff only. Enter whole number without dollar sign ($) or commas (,). Calculated field based upon 32.85% of direct labor costs for full-time and part-time permanent FTE positions, Full fringe benefits includes retirement, insurance and health, medicare, and miscellaneous benefits. The calculation is 7.65% of direct labor costs for temporary and seasonal FTE positions. This amount is the Social Security (FICA) amount. Full-time permanent 490000; Part-time permanent 140000; Full or Parttime temporary 0; Seasonal 10500 6678
Indirect Labor
Performance Awards Fringe Benefits
Calculated field
Other Pay - GS Schedule FTEs
Overtime - GS
Calculated field based on summation of overtime, Calculated field holiday pay, Sunday pay, night pay, cash awards, bonuses, and uniform allowance for General Schedule FTEs only Annual labor costs for overtime for the commercial Full-time permanent 2000; Part-time permanent 0; Full or Part-time activity. Enter whole number without dollar sign ($) or temporary 0; Seasonal 2000 commas (,). Annual cost for holiday pay for individuals in the Full-time permanent 5000; Part-time permanent 0; Full or Part-time commercial activity. Enter whole number without dollar temporary 0; Seasonal 10000 sign ($) or commas (,). Annual cost for Sunday pay for individuals in the Full-time permanent 3000; Part-time permanent 1000; Full or Part-time commercial activity. Enter whole number without dollar temporary 0; Seasonal 25000 sign ($) or commas (,). Annual cost for Night pay for individuals in the Full-time permanent 2000; Part-time permanent 1000; Full or Part-time commercial activity. Enter whole number without dollar temporary 0; Seasonal 3000 sign ($) or commas (,). Full-time permanent 7000; Part-time permanent 1000; Full or Part-time temporary 0; Seasonal 500
Holiday Pay - GS
Sunday Pay - GS
Night Pay - GS
Cash Awards - GS Annual cost for cash awards, not to include performance awards, for individuals in the commercial activity. Enter whole number without dollar sign ($) or commas (,). Bonuses - GS Annual cost of bonuses such as retention, relocation, or hiring bonuses for individuals in the commercial activity. Enter whole number without dollar sign ($) or commas (,). Uniform Allowance - Annual cost for uniforms allowances for individuals in GS the commercial activity. Enter whole number without dollar sign ($) or commas (,).
Full-time permanent 15000; Part-time permanent 0; Full or Part-time temporary 0; Seasonal 0
Full-time permanent 0; Part-time permanent 0; Full or Part-time temporary 0; Seasonal 0
Other Pay Calculated field - summation of overtime, holiday pay, Calculated field Entitlements Wage Sunday pay, night and environmental differentials, Grade Schedule FTEs cash awards and bonuses for Wage Grade FTEs only. Overtime - WG Annual labor costs for overtime for the commercial activity. Enter whole numbers without dollar sign ($) or commas (,). Annual cost for holiday pay for individuals in the commercial activity. Enter whole numbers without dollar sign ($) or commas (,). Full-time permanent 2000; Part-time permanent 0; Full or Part-time temporary 0; Seasonal 2000 Full-time permanent 5000; Part-time permanent 0; Full or Part-time temporary 0; Seasonal 10000
Holiday Pay - WG
Competitive Sourcing Sensitive Information -- Limited Distribution/Sharing Page 2 of 7
Preliminary Planning -- Baseline Costs: In-house Data Call Instructions
Data Definitions Example Data Element Definition O&M of Navigation Locks and Dams permanent 1000; Full or Part-time Sunday Pay - WG Annual cost for Sunday pay for individuals in the Full-time permanent 3000; Part-time commercial activity. Enter whole numbers without temporary 0; Seasonal 25000 dollar sign ($) or commas (,). Night Differential - Annual labor cost for night differential pay for WG individuals in the commercial activity. Enter whole numbers without dollar sign ($) or commas (,). Environmental Differential - WG Full-time permanent 4500; Part-time permanent 2500; Full or Part-time temporary 0; Seasonal 2500
Annual labor cost for environmental differential pay for Full-time permanent 4500; Part-time permanent 2500; Full or Part-time individuals in the commercial activity. This includes temporary 0; Seasonal 2500 hazardous conditions, physical hardship, and working in unusual or severe conditions as determined by OPM regulations. Enter whole number without dollar sign ($) or commas (,). Full-time permanent 5000; Part-time permanent 1000; Full or Part-time temporary 0; Seasonal 750
Cash Awards - WG Annual cost for cash awards, not to include performance awards, for individuals in the commercial activity. Enter whole number without dollar sign ($) or commas (,). Bonuses - WG Annual cost of bonuses such as retention, relocation,
Administration & Surveillance of Contracts and FeeFor-Service agreements 2. Materials & Supplies Materials and Supplies
Full-time permanent 0; Part-time permanent 0; Full or Part-time or hiring bonuses for individuals in the commercial temporary 0; Seasonal 0 activity. Enter whole number without dollar sign ($) or commas (,). The annual cost of labor and other related costs for the Full-time permanent 4500; Part-time permanent 0; Full or Part-time administration and surveillance of FY 04 contracts that temporary 0; Seasonal 0 support the commercial activity, i.e. COR and COTR costs. Calculated field - summarization of material, supplies, shipping and handling. Calculated field
Shipping and Handling
Annual cost of all materials and supplies. The total for 60560 annual cost for In-House materials and supplies is the sum of all Annual Costs (column F) on the Baseline Costs: Materials & Supplies data call spreadsheet. Enter whole numbers without dollar sign ($) or commas (,). Annual cost for shipping and handling of materials and 4578 supplies purchased in support of the commercial activity not captured elsewhere. Enter whole numbers without dollar sign ($) or commas (,).
Competitive Sourcing Sensitive Information -- Limited Distribution/Sharing Page 3 of 7
Preliminary Planning -- Baseline Costs: In-house Data Call Instructions
Data Definitions Example Data Element Definition O&M of Navigation Locks and Dams Calculated field 3. Other Specifically Calculated field - summarization of costs for Depreciation, Facilities, Insurance, IMPAC (Credit Attributable Costs Card) Purchases, Travel, and Other Costs. Depreciation Minor Items Calculated field - summation of minor items and capital Calculated field assets. Actual cost of minor items (less than 25K). Use 10800500 Property Book value. Enter whole number without dollar sign ($) or commas (,). You can use the prepopulated Equipment spreadsheet as a source of these items. Capital or major items (cost greater than 25K) use the 10900600 depreciated value. Enter whole number without dollar sign ($) or commas (,). May be a PRIP item should be in CEFMS - RM may be able to assist. Calculated field - summation of rent, utilities and maintenance and repair costs. Calculated field
Capital Assets
Facilities Rent Utilities
Annual cost of rent. Enter whole number without dollar 350000 sign ($) or commas (,). Annual cost of utilities (electric, telephone, water, sewage, etc.). Enter whole number without dollar sign ($) or commas (,). Annual cost of maintenance and repair NOT REPORTED ELSEWHERE. Enter whole number without dollar sign ($) or commas (,). Calculated field - summation of Casualty, GFE Casualty, and Liability Insurance 200000
Maintenance and Repair Insurance
500000
Calculated field Calculated field N/A Calculated field 9800
Casualty Insurance Calculated field - sum of materials & supplies and depreciation costs multiplied by .005. GFE Casualty Insurance IMPAC (Credit Card) Purchases For this data call, this cost will not be captured or calculated. Annual amount of credit card purchases for equipment, services, and support services. Enter whole number without dollar sign ($) or commas (,). Do not include IMPAC purchases for Materials and Supplies that were entered on the Materials and Supplies spreadsheet. Annual cost of travel associated with this commercial activity. Enter whole number without dollar sign ($) or commas (,). Annual cost of other activities associated with the commercial activity such as training, certification renewal, etc. Enter whole number without dollar sign ($) or commas (,). Calculated entry based on 12% of personnel costs for the commercial activity. Annual cost for unusual or special costs for special circumstances, medical or physical exams, etc. Documentation is required to support cost and computation. Enter whole number without dollar sign ($) or commas (,). Calculated field summation of Personnel Costs, Materials & Supplies, Other Specifically Attributable Costs, Overhead and Additional Costs.
Liability Insurance Calculated field - personnel costs multiplied by .007
Travel
3000
Other Costs
2000
4. Overhead 5. Additional Costs
Calculated field 1500
Grand Total
Calculated field
Competitive Sourcing Sensitive Information -- Limited Distribution/Sharing Page 4 of 7
Preliminary Planning -- Baseline Costs: In-house Data Call Instructions
Data Element Pay Tables
Data Definitions Example Definition O&M 146 WV Identify and list all OPM Pay tables that apply to the FWS of Navigation Locks and Dams positions (staff) covered in this data call. Your RM office may be able to supply this information. If not, another source is the OPM website. For General Schedule (GS) tables: http://www.opm.gov/oca/05tables/index.asp and for Wage Grade tables: http://www.cpms.osd.mil/wage/wage.html. Select Appropriated Fund Pay Schedules.
Competitive Sourcing Sensitive Information -- Limited Distribution/Sharing Page 5 of 7
Preliminary Planning Data Call Template
BASELINE COSTS: In-house
Competition Name: POC: Command: Baseline Period: Full-Time Premenant Cost Category FTE 1. Personnel Costs Labor Costs Direct Labor Indirect Labor Performance Awards Fringe Benefits Other Pay (GS) Overtime Holiday Pay Sunday Pay Night Pay Cash Awards Bonuses Uniform Allowance Other Pay Entitlements (WG) Overtime Holiday Pay Sunday Pay Night Differential Environmental Differential Cash Awards Bonuses Admin & Surveillance of Contract and Fee-For-Service Agreements 2. Materials & Supplies Materials and Supplies Shipping & Handling Part-Time Premenant Full & Part-Time Temporary
As of Date: Phone Number:
Seasonal
Sub Total
Total $0 $0 $0 $0 $0 $0 $0 $0 0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Additional Informaiton
$0 $0
$0 $0
$0 $0
$0 $0
$0
$0
$0
$0
Competitive Sourcing Sensitive Information -- Limited Distribution/Sharing
6
Preliminary Planning Data Call Template
POC: Command: Baseline Period: 3. Other Specifically Attributable Costs Depreciation Minor Items Capital Assets Facilities Rent Utilities Mainteance & Repair Insurance Casualty Insurance GFE Casualty Insurance Liability Insurance IMPACT VISA Credit Card Purchases (Labor & Equipment/Services/Service Support) Travel Other Costs 4. Overhead 5. Additional Costs Grand Total (Line 6) Pay Tables
Phone Number:
$0 $0
$0
$0
$0 $0 $0
$0
$0
$0
$0
$0 $0 $0 $0
$0
$0
$0
$0
Competitive Sourcing Sensitive Information -- Limited Distribution/Sharing
7