Attachment 1.xlsx

This is a sales performance spreadsheet for snack and beverage vending services in South Carolina, documenting historical sales data and commission calculations across multiple fiscal years and product categories (Pepsi and Canteen offerings).

The document presents sales figures and corresponding commissions for four fiscal year periods: July 1, 2019 through June 30, 2020; July 1, 2021 through June 30, 2022; July 1, 2022 through June 30, 2023; and July 1, 2023 through June 30, 2024. For the 2019-2020 period, total sales reached $220,154.80 with commissions of $37,395.92 applied at rates of 0.48 and 0.21. The 2021-2022 period generated $116,154.44 in sales with $24,895.09 in commissions. The 2022-2023 period showed $134,085.42 in sales with $27,456.59 in commissions, while the 2023-2024 period (estimated to year-end) projects $162,866.20 in sales with $33,174.54 in commissions. Commission rates remain consistent across all periods at 0.48 for Pepsi products and 0.21 for Canteen products, reflecting a tiered commission structure based on vendor type or product category.