Attachment G - 2023 Model Year Estimated Quantities.xlsx

XLSX spreadsheet 20 KB Posted

Attached to
2023 Light Duty Vocational Trucks
Solicitation number
47QMCA22R0014
Issued by

About this file

This document contains an estimated quantities spreadsheet and information about a related federal contract opportunity for light duty vocational vehicles for the 2023 model year. The estimated quantities spreadsheet lists over 100 product categories including various cab and chassis truck configurations, utility trucks, cargo vans, stake bed trucks, dump trucks, and panel vans. It provides the estimated total quantity needed and estimated total value for each category, as well as the estimated fleet quantities and values. The total estimated value of all items is over $148 million.

The related federal contract opportunity is a draft solicitation from the GSA Federal Acquisition Service seeking light duty vocational trucks for the 2023 model year. The solicitation number is 47QMCA22R0014 and proposals are due by September 12, 2022. The opportunity involves the procurement of a wide range of vehicle types and configurations to meet various fleet needs as detailed in the estimated quantities spreadsheet.

View the file

Other files

File Type Posted
47QMCA22R0014 Amendment 0004 SF30 09_30_2022.pdf PDF
47QMCA22R0014 Amendment 003 SF30 09_21_2022.pdf PDF
47QMCA22R0014 Pre-Proposal Conference slides 09_20_2022.pptx PPTX presentation
47QMCA22R0014 Solicitation Document 09_13_2022.pdf PDF
Attachment A - Proposal Checklist.docx DOCX document
47QMCA22R0014 Amendment 002 SF30 09_13_2022.pdf PDF
Attachment B - SF1449.pdf PDF
47QMCA22R0014 Amendment 001 SF30 08_16_2022.pdf PDF
Attachment Q - AutoChoice Online Ordering Instructions.pdf PDF
Attachment M2 - Supplemental Weekly Vendor Status Reports Template.xlsx XLSX spreadsheet
Attachment P - AutoBid Vendor Instructions.pdf PDF
Attachment R1 - UltraMod Instructions.pdf PDF
Attachment D1 - Technical Proposal Template.docx DOCX document
Attachment H1 - Optional Equipment Analysis.pdf PDF
Attachment E3 - Option MBC Description.pdf PDF
Attachment I - 888E Proposal Template.xlsx XLSX spreadsheet
Attachment B - SF1449.pdf PDF
Attachment E1 - Federal Vehicle Standard 307BB.pdf PDF
Attachment J - NMY Cut-off Date Pricing Template.xlsx XLSX spreadsheet
Attachment F2 - Schedule of Items - FCA US LLC.pdf PDF
Attachment L - Weekly Contractor Status Reports Submission Requirements.docx DOCX document
Attachment K3 - DIT Process for 2023 Light Duty Trucks Solicitation (Leasing).docx DOCX document
Attachment R2 - UltraMod Worksheet.pdf PDF
Attachment D2 - Technical Exceptions Worksheet.xlsx XLSX spreadsheet
Attachment F4 - Schedule of Items - General Motors.pdf PDF
Attachment K2 - DIT Claim Form Template (Purchasing).pdf PDF
Attachment E2 - Option CF52 Description.pdf PDF
Attachment F1 - Schedule of Items - Daimler Trucks North America.pdf PDF
Attachment N1 - Introduction to FedConnect.pdf PDF
Attachment E5 - Option MSTL Description.pdf PDF
Attachment F3 - Schedule of Items - Ford.pdf PDF
Attachment F5 - Schedule of Items - 888E.pdf PDF
Attachment A - Proposal Checklist.docx DOCX document
Attachment N2 - FedConnect Ready Set Go Guide.pdf PDF
Attachment S - Full Text of Clauses Incorporated by Reference (IBR).pdf PDF
Attachment K4 - DIT Process for 2023 Light Duty Vocational Solicitation (Purchasing).docx DOCX document
Attachment N3 - FedConnect Vendor Reference Guide.pdf PDF
Attachment O - Inspection Points Template.xlsx XLSX spreadsheet
Attachment E4 - Option MCTL Description.pdf PDF
Attachment H2 - Optional Equipment Combination Analysis.pdf PDF
Attachment M1 - Weekly Contractor Status Reports EXAMPLE.xlsx XLSX spreadsheet
Attachment E6 - Option MTTP Description.pdf PDF
47QMCA22R0014 Solicitation Document 07_15_2022.pdf PDF
Attachment C - Offeror Response Document.docx DOCX document
Attachment K1 - DIT Claim Form Template (Leasing).pdf PDF
Show all 45

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

