Attachment M4 - LU Orders Status Reporting Template.xlsx

This is a status reporting template for tracking light-duty vehicle orders and production progress within the GSA Fleet Vehicle Solutions Program (GFVSP).

The template is designed for vendors to report on orders across multiple vehicle line designations (LU05, LU15, LU50, LU68, LU70, LU71, LU80, LU83, LU84, LU85, LU87, and LU88). It captures order-level metrics including package number, order quantity, units received by upfitter, units completed and ready for shipment, total units shipped, and total units delivered. The vehicle status section tracks individual unit performance through the supply chain using key data points: RPN (Reference Part Number), VIN (Vehicle Identification Number), customer information, OEM designation, and critical timeline dates including scheduled production date, receipt by upfitter, completion date, inspection date, final shipment date, GSA contract shipment date, and final delivery date to customer. This template enables vendors to maintain visibility and accountability for vehicle orders from initial production through final customer delivery under the GSA contract vehicle program.