Attachment J11 - Pricing Workbook.xlsx
XLSX spreadsheet 39 KB Posted
- Solicitation number
- 030ADV22R0036
- Issued by
-
Library of Congress
View the file
Other files
Show all 21
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Total Evaluated Price (TEP)
| The pricing below should be a summation of the relevant tabs contained within this workbook: | |||
| Service Area | Tab | Total | Contact Information |
| Task Order | Task Order Price | Contract Point of Contact: | |
| Seven-Year Subscription and/or Hosting Costs | Subscription and Hosting Costs | Email: | |
| Future Implementation: Support for Non-MARC Thesauri | Support for Non-MARC Thesauri | Phone: | |
| Offeror's Total Evaluated Price | Address: |
**The TEP will not incorporate the IDIQ rates/Other Itemized Costs; however, those costs will be vetted for reasonableness.
Task Order Price
| L-CAP Task Order Price | ||||
| **On this sheet, please provide a breakdown of services pertaining to your individualized solution. Add or subtract rows pursuant to the number of labor categories/Itemized costs needed to complete the requirements according to your proposal. All labor categories and priced items must be derived from the prices listed you've listed in the tabs titled "IDIQ Rates" or "Other Itemized Costs." These labor categories and priced items must be equal to or less than the prices stated in those tabs. | ||||
| CLIN # | Labor Category/Itemized Cost | Period of Performance | Quantity | Total |
| 1 | Core System Implementation (Objectives 1, 2, 3, 4, 5, 6) |
| CLIN 0001 Total | ||
| 2 | Additional Requirements Analysis (Objective 1) |
| Optional CLIN 0002 Total | ||
| 3 | Discovery Layer (Objective 1, 2) |
| Optional CLIN 0003 Total | ||
| 4 | Subscription and/or Hosting |
| **This should match the task order amount listed in the next tab | Optional CLIN 0004 Total |
| Total Task Order Price |
Subscription and Hosting Costs Subscription and/or Hosting Environment Costs These are the annual recurring costs required to support the solution after initial implementation. Please make clear if you do not bill using yearly suscriptions. Add any labor categories/priced items used to calculate your price. All labor categories and priced items must be derived from the prices listed you've listed in the tabs titled "IDIQ Rates" or "Other Itemized Costs." These labor categories and priced items must be equal to or less than the prices stated in those tabs.
| Year | Labor Category/Description | % Escalation from base year | Price |
| 1 |
| 7 | |||
| Total Subscription/Hosting Environment Costs for IDIQ Lifecycle | $ - 0 | ||
| For this table, please put the price that it will take to host your solution for the length of the period of performance for Task Order 1. | |||
| Hosting for Task Order Length Only | |||
| Year | Labor Category/Description | % Escalation from base year | Price |
Support for Non-MARC Thesauri
| Support for Non-MARC Thesauri |
| Please provide example of pricing for a potential out-year project below for evaluation proposes. |
As mentioned in "Tab 3.0 Bibliographic Control" of Attchment J4 - Requirements Traceability Matrix (RTM) for Analysis, the Library manages several non-MARC thesauri such as the Thesaurus for Graphic Materials (https://www.loc.gov/pictures/collection/tgm/) and the Ethnographic Thesaurus (https://id.loc.gov/vocabulary/ethnographicTerms.html). In the table below, please price out an example of your anticipated solution for a feature to support non-MARC thesauri within LCAP. Please note: actual implementation of support for non-MARC thesauri is not be included in the scope of Task Order 1. This project will be issued as a future task order against the awardee's IDIQ.
Labor Category/Itemized Cost Length of Performance Quantity Total
| Support for Non-MARC Thesauri Project Price | |||
| Requirements from Attachment J4 - Requirements Traceability Matrix (RTM) for Analysis included below for reference: | |||
| 3.7.0 | Authority/Identity Management | ||
| Summary: | For current MARC based cataloging in the ILS, authority control is a significant activity and the Library is the maintenance agency for several authority files that are also present in our current ILS, including the LC-NACO Authority File (names and titles), subject authority records representing LCSH, and genre/form authority records representing LCGFT. The Library is also responsible for the MARC authority records for the LCMPT and LCDGT vocabularies, although these records are not currently loaded to the ILS. The Library also develops other thesauri outside of the MARC context, including the Thesaurus for Graphic Materials (subject and genre headings) and the Ethnographic Thesaurus. In addition to the access points from vocabularies maintained by LC, LC bibliographic records may contain subject and genre access points from any of dozens of externally maintained vocabularies, including faceted headings from OCLC FAST, RBMS controlled vocabularies, MeSH headings from the National Library of Medicine, etc. The Library would like a solution that can validate access points from vocabularies it produces at a minimum, and would be interested in validating against non-MARC records to the extent possible. | ||
| 3.7.1 | Authority/Identity Management | The Library needs a system that supports "local" authority files separate from national and cooperatively maintained authority files. | |
| 3.7.2 | Authority/Identity Management | The system needs to integrate with externally managed authority files when bibliographic headings are present for those externally managed systems. | |
| 3.7.3 | Authority/Identity Management | The Library needs a system that supports access to records from multiple authority files. For authority systems incorporated into the system but not used by LC, the user should have the ability to restrict their view of authorities to only their preferred files. | Because staff will be working in an environment with multiple authorities, they need the ability to restrict their local cataloging interface to the authorities that are appropriate to their work. |
IDIQ Rates
L-CAP IDIQ Labor Categories ** These rates will be binding labor rates. For all future task orders, the awardee of the single-award IDIQ must propose rates equal to or lower than the rates specifed below. If a a labor rate is listed in any other tab (not as a sum) then it MUST be also listed and priced below.
| Labor Category | Role | Labor Category Description | Years of Experience | Year 1 | ||
| Hourly Rate | Year 2 | |||||
| Hourly Rate | Year 3 | |||||
| Hourly Rate | Year 4 | |||||
| Hourly Rate | Year 5 | |||||
| Hourly Rate | Year 6 | |||||
| Hourly Rate2 | Year 7 |
Hourly Rate3
| Project Management | ||||||
| Agile Process SME/Scrum Master | Embed an agile culture using techniques from a wide range of agile and lean methodologies and frameworks, but be methodology agnostic. Showcase relevant tools and techniques such as coaching, advising, workshops, and mentoring. Engage with stakeholders at all levels of the organization. Develop clear lines of escalation, in agreement with senior managers. Ensure any stakeholder can easily find out an accurate and current project or program status, without disruption to delivery. Work effectively with other suppliers and agencies. Apply best tools and techniques to: team roles, behaviors, structure and culture, agile ceremonies and practices, knowledge transfer and sharing, program management, cross-team coordination, and overall governance of digital service delivery. Ensure key metrics and requirements that support the team and delivery are well defined and maintained. Equip staff with the ability to coach others. If organization level, executive coaching on the fundamental considerations of digital service delivery design | 5-7+ | ||||
| Product Manager | Manages the delivery, ongoing success, and continuous improvement of one or more digital products and/or platforms. Lead one or more multi-disciplinary agile delivery teams to deliver new products and/or iterations to existing products to meet user needs. Gather user requirements based on a communicable understanding of diverse audience groups. Define and get stakeholder buy-in for product definition and delivery approach. Create effective, prioritized product descriptions, and delivery plans to meet user needs in a cost-effective way. Interpret user research in order to make the correct product decisions. Continually keep abreast of changes to user habits, preferences, and behaviors across various digital platforms and their implications for successful delivery of government digital services. Support the delivery and iteration of digital services through effective analysis of qualitative and quantitative user data. Communicate credibly with a wide range of digital delivery disciplines and talent. | 7-10+ | ||||
| Program Manager | Serve as the program manager typically responsible for organizing, directing, and managing all aspects of contract operational support functions involving multiple complex and inter-related project tasks that often require managing teams of contractor personnel at multiple locations. Provide overall direction of program activities. Manage and maintain contractor interface with the senior levels of the customer’s organization. Consult with customer and contractor personnel to formulate and review task plans and deliverables, ensuring conformance with program and project task schedules and costs and contractual obligations. Establish and maintain technical and financial reports to show progress of projects to management and customers, organize and assign responsibilities to subordinates, oversee the successful completion of all assigned tasks, and assume the initiative and provide support to marketing personnel in identifying and acquiring potential business. | 10+ | ||||
| Project Manager Level I | Typically oversee all aspects of the project, leading a team on large projects or a significant segment of large and complex projects. Analyze new and complex project-related problems and create innovative solutions that normally involve the schedule, technology, methodology, tools, solution components, and financial management of the project. Provide applications systems analysis and long and short-range plans for application selection, systems development, systems maintenance, and production activities for necessary support resources. Commensurate experience and education for the specific level. | 3-5 | ||||
| Project Manager Level II | Typically oversee all aspects of the project, leading a team on large projects or a significant segment of large and complex projects. Analyze new and complex project-related problems and create innovative solutions that normally involve the schedule, technology, methodology, tools, solution components, and financial management of the project. Provide applications systems analysis and long and short-range plans for application selection, systems development, systems maintenance, and production activities for necessary support resources. Commensurate experience and education for the specific level. | 5-10 | ||||
| Project Manager Level III | Typically oversee all aspects of the project, leading a team on large projects or a significant segment of large and complex projects. Analyze new and complex project-related problems and create innovative solutions that normally involve the schedule, technology, methodology, tools, solution components, and financial management of the project. Provide applications systems analysis and long and short-range plans for application selection, systems development, systems maintenance, and production activities for necessary support resources. Commensurate experience and education for the specific level. | 10+ | ||||
| Consultants / Business Analysts (includes Product Owners and Implementation, Migration, Technical Consultants) | ||||||
| Business Analyst Level II | Assist in applying common best practices for the industry to the customer using a knowledge base to create conceptual business models and to identify relevant issues and considerations in selecting application software packages. Assess the operational and functional baseline of an organization and its organizational components, and help to define the direction and strategy for an engagement while ensuring the organizational needs are being addressed. Typical areas addressed include Human Resources, Finance, Supply, and operations. Identify information technology inadequacies and/or deficiencies that affect the functional area’s ability to support/meet organizational goals. Support the development of functional area strategies for enhanced IT. Commensurate experience and education. | 3-7 | ||||
| Business Analyst Level III | Assist in applying common best practices for the industry to the customer using a knowledge base to create conceptual business models and to identify relevant issues and considerations in selecting application software packages. Assess the operational and functional baseline of an organization and its organizational components, and help to define the direction and strategy for an engagement while ensuring the organizational needs are being addressed. Typical areas addressed include Human Resources, Finance, Supply, and operations. Identify information technology inadequacies and/or deficiencies that affect the functional area’s ability to support/meet organizational goals. Generate functional area strategies for enhanced IT operations in a cross-functional area mode throughout the organization. Participate in account strategy sessions, strategic assessments and design reviews to validate enterprise approach and associated work products, such as ERP implementations coordinating the resolution of highly complex problems and tasks. Commensurate experience and education. | 7+ | ||||
| Database Administrator | Analyze database requirements of assigned projects. Analyze and determine information needs and elements, database relationships and attributes, proposed manipulation, data flow and storage requirements, and data output and reporting capabilities. Apply knowledge of database management systems to coordinate maintenance and changes to databases. Test and implement changes or new database designs. Write logical and physical database descriptions, including location, space, access method, and security requirements. Provide direction to programmers and analysts as required to affect changes to database management systems. Provide answers to database questions. Knowledge of and ability to monitor databases and to analyze and organize data and apply new technology designs and programs. | 1-3 | ||||
| Database Administrator Level II | Analyze database requirements of assigned projects. Analyze and determine information needs and elements, database relationships and attributes, proposed manipulation, data flow and storage requirements, and data output and reporting capabilities. Apply knowledge of database management systems to coordinate maintenance and changes to databases. Test and implement changes or new database designs. Write logical and physical database descriptions, including location, space, access method, and security requirements. Provide direction to programmers and analysts as required to affect changes to database management systems. Provide answers to database questions. Knowledge of and ability to monitor databases and to analyze and organize data and apply new technology designs and programs. | 3-7 | ||||
| Database Administrator Level III | Analyze database requirements of assigned projects. Analyze and determine information needs and elements, database relationships and attributes, proposed manipulation, data flow and storage requirements, and data output and reporting capabilities. Apply knowledge of database management systems to coordinate maintenance and changes to databases. Test and implement changes or new database designs. Write logical and physical database descriptions, including location, space, access method, and security requirements. Provide direction to programmers and analysts as required to affect changes to database management systems. Provide answers to database questions. Knowledge of and ability to monitor databases and to analyze and organize data and apply new technology designs and programs. | 7+ | ||||
| Quality Assurance Manager | Establish and maintain a process for evaluating software and associated documentation. Determine the resources required for quality control. Maintain the level of quality throughout the software life cycle. Conduct formal and informal reviews at pre-determined points throughout the development life cycle. Provide daily supervision and direction to support staff. | 7+ | ||||
| Quality Assurance Specialist | Develop and implement quality control methodologies to ensure compliance with quality assurance standards, guidelines, and procedures in a large computer-based organization. Develop and define major and minor characteristics of quality including quality metrics and scoring parameters and determines requisite quality control resources for an actual task order. Establish and maintain a process for evaluating hardware, software, and associated documentation and/or assist in the evaluation. Conduct and/or participate in formal and informal reviews at pre-determined points throughout the development life cycle. | 3-5 | ||||
| Security Engineer | Manages complex technology implementations in a product-centric environment. Bridge the gap between legacy development or operations teams and working toward a shared culture and vision. Ensures and help developers create the most secure systems while enhancing the privacy of all system users. Experience with white-hat hacking and fundamental computer science concepts strongly desired. | |||||
| Perform security audits, risk analysis, application-level vulnerability testing, and security code reviews. Develop and implement technical solutions to help mitigate security vulnerabilities. Conduct research to identify new attack vectors. | 5+ | |||||
| Subject Matter Expert Level I | Provide technical knowledge and analysis of highly specialized applications and operational environment, high-level functional systems analysis, design, integration, documentation and implementation advice on moderately complex problems that require an appropriate level of knowledge of the subject matter for effective implementation. Apply principles, methods and knowledge of the functional area of capability to specific task order requirements, advanced mathematical principles and methods to exceptionally difficult and narrowly defined technical problems in engineering and other scientific applications to arrive at automated solutions. Assist other senior consultants with analysis and evaluation and with the preparation of recommendations for system improvements, optimization, development, and/or maintenance efforts in the following specialties: information systems architecture, networking; telecommunications, automation; communications protocols, risk management/electronic analysis, software; lifecycle management, software development methodologies, and modeling and simulation. Commensurate experience in IT and in new and related older technology that directly relates to the required area of expertise. | 5-7 | ||||
| Subject Matter Expert Level II | Analyze user needs to determine functional requirements and define problems and develop plans and requirements in the subject matter area for moderately complex to complex systems related to information systems architecture, networking; telecommunications, automation, communications protocols, risk management/electronic analysis, software, lifecycle management, software development methodologies, and modeling and simulation. Perform functional allocation to identify required tasks and their interrelationships. Identify resources required for each task. Possess requisite knowledge and expertise so recognized in the professional community that the government is able to qualify the individual as an expert in the field for an actual task order. Demonstrate exceptional oral and written communication skills. Commensurate experience in IT and in new and related older technology that directly relates to the required area of expertise. | 7-10 | ||||
| Subject Matter Expert Level III | Provide technical, managerial, and administrative direction for problem definition, analysis, requirements development, and implementation for complex to extremely complex systems in the subject matter area. Make recommendations and advise on organization-wide system improvements, optimization or maintenance efforts in the following specialties: information systems architecture; networking; telecommunications; automation; communications protocols; risk management/electronic analysis; software; lifecycle management; software development methodologies; and modeling and simulation. Commensurate experience in IT and in new and related older technology that directly relates to the required area of expertise. | 10+ | ||||
| System Administrator Level I | Assist with the daily activities of configuration and operation of systems which may be mainframe, mini, or client/server based. Assist with the optimizing of system operation and resource utilization, and perform system capacity analysis and planning. Provide assistance to users in accessing and using business systems. Commensurate experience and education. | 3-5 | ||||
| System Administrator Level II | Perform the daily activities of configuration and operation of systems which may be mainframe, mini, or client/server based. Perform the optimizing of system operation and resource utilization, and perform system capacity analysis and planning. Provide assistance to users in accessing and using business systems. Commensurate experience and education. | 5-7 | ||||
| System Administrator Level III | Supervise and manage the daily activities of configuration and operation of systems which may be mainframe, mini, or client/server based. Plan and monitor the optimizing of system operation and resource utilization, and perform systems capacity analysis and planning. Plan and monitor assistance to users in accessing and using business systems. Commensurate experience and education. | 7-10+ | ||||
| Systems Architect Level I | Establish system information requirements using analysis of the information engineer(s) in the development of enterprise-wide or large-scale information systems. Design architecture to include the software, hardware, and communications to support the total requirements as well as provide for present and future cross-functional requirements and interfaces. Ensure these systems are compatible and in compliance with the standards for open systems architectures, the Open Systems Interconnection (OSI) and ISO reference models, and profiles of standards - such as Institute of Electrical and Electronic Engineers (IEEE) Open Systems Environment (OSE) reference model - as they apply to the implementation and specification of information management solution of the application platform, across the Application Program Interface (API), and the external environment/software application. Ensure that the common operating environment is compliant with the Agency enterprise architecture and applicable reference models. Evaluate analytically and systematically problems of workflows, organization, and planning and develop appropriate corrective action. Provide daily supervision and direction to staff. | 5-7 | ||||
| Systems Architect Level II | Establish system information requirements using analysis of the information engineer(s) in the development of enterprise-wide or large-scale information systems. Design architecture to include the software, hardware, and communications to support the total requirements as well as provide for present and future cross-functional requirements and interfaces. Ensure these systems are compatible and in compliance with the standards for open systems architectures, the OSI and ISO reference models, and profiles of standards - such as IEEE OSE reference model - as they apply to the implementation and specification of information management solution of the application platform, across the API, and the external environment/software application. Ensure that the common operating environment is compliant with the Agency enterprise architecture and applicable reference models. Evaluate analytically and systematically problems of workflows, organization, and planning and develop appropriate corrective action. Provide daily supervision and direction to staff. | 7-10+ | ||||
| Test Engineer II | Test Plan and Test Case Development; Support for Test Automation and Test Management tools; Integrated QA and QC services; Load and Performance Testing; Independent Validation and Verification Services; and Accessibility Testing (mid level) | 5-7 | ||||
| Test Engineer III | Test Plan and Test Case Development; Support for Test Automation and Test Management tools; Integrated QA and QC services; Load and Performance Testing; Independent Validation and Verification Services; and Accessibility Testing (Sr level) | 7-10+ | ||||
| Developers (includes frontend, backend, and DevOps) | ||||||
| Application Programmer Level II | Participate in the design of software tools and subsystems to support reuse and domain analysis. Assist Applications Engineer and Applications Programmer to interpret software requirements and design specifications to code, and integrate and test software components. | 3-7 | ||||
| Application Programmer Level III | Analyze functional business applications and design specifications for functional areas such as finance, accounting, personnel, manpower, logistics, and contracts. Develop block diagrams and logic flow charts. Translate detailed design into computer software. Test, debug, and refine the computer software to produce the required product. Prepare required documentation, including both program-level and user-level documentation. Enhance software to reduce operating time or improve efficiency. Provide technical direction to programmers to ensure program deadlines are met. Experience in information system design, including application programming on large-scale DBMS and the development of complex software to satisfy design objectives. | 7+ | ||||
| Backend Web Developer | Experience using modern, open source software to prototype and deploy backend web applications, including all aspects of server-side processing, data storage, and integration with frontend development. Web development using open-source web programming languages (e.g., Ruby, Python) and frameworks (e.g., Django, Rails); Developing and consuming web-based, RESTful APIs. Using and working in team environments that use agile methodologies (e.g., Scrum, Lean). Authoring developer-friendly documentation (e.g., API documentation, deployment operations) Test-driven development. Use of version control systems, specifically Git and GitHub. Quickly researching and learning new programming tools and techniques. Relational and non-relational database systems. Scalable search technology (e.g. ElasticSearch, Solr). Handling large data sets and scaling their handling and storage; Using and working with open source solutions and community. Communicating technical concepts to a non-technical audience | 5+ | ||||
| Cloud Architect II | Works with other architects and developers to implement and support cloud solutions on Microsoft Azure. Ensures that the implementation of cloud solutions follows all internally defined security and compliance controls. Ensure that best standards and practices are used during implementation of services such as Cloud platforms, such as Amazon Web Services (AWS), Microsoft Azure, Google Cloud. | 3-5 | ||||
| Cloud Architect III | Responsible for scoping, architecting and designing cloud solutions. Plans enterprise-scale cloud environments, including applications dependencies, data storage and flow, network connectivity and overall cloud hosting. Responsible for interfacing with engineering and other cloud focused teams across the enterprise to coordinate the technical design and delivery of cloud based solutions. | 5+ | ||||
| DevOps Engineer | Deploy and configure services using infrastructure as a service providers (e.g., Amazon Web Services, Microsoft Azure, Google Compute Engine, RackSpace/OpenStack). Configure and manage Linux-based servers to serve a dynamic website. Debug cluster-based computing architectures. Use scripting or basic programming skills to solve problems. Installation and management of open source monitoring tools. Configuration management tools (e.g., Puppet, Chef, Ansible, Salt). Architecture for continuous integration and deployment, and continuous monitoring. Containerization technologies (e.g., LXC, Docker, Rocket). | 3-5+ | ||||
| Frontend Web Developer | Use modern techniques and frameworks (e.g., HTML5, CSS3, CSS frameworks like LESS and SASS, Responsive Design, Bourbon, Twitter Bootstrap). JavaScript development using modern standards, including strict mode compliance, modularization techniques and tools, and frameworks and libraries (e.g., jQuery, MV* frameworks such as Backbone.js and Ember.js, D3). Consume RESTful APIs. Use and work in team environments that use agile methodologies (e.g., Scrum, Lean). Use of version control systems, specifically Git and GitHub. Ensure Section 508 Compliance. Use and work with open source solutions and community. Create web layouts from static images. Create views and templates in full-stack frameworks like Rails, Express, or Django | 5+ | ||||
| Web Software Developer | Oversees all visual design efforts. Ensures successful completion of all work executed by the team (on time, on budget, and ensuring quality). Ensures compliance with the project management methodologies and the Project Management Office processes and standards. Develops, maintains, and ensures compliance of application release management, outage management and change control processes and standards. Defines, creates, communicates, and manages resource plans and other required project documentation such as style guides and provides updates as necessary. | 5-7+ | ||||
| Additional roles to be defined by Contractor | **In the spaces below, the Contractor shall include any labor categories pertinent to--or foreseesable for--their proposed solution. As stated above, for all future task orders, the awardee of the single-award IDIQ must propose rates equal to or lower than the rates specifed below. |
Itemized Costs
| If the Offeror's proposal requires any other unique items, licenses, parts, or modules for their platform solution, the offeror should list the item and a brief description of what it is, the service category, and cost per unit below. If a category is listed as an item in any other tab (not as a sum) then it MUST also be listed and priced below. For all future task orders, the awardee of the single-award IDIQ must propose prices equal to or lower than the prices specifed below. All the vendor's commercial or non-commercial items related to LCAP should be listed below. | |||||
| ITEMIZED COSTS - L-CAP | |||||
| # | Description | Service Category | Year 1 | ||
| Hourly Rate | Year 2 | ||||
| Hourly Rate | Year 3 | ||||
| Hourly Rate | Year 4 | ||||
| Hourly Rate | Year 5 | ||||
| Hourly Rate | Year 6 | ||||
| Hourly Rate | Year 7 |
Hourly Rate
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
| 12 |
| 13 |
| 14 |
| 15 |
| 16 |
| 17 |
| 18 |
| 19 |
| 20 |
Assumptions or Conditions
| Assumptions and/or Conditions |
| Provide any assumptions and/or conditions regarding your pricing model in this tab. You must list all conditions and/or assumptions relevant to your intended LCAP here; external conditions and/or assumptions will not be included in the IDIQ nor the Task Order unless it has been written below or negotiated between the Library and the Contractor. Note: The likely costs to be incurred during this IDIQ or Task Order may be re-calculated or adjusted by the Library based on the information included below. |
File details come from the government source that posted it. Updated .