ATTACHMENT 6 - Sample BOM Summary.xlsx

19 KB Posted

Attached to
Forest Service Fire Tape Storage
Solicitation number
12760425Q0011
Issued by

About this file

Written by GovTribe AI ·

The file is an Excel-based Bill of Materials (BOM) Summary for a federal contract (12760423F0000) with a base year and four option years. The contract includes a base year from 2/1/21 to 1/31/22 at $10.00, followed by four option years incrementally priced at $15.00, $20.00, $25.00, and $30.00 respectively, with two items per year. The total original award value is $190.00, with an additional modification of $2.00 for extra software, bringing the modified contract value to approximately $192.00.

The BOM also includes a comprehensive holiday schedule covering years 2022-2030, tracking observed dates for federal holidays such as New Year's Day, Martin Luther King Jr. Day, Memorial Day, Independence Day, and Christmas Day. The contract appears to have a color-coded tracking system for Period of Performance (PoP) status, with red indicating PoP end has passed and yellow signaling PoP within 90 days. The contract structure allows for potential extensions and modifications, with a current total exercised value of $12.00.

View the file

Other files

File Type Posted
RFQ 12760425Q0011.pdf PDF
ATTACHMENT 5 - USDA C-SCRM Standard Contract Language.pdf PDF
ATTACHMENT 2 - Fire Tape Media Offsite Storage.pdf PDF
ATTACHMENT 4 - ART Language 8-5-2024.pdf PDF
ATTACHMENT 1 - BOM.xlsx XLSX spreadsheet
ATTACHMENT 3 - QASP - Fire Tape Storage.pdf 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
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

12760423F0000

12760423F0000 - Something Awarded NameSUM OF EXERCISED $:$12.00
CLINDESCRIPTION# ITEMS$ PER ITEMTOTAL $ PER ITEMPOP STARTSTART DAYPOP ENDEND DAY# WORKDAYS REMAINING# CALENDAR DAYS REMAININGEXERCISED?SUM OF AWARD AS ORIGINALLY AWARDED WITHOUT ADDITIONAL MODS:$190.00
0001Base Year1$10.00$10.002/1/21Monday1/31/22Monday-241-351yes
0002Option Year 12$15.00$30.002/1/22Tuesday1/31/23Tuesday1114
0003Option Year 22$20.00$40.002/1/23Wednesday1/31/24Wednesday261379Additional Mods not part of optional mods such as travelMod 1 - Extra software$2.00
0004Option Year 32$25.00$50.002/1/24Thursday1/31/25Friday512745
0005Option Year 42$30.00$60.002/1/25Saturday1/31/26Saturday7611110
Red = PoP end passed
Yellow = PoP within 90 days
SUM OF EXTRA MODS:$2.00
% MOD SUM TO AWARDED $1.05%

HOLIDY SCHEDULE

