Attachment_7_-_Pricing_Spreadsheet_-_V1.xlsx
XLSX spreadsheet 38 KB Posted
- Attached to
- DOI Tribal Consultation Training
- Solicitation number
- 140D0421Q0217
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment_8_-_Questions_and_Answers_0001.docx | DOCX document | |
| Sol_140D0421Q0217_Amd_0001.pdf | ||
| Attachment_3_-_Service_Contract_Act_WD_District_of_Columbia_2015-4281.txt | TXT text file | |
| Attachment_5_-_Service_Contract_Act_WD_Phoenix_2015-5419.txt | TXT text file | |
| Attachment_4_-_Service_Contract_Act_WD_Denver_2015-5469.txt | TXT text file | |
| Sol_140D0421Q0217.pdf | ||
| Attachment_2_-_Tribal_Consultation_Course_QASP_V1_0.docx | DOCX document | |
| Attachment_1_-_Tribal_Consultation_Course_PWS_V2_0.docx | DOCX document | |
| Attachment_6_-_Service_Contract_Act_WD_Albuquerque_2015-5443.txt | TXT text file |
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
Summary
| Vendor |
| RFQ Number |
| POC Name |
| Phone Number |
| Line Item Summary | |||
| Line Item | Period | Task | Subtotal |
| 00010 | One | Tribal Consultation Virtual Course | $0.00 |
| 00020 | One | Tribal Consultation In-Person Course | $0.00 |
| 00030 | One | Annual Review Meeting | $0.00 |
| 00040 | One | Additional Course Participant | $0.00 |
| 01010 | Two | Tribal Consultation Virtual Course | $0.00 |
| 01020 | Two | Tribal Consultation In-Person Course | $0.00 |
| 01030 | Two | Annual Review Meeting | $0.00 |
| 01040 | Two | Additional Course Participant | $0.00 |
| 02010 | Three | Tribal Consultation Virtual Course | $0.00 |
| 02020 | Three | Tribal Consultation In-Person Course | $0.00 |
| 02030 | Three | Annual Review Meeting | $0.00 |
| 02040 | Three | Additional Course Participant | $0.00 |
| 03010 | Four | Tribal Consultation Virtual Course | $0.00 |
| 03020 | Four | Tribal Consultation In-Person Course | $0.00 |
| 03030 | Four | Annual Review Meeting | $0.00 |
| 03040 | Four | Additional Course Participant | $0.00 |
| 04010 | Five | Tribal Consultation Virtual Course | $0.00 |
| 04020 | Five | Tribal Consultation In-Person Course | $0.00 |
| 04030 | Five | Annual Review Meeting | $0.00 |
| 04040 | Five | Additional Course Participant | $0.00 |
| Grand Total | $0.00 |
&F - &A &D
&P of &N
Pricing
| Instructions |
| Instructions |
1. Select "Line Item" from drop down in the Cell. "Deliverable" autofills.
2. Enter "Item / Labor Category"
3. Select whether the Service Contract Act applies.
4. Select the Unit of Issue from the drop down. To keep calculations simple only "Hours" and "Each" are available.
5. Enter quantity and Rate. "Subtotal" automatically calculates.
6. Enter the "Discount %". The "Discounted Rate" and "Total" automatically calculates.
If more rows are needed, insert another row above the "Grand Total" row.
Make sure to add your company information to the CLIN Summary sheet!
| Example Table | |||||||||||
| Item | Deliverable | Period | Item / Labor Category | Service Contract Act | Unit of Issue | Quantity | Rate | Subtotal | Discount | Discounted Rate | Total |
| 0010A | Example Labor | Exempt | Hours | 50 | $ 50.00 | $ 2,500.00 | 10.00% | $ 45.00 | $ 2,250.00 | ||
| X001 | Example Deliverable Report | Base | Assistant | Not Exempt | Hours | 40 | $ 250.00 | $ 10,000.00 | 10.00% | $ 225.00 | $ 9,000.00 |
| X001 | Example Deliverable Report | Base | Travel | Not Labor Category | Dollars | 350 | $ 1.00 | $ 350.00 | 0.00% | $ 1.00 | $ 350.00 |
| X002 | Annual Software License | Base | One Year License P/N X9000 | Not Labor Category | Each | 1 | $ 9,000.00 | $ 9,000.00 | 20.00% | $ 7,200.00 | $ 7,200.00 |
| Pricing Data Table | $ - 0 | ERROR:#DIV/0! | $ - 0 | ||||||||
| Line Item | Deliverable | Period | Item / Labor Category | Service Contract Act | Unit of Issue | Quantity | Rate | Subtotal | Discount | Discounted Rate | Total |
| 00010 | A0001 Evaluation Report - Tribal Consultation Virtual Course | One | Example Labor | Exempt | Hours | $ - 0 | 10.00% | $ - 0 | $ - 0 | ||
| 00010 | A0001 Evaluation Report - Tribal Consultation Virtual Course | One | Example Labor | Not Exempt | Hours | $ - 0 | 0.00% | $ - 0 | $ - 0 | ||
| 00010 | A0001 Evaluation Report - Tribal Consultation Virtual Course | One | Example Item | Not Labor Category | Each | $ - 0 | 5.00% | $ - 0 | $ - 0 | ||
| 00010 | A0001 Evaluation Report - Tribal Consultation Virtual Course | One | Test | $ - 0 | 0.00% | $ - 0 | $ - 0 | ||||
| 00020 | A0002 Evaluation Report - Tribal Consultation In-Person Course | One | Test | $ - 0 | 0.00% | $ - 0 | $ - 0 | ||||
| 00030 | A0003 Annnual Review Meeting Summary | One | Test | $ - 0 | 0.00% | $ - 0 | $ - 0 | ||||
| 00040 | Additional Course Participant | One | Test | $ - 0 | 0.00% | $ - 0 | $ - 0 | ||||
| 01010 | A0001 Evaluation Report - Tribal Consultation Virtual Course | Two | Test | $ - 0 | 0.00% | $ - 0 | $ - 0 | ||||
| 01020 | A0002 Evaluation Report - Tribal Consultation In-Person Course | Two | Test | $ - 0 | 0.00% | $ - 0 | $ - 0 | ||||
| 01030 | A0003 Annnual Review Meeting Summary | Two | Test | $ - 0 | 0.00% | $ - 0 | $ - 0 | ||||
| 01040 | Additional Course Participant | Two | Test | $ - 0 | 0.00% | $ - 0 | $ - 0 | ||||
| 02010 | A0001 Evaluation Report - Tribal Consultation Virtual Course | Three | Test | $ - 0 | 0.00% | $ - 0 | $ - 0 | ||||
| 02020 | A0002 Evaluation Report - Tribal Consultation In-Person Course | Three | Test | $ - 0 | 0.00% | $ - 0 | $ - 0 | ||||
| 02030 | A0003 Annnual Review Meeting Summary | Three | Test | $ - 0 | 0.00% | $ - 0 | $ - 0 | ||||
| 02040 | Additional Course Participant | Three | Test | $ - 0 | 0.00% | $ - 0 | $ - 0 | ||||
| 03010 | A0001 Evaluation Report - Tribal Consultation Virtual Course | Four | Test | $ - 0 | 0.00% | $ - 0 | $ - 0 | ||||
| 03020 | A0002 Evaluation Report - Tribal Consultation In-Person Course | Four | Test | $ - 0 | 0.00% | $ - 0 | $ - 0 | ||||
| 03030 | A0003 Annnual Review Meeting Summary | Four | Test | $ - 0 | 0.00% | $ - 0 | $ - 0 | ||||
| 03040 | Additional Course Participant | Four | Test | $ - 0 | 0.00% | $ - 0 | $ - 0 | ||||
| 04010 | A0001 Evaluation Report - Tribal Consultation Virtual Course | Five | Test | $ - 0 | 0.00% | $ - 0 | $ - 0 | ||||
| 04020 | A0002 Evaluation Report - Tribal Consultation In-Person Course | Five | Test | $ - 0 | 0.00% | $ - 0 | $ - 0 | ||||
| 04030 | A0003 Annnual Review Meeting Summary | Five | Test | $ - 0 | 0.00% | $ - 0 | $ - 0 | ||||
| 04040 | Additional Course Participant | Five | Test | $ - 0 | 0.00% | $ - 0 | $ - 0 | ||||
| Grand Total | $ - 0 | $ - 0 |
Deliverables
| Notice | ||||||||
| This sheet updates based on information entered into the "Pricing" Sheet. Please do not change this sheet unless absolutely necessary. | ||||||||
| Line Item and Deliverable Table | ||||||||
| Line Item | Task | Period | Deliverable | Qty | Unit | Price | Total Amount | |
| 00010 | Tribal Consultation Virtual Course | One | A0001 Evaluation Report - Tribal Consultation Virtual Course | 1 | EA | $0.00 | $0.00 | |
| 00020 | Tribal Consultation In-Person Course | One | A0002 Evaluation Report - Tribal Consultation In-Person Course | 1 | EA | $0.00 | $0.00 | |
| 00030 | Annual Review Meeting | One | A0003 Annnual Review Meeting Summary | 1 | EA | $0.00 | $0.00 | |
| 00040 | Additional Course Participant | One | Additional Course Participant | 1 | EA | $0.00 | $0.00 | |
| 01010 | Tribal Consultation Virtual Course | Two | A0001 Evaluation Report - Tribal Consultation Virtual Course | 1 | EA | $0.00 | $0.00 | |
| 01020 | Tribal Consultation In-Person Course | Two | A0002 Evaluation Report - Tribal Consultation In-Person Course | 1 | EA | $0.00 | $0.00 | |
| 01030 | Annual Review Meeting | Two | A0003 Annnual Review Meeting Summary | 1 | EA | $0.00 | $0.00 | |
| 01040 | Additional Course Participant | Two | Additional Course Participant | 1 | EA | $0.00 | $0.00 | |
| 02010 | Tribal Consultation Virtual Course | Three | A0001 Evaluation Report - Tribal Consultation Virtual Course | 1 | EA | $0.00 | $0.00 | |
| 02020 | Tribal Consultation In-Person Course | Three | A0002 Evaluation Report - Tribal Consultation In-Person Course | 1 | EA | $0.00 | $0.00 | |
| 02030 | Annual Review Meeting | Three | A0003 Annnual Review Meeting Summary | 1 | EA | $0.00 | $0.00 | |
| 02040 | Additional Course Participant | Three | Additional Course Participant | 1 | EA | $0.00 | $0.00 | |
| 03010 | Tribal Consultation Virtual Course | Four | A0001 Evaluation Report - Tribal Consultation Virtual Course | 1 | EA | $0.00 | $0.00 | |
| 03020 | Tribal Consultation In-Person Course | Four | A0002 Evaluation Report - Tribal Consultation In-Person Course | 1 | EA | $0.00 | $0.00 | |
| 03030 | Annual Review Meeting | Four | A0003 Annnual Review Meeting Summary | 1 | EA | $0.00 | $0.00 | |
| 03040 | Additional Course Participant | Four | Additional Course Participant | 1 | EA | $0.00 | $0.00 | |
| 04010 | Tribal Consultation Virtual Course | Five | A0001 Evaluation Report - Tribal Consultation Virtual Course | 1 | EA | $0.00 | $0.00 | |
| 04020 | Tribal Consultation In-Person Course | Five | A0002 Evaluation Report - Tribal Consultation In-Person Course | 1 | EA | $0.00 | $0.00 | |
| 04030 | Annual Review Meeting | Five | A0003 Annnual Review Meeting Summary | 1 | EA | $0.00 | $0.00 | |
| 04040 | Additional Course Participant | Five | Additional Course Participant | 1 | EA | $0.00 | $0.00 | |
| Total | $0.00 |
File details come from the government source that posted it. Updated .