Appendix C, Report.xlsx
XLSX spreadsheet 12 KB Posted
- Attached to
- Recreational Management System
- Solicitation number
- 198
- Issued by
- Ada County, Idaho
About this file
The document appears to be a report detailing the requirements for reports and data analysis capabilities within a Recreational Management System for the Idaho Department of Parks and Recreation (IDPR). The system must have the ability to generate various types of reports, including financial, operational, and statistical reports, as well as reports on reservations, occupancy, camper activity, availability, unconfirmed orders, fee adjustments, closures, demographics, park visitation, and point-of-sale (POS) data. The system must also have the ability to generate ad-hoc reports and allow users to select specific data elements to include in the reports. The reports must be available in multiple formats, including PDF and Excel, and must be accessible online or through email.
The state and local contract opportunity related to this document is for a Recreational Management System that will be used by the IDPR, its partners, and customers. The system must utilize a single central database operating in real-time and accessed through secure web-based interfaces. The contract opportunity does not provide details on the specific quantities, response dates, award dates, or contract term.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Appendix E Performance Metrics.xlsx | XLSX spreadsheet | |
| Insurance Requirements 2023.docx | DOCX document | |
| Event 104 Administration Document.docx | DOCX document | |
| amendment acknowledge.docx | DOCX document | |
| ITB_Event 105 ITS Peripherals and Optics.docx | DOCX document | |
| Attachment 4 Lease agreement.docx | DOCX document | |
| ITB_Attachment 2-Bid Schedule.docx | DOCX document | |
| Signature Page ITB RFP August 2020.pdf | ||
| Standard Terms and Conditions_May 2021.pdf | ||
| Insurance Requirements.docx | DOCX document | |
| RFP Event 198 Administrative Document Amended 2.docx | DOCX document | |
| Signature+Page.pdf | ||
| solicitation_instructions Jan 2017.pdf | ||
| Signature-Page-ITB-RFP-1.pdf | ||
| solicitation_instructions+Jan+2017.pdf | ||
| FY24 Peripherals and Optics Contract BID.xlsx | XLSX spreadsheet | |
| Standard-Terms-and-Conditions_May-2021.pdf |
Show all 17
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
Reports
| Report Requirements | |
| ALL REPORTS MUST HAVE ABILITY TO RUN AS PDF OR EXCEL FILE. ALL REPORTSD MUST HAVE ABILITY TO BE EMAILED OR RUN ONLINE. ALL REPORTS MUST HAVE ABILITY TO RUN FOR VARIOUS TIME FRAMES WITHIN A 366 DAY PERIOD. | |
| Reports | Comment |
| Reports must be role driven. Examples: Financial, Operational, Statistical, etc.. | |
| System must allow ad Hoc reporting capabilities. System must allow the ability to pick every piece of information to report on for each function of the system. | |
| In addition to ad Hoc reports, the vendor is encouraged to have preset reports. | |
| Reservation methods report. Report needs to show the number of orders and nights made through the website, call center and field. Report must be able to be ran by order date or date of arrival. It must also have the ability to run by park, region or statewide and have the ability to display residency totals (nonresident/resident). | |
| Occupancy reports for park, region, or statewide, by site types, by individual sites, by customer type (break out for standard customer vs. customers who receive a pass), residency, and by discount type. must have ability to sort by camground/loop. must take into account any site closures. | |
| Camper Report/Daily Arrival Report. Needs to have the ability to be organized by loop then site. must have the ability to include all site (including available sites) or just occupied/reserved sites. If a park has multiple loops, the park needs the ability to have all loops or individual loops. must include all reservations (incoming, occupied, outgoing). must have ability to include: arrival/departure date, # of occupants, passes/discounts applied, camping units/equiptment, notes, etc. | |
| Reservation report must be available by park or statewide for a specified time that includes when reservation was made, arrival and departure dates, number of nights booked. Pass or discounts applied. must also show status of reservations (active, canceled, pending or no show). | |
| Availability report must be in a grid format that shows two weeks availability within a specified start date. Must be able to select the entire park, loop or site type. | |
| Unconfirmed Orders/Balance Due Report. Shows customers and orders with outstanding balances. Report must be by individual sales location, grouped by slaes channel, region, statewide, etc. Permission based. | |
| Fee adjustment detailed and/or summary report must be able to be ran by individual sales location, grouped by sales channel, region, statewide, etc. Report must be for all or specific product type, reservation, etc. | |
| Closure report must be ran a park level that shows details of closures for a specific point of time. | |
| Demographic reports must be able to be ran by park or statewide. Must show number of visitors by state, country or Provence, city, zip code. Must be by arrival date or order date for a specific date range. Must show sales channel (Web, Call Center and Field), Total orders, number of nights, average number of nights per order, number of occupants per order. | |
| Daily/Weekly park visitation report shows the number of people on site per day by site type and show number of resident vs nonresidents. must have ability to sort/select by site type. | |
| After hours availability report by park for a specific date showing entire park or specific loop, by all site types or specific site type, by site status of available or unavailable. | |
| Park profile report must be able to be ran for a specific period of time. This report must run an Excel file that shows the details for each site or facility. | |
| Tax detail or summary report must be ran for all or individual sales channels for a specified date of time. | |
| Voucher balance and/or utilization report must ran for an individual park or statewide by voucher owner or issue date. must show customer, reservation number and sales channel voucher was created. | |
| Park revenue report must be ran for an individual park or statewide for a specific date range that can include or exclude adjustments, ability to show payment types, collection locations (all or individual locations), can include or exclude vendor fees, includes or excluded non depositables, may or may not include deferred items, may or may not include park totals, may or may not include station, may or may not include revenue type and revenue account codes. | |
| POS Best and Worst Sellers report must be ran for an individual park or statewide for a specified date or range, by product class, product group or subgroup. | |
| POS Product summary report must be able to be ran for an individual park or statewide for a specific date and/or time. must report by facility or operator and show total quantities sold by product group(s). | |
| POS Product detail report must be able to be ran for an individual park or statewide for a specific date and/or time. must report by facility or operator and show total quantities sold by product group(s). must include all transaction information including POS sales number. | |
| POS inventory valuation report must be ran for an individual park or statewide for a specified date range by product type. must include inventory on hand, unit cost, retail cost. | |
| POS inventory listing by individual park or statewide. must include by not limited to product name, barcode, product group, quantity on hand and supplier(s). | |
| POS sold with reservation report must report by individual park or statewide. | |
| Refund report by individual park or statewide to show what refunds need to be issued or status of refund. | |
| Event report must be able to be ran by individual park. must be filterable by event or date. must show occupants signed up for event, including balance owed (if applicable). | |
| Daily Sales Acitivity Report. Shows all registration & permit sales for specific location, grouped by region, sales channel, statewide etc. must be able to run for week/month/year. must include product type/name, sticker year, customer residency, product attribute information (vehicle type, use area, etc.) Payment type, cost - including $0 sales. Option to include system user. | |
| Monthly Distribution Reports for registration and permit sales. Summary of all funds allocated to specific accounts by product type. Detail report of all transactions including: date, sales location, product(s), sticker number(s), account info, etc. Use Area Summary showing total funds and designation counts by product type. Use Area Detail to show all transactions including: date, sales location, product(s), attribute data, etc. | |
| Invoice Reports - Monthly reports outlining sales for vendors. Including total sales, total costs, vedor fees, invoice amounts. Detailed and Summary reports. Ability to be pre-scheduled & automated. |
File details come from the government source that posted it. Updated .