Attachment A - ITSC Price Spreadsheet (Amendment 0001).xlsx
XLSX spreadsheet 429 KB Posted
- Solicitation number
- 36C10B21R0007
About this file
This federal solicitation requests proposals for IT strategic communication support services. The Department of Veterans Affairs Office of Information and Technology seeks a contractor to provide proactive, synchronized strategic communication services to support its large-scale IT modernization efforts. Services include program analysis, content management, support for major initiatives, executive messaging, social media strategy, public affairs, graphics and multimedia support. Pricing is to be proposed using the attached price spreadsheet template, with labor rates by category and fixed prices for deliverables. The period of performance is a one-year base period and two optional one-year periods. Proposals are due by January 6, 2021 and shall be submitted to the identified contracting staff. The North American Industry Classification code for this effort is 541613.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment A - ITSC Price Spreadsheet (Amendment 0001) 01.07.2021.xlsx | XLSX spreadsheet | |
| 36C10B21R0007 Questions and Answers 01.05.2021.pdf | ||
| Attachment B - Bingo Card (Amendment 0001).docx | DOCX document | |
| 36C10B21R0007 0001.docx | DOCX document | |
| 36C10B21R0007 0001 Amended RFP.pdf | ||
| 36C10B21R0007 0001.docx | DOCX document | |
| Attachment B - Bingo Chart (Amendment 0001).docx | DOCX document | |
| 36C10B21R0007 Questions and Answers (Amendment 0001).pdf | ||
| Attachment A - ITSC Price Spreadsheet.xlsx | XLSX spreadsheet | |
| 36C10B21R0007.pdf | ||
| 36C10B21R0007_1.docx | DOCX document |
Show all 11
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
Instructions Attachment A - ITSC Price Spreadsheet Instructions
Section B Tab Instructions -
(1) Input of unit prices is only required for the Firm Fixed Price (FFP) Line Items (all red shaded cells). The proposed T&M labor prices will be automatically populated based on the Offeror's proposed fully loaded blended labor rates entered in the T&M Labor Rate Table tab. (2) The Offeror shall enter unit prices for all FFP line items (all red shaded cells). No other cells require entry of data. Unit prices shall be entered with no more than two decimal places. If unit prices are entered with more than two decimal places, cells are formatted to be flagged and will be color shaded. Ensure all unit price cells are corrected so no color shading is remaining before submitting the proposal. (3) Formulas are contained in the Section B tab which will automatically calculate the total evaluated price.
T&M Labor Rate Table Tab Instructions -
(1) In the red shaded cell in row 3 (cell A3) the Offeror shall enter the name of the Prime Offeror.
(2) Each labor category specified by the Government must be addressed (i.e., no un-addressed labor categories). (3) For each labor category specified by the Government the Offeror shall enter fully loaded blended hourly labor rates (no more than two decimal places) for the Base Period and all Option Periods (all red shaded cells). If the fully loaded blended labor rates are entered with more than two decimal places, cells are formatted to be flagged and will be color shaded. Ensure all labor rate cells are corrected so no color shading is remaining before submitting the proposal.
(4) The proposed fully loaded blended labor rates may be escalated as deemed appropriate by the Offeror.
(5) The proposed fully loaded blended labor rates will be incorporated into any resultant task order, as binding, Not To Exceed (NTE) ceiling labor rates. The proposed fully loaded blended labor rates will be used for the prime and all subcontractors/team members in performance of this task order.
T&M Labor Tab Instructions -
(1) The Offeror shall make no inputs in this tab. T&M Labor tab automatically calculates the total T&M labor price based on the Offeror's proposed fully loaded blended labor rates entered in the T&M Labor Rate Table tab.
T&M Travel & Travel Handling Tab Instructions -
(1) The Offeror shall use the Government provided estimated Not To Exceed (NTE) Travel amounts in row 4. (2) In the yellow shaded cells, Offeror shall either enter a Travel Fixed Handling percentage (whole number and two decimal places; i.e. 5.35%) or 0.00% (if Offeror proposes no Travel Fixed Handling costs). If Travel Handling percentage is entered with more than two decimal places, cells are formatted to be flagged and will be color shaded. Ensure all Travel Handling percentage cells are corrected so no color shading is remaining before submitting the proposal. If not included in the proposal, Travel Fixed Handling will not be added during contract performance. (3) The proposed Travel Fixed Handling rates will be incorporated into the resultant contract, as binding, Not To Exceed (NTE) ceiling rates. (4) Calculation of the Total Evaluated Price for the T&M Travel & Travel Fixed Handling will be done automatically based on the Travel Fixed Handling rates entered in yellow by the Offeror.
Section B Section B Price Schedule Tab
| LINE ITEM | DELIVERABLE DESCRIPTION | QUANTITY | UNIT | UNIT PRICE | TOTAL EVALUATED PRICE |
| BASE PERIOD: | |||||
| 0001 | Project Management in accordance with (IAW) Performance Work Statement (PWS) paragraph 5.1, inclusive of subsections - FFP. | 12 | MO | $0.00 | |
| 0002 | Strategic Communication Program Analysis, Strategy, and Planning IAW PWS Section 5.2, inclusive of subsections - FFP. | 12 | MO | $0.00 | |
| 0003 | Communication Content Management IAW PWS Section 5.3, inclusive of subsections - FFP. | 12 | MO | $0.00 | |
| 0004 | Strategic Communication Support of Major Initiatives IAW PWS Section 5.4 - FFP. | 12 | MO | $0.00 | |
| 0005 | OIT Front Office Communication Support and Executive Messaging IAW PWS Section 5.5, inclusive of subsections - FFP. | 12 | MO | $0.00 | |
| 0006 | Organizational Recognition IAW PWS Section 5.6 - FFP. | 12 | MO | $0.00 | |
| 0007 | OIT Social Media Strategy and Implementation IAW PWS Section 5.7 - FFP. | 12 | MO | $0.00 | |
| 0008 | Speaking Engagement Support IAW PWS Section 5.8 - FFP. | 12 | MO | $0.00 | |
| 0009 | Public Affairs and Media Relations Support IAW PWS Section 5.9 - FFP. | 12 | MO | $0.00 | |
| 0010 | Congressional Affairs Support IAW PWS Section 5.10 - FFP. | 12 | MO | $0.00 | |
| 0011 | OIT and VA Staff Communication Support IAW PWS Section 5.11 - FFP. | 12 | MO | $0.00 | |
| 0012 | Graphics, Designs and Multimedia Support IAW PWS Section 5.12 - FFP. | 12 | MO | $0.00 | |
| 0013 | Image and Video Support IAW PWS Section 5.13 - FFP. | 12 | MO | $0.00 | |
| 0014 | Business Operations and Information Management Support IAW PWS Section 5.14 - FFP. | 12 | MO | $0.00 | |
| 0015 | Accessibility IAW PWS Section 5.15 - FFP. | 12 | MO | $0.00 | |
| 0016 | Travel IAW PWS Section 4.4 - T&M | 1 | Lot | $32,247.84 | $32,247.84 |
| TOTAL BASE PERIOD EVALUATED PRICE - FFP | $32,247.84 | ||||
| OPTION PERIOD 1: | |||||
| 1001 | Project Management in accordance with (IAW) Performance Work Statement (PWS) paragraph 5.1, inclusive of subsections - FFP. | 12 | MO | $0.00 | |
| 1002 | Strategic Communication Program Analysis, Strategy, and Planning IAW PWS Section 5.2, inclusive of subsections - FFP. | 12 | MO | $0.00 | |
| 1003 | Communication Content Management IAW PWS Section 5.3, inclusive of subsections - FFP. | 12 | MO | $0.00 | |
| 1004 | Strategic Communication Support of Major Initiatives IAW PWS Section 5.4 - FFP. | 12 | MO | $0.00 | |
| 1005 | OIT Front Office Communication Support and Executive Messaging IAW PWS Section 5.5, inclusive of subsections - FFP. | 12 | MO | $0.00 | |
| 1006 | Organizational Recognition IAW PWS Section 5.6 - FFP. | 12 | MO | $0.00 | |
| 1007 | OIT Social Media Strategy and Implementation IAW PWS Section 5.7 - FFP. | 12 | MO | $0.00 | |
| 1008 | Speaking Engagement Support IAW PWS Section 5.8 - FFP. | 12 | MO | $0.00 | |
| 1009 | Public Affairs and Media Relations Support IAW PWS Section 5.9 - FFP. | 12 | MO | $0.00 | |
| 1010 | Congressional Affairs Support IAW PWS Section 5.10 - FFP. | 12 | MO | $0.00 | |
| 1011 | OIT and VA Staff Communication Support IAW PWS Section 5.11 - FFP. | 12 | MO | $0.00 | |
| 1012 | Graphics, Designs and Multimedia Support IAW PWS Section 5.12 - FFP. | 12 | MO | $0.00 | |
| 1013 | Image and Video Support IAW PWS Section 5.13 - FFP. | 12 | MO | $0.00 | |
| 1014 | Business Operations and Information Management Support IAW PWS Section 5.14 - FFP. | 12 | MO | $0.00 | |
| 1015 | Accessibility IAW PWS Section 5.15 - FFP. | 12 | MO | $0.00 | |
| 1016 | Travel IAW PWS Section 4.4 - T&M | 1 | Lot | $32,989.54 | $32,989.54 |
| TOTAL OPTION PERIOD 1 EVALUATED PRICE - FFP | $32,989.54 | ||||
| OPTION PERIOD 2: | |||||
| 2001 | Project Management in accordance with (IAW) Performance Work Statement (PWS) paragraph 5.1, inclusive of subsections - FFP. | 12 | MO | $0.00 | |
| 2002 | Strategic Communication Program Analysis, Strategy, and Planning IAW PWS Section 5.2, inclusive of subsections - FFP. | 12 | MO | $0.00 | |
| 2003 | Communication Content Management IAW PWS Section 5.3, inclusive of subsections - FFP. | 12 | MO | $0.00 | |
| 2004 | Strategic Communication Support of Major Initiatives IAW PWS Section 5.4 - FFP. | 12 | MO | $0.00 | |
| 2005 | OIT Front Office Communication Support and Executive Messaging IAW PWS Section 5.5, inclusive of subsections - FFP. | 12 | MO | $0.00 | |
| 2006 | Organizational Recognition IAW PWS Section 5.6 - FFP. | 12 | MO | $0.00 | |
| 2007 | OIT Social Media Strategy and Implementation IAW PWS Section 5.7 - FFP. | 12 | MO | $0.00 | |
| 2008 | Speaking Engagement Support IAW PWS Section 5.8 - FFP. | 12 | MO | $0.00 | |
| 2009 | Public Affairs and Media Relations Support IAW PWS Section 5.9 - FFP. | 12 | MO | $0.00 | |
| 2010 | Congressional Affairs Support IAW PWS Section 5.10 - FFP. | 12 | MO | $0.00 | |
| 2011 | OIT and VA Staff Communication Support IAW PWS Section 5.11 - FFP. | 12 | MO | $0.00 | |
| 2012 | Graphics, Designs and Multimedia Support IAW PWS Section 5.12 - FFP. | 12 | MO | $0.00 | |
| 2013 | Image and Video Support IAW PWS Section 5.13 - FFP. | 12 | MO | $0.00 | |
| 2014 | Business Operations and Information Management Support IAW PWS Section 5.14 - FFP. | 12 | MO | $0.00 | |
| 2015 | Accessibility IAW PWS Section 5.15 - FFP. | 12 | MO | $0.00 | |
| 2016 | Travel IAW PWS Section 4.4 - T&M | 1 | Lot | $33,748.30 | $33,748.30 |
| TOTAL OPTION PERIOD 2 EVALUATED PRICE - FFP | $33,748.30 | ||||
| OPTIONAL TASKS (T&M): | |||||
| 0017 | Optional Task 1–Intra-Division Communication Support (T&M) IAW PWS Section 5.16 - Not To Exceed (NTE). | NTE | ERROR:#VALUE! | ERROR:#VALUE! | |
| 0018 | Optional Task 2 – OIT Web Maintenance (T&M) IAW PWS Section 5.17 - Not To Exceed (NTE). | NTE | ERROR:#VALUE! | ERROR:#VALUE! | |
| TOTAL OPTIONAL TASKS EVALUATED PRICE - T&M NOT TO EXCEED (NTE) | ERROR:#VALUE! | ||||
| OPTIONAL TASK (FFP) | |||||
| 0019 | Optional Task 3 – Transition Out Services/Transition Plan IAW PWS Section 5.18 - FFP | 1 | Lot | $0.00 | |
| TOTAL TASK ORDER EVALUATED PRICE FFP and T&M (BASE PERIOD, OPTION PERIODS, and OPTIONAL TASKS) | ERROR:#VALUE! |
T&M Labor Rate Table T&M Labor Rate Table Tab
| Base Period | Option Period 1 | Option Period 2 | |
| Project Manager | Proposed Fully Loaded Blended Hourly Labor Rate | Proposed Fully Loaded Blended Hourly Labor Rate | Proposed Fully Loaded Blended Hourly Labor Rate |
| Project Manager | |||
| Functional Area Analyst | |||
| Communications Specialist | |||
| Technical Writer | |||
| Graphic Designer | |||
| Web Designer |
T&M Labor
| T&M Labor Tab | |||||||||||||
| 0 | Task Order Base Period | Task Order Base Period | Task Order Base Period | Task Order Option Period 1 | Task Order Option Period 1 | Task Order Option Period 1 | Task Order Option Period 2 | Task Order Option Period 2 | Task Order Option Period 2 | Total Task Order | Total Task Order | ||
| CLIN | PWS Task | Government Task Order Labor Category | Labor Hours |
(For Evaluation Purposes Only) Fully Loaded Blended Hourly Labor Rate Total Labor Labor Hours (For Evaluation Purposes Only) Fully Loaded Blended Hourly Labor Rate Total Labor Labor Hours (For Evaluation Purposes Only) Fully Loaded Blended Hourly Labor Rate Total Labor Labor Hours (For Evaluation
| Purposes Only) | Total Labor | |||||||||||||
| 4001 | 5.16 Intra-Division Communication Support (Optional Task 1) | Project Manager | 3,840 | $0.00 | Need Rate | 3,840 | $0.00 | Need Rate | 3,840 | $0.00 | Need Rate | 11,520 | ERROR:#VALUE! | |
| Functional Area Analyst | 13,440 | $0.00 | Need Rate | 13,440 | $0.00 | Need Rate | 13,440 | $0.00 | Need Rate | 40,320 | ERROR:#VALUE! | |||
| Communications Specialist | 19,200 | $0.00 | Need Rate | 19,200 | $0.00 | Need Rate | 19,200 | $0.00 | Need Rate | 57,600 | ERROR:#VALUE! | |||
| Technical Writer | 3,840 | $0.00 | Need Rate | 3,840 | $0.00 | Need Rate | 3,840 | $0.00 | Need Rate | 11,520 | ERROR:#VALUE! | |||
| Graphic Designer | 5,760 | $0.00 | Need Rate | 5,760 | $0.00 | Need Rate | 5,760 | $0.00 | Need Rate | 17,280 | ERROR:#VALUE! | |||
| 46,080 | $0.00 | 46,080 | $0.00 | 46,080 | $0.00 | 138,240 | ERROR:#VALUE! | |||||||
| 5001 | 5.17 OIT Web Maintenance (Optional Task 2) | Web Designer | 960 | $0.00 | Need Rate | 960 | $0.00 | Need Rate | 960 | $0.00 | Need Rate | 2,880 | ERROR:#VALUE! |
960 $0.00 960 $0.00 960 $0.00 2,880 ERROR:#VALUE!
| Total T&M Labor | 47,040 | $0.00 | 47,040 | $0.00 | 47,040 | $0.00 | 141,120 | ERROR:#VALUE! |
| . |
T&M Travel & Travel Handling
| T&M Travel & Travel Handling Tab | |||||||
| IAW PWS section 4.4 | Base Period | Option Period 1 | Option Period 2 | Total | |||
| Travel - Not To Exceed (NTE) | $32,247.84 | $32,989.54 | $33,748.30 | $98,985.68 | |||
| Travel Fixed Handling Percent and Amount | $0.00 | $0.00 | $0.00 | $0.00 | |||
| Travel & Travel Fixed Handling Amount - NTE | $32,247.84 | $32,989.54 | $33,748.30 | $98,985.68 |
LCAT Descriptions
| ITSC Labor Categories and Descriptions | |||
| LCAT | Description | Experience | |
| (Years) | Education | ||
| Communications Specialist | Provides support for communication, content development, and formative research projects, as well as general business development support. Interacts effectively with |
writers, designers, and other production personnel in the development of final deliverables. Assists in the development of media or marketing campaigns; manages
| outreach mailings; manages conference exhibition and other promotional meetings; assists in the preparation of marketing materials; and provides support to home page development. Organizes and manages social media programs and initiatives that promote community wellness, engagement and information sharing. Provides in-depth knowledge of best marketing and outreach practices to reach the target populations and special populations. | 3 to 5 | BA/BS | ||
| Functional Area Analyst | The Functional Area Analyst must have experience with executive-level communication, content development, and formative research projects, as well general business development and communication services support and the analysis of business, functional, technical, activities, and events. Analyst is responsible for working with users and customers to document and strategize for communication services support, as well as process improvements for current business processes related to strategic communication support. | 5 | BA/BS | |
| Graphic Designer | Produces creative graphic design projects including print collateral, logos, brochures, exhibit graphics, web design, etc. Knowledgeable in current design and layout software and advanced techniques for print and digital publications. Duties may include layout, 508 conforming, Search Engine Optimization, Website layout, uploading, template design, content development, exhibit signage, or other related design responsibilities. Works alone or with other staff to develop multimedia and exhibit projects. Must possess excellent communication and interpersonal skills. | 3 to 5 | BA/BS | |
| Project Manager | Performs day‐to‐day management of contract support operations, possibly involving multiple tasks and groups of personnel at multiple locations, on a single project. Demonstrates skills in the scope of work encompassed by the task order; provides technical guidance to the project team in performance of the work, and reviews the quality of all work products. Organizes, directs, and coordinates the planning and production of all contract support activities. In addition, responsible for staffing, project planning, project financials, and staff direction and oversight. Assist the Program Manager as required in managing contract performance. Supervisory and management experience. Specific experience areas include requirements definition, work planning, control of budget, schedule, and task execution, and personnel management and supervision. Manages project resources on | |||
| a day-to-day basis and guides junior staff. Leads identification, recruitment, and management of project staff. Ensure that all deliverables are on target and on time. | 10 | BA/BS | ||
| Technical Writer | Serves as the main point of contact for writing and editorial services to be performed for an assigned task. |
• Meet with the agency program official to establish preferred stylistic guidelines, adhering to the GPO Style Manual, Agency Correspondence Procedures, or any other guidelines selected by the agency program official to ensure that summaries, transcripts, and other publications are produced in a consistent manner.
• Participates in planning meetings to develop an understanding of meeting content and the types of deliverables needed.
• Provides document/publication review and editing so that they are grammatically correct within the preferred stylistic guidelines and reflect consistency.
| • Manages the development (literature search/retrieval), writing, formatting, printing, and distribution of patient, lay-person, andscientific publications, resource materials, and annual reports in support of agency needs. | 3 to 5 | BA/BS | ||
| Web Designer | The Web Designer directs and manages the design, development, and management of client web sites. Produces graphic sketches, designs, and copy layouts for online content. Determines size and arrangement of illustrative material and copy, selects style and size of type, and arranges layout based upon available space; knowledge of layout principles; and aesthetic design concepts. Has experience in web design; website development; web production management; web-based scripting language; and design standards and file types. Has knowledge of commonly-used concepts, practices, and procedures within a particular field. Relies on instructions and pre-established guidelines to perform the functions of the job. Has working knowledge of Section 508 standards as well as experience with design-related graphics and relevant applications, such as Adobe. | 3 to 5 | BA/BS |
File details come from the government source that posted it. Updated .