Attachment F Visits 2022.xlsx
XLSX spreadsheet 21 KB Posted
- Attached to
- VENDING SERVICES (RE-BID)
- Solicitation number
- 5400026806
- Issued by
- Richland County, South Carolina
About this file
This file is a visitation analysis spreadsheet for a South Carolina vending services contract re-bid, documenting weekly visit data across 21 institutions throughout 2022. The spreadsheet provides comparative data between average weekly visits during 2018-19 and actual visits recorded during weekly sampling periods from March through November 2022, enabling prospective vendors to assess traffic patterns and demand across multiple facility locations. The institutions included range from Allendale (161 average weekly visits baseline) to Tyger River (260 average weekly visits baseline), with notable variations in visitation throughout the year. Weekend visitation totals are also tracked, ranging from 458 to 780 visits across the sampled weekends, providing insight into usage patterns that may inform staffing and inventory decisions for vending operations.
The data reveals significant fluctuations in facility usage across the year, with some institutions experiencing considerable variations between baseline 2018-19 averages and 2022 actual visits, while others maintained relatively consistent traffic levels. Notable anomalies appear in certain months for specific locations—such as zero or minimal visits recorded for Kershaw and Kirkland in July 2022, and Manning in August 2022—suggesting potential facility closures or data collection gaps. The information provides prospective bidders with critical demand forecasting data to develop realistic operational projections, staffing models, and inventory management strategies for the vending services contract, with the overall weekend visitation data showing a general upward trend from early 2022 (498 visits in March) to late 2022 (774 visits in November).
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Amendment 2.docx | DOCX document | |
| Intent to Award.pdf | ||
| Attachment A FY 22-23.xlsx | XLSX spreadsheet | |
| Attachment A FY 21-22.xlsx | XLSX spreadsheet | |
| Amendment 1.docx | DOCX document | |
| Award Extension 1.docx | DOCX document | |
| Attachment A FY 20-21.xlsx | XLSX spreadsheet | |
| FULL BID.docx | DOCX document | |
| Attachment F Visits 2023.xlsx | XLSX spreadsheet |
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
Sheet1
| VISITATION ANALYSIS | |||||||||||||||||||||
| Institution | AVG Weekly Visits 2018-19 | 3/26-27/22 | 4/2-3/22 | 4/9-10/22 | 4/23-24/22 | 7/2-3/22 | 7/9-10/22 | 7/16-17/22 | 7/23-24/22 | 7/30-31/22 | 8/6-7/22 | 8/13-14/22 | 9/3-5/22 | 9/10-11/22 | 9/17-18/22 | 9/24-25/22 | 10/8-9/22 | 10/15-15/22 | 10/22-23/22 | 11/5-6/22 | 11/12-12/22 |
| Allendale | 161 | 16 | 21 | 33 | 17 | 27 | 23 | 28 | 19 | 25 | 18 | 6 | 24 | 27 | 26 | 47 | 36 | 33 | 37 | 37 | 34 |
| Broad River | 249 | 52 | 103 | 92 | 59 | 51 | 97 | 55 | 54 | 46 | 47 | 44 | 44 | 48 | 51 | 77 | 46 | 71 | 33 | 44 | 53 |
| Evans | 148 | 29 | 47 | 42 | 35 | 34 | 39 | 31 | 18 | 23 | 29 | 24 | 32 | 33 | 51 | 40 | 41 | 33 | 36 | 41 | 45 |
| Goodman | 159 | 19 | 18 | 16 | 25 | 17 | 15 | 20 | 19 | 2 | 3 | 1 | 21 | 24 | 20 | 14 | 15 | 18 | 15 | 12 | 23 |
| Graham | 156 | 30 | 23 | 23 | 26 | 23 | 26 | 24 | 31 | 24 | 18 | 17 | 11 | 19 | 29 | 36 | 40 | 19 | 23 | 30 | 19 |
| Kershaw | 198 | 53 | 58 | 39 | 39 | 45 | 55 | 59 | 0 | 0 | 46 | 49 | 42 | 48 | 41 | 57 | 33 | 50 | 51 | 54 | 50 |
| Kirkland | 199 | 16 | 20 | 19 | 17 | 16 | 21 | 21 | 25 | 0 | 0 | 11 | 18 | 15 | 15 | 25 | 21 | 26 | 19 | 25 | 20 |
| Leath | 180 | 10 | 10 | 11 | 20 | 16 | 17 | 18 | 16 | 16 | 14 | 15 | 19 | 19 | 20 | 23 | 19 | 27 | 19 | 16 | 31 |
| Lee | 278 | 35 | 50 | 51 | 39 | 44 | 46 | 54 | 61 | 50 | 55 | 40 | 65 | 53 | 50 | 51 | 50 | 41 | 31 | 39 | 50 |
| Lieber | 190 | 22 | 43 | 39 | 0 | 26 | 28 | 24 | 44 | 52 | 49 | 42 | 27 | 26 | 44 | 36 | 63 | 41 | 50 | 41 | 47 |
| Livesay | 215 | 23 | 41 | 49 | 25 | 31 | 43 | 34 | 40 | 24 | 45 | 40 | 53 | 34 | 40 | 39 | 48 | 53 | 45 | 38 | 57 |
| MacDougall | 186 | 24 | 27 | 30 | 23 | 22 | 46 | 39 | 33 | 34 | 29 | 32 | 52 | 42 | 45 | 41 | 56 | 48 | 53 | 48 | 43 |
| Manning | 155 | 17 | 24 | 26 | 19 | 19 | 27 | 21 | 0 | 1 | 1 | 3 | 44 | 34 | 29 | 50 | 44 | 50 | 34 | 34 | 32 |
| McCormick | 172 | 18 | 20 | 30 | 29 | 30 | 27 | 35 | 32 | 33 | 16 | 26 | 31 | 32 | 37 | 42 | 43 | 42 | 42 | 34 | 41 |
| Palmer | 65 | 9 | 13 | 13 | 2 | 7 | 3 | 8 | 6 | 4 | 2 | 7 | 11 | 10 | 10 | 4 | 10 | 9 | 5 | 9 | 11 |
| Perry | 148 | 32 | 30 | 34 | 26 | 23 | 27 | 32 | 30 | 31 | 35 | 26 | 27 | 33 | 34 | 29 | 29 | 27 | 31 | 28 | 28 |
| Ridgeland | 105 | 18 | 23 | 14 | 13 | 20 | 55 | 51 | 32 | 21 | 23 | 17 | 19 | 20 | 25 | 29 | 27 | 27 | 20 | 43 | 30 |
| Trenton | 109 | 20 | 33 | 36 | 22 | 37 | 22 | 19 | 13 | 15 | 24 | 30 | 23 | 25 | 28 | 31 | 33 | 35 | 30 | 28 | 37 |
| Turbeville | 185 | 21 | 27 | 29 | 26 | 19 | 19 | 39 | 38 | 4 | 58 | 55 | 41 | 39 | 42 | 26 | 56 | 50 | 54 | 30 | 53 |
| Tyger River | 260 | 25 | 0 | 44 | 40 | 46 | 46 | 37 | 31 | 38 | 37 | 35 | 49 | 44 | 48 | 46 | 54 | 52 | 46 | 57 | 57 |
| Wateree River | 169 | 9 | 19 | 10 | 9 | 15 | 16 | 17 | 22 | 15 | 9 | 17 | 18 | 14 | 11 | 13 | 16 | 12 | 16 | 17 | 13 |
| Weekend #'s | 3687 | 498 | 650 | 680 | 511 | 568 | 698 | 666 | 564 | 458 | 558 | 487 | 671 | 639 | 696 | 756 | 780 | 764 | 690 | 705 | 774 |
File details come from the government source that posted it. Updated .