Attachment 2 Pricing worksheet 10-8-25.xlsx
XLSX spreadsheet 25 KB Posted
- Attached to
- IRS Graphic Design Services
- Solicitation number
- 2043FY-25-Q-00054
About this file
This document is a Pricing Worksheet (Attachment 2) for an Internal Revenue Service (IRS) Graphic Design Services solicitation. The procurement is a Total Small Business Set-Aside for NAICS code 541430, with a small business size standard of $9.0 million. The contract is a Firm Fixed Price arrangement spanning a base year and four option years, each 12 months long. The pricing template requires vendors to complete hourly rates and hours for three labor categories: Creative Director I, Senior Graphic Designer, and Production Manager, along with printing costs.
The solicitation (RFQ 2043FY-25-Q-00054) includes a fixed Not-To-Exceed amount for software license subscriptions starting at $40,000 in the base year and escalating 10% annually to $58,564 in the fourth option year. Key dates include questions due by 9/25/2025 at 5:00 PM EST and quotes due by 10/07/2025 at 5:00 PM EST. The total contract value across all periods is $244,204.00, covering graphic design services, printing, and software license subscriptions. The procurement is being conducted by the Department of the Treasury Internal Revenue Service using simplified acquisition procedures under FAR Part 13.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| RFQ 2043FY-25-Q-00054 Amendment 0002.pdf | ||
| Request for Information Log_Graphic Design RFQ 2043FY-25-Q-00054.xlsx | XLSX spreadsheet | |
| Section 3 Attachment 1 Statement of Work_R1_7Oct25.pdf | ||
| RFQ 2043FY-25-Q-00054 Amendment 0001.pdf | ||
| Attachment 2 Draft Pricing worksheet.xlsx | XLSX spreadsheet | |
| Attachment 1 Statement of Work.pdf | ||
| RFQ 2043FY-25-Q-00054.pdf |
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
Worksheet Instructions
Instructions on how to complete Pricing Worksheet Attachment 2:
This pricing worksheet is required to be completed by vendors to show the Government how vendors arrived at their total price. The completion of this worksheet will assist the Government in determining whether the vendor’s proposed price is realistic based on hours proposed and costs associated with software licenses and printing.
Using the Base Year as an example, for each year of the contract, vendors will fill out the following:
a) Hours Column (Cells B7, B8 and B9) – Represents the vendors proposed hours for each position. These cells require vendors to input information.
b) Fully Burdened Rate Column (Cells C7, C8 and C9) – Represents the proposed hourly rate for each position. These cells require vendors to input the proposed hourly rate for each position.
c) Total Column (Cells D7, D8 and D9) - Represents the total cost for each position. The total will automatically populate in this column of the spreadsheet once the hours and fully burdened rate cells have been completed and does not require vendors to input information.
d) Labor Total (Row 11 on the Spreadsheet) – The sum of the total hours of cells B7-B9 and total cost of cells D7-D10 will automatically populate in Cells B11 (Labor Total Hours) and D11 (Labor Total Dollar amount). These cells do not require the vendor to input information.
e) Printing Costs (Cell D13) - Vendors shall input their anticipated costs for Printing into cell D13.
f) CLIN 0001 Graphic Design Services Total (Cell D14) – The total amount in cell D14 will automatically populate and represents the total of cells D11 (Labor Total Dollar Amount) and D13 (Printing Costs). Cell D14 does not require vendors to input information.
g) CLIN 0002 License Subscriptions Total (Cell D15) – The costs of the SOW Licenses shall be a $40,000.00 Not To Exceed amount that will escalate 10% each year. This is what the Government is currently paying for these licenses. Per SOW section C.3.4.1, the awardee shall be responsible to take over and manage current active subscriptions and billing. The Government has input these amounts in the Base Year and the associated Option Years of the Pricing Worksheet. Cell D15 does not require vendors to input information and is locked.
h) Period Total (Cell D16) – The cell D16, is the sum of cells D14 (CLIN 0001 Total) and D15 (CLIN 0002 Total). The total will be automatically populated and does not require vendors to input information into the cell.
i) Total Contract Price (Cell P18) – Cell P18 represents the total price of the contract. This cell is the sum of the Base year and Option year cells D16, G16, J16, M16 and P16. This amount will automatically populate and does not require vendor input.
*NOTE: The Cells referenced above were using the Base Year of the contract as an example. Vendors shall similarly complete the corresponding cells for each option year to complete the spreadsheet. The Option Year cells follow the same format/formulas as the Base Year cells. In the event vendors find errors in the Worksheet while preparing their quote, they will immediately notify the Government.
Attachment 2-Pricing Worksheet
| Pricing Worksheet | |||
| Company Name: | Project Title: | Graphic Design Services | |
| Date: |
| CLIN 0001 (Base Period): 12 Months | CLIN 1001 (Option Year 1): 12 Months | CLIN 2001 (Option Year 2): 12 Months | CLIN 3001 (Option Year 3): 12 Months | CLIN 4001 (Option Year 4) : 12 Months | |||||||||||
| Labor Category | Hours | Fully Burdened Rate | Total | Hours | Fully Burdened Rate | Total | Hours | Fully Burdened Rate | Total | Hours | Fully Burdened Rate | Total | Hours | Fully Burdened Rate | Total |
| Creative Director I | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 |
| Senior Graphic Designer | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 |
| Production Manager | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 | 0.00 | $0.00 | $0.00 |
Labor Total 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00
| Printing Costs | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| CLIN 0001 Graphic Design Services TOTAL | CLIN 0001 | $0.00 | CLIN 1001 | $0.00 | CLIN 2001 | $0.00 | CLIN 3001 | $0.00 | CLIN 4001 | $0.00 |
| CLIN 0002 License Subscriptions NOT TO EXCEED TOTAL | CLIN 0002 | $40,000.00 | CLIN 1002 | $44,000.00 | CLIN 2002 | $48,400.00 | CLIN 3002 | $53,240.00 | CLIN 4002 | $58,564.00 |
| Period Total | Base Year Total | $40,000.00 | Option Year 1 Total | $44,000.00 | Option Year 2 Total | $48,400.00 | Option Year 3 Total | $53,240.00 | Option Year 4 Total | $58,564.00 |
Total Contract Price $244,204.00
&"Calibri"&10&K000000 Sensitive But Unclassified (SBU) data: Share only with authenticated authorized persons with need to know. &1#_x000D_
File details come from the government source that posted it. Updated .