Attachment G - Sample Report.xlsx

This is a sample report template in Excel format for tracking vehicle and equipment purchases under a state and local contract opportunity for truck bodies in South Carolina. The spreadsheet is designed to document transactions with Lee Transport Equipment (Vendor Contract Number 4400035733) and includes columns for vendor information, billing details, order and purchase order numbers, dates (PO/Order Date, Ship Date, Invoice Date), vehicle descriptions, quantities, pricing (Base Price, Optional Additions Cost, Optional Deductions Cost), total prices, and administrative fees.

The template contains extensive formula-based rows intended to calculate total sales and administrative fees, with a reporting period dated 3/31/25. However, the spreadsheet currently displays formula errors (#N/A) throughout most data cells and shows all monetary values at $0.00, indicating the template is incomplete and requires proper data population and formula correction before use. The document appears to be an administrative tool for tracking and reporting equipment purchases and associated costs under the South Carolina truck bodies contract, with built-in functionality for deducting optional items from base pricing.