Technical Exhibit 5 Estimated Worload.pdf
PDF 157 KB Posted
- Attached to
- IT and Support Services Federal contract opportunity
- Solicitation number
- W911S820R0004
About this file
This document provides an estimated workload for IT and support services required by the Directorate of Public Works at Joint Base Lewis-McChord. The services include GIS data management, CAD services, database administration, web site operation and graphic design, data analysis, data entry, procurement support, and utility billing and data entry. Specific requirements include conducting 150-200 basic GIS user requests, 22 CAD drawing retrieval requests per month, training 2-3 users per week on database programs, monitoring the website daily and updating pages every two years, providing 2 data trend reports per month, and entering over 30,000 records annually into financial and work order databases. The related federal contract opportunity is solicitation number W911S820R0004 for IT and support services at JBLM DPW, issued by the Department of the Army Materiel Command Mission and Installation Contracting Command at Joint Base Lewis-McChord. The scope requires the contractor to provide all personnel, equipment, supplies and non-personal services defined in the performance work statement, excluding government furnished property and services.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Amendment 4.pdf | ||
| Amendment 3.pdf | ||
| Questions and Responses.pdf | ||
| Technical Exhibit 7 Mission Essential Contractor Services.pdf | ||
| Technical Exhibit 6 Estimated Inventory Of Equipment Assets and Users.pdf | ||
| Amendment 2.pdf | ||
| IT PWS Revision 1 (20 March 2020).pdf | ||
| Response to Questions.pdf | ||
| Technical Exhibit 4 Wage Determination 2015-5544 Rev 10 dated 12-23-19.pdf | ||
| Amendment 01.pdf | ||
| Attachment 2 Wage Determination 2015-5539.pdf | ||
| Attachment 3 DD254 Contract Security Classification.pdf | ||
| Attachment 3 DD254 Contract Security Classification (Cont).pdf | ||
| W911S8-20-R-0004.pdf | ||
| IT PWS 31 January 2020.pdf |
Show all 15
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
TECHNICAL EXHIBIT 5
Estimated Workload
# of Instances Period Description
Paragraph 1.6.13 Historical Travel/Training Information
$15,000 per year Travel/Training for 2019 - Four travel instances during this period.
Training for SAP, ESRI, MS Ignite (For Information Only)
Paragraph 5.2 Information Assurance services, hardware support, software support and user management 300 per year Computers replaced or reimaged
5 to 10 per week Computer workstation moved 10 per week Printer and scanner setup/service/assistance
300 per year Software Patches (above baseline software) 20 to 50 per month New/Reinstated User Account Request (DD2875)
30 to 100 per day Routine User Request - recurring issue with known solution 15 per week Non-routine User Request - troubleshooting or research required
200 per year Mobile Device Support instances 127 per year Annual smartphone provisioning (per phone) 50 per year Annual cellular wifi device provisioning (per phone)
220 per year Annual cellular feature phone provisioning (per phone) 8 twice per month Server Patched (number of servers patched per cycle) 8 per day Monitor server logs 6 per year Incident Response 5 per week ICS field service call
210 per year ICS server and workstation patched 25 per year ICS workstation replaced
Paragraph 5.2.9 Equipment/Warranty Tracking, Disposal
2 per year 100% equipment hands-on inventory 300 pieces per year Receive new equipment (computers and monitors) 300 pieces per year Turn-in equipment to IPBO (computers and monitors)
1 to 3 per month Turn-in visits to IPBO 200 per year Hard drive disposal
Paragraph 5.3 GIS Data Management
150 to 200 per year Basic User Request. Using existing data and little analysis. Under 4 hours effort
35 to 50 per year Standard User Request. Requires data analysis. Uses routine methods.
Typically level of effort: 4 to 40 hours.
25 to 35 per year Advanced User Request. Complex project requiring analyst to provide definition, data analysis and data collection from multiple sources.
Typical time to completion: 1 to 6 weeks.
Paragraph 5.4 CAD Services 22 per month Drawing retreival user requests on readily available drawings
5 per month Drawing retreival user requests requiring user coordination and/or research
3 per month Project As-built reviews for completeness, standards compliance and clarity/legibility
20 per month Scan drawing sheets to virtual drawing repository 586500 drawings Manage physical drawing repository, repair damaged drawings 479595 drawings Manage virtual drawing repository
4 per year Provide AutoCAD basic user training in classroom 1 to 2 per month Troubleshoot AutoCAD user problems
Paragraph 5.5 Database Administration
2 per month New User Classroom training 2 to 3 per week Individual deskside training
12 per week Individual user set up 2 per month Query to support data call
250 per week Preventive Maintenance orders modification requests 90 Semi-annually New or modified GFEBS work instructions
400 Semi-annually Verify all GFEBS user accounts 50 per month New GFEBS accounts or new account roles
150 per week Support GFEBS reports and views based on user requests 10 per week Research and correct data anomalies
1 per year GFEBS Year-end changeover (last week of old year / first week of new year)
1 per week Verify file back up by NEC
Paragraph 5.7 Web Site Operation and Graphic Design 1 per day Monitor Web Site status and broken links 2 per day Respond to user request 1 per day Page maintenance such as new content, page update, new design, coordinate with content providers 2 per year Respond to Data Call or OPORD
Paragraph 5.8 Data Analyst Services
2 per month Provide data trend reports on PW data sets including GFEBS, GIS, CAD and Fuel Dispensing Systems. Format may be tabular or graphical.
7 per month Support datacalls by running existing reports or adhoc reports.
10 per month Identify data anomalies. Research remedy and act on with Govt approval 2 per month Monthly Fuel Dispensing System consumption reports 1 per month Provide technical support on Fuel Dispensing Systems
2 per month Run GFEBS service order / work order report. Upload to GIS database.
1 per week Prepare Directorate time confirmation report
10 per day Open or Close GFEBS work orders 1 per year GFEBS Year-end changeover (last week of old year / first week of new year)
1 per month Operational support to the Utilities Database which is the central repository receving information from a variety of sources. In addition to containing all billing data from Procurement Support, the Database contains all utility data for 1,500 individual facilities plus housing area energy use
5 per month Troubleshoot Utilities Database technical problems. Research data anomalies and modify database as necessary.
1 per month Generate Utilities Report for the Army Energy and Water Reporting System (AEWRS)
2 per month In coordination with the Utilities Officer, perform data process analysis to streamline dataflow and consolidate data sources. Recommend methods to simplify utility data collection. Typically requires 16 to 40 hours of effort.
Paragraph 5.9 Data Entry and Procurement Support Services Data Entry Services
7000 per year Enter GFEBS time confirmations 2000 per year Update GFEBS WBS funding for functional locations & sublocations 2000 per year Enter GFEBS Preventive Maintenance missed cycle cancellations
10000 per year GFEBS Property Records actions 1000 per year Input new GFEBS work orders and preventive maintenance orders 2222 per year YTC: enter GFEBS work orders and service orders received by email, phone and walk-in 375 per year YTC: enter GFEBS preventive maintenance order
Procurement Support Services
700 per year Enter, edit and monitor Task Orders in the form of GFEBS purchase requests (approximately 8-10 hours per task order)
700 per year Monitor invoicing and MICC coordination for each task order 700 per year Prepare documentation for Task Order Closeout
Paragraph 5.9.1 Utility Data Entry and Procurement Support Services
120 per year Annual account set up for Payable and Receivable accounts 70 per month Enter monthly Utility Vendor Payment information (payable) into
Utility Database. Prepare documents for review by Govt Utilities Officer
50 per month Generate monthly Reimbursable Utility Bills (receivable) by entering utility billing data into Utility Database. Average customer uses four commodities and is billed for five buildings.
120 per month Maintain copies of Government utility contracts, reimbursable customer agreements and utility bills
5 month Investigate and resolve financial errors in utility billing
Paragraph 5.10 Monthly Status 1 per month Monthly status report
File details come from the government source that posted it. Updated .