B08_Attachment_3_Appendix_1-_Sample_Spreadsheet.xlsx

This file is a sample spreadsheet template for tracking permit sales and revenues related to Imperial Sand Dunes Recreation Area (ISDRA) fee collection services. The spreadsheet is designed to capture sales data across multiple distribution channels including online sales through ISDpermits.com, on-site sales at the Sand Sports Super Show, off-site local store sales, and sales at ranger stations (Cahuilla and Buttercup). The template organizes data by month from September 2019 through April 2020, tracking both season permits and week permits with corresponding unit sales, BLM revenues, online commissions, and local store revenues.

The spreadsheet includes consolidated reporting sections that summarize on-site versus off-site permit sales, season versus weekly permit comparisons, and total revenue calculations. It calculates payments to UPC (the permit vendor) at $9.00 per unit and tracks vendor on-hand inventory levels for local store locations. The template contains pivot chart areas for visualizing season permit and week permit sales trends across the tracking period. All data cells are currently populated with zeros, indicating this is a blank template awaiting actual sales data entry from the contracting organization managing ISDRA permit sales and fee collection operations.