QUESTIONS-ANSWERS.docx

IDT Attendance Report Questions Overview Section Questions:

1. At the statewide level how many people will be utilizing the system?

A: Approximately 1000.

2. Will there be need for virtual access to the system?

A: It will be hosted on our internal network and we prefer a web based application but are open to other possibilities.

3. Will the LANG be conducting any virtual training throughout this contract?

A: No

4. How often will the system be used per day, per week, per month, or per year?

A: System will be available 24 x 7. Though there is not a requirement for High-Availability.

5. What is the number of soldier’s attending the inactive duty training (IDT) on a monthly basis?

A: Approximately 10000, though each Soldier acquires about 48 units of IDT within a year.

6. Are the various codes being used to record the attendance status of each Soldier in accordance with National Guard Regulation (NGR) 680-1 (P=Present, C=Constructive, U=AWOL, etc.) already written or will the vendor need to write/create these codes from scratch?

A:Codes from item 1.1 of SOW are available as part of one of the databases used to create report.

7. Does the government has an estimated manhours (level of effort) and labor categories to support this requirement and if not how many data analysis engagements should we plan on providing by type. This will allow us to accurately bid the analysis portion.

A: Our current man-hours estimate is approximately 60 hours to create an executive summary using Microsoft SQL Server Report Services. Number of data analysis engagements is dependent on contractor determination.

Contract Performance Section Questions:

1. For the Off-Site performance of this contract what is the radius which the vendor must be within?

A: There is no radius requirement. On-site means Louisiana Army National Guard installation and Off-site means at the vendor location (prepping for on-site work).

2. Will the various reports that are being created be considered an official record of the LANG?

A: No, the report will not be considered official record only “For Official Use Only”. See item 3.3 of SOW.

3. As a follow up to question three (3) on whether or not the reports being considered an official record. Will the LANG be requiring the vendor to adhere to the National Archives and Records Administration (NARA) standards for Electronic Records?

A: No

4. Has the LANG considered what tool they would like to use to capture these records or would the LANG be open to the vendor recommending a specific tool to address this need?

A: We are currently have adequate Microsoft Business Intelligence licenses (SSRS, SSAS, SSIS, PowerBI Report Server) and are open to suggestion. Review item 2.1 and 2.3 of SOW.

Item 3: Support Section Questions:

1. Under the IDT Attendance Report contract the contractor will be required to touch classified personally identifiable information (PII) (i.e. social security numbers, dates of birth, addresses, etc.). What level of a Security Clearance has the LANG considered the vendor supporting this contract must have prior to award?

A: All data is labeled Unclassified Privacy Act Protected. No Security Clearance required as contractor will not have unsupervised access to servers/databases. See item 1.2 of SOW that addresses that the contractor will work in conjunction with LANG in order to develop the report.

2. What is the page count for the vendors technical and management response each?

A: no technical word count

3. How many Past Performances will be required?

A: 3

4. Will the LANG require the vendor to submit Past Performance Questionnaires?

A: no, it must be relevant to the government requirements of this contract

5. How far back with the government accept a Past Performance reference 3 to 5 year range?

A: 3 years

6. What procurement method has the government considered using to procure this piece of work? (8(a), 8(a) STARS II, Alliant SB, or Alliant 2 SB) A: It’s on FBO and issued as a set-aside for small businesses.

7. Will the government consider extending the due to one (1) week after the government has released the Q&A’s they have received?

A: questions and answers will be posted by 11 July, proposals are due 17 July.

8. What is the official due date and time for submission of all proposals?

A: The suspense for proposals is 17 July 2018, 1100 hours (11:00am) CST.

9. Will the vendor be required to hold a Facilities Clearance to Prime this contract?

A: No Facility Clearance is required but valid ID is required to gain access to the facility.

10. Are there any Key Personnel for this contract?

A: no

11. How does the LANG expect all proposals be submitted? (Electronic, US Mail, or Hand Delivery) A: electronic to email listed

12. Is this a base (1) plus (4) one year option contract?

A: no. 30 days after receipt of award of 15 September, whichever comes first.

13. How will the LANG be evaluating proposals?

A: LPTA. Added to solicitation

14. Will price be more important than technical proficiency?

A: LPTA

15. Will technical proficiency be considered more important than price?

A: LPTA

16. Would the government please expound further on this statement “Price and Delivery with delivery being more important.”?

A: this statement shall be removed. Lowest price technically acceptable shall be used to evaluate this award.

17. How is the government defining delivery?

A: when government accepts a working IDT Tool which meets all specifications within this solicitation

18. What are the hours of operation for this contract?

A: Tuesday to Friday 0800 AM to 1700. We can accommodate hours outside of this.

1. Are specific Information Technology type certifications required? No

2. Past Performance: The government requests not more than three relevant past performance evaluations.

1. Are security clearances required to perform on this project?

Already answered above.

2. What versions of SQL server are you using?

Infrastructure components we currently own and are available to use are:

Microsoft Power BI Report Server - March 2018 (SSRS 2017)

SQL Server Analysis Services 2016

SQL Server Integration Services 2016

SQL Server Database Engine 2012 (Operational Data Store)

3. Can you provide the number of records, the number of databases these are records are in, and the number of records per database?

There is one database, two schemas, about 10-15 tables, the largest table containing 4 million records.

Pre-Bid Questions and Answers:

1. Are the tables normalized?

No restructure of tables needed

2. Does the tool we are creating need an audit function?

No

3. No SSRS or BI reports are currently being used at this time.

4. Users can only read, no modifications shall be made

5. Will the government require training?

No

6. Is there a trending analysis requirement?

No

7. Is there a print or save capability requirement?

No

8. Can we have access to the tables offline?

No access will be given offline, the government has provided a sample of the letterhead on three reports

9. Are there any user interface restrictions?

Has to be integrated with active directory and interface with SQL servers

10. Does the government was restrictions around active directories?

No