202220252028
Holiday NameDay of Week2022 Observed DateHoliday NameDay of Week2025 Observed DateHoliday NameDay of Week2028 Observed Date
New Year's Day †FridayDecember 31st, 202131-Dec-21New Year's DayWednesdayJanuary 1st, 20251-Jan-25New Year's Day †FridayDecember 31st, 202831-Dec-28
Birthday of Martin Luther King, Jr.MondayJanuary 17th, 202217-Jan-22Birthday of Martin Luther King, Jr.MondayJanuary 20th, 202520-Jan-25Birthday of Martin Luther King, Jr.MondayJanuary 17th, 202817-Jan-28
Washington's BirthdayMondayFebruary 21st, 202221-Feb-22Washington's BirthdayMondayFebruary 17th, 202517-Feb-25Washington's BirthdayMondayFebruary 21st, 202821-Feb-28
Memorial DayMondayMay 30th, 202230-May-22Memorial DayMondayMay 26th, 202526-May-25Memorial DayMondayMay 29th, 202829-May-28
Juneteenth Independence Day †MondayJune 20th, 202220-Jun-22Juneteenth Independence DayThursdayJune 19th, 202519-Jun-25Juneteenth Independence Day †MondayJune 19th, 202819-Jun-28
Independence DayMondayJuly 4th, 20224-Jul-22Independence DayFridayJuly 4th, 20254-Jul-25Independence DayTuesdayJuly 4th, 20284-Jul-28
Labor DayMondaySeptember 5th, 20225-Sep-22Labor DayMondaySeptember 1st, 20251-Sep-25Labor DayMondaySeptember 4th, 20284-Sep-28
Columbus DayMondayOctober 10th, 202210-Oct-22Columbus DayMondayOctober 13th, 202513-Oct-25Columbus DayMondayOctober 9th, 20289-Oct-28
Veterans Day (0 days)FridayNovember 11th, 202211-Nov-22Veterans Day (0 days)TuesdayNovember 11th, 202511-Nov-25Veterans Day (0 days)FridayNovember 10th, 202810-Nov-28
Thanksgiving DayThursdayNovember 24th, 202224-Nov-22Thanksgiving DayThursdayNovember 27th, 202527-Nov-25Thanksgiving DayThursdayNovember 23th, 202823-Nov-28
Christmas Day †MondayDecember 26th, 202226-Dec-22Christmas DayThursdayDecember 25th, 202525-Dec-25Christmas Day †MondayDecember 25th, 202825-Dec-28
202320262029
Holiday NameDay of Week2023 Observed DateHoliday NameDay of Week2026 Observed DateHoliday NameDay of Week2029 Observed Date
New Year's Day †MondayJanuary 2nd, 20232-Jan-23New Year's DayThursdayJanuary 1st, 20261-Jan-26New Year's DayMondayJanuary 1st, 20291-Jan-29
Birthday of Martin Luther King, Jr.MondayJanuary 16th, 202316-Jan-23Birthday of Martin Luther King, Jr.MondayJanuary 19th, 202619-Jan-26Birthday of Martin Luther King, Jr.MondayJanuary 15th, 202915-Jan-29
Washington's BirthdayMondayFebruary 20th, 202320-Feb-23Washington's BirthdayMondayFebruary 16th, 202616-Feb-26Washington's BirthdayMondayFebruary 19th, 202919-Feb-29
Memorial DayMondayMay 29th, 202329-May-23Memorial DayMondayMay 25th, 202625-May-26Memorial DayMondayMay 28th, 202928-May-29
Juneteenth Independence DayMondayJune 19th, 202319-Jun-23Juneteenth Independence DayFridayJune 19th, 202619-Jun-26Juneteenth Independence DayTuesdayJune 19th, 202919-Jun-29
Independence DayTuesdayJuly 4th, 20234-Jul-23Independence Day †FridayJuly 3rd, 20263-Jul-26Independence DayWednesdayJuly 4th, 20294-Jul-29
Labor DayMondaySeptember 4th, 20234-Sep-23Labor DayMondaySeptember 7th, 20267-Sep-26Labor DayMondaySeptember 3rd, 20293-Sep-29
Columbus DayMondayOctober 9th, 20239-Oct-23Columbus DayMondayOctober 12th, 202612-Oct-26Columbus DayMondayOctober 8th, 20298-Oct-29
Veterans Day † (0 days)FridayNovember 10th, 202310-Nov-23Veterans Day (0 days)WednesdayNovember 11th, 202611-Nov-26Veterans Day (0 days)MondayNovember 12th, 209412-Nov-29
Thanksgiving DayThursdayNovember 23rd, 202323-Nov-23Thanksgiving DayThursdayNovember 26th, 202626-Nov-26Thanksgiving DayThursdayNovember 22nd, 202922-Nov-29
Christmas DayMondayDecember 25th, 202325-Dec-23Christmas DayFridayDecember 25th, 202625-Dec-26Christmas DayTuesdayDecember 25th, 202925-Dec-29
202420272030
Holiday NameDay of Week2024 Observed DateHoliday NameDay of Week2027 Observed DateHoliday NameDay of Week2030 Observed Date
New Year's DayMondayJanuary 1st, 20241-Jan-24New Year's DayFridayJanuary 1st, 20271-Jan-27New Year's DayTuesdayJanuary 1st, 20301-Jan-30
Birthday of Martin Luther King, Jr.MondayJanuary 15th, 202415-Jan-24Birthday of Martin Luther King, Jr.MondayJanuary 18th, 202718-Jan-27Birthday of Martin Luther King, Jr.MondayJanuary 21st, 203021-Jan-30
Washington's BirthdayMondayFebruary 19th, 202419-Feb-24Washington's BirthdayMondayFebruary 15th, 202715-Feb-27Washington's BirthdayMondayFebruary 18th, 203018-Feb-30
Memorial DayMondayMay 27th, 202427-May-24Memorial DayMondayMay 31st, 202731-May-27Memorial DayMondayMay 27th, 203027-May-30
Juneteenth Independence DayWednesdayJune 19th, 202419-Jun-24Juneteenth Independence Day †FridayJune 18th, 202718-Jun-27Juneteenth Independence DayWednesdayJune 19th, 203019-Jun-30
Independence DayThursdayJuly 4th, 20244-Jul-24Independence Day †MondayJuly 5th, 20275-Jul-27Independence DayThursdayJuly 4th, 20304-Jul-30
Labor DayMondaySeptember 2nd, 20242-Sep-24Labor DayMondaySeptember 6th, 20276-Sep-27Labor DayMondaySeptember 2nd, 20302-Sep-30
Columbus DayMondayOctober 14th, 202414-Oct-24Columbus DayMondayOctober 11th, 202711-Oct-27Columbus DayMondayOctober 14th, 203014-Oct-30
Veterans Day (0 days)MondayNovember 11th, 202411-Nov-24Veterans Day (0 days)ThursdayNovember 11th, 202711-Nov-27Veterans Day (0 days)MondayNovember 11th, 203011-Nov-30
Thanksgiving DayThursdayNovember 28th, 202428-Nov-24Thanksgiving DayThursdayNovember 25th, 202725-Nov-27Thanksgiving DayThursdayNovember 28th, 203028-Nov-30
Christmas DayWednesdayDecember 25th, 202425-Dec-24Christmas Day †FridayDecember 24th, 202724-Dec-27Christmas DayWednesdayDecember 25th, 203025-Dec-30
31-Dec-21
17-Jan-22
21-Feb-22
30-May-22
20-Jun-22
4-Jul-22
5-Sep-22
10-Oct-22
11-Nov-22
24-Nov-22
26-Dec-22
2-Jan-23
16-Jan-23
20-Feb-23
29-May-23
19-Jun-23
4-Jul-23
4-Sep-23
9-Oct-23
10-Nov-23
23-Nov-23
25-Dec-23
1-Jan-24
15-Jan-24
19-Feb-24
27-May-24
19-Jun-24
4-Jul-24
2-Sep-24
14-Oct-24
11-Nov-24
28-Nov-24
25-Dec-24
1-Jan-25
20-Jan-25
17-Feb-25
26-May-25
19-Jun-25
4-Jul-25
1-Sep-25
13-Oct-25
11-Nov-25
27-Nov-25
25-Dec-25
1-Jan-26
19-Jan-26
16-Feb-26
25-May-26
19-Jun-26
3-Jul-26
7-Sep-26
12-Oct-26
11-Nov-26
26-Nov-26
25-Dec-26
1-Jan-27
18-Jan-27
15-Feb-27
31-May-27
18-Jun-27
5-Jul-27
6-Sep-27
11-Oct-27
11-Nov-27
25-Nov-27
24-Dec-27
31-Dec-27
17-Jan-28
21-Feb-28
29-May-28
19-Jun-28
4-Jul-28
4-Sep-28
9-Oct-28
10-Nov-28
23-Nov-28
25-Dec-28
1-Jan-29
15-Jan-29
19-Feb-29
28-May-29
19-Jun-29
4-Jul-29
3-Sep-29
8-Oct-29
12-Nov-29
22-Nov-29
25-Dec-29
1-Jan-30
21-Jan-30
18-Feb-30
27-May-30
19-Jun-30
4-Jul-30
2-Sep-30
14-Oct-30
11-Nov-30
28-Nov-30
25-Dec-30

File details come from the government source that posted it. Updated .