Table 1

2023 MODEL YEAR ESTIMATED QUANTITIES - LIGHT DUTY VOCATIONAL VEHICLES
SOLICITATION 47QMCA22R0014
Std ItemVehicle TypeDescriptionTotal QtyValueFleet QtyFleet Value
73Cab & Chassis (4x2)4X2 CAB AND CHASSIS, REGULAR CAB, MIN 8000 LBS GVWR1$26,037.000$0.00
73CCab & Chassis (4x2)4X2 CAB AND CHASSIS, EXTENDED CAB, MIN 8000 LBS GVWR1$28,568.000$0.00
73DCab & Chassis (4x2)4X2 CAB AND CHASSIS, EXT CAB, 10,001 - 12,000 LBS GVWR1$30,933.000$0.00
73ECab & Chassis (4x2)4X2 CAB AND CHASSIS, CREW CAB, MIN 8000 LBS GVWR1$29,388.000$0.00
73FCab & Chassis (4x2)4X2 CAB AND CHASSIS, CREW CAB, 10,001 - 12,000 LBS GVWR1$30,850.001$30,850.00
74Cab & Chassis (4x2)4X2 CAB AND CHASSIS, REGULAR CAB 10,001 - 12,000 LBS GVWR1$27,159.001$27,159.00
74ACab & Chassis (4x2)4X2 CAB AND CHASSIS, REGULAR CAB, MIN 10,001 LBS GVWR4$118,988.002$59,494.00
74BCab & Chassis (4x2)4X2 CAB AND CHASSIS, REGULAR CAB, MIN 14,001 LBS GVWR1$33,647.000$0.00
74CCab & Chassis (4x2)4X2 CAB AND CHASSIS, EXTENDED CAB, MIN 10,001 LBS GVWR1$31,838.000$0.00
74DCab & Chassis (4x2)4X2 CAB AND CHASSIS, REGULAR CAB, MIN 16,001 LBS GVWR4$138,620.004$138,620.00
74ECab & Chassis (4x2)4X2 CAB AND CHASSIS, CREW CAB, MIN 10,001 LBS GVWR1$32,326.000$0.00
74FCab & Chassis (4x2)4X2 CAB AND CHASSIS, CREW CAB, MIN 14,001 LBS GVWR1$37,873.001$37,873.00
74GCab & Chassis (4x2)4X2 CAB AND CHASSIS, CREW CAB, MIN 16,001 LBS GVWR1$38,881.001$38,881.00
74HCab & Chassis (4x2)4X2 CAB AND CHASSIS, EXTENDED CAB, MIN. 14,001 LBS GVWR1$37,089.000$0.00
74JCab & Chassis (4x2)4X2 CAB AND CHASSIS, EXTENDED CAB, MIN. 16,001 LBS GVWR1$38,098.000$0.00
75Cab & Chassis (4x2)4X2 CUTAWAY CAB AND CHASSIS, 10,000 AND UNDER LBS GVWR1$23,411.000$0.00
75ACab & Chassis (4x2)4X2 CUTAWAY CAB AND CHASSIS, MIN 10,001 LBS GVWR1$26,736.000$0.00
75BCab & Chassis (4x2)4X2 CUTAWAY CAB AND CHASSIS, MIN 14,001 LBS GVWR1$30,584.000$0.00
75ECab & Chassis (4x2)4X2 STRIPPED CHASSIS, MIN 10,001 LBS GVWR1$26,389.000$0.00
75FCab & Chassis (4x2)4X2 STRIPPED CHASSIS, MIN 14,001 LBS GVWR1$28,429.000$0.00
75GCab & Chassis (4x2)4X2 STRIPPED CHASSIS, MIN 16,001 LBS GVWR1$29,980.000$0.00
77Cab & Chassis (4x4)4X2 CAB AND CHASSIS, REGULAR CAB, MIN 8000 LBS GVWR2$57,440.001$28,720.00
77CCab & Chassis (4x4)4X4 CAB AND CHASSIS, EXTENDED CAB, MIN 8000 LBS GVWR3$94,713.001$31,571.00
77ECab & Chassis (4x4)4X4 CAB AND CHASSIS, CREW CAB, MIN 8000 LBS GVWR7$229,110.004$130,920.00
78Cab & Chassis (4x4)4X4 CAB AND CHASSIS, REGULAR CAB, 10,001 - 12,000 LBS GVWR4$118,992.002$59,496.00
78CCab & Chassis (4x4)4X4 CAB AND CHASSIS, EXT CAB, 10,001 - 12,000 LBS GVWR36$1,176,948.002$65,386.00
78ECab & Chassis (4x4)4X4 CAB AND CHASSIS, CREW CAB, 10,001 - 12,000 LBS GVWR13$438,737.002$67,498.00
79ACab & Chassis (4x4)4X4 CAB AND CHASSIS, REGULAR CAB, MIN 10,001 LBS GVWR1$33,024.000$0.00
79BCab & Chassis (4x4)4X4 CAB AND CHASSIS, REGULAR CAB, MIN 14,001 LBS GVWR6$220,284.001$36,714.00
79CCab & Chassis (4x4)4X4 CAB AND CHASSIS, EXTENDED CAB, MIN 10,001 LBS GVWR6$212,712.004$141,808.00
79DCab & Chassis (4x4)4X4 CAB AND CHASSIS, CREW CAB, MIN 14,001 LBS GVWR70$2,904,720.002$82,992.00
79ECab & Chassis (4x4)4X4 CAB AND CHASSIS, CREW CAB, MIN 10,001 LBS GVWR35$1,268,540.001$36,244.00
79FCab & Chassis (4x4)4X4 CAB AND CHASSIS, REGULAR CAB, MIN 16,001 LBS GVWR5$188,640.001$37,728.00
79GCab & Chassis (4x4)4X4 CAB AND CHASSIS, CREW CAB, MIN 16,001 LBS GVWR100$4,250,000.0028$1,190,000.00
79HCab & Chassis (4x4)4X4 CAB AND CHASSIS, EXTENDED CAB, MIN. 14,001 LBS GVWR16$651,312.002$81,414.00
79JCab & Chassis (4x4)4X4 CAB AND CHASSIS, EXTENDED CAB, MIN. 16,001 LBS GVWR15$625,680.004$166,848.00
82Utility Trucks (4x2)4X2 UTILITY SERVICE, REGULAR CAB, MIN 8000 LBS GVWR517$16,834,037.00472$15,368,792.00
82CUtility Trucks (4x2)4X2 UTILITY SERVICE, EXTENDED CAB, MIN 8000 LBS GVWR131$4,598,100.00101$3,545,100.00
83Utility Trucks (4x2)4X2 UTILITY SERVICE, REGULAR CAB, 10,001 - 12,000 LBS GVWR62$2,075,078.0060$2,008,140.00
83CUtility Trucks (4x2)4X2 UTILITY SERVICE, EXT CAB, 10,001 - 12,000 LBS GVWR50$1,862,750.0046$1,713,730.00
84Utility Trucks (4x2)4X2 UTILITY SERVICE, REGULAR CAB, MIN 10,001 LBS GVWR47$1,746,661.0033$1,226,379.00
84BUtility Trucks (4x2)4X2 UTILITY SERVICE, REGULAR CAB, MIN 14,001 LBS GVWR5$205,370.004$164,296.00
84CUtility Trucks (4x2)4X2 UTILITY SERVICE, EXTENDED CAB, MIN 10,001 LBS GVWR13$510,380.0011$431,860.00
84DUtility Trucks (4x2)4X2 UTILITY SERVICE, REGULAR CAB, MIN 16,001 LBS GVWR2$84,170.002$84,170.00
84HUtility Trucks (4x2)4X2 UTILITY SERVICE, EXTENDED CAB, MIN. 14,001 LBS GVWR2$89,052.002$89,052.00
84JUtility Trucks (4x2)4X2 UTILITY SERVICE, EXTENDED CAB, MIN. 16,001 LBS GVWR3$136,614.003$136,614.00
87Utility Trucks (4x4)4X4 UTILITY SERVICE, REGULAR CAB, MIN 8000 LBS GVWR165$5,850,900.00127$4,503,420.00
87CUtility Trucks (4x4)4X4 UTILITY SERVICE, EXTENDED CAB, MIN 8000 LBS GVWR245$9,388,155.00193$7,395,567.00
88Utility Trucks (4x4)4X4 UTILITY SERVICE, REGULAR CAB, 10,001 - 12,000 LBS GVWR62$2,249,608.0043$1,560,212.00
88CUtility Trucks (4x4)4X4 UTILITY SERVICE, EXTENDED CAB, 10,001 - 12,000 LBS GVWR122$4,786,914.0071$2,785,827.00
89AUtility Trucks (4x4)4X4 UTILITY SERVICE, REGULAR CAB, MIN 10,001 LBS GVWR96$3,903,072.0057$2,317,449.00
89BUtility Trucks (4x4)4X4 UTILITY SERVICE, REGULAR CAB, MIN 14,001 LBS GVWR6$266,142.004$177,428.00
89CUtility Trucks (4x4)4X4 UTILITY SERVICE, EXTENDED CAB, MIN 10,001 LBS GVWR64$2,757,824.0043$1,852,913.00
89DUtility Trucks (4x4)4X4 UTILITY SERVICE, REGULAR CAB, MIN 16,001 GVWR6$272,250.005$226,875.00
89HUtility Trucks (4x4)4X4 UTILITY SERVICE, EXTENDED CAB, MIN. 14,001 LBS GVWR5$241,815.005$241,815.00
89JUtility Trucks (4x4)4X4 UTILITY SERVICE, EXTENDED CAB, MIN. 16,001 LBS GVWR16$789,920.0013$641,810.00
92Cargo-Vans4X2 CUTAWAY DRY CARGO VAN, 10,000 and Under LBS GVWR7$241,374.007$241,374.00
94Cargo-Vans4X2 CUTAWAY DRY CARGO VAN, MIN 10,001 LBS GVWR33$1,240,668.0032$1,203,072.00
94BCargo-Vans4X2 CUTAWAY DRY CARGO VAN, MIN 14,001 LBS GVWR16$686,832.0014$600,978.00
95Cargo-Vans4X2 REGULAR CAB DRY CARGO VAN, MIN 10,001 LBS GVWR4$161,200.004$161,200.00
95BCargo-Vans4X2 REGULAR CAB DRY CARGO VAN, MIN 14,001 LBS GVWR5$282,565.005$282,565.00
95CCargo-Vans4X2 REGULAR CAB DRY CARGO VAN, MIN 16,001 LBS GVWR9$503,973.005$279,985.00
95ECargo-Vans4X2 DRY CARGO VAN, 8000 -19,500 LBS GVWR, ELECTRIC1$56,125.000$0.00
122Stake Bed Trucks (4x2)4X2 STAKE BED TRUCK, REGULAR CAB, MIN 8,000 LBS GVWR103$3,116,368.0087$2,632,272.00
122CStake Bed Trucks (4x2)4X2 STAKE BED TRUCK, EXTENDED CAB, MIN 8000 LBS GVWR6$193,662.005$161,385.00
122EStake Bed Trucks (4x2)4X2 STAKE BED TRUCK, CREW CAB, MIN 8000 LBS GVWR8$271,592.007$237,643.00
123Stake Bed Trucks (4x2)4X2 STAKE BED TRUCK, REGULAR CAB, 10,001 - 12,000 LBS GVWR36$1,122,264.0036$1,122,264.00
123CStake Bed Trucks (4x2)4X2 STAKE BED TRUCK, EXTENDED CAB, 10,001 - 12,000 LBS GVWR4$139,840.003$104,880.00
123EStake Bed Trucks (4x2)4X2 STAKE BED TRUCK, CREW CAB, 10,001 - 12,000 LBS GVWR6$209,256.005$174,380.00
124Stake Bed Trucks (4x2)4X2 STAKE BED TRUCK, REGULAR CAB, MIN 10,001160$5,422,400.00145$4,914,050.00
124BStake Bed Trucks (4x2)4X2 STAKE BED TRUCK, REGULAR CAB, MIN 14,00114$529,214.0011$415,811.00
124CStake Bed Trucks (4x2)4X2 STAKE BED TRUCK, EXTENDED CAB, MIN 10,001 LBS GVWR17$611,762.0017$611,762.00
124DStake Bed Trucks (4x2)4X2 STAKE BED TRUCK, REGULAR CAB, MIN 16,001 LBS GVWR4$155,248.004$155,248.00
124EStake Bed Trucks (4x2)4X2 STAKE BED TRUCK, CREW CAB, MIN 10,001 LBS GVWR20$729,500.0018$656,550.00
124FStake Bed Trucks (4x2)4X2 STAKE BED TRUCK, CREW CAB, MIN 14,001 LBS GVWR9$378,351.009$378,351.00
124GStake Bed Trucks (4x2)4X2 STAKE BED TRUCK, CREW CAB, MIN 16,001 LBS GVWR3$129,150.002$86,100.00
124HStake Bed Trucks (4x2)4X2 STAKE BED TRUCK, EXTENDED CAB, MIN. 14,001 LBS GVWR2$82,504.000$0.00
124JStake Bed Trucks (4x2)4X2 STAKE BED TRUCK, EXTENDED CAB, MIN. 16,001 LBS GVWR1$42,387.000$0.00
128Stake Bed Trucks (4x4)4X4 STAKE BED TRUCK, REGULAR CAB, 10,001 - 12,000 LBS GVWR23$776,756.0016$540,352.00
128CStake Bed Trucks (4x4)4X4 STAKE BED TRUCK, EXTENDED CAB, 10,001 - 12,000 LBS GVWR21$771,225.0015$550,875.00
128EStake Bed Trucks (4x4)4X4 STAKE BED TRUCK, CREW CAB, 10,001 - 12,000 LBS GVWR24$906,816.0016$604,544.00
129Stake Bed Trucks (4x4)4X4 STAKE BED TRUCK, REGULAR CAB, MIN 10,001 LBS GVWR37$1,375,512.0029$1,078,104.00
129AStake Bed Trucks (4x4)4X4 STAKE BED TRUCK, REGULAR CAB, MIN 14,001 LBS GVWR7$286,132.006$245,256.00
129BStake Bed Trucks (4x4)4X4 STAKE BED TRUCK, REGULAR CAB, MIN 16,001 LBS GVWR12$502,728.009$377,046.00
129CStake Bed Trucks (4x4)4X4 STAKE BED TRUCK, EXTENDED CAB, MIN 10,001 LBS GVWR11$435,710.006$237,660.00
129DStake Bed Trucks (4x4)4X4 STAKE BED TRUCK, CREW CAB, MIN 10,001 LBS GVWR32$1,292,960.0023$929,315.00
129EStake Bed Trucks (4x4)4X4 STAKE BED TRUCK, CREW CAB, MIN 14,001 LBS GVWR19$867,768.0018$822,096.00
129FStake Bed Trucks (4x4)4X4 STAKE BED TRUCK, CREW CAB, MIN 16,001 LBS GVWR50$2,333,950.0017$793,543.00
129HStake Bed Trucks (4x4)4X4 STAKE BED TRUCK, EXTENDED CAB, MIN. 14,001 LBS GVWR11$493,702.007$314,174.00
129JStake Bed Trucks (4x4)4X4 STAKE BED TRUCK, EXTENDED CAB, MIN. 16,001 LBS GVWR6$275,334.002$91,778.00
134Cargo-Vans4X2 MULTISTOP VAN, MIN 10,001 LBS GVWR86$4,776,010.0075$4,165,125.00
134BCargo-Vans4X2 MULTISTOP VAN, MIN 14,001 LBS GVWR34$1,993,046.0033$1,934,427.00
134FCargo-Vans4X2 MULTISTOP VAN, MIN 16,001 LBS GVWR5$307,390.001$61,478.00
141Utility Trucks (4x2)4X2 UTILITY SERVICE, CREW CAB, MIN 8000 LBS GVWR127$4,604,258.00121$4,386,734.00
142Utility Trucks (4x2)4X2 UTILITY SERVICE, CREW CAB, 10,001 - 12,000 LBS GVWR26$966,706.0023$855,163.00
144Utility Trucks (4x2)4X2 UTILITY SERVICE, CREW CAB, MIN 10,001 LBS GVWR37$1,470,713.0028$1,112,972.00
144AUtility Trucks (4x2)4X2 UTILITY SERVICE, CREW CAB, MIN 14,001 LBS GVWR11$498,443.0011$498,443.00
144BUtility Trucks (4x2)4X2 UTILITY SERVICE, CREW CAB, MIN 16,001 LBS GVWR1$46,324.000$0.00
146Utility Trucks (4x4)4X4 UTILITY SERVICE, CREW CAB, MIN 8,000 LBS GVWR208$8,212,048.00172$6,790,732.00
147Utility Trucks (4x4)4X4 UTILITY SERVICE, CREW CAB, 10,001 - 12,000 LBS GVWR205$8,260,680.00105$4,231,080.00
149Utility Trucks (4x4)4X4 UTILITY SERVICE, CREW CAB, MIN 10,001 LBS GVWR94$4,125,284.0067$2,940,362.00
149AUtility Trucks (4x4)4X4 UTILITY SERVICE, CREW CAB, MIN 14,001 LBS GVWR30$1,474,590.0016$786,448.00
149BUtility Trucks (4x4)4X4 UTILITY SERVICE, CREW CAB, MIN 16,001 LBS GVWR45$2,257,200.0029$1,454,640.00
154Dump Trucks (4x2)4X2 DUMP TRUCK, REGULAR CAB. MIN 10,001 LBS GVWR1$46,622.000$0.00
154BDump Trucks (4x2)4X2 DUMP TRUCK, REGULAR CAB, MIN 14,001 LBS GVWR1$60,847.001$60,847.00
154HDump Trucks (4x2)4X2 DUMP TRUCK, REGULAR CAB, MIN 16,001 LBS GVWR2$118,364.002$118,364.00
159Dump Trucks (4x4)4X4 DUMP TRUCK, REGULAR CAB, MIN 10,001 LBS GVWR31$1,382,414.0020$891,880.00
159ADump Trucks (4x4)4X4 DUMP TRUCK, REGULAR CAB, MIN 14,001 LBS GVWR13$644,124.009$445,932.00
159HDump Trucks (4x4)4X4 DUMP TRUCK, REGULAR CAB, MIN 16,001 LBS GVWR14$707,910.004$202,260.00
162Cargo-Vans4X2 PANEL VAN, MAINTEN. CONVERSION, 10,000 and U LBS GVWR276$7,789,272.00165$4,656,630.00
162ECargo-VansPANEL VAN, MAINTEN. CONVERSION, ELECTRIC1$48,893.000$0.00
Totals3,934$148,381,454.002,822$105,559,795.00
All estimated quantities and dollar values are based on the last full-year ordering cycle (FY21). All Fleet Quantities and Values are a subset of the Total Quantity and Values.
Estimates are based on FY23 projections.

ESRI_MAPINFO_SHEET

DO NOT EDIT

For Esri use only

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