D--WEB BASED EMPLOYEE TIMECARD SYSTEM UPGRADE

This announcement is published as a Total Small Business Set-Aside action per FAR 52.219-1 and 52.219-6 (this means you must be a small business, quoting the product of a small-business manufacturer); all eligible, responsible sources may submit an offer. This is a combined synopsis / solicitation for commercial items prepared in accordance with FAR 13 and the format in FAR subpart 12.6, as supplemented with additional information included in this notice. Solicitation number / RFQ N00244 -04-T-1306 applies; an electronic copy of the RFQ can be accessed at http://www.neco.navy.mil . This solicitation document and incorporated provisions and clauses are those in effect through Federal Acquisition Circular 2001-24 and DFAR Change Notices effective through 20040625. The associated NAICS code is 518210 and the business size standard is $18.0M. The agency need is for programming support of electronic Employee Time Card (ETC) system to be completed 8 weeks from date of award.! The requirement is for a firm fixed priced contract for one line item as follows. The ETC System is a web application for SE50 Division Employees to submit their daily labor times, leave hours, and associated ABM codes. 1. Development Requirements a. Business and Technical Requirements will be grouped and associated with functional modules (ASP pages, DLLs, Stored Procedures, Queries, etc.) and documented. i. Documentation will include: 1. Requirements fulfilled by the module 2. Functional explanation of the module 3. Diagram of interaction/dependencies with other modules 4. Risk analysis of the module based on the likelihood of it not fulfilling its requirements and the impact this will have on the system and development schedule. b. Functional module documentation will be presented for approval to the Government POC (Bryan Chun) at least one week before development of that module is scheduled to begin. i. Government approval or recommendation for change will be presented to the developer within 3 business days of receipt. c. An overall schedule including, modules, deliverables, and project completion will be presented to the Government POC during the weekly meeting at NSWC Corona (currently Thursdays 1330-1500) i. Deliverables are defined as functional module documentation, completed modules, code/user/administrator documentation, and schedules. 2. Business Requirements a. The ETC system must comply with all current business rules and processes including, but not limited to: b. SE50 Division Employee Labor rules i. Time In/Time Out data recorded when it occurs by the weekly lockdown time (currently Thursday 1200), employees must have completed their time for Sunday-Wednesday, estimated their total hours for Thursday-Saturday, and assigned ABM codes to all hours. ii. Hours not requiring In/Out Times (Vacation, Leave, Travel, Holiday) may be entered for future dates. 1. Vacation, Leave and Travel can be entered for a multi-day period (as a single action), in addition to a single day at a time. iii. The system should be able to compute pay period equations based on employee work schedule: 1. First 80- Employees work 80 hours over the 2-week pay period any way they see fit. Compute how many hours the employee has worked for the pay period, and how many the employee has left for the pay period 2. First 40- Employees work 40 hours over a week any way they see fit. Compute how many hours the employee has worked for the week, and how many the employee has left for the week. 3. Straight 8- Employees work 8 hours on Monday-Friday. Error check all weekday values against 8 hours. iv. Timecards are submitted at the weekly lockdown time, and reconciled between then and the final lockdown time (currently Monday 0900) All estimated days must be reconciled into Time In/Time Out or Vacation, Travel, Leave hours. 1. Changes from estimates to actuals made per hour, per ABM code will be reported to Timecard Administrators. c. SE50 Division Branch Administration Rules i. Branch Administrators have the ability to view/print/edit their employees timecards within the Labor rules and Timecard process. d. SE50 Division Timecard Administration (TAs) Rules i. TAs can lock/unlock employee timecards at any time. ii. TAs can change employee timecards at any time. iii. TAs can view/print employee timecards at any time by employee, branch, division, SLDCADA order. iv. TAs can add/delete/edit holiday hours globally in a single action. e. SE50 Division ABM Code- formatting and reference tables to be provided i. Customer paying for ii. Customer working for iii. Work Breakdown Structure primary iv. Work Breakdown Structure secondary (System) v. Subsystem vi. Activity- default Non-System vii. Project- optional viii. Exercise- optional 3. Functional Requirements a. Employee Section i. Daily Time In/Time Out entry will require no more than 4 pages to complete: login page, calendar page with current date for data entry, daily page for past dates, and the verification/correction page. ii. Vacation, Travel, Leave entry will require no more than 3 pages to complete: login page, calendar page, and the verification/correction page. iii. ABM Codes 1. ABM Codes must be displayed as English language format and error checked against the reference list. 2. The last 10 used ABM Codes from Customer paying to Subsystem (parts i. Through v.) must be - hot buttoned on the daily time entry page. b. Branch Administration Section i. Existing functionality ii. Single page view/enter time for branch employees c. Timecard Administration Section i. Existing functionality ii. Charge Numbers 1. - hot button the last 5 Charge Numbers per employee 2. - hot buttons for 5 Charge Numbers customizable by each TA 3. TAs will have a page to create Charge Number rules. a. Charge Number rules are defined as rules based on a combination of employee labor data (Customer Code, ABM Code, Branch, Labor type, etc.) where a charge number is automatically applied to the hours that fit each rule. This will be triggered by Thursday and Monday lockdowns. iii. ABM Code Reference List 1. Add/Edit/Delete ABM Code reference lists d. User Management and Administration i. Add/Edit/Archive employees and their data e. Error Checking i. Hour checking against 24-hour military time format and 24-hour day. ii. ABM Code error checking against reference lists upon employee daily time entry completion. 4. Reporting Requirements a. Muster Sheet b. SLDCADA Output c. DIFMS Sheet d. Op-Nav Training Range Cost Database Spreadsheet Output i. ABM Codes in number format 5. Technical Requirements a. Hosting Server Specifications i. Dual Xeon (2.6ghz) Web Server and Database Server ii. Windows 2000 Server with latest Service Packs and patches iii. SQL Server 2000 with latest Service Packs and patches iv. IIS with latest updates and patches b. Code Deliverables i. Web pages, DLLs, and database elements to be installed on CSC servers must be delivered to CSC via email or CD to CSC POC (Patrick Lister). ii. Deliverables must be accompanied with complete documentation as stated in the Development Requirements and must have complete installation documentation including locations, IIS changes, SQL schemas, and network/internet requirements. iii. Deliverables will be installed within 2 business days of receipt. iv. The developer has the option of scheduling on-site deliverable installation 3 business days in advance with CSC POC. c. BMR Interaction Requirements i. Database Dictionary 1. Required for BMR development d. Inline code documentation 6. User Guide and Training a. User Guide i. Will be included with development and documentation at least 1 week prior to launch of the site. b. Training i. Will be handled by NAVSEA The provision at FAR 52.212-1, Instructions to Offerors - Commercial Items applies. Clause 52.212-4, Contract Terms and Conditions - Commercial Items applies as well as the following addendum clauses: FAR 219-1, Small Business Program Representations; FAR 52.219-6, Notice of Total Small Business Set-Aside; FAR 52.211-5, Material Requirements. The clause at 52.212-5, Contract Terms and Conditions Required to Implement Statutes or Executive Orde rs - Commercial Items applies with the following applicable clauses for paragraph (b): FAR 52.222-26, Equal Opportunity; FAR 52.222-35, Affirmative Action for Disabled Veterans and Veterans of the Vietnam Era, FAR 52.222-36, Affirmative Action for Workers with Disabilities; FAR 52.222-37, Employment Reports on Disabled Veterans and Veterans of the Vietnam Era. DFARS 252.212-7001, Contract Terms and Conditions Required to Implement Statutes or Executive Orders Applicable to Defense Acquisitions of Commercial Items, applies with the foll! owing clauses applicable for paragraph (b): DFARS 252.225-7001, Buy American Act and Balance of Payment Program; and DFARS 252.225-7012, Preference for Certain Domestic Commodities. OFFERORS ARE REQUIRED TO COMPLETE AND INCLUDE A COPY OF THE FOLLOWING PROVISIONS WITH THEIR PROPOSALS: FAR 52.212-3, Offeror Representation and Certifications - Commercial Items. The government intends to make a single award to the responsible offeror whose offer is the most advantageous to the government considering the following factors shall be used to evaluate offers: (1) Price, and (2) Past Performance. Provision 52.212-2, Evaluation - Commercial Items, applies with paragraph (a) completed as follows: Note: The full text of the Federal Acquisition Regulations (FAR) can be accessed on the Internet at www.arnet.gov.far or www.deskbook.osd.mil ; Defense Federal Acquisition Regulation Supplement (DFARS) can be accessed on the Internet at www.dtic.mil/dfars . Parties responding to this solici! tation may submit their quote in accordance with their standard commercial practices (e.g. on company letterhead, formal quote form, etc.) but must include the following information: 1) Company's complete mailing and remittance addresses, discounts for prompt payment, if any (e.g. 1% 10 days), anticipated delivery / availability of product / s, the company's CAGE code, Dun & Bradstreet Number, and Taxpayer ID number. In addition, if you are quoting on a comparable commercial item, product literature must be included. All FAR certifications and representations specified above must also accompany your quote. IMPORTANT NOTICE: DFARS 252.204-7004 "Required Central Contractor Registration" applies to all solicitations issued on / or after 06-01-98. Lack of registration in the CCR database will make an offeror / quoter INELIGIBLE FOR AWARD. Please ensure compliance with this regulation when submitting your quote. Call +1 (555) 000-0000 or visit the Internet at http://www.bpn.gov/ccr/! scripts/index.html for more information. Quotes must be received no later than 11:00 AM, local time, 17 September 2004, and will be accepted via e-mail @ contact@example.gov . Quotes submitted, as an attachment to an e-mail should be sent in Word Version 6.0 or higher. .