Event Product Stock Report Overview
Parent Hub: π€ Sales, Groups & Events Reports
Category: π₯ Event Management (EventKey)
Target Roles: Catering & Event Directors, Banquet Operations Managers, Audio-Visual (AV) Supervisors, Food & Beverage Directors, Hotel Controllers, General Managers
Key Value: Monitor daily and rolling event product inventory, track physical equipment and catering consumption, prevent overbooking and equipment stockouts, audit inventory replenishment, and identify negative stock deficits before event execution.
Date Parameter: Date Range Selector (Start & End) | Past & Future | Maximum Window: 731 Days
Executive Summary
The Event Product Stock Report is a critical operational logistics, equipment resource allocation, and inventory management document within the π₯ Event Management (EventKey) category of the π€ Sales, Groups & Events Reports hub. Designed to deliver complete real-time visibility over catering assets, rental equipment, audio-visual technology, and perishable banquet goods, it tracks item availability, consumption velocity, and replenishment flows across specified date windows.
-
By organizing inventory tracking into 2 defined report sections: Event Product Stock Daily and Event Product Stock Rolling, this report enables banquet leads, AV coordinators, and event operations managers to evaluate fixed daily rental asset utilization (
Event Product Stock Daily) alongside continuous perishable replenishment models (Event Product Stock Rolling). It correlates inventory item descriptions (Product Name,Product Category,Product Type) and calendar schedules (Date) with stock levels (Initial Stock,Consumed Stock,Available Stock,Added,Expired,Current Available,Current Consumption) and event demand density (Sub Event Count) to prevent equipment shortages, manage third-party cross-rentals, and ensure operational readiness across all function spaces.
Key Capabilities
-
Two-Section Asset Management Structure: Separates daily recurring rental equipment tracking (
Event Product Stock Daily) from perpetual rolling inventory models (Event Product Stock Rolling). -
Real-Time Stock Deficit & Overbooking Alerts: Dynamically computes available inventory balances (
Available Stock,Current Available) to highlight over-allocated assets (negative stock balances) where event requirements exceed on-hand inventory. -
Multi-Departmental Resource Tracking: Consolidates banquet furniture, audio-visual gear, staging items, and catering ingredients into unified operational categories (
Product Category,Product Type, e.g.,DAILY_RENTAL,PERISHABLE). -
Perishable Item & Waste Control: Monitors rolling replenishment (
Added) and product spoilage write-offs (Expired) to reduce food waste and optimize ordering cycles. -
Event Function Density Correlation: Maps product consumption directly to active sub-event function volumes (
Sub Event Count) to audit resource utilization per function room.
Report Views & Functional Breakdown
The Event Product Stock Report presents event inventory and resource allocation data across 2 defined sections:
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β EVENT PRODUCT STOCK REPORT β
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€
β 2 Defined Report Sections β
ββββββββββββββββββββββββββββ¬ββββββββββββββββββββββββββββββββββββββββββββββ€
β 1. Event Product Stock β 2. Event Product Stock Rolling β
β Daily (Rental Assets) β (Continuous Inventory & Perishables) β
ββββββββββββββββββββββββββββ΄ββββββββββββββββββββββββββββββββββββββββββββββ
1. Event Product Stock Daily Section (Rental Assets)
Monitors daily fixed-quantity assets and equipment rentalsβsuch as wireless microphones, projectors, banquet chairs, and podiumsβthat reset on a daily operational cycle.
-
Primary Use: Verifying daily equipment availability, auditing AV gear allocations, identifying equipment overbookings (e.g., negative
Available Stock), and sourcing cross-rentals in advance. -
Key Metrics: Date, Product Name, Product Category, Initial Stock, Consumed Stock, Available Stock, Sub Event Count, Product Type.
2. Event Product Stock Rolling Section (Continuous Inventory & Perishables)
Tracks continuous inventory items, catering supplies, and perishable banquet goods that roll forward across days rather than resetting daily.
-
Primary Use: Managing banquet food and beverage inventory, tracking stock additions and expirations, and ensuring sufficient pars for multi-day catered events.
-
Key Metrics: Date, Product Name, Product Category, Product Type, Added, Expired, Initial Stock, Consumed Stock, Current Available, Current Consumption, Sub Event Count.
Data Dictionary (Dynamic View Columns)
Customize your default view using the Configure (βοΈ) icon on the report page. Below is the full data dictionary representing all 12 exact dynamic columns available across the 2 report sections, sorted in alphabetical order by column name:
π¦ Inventory Allocation Logic:
Available Stockin Section 1 is dynamically calculated as Initial Stock - Consumed Stock. A negative value indicates that contracted event demand exceeds on-hand property inventory, necessitating sub-rentals or inventory reallocations. In Section 2,Current Availablereflects rolling stock after factoring in Added - Expired - Current Consumption.
|
Column Name |
Section Applicability |
Description |
Data Source / System Mapping |
Includes Taxes & Fees? |
|
Added |
Section 2 |
Quantity of new inventory or restocked product units added to rolling stock on the specified date. |
Inventory Ledger > Restock Quantity |
N/A |
|
Available Stock |
Section 1 |
Net remaining physical units of the product available for allocation on the target date (Initial Stock - Consumed Stock). |
Calculated: Net Available Balance |
N/A |
|
Consumed Stock |
Both Sections |
Count of product units allocated, reserved, or consumed across event functions on the specified date. |
Event BEO Engine > Allocated Quantity |
N/A |
|
Current Available |
Section 2 |
Real-time rolling available inventory units remaining after accounting for additions, expirations, and consumption. |
Inventory Ledger > Rolling Available |
N/A |
|
Current Consumption |
Section 2 |
Count of product units consumed during the active operational period under the rolling inventory model. |
Event BEO Engine > Active Consumption |
N/A |
|
Date |
Both Sections |
Calendar date for which product inventory availability, consumption, and event allocations are tracked. |
Event Calendar > Execution Date |
N/A |
|
Expired |
Section 2 |
Quantity of perishable product units written off or removed due to expiration on the specified date. |
Inventory Ledger > Spoilage / Expired |
N/A |
|
Initial Stock |
Both Sections |
Baseline opening stock quantity of the product available at the start of the date or inventory cycle. |
Inventory Master > Base Quantity |
N/A |
|
Product Category |
Both Sections |
Operational categorization or department grouping assigned to the product (e.g., |
Product Master > Category Code |
N/A |
|
Product Name |
Both Sections |
Descriptive title or commercial name of the inventory item or equipment (e.g., |
Product Master > Item Description |
N/A |
|
Product Type |
Both Sections |
Inventory classification governing stock tracking and replenishment rules (e.g., |
Product Master > Item Type |
N/A |
|
Sub Event Count |
Both Sections |
Numerical count of event sessions or sub-event functions utilizing the product on the target date. |
Event Schedule > Function Demand Count |
N/A |
Customization & Platform Features
User & Property Preferences
-
Personal Preference: Tailor your individual view by hiding or dragging columns. Your preferences save automatically for future sessions.
-
Property Defaults: System Admins can configure standard default layouts across all property users to streamline operational reporting. To maximize audit efficiency, group the columns into the below logical blocks:
-
Section 1: Event Product Stock Daily
-
Calendar Anchor & Product Identification (Cols 1β3):
Date|Product Name|Product Category -
Inventory Balance & Consumption KPIs (Cols 4β6):
Available Stock|Initial Stock|Consumed Stock -
Product Classification & Event Demand (Cols 7β8):
Product Type|Sub Event Count
-
-
Section 2: Event Product Stock Rolling
-
Calendar Anchor & Product Identification (Cols 1β3):
Date|Product Name|Product Category -
Current Stock Balances & Real-Time Consumption (Cols 4β5):
Current Available|Current Consumption -
Baseline Stock Levels & Cumulative Deductions (Cols 6β7):
Initial Stock|Consumed Stock -
Inventory Adjustments & Spoilage Tracking (Cols 8β9):
Added|Expired -
Product Classification & Event Demand (Cols 10β11):
Product Type|Sub Event Count
-
-
Report Toolbar & Quick Actions
Use the top-right toolbar icons on the report page to manage and export your data view:
|
Icon |
Action / Feature |
Description |
|
Knowledge Article |
Opens the knowledge base article to learn how to interpret this report. |
|
Saved Views |
Saves your column filtering, sorting, and highlight preferences so you can easily reload your custom view later without reconfiguring the report. |
|
Filter |
Opens filter controls to isolate specific data within a column based on your selected criteria. |
|
Highlight |
Highlights column values in a designated color based on selected conditions. |
|
Export |
Exports and downloads the report in various formats (Excel, PDF, CSV) for offline analysis or printing. |
|
Configure |
Opens column selection controls to toggle visibility, reorder columns, or hide rows with all zeros. |
|
Additional Configuration |
Provides advanced report configuration and display formatting options to customize data presentation. |
Advanced Controls
-
Pre-Event Shortage Audits: Filter Section 1 by
Available Stock < 0for upcoming dates to identify required cross-rentals (e.g., microphones, projectors) before function arrival. -
Perishable Stock Monitoring: Review Section 2
ExpiredandCurrent Availableto evaluate banquet food par levels and prevent over-ordering. -
Highlighting (Conditional Formatting): Apply custom rules to automatically highlight negative available stock (
Available Stock < 0), fully utilized assets (Available Stock = 0), or items tied to multiple simultaneous functions (Sub Event Count > 2).
π Related Reports & Next Steps
Within π€ Sales, Groups & Events Reports & π₯ Event Management (EventKey):
-
All Events Report β Two-section master event summary and sub-event execution log.
-
Event Books Report β Three-section catering sales audit tracking status-based yields, sub-event revenues, and attached room blocks.
-
Event Covers Report β Three-section catering attendance and cover revenue audit report.
-
Event Contracts Report β Event contract and BEO signature workflow tracking report.
-
Event Inquiry Source Report β Inbound lead inquiry source channel performance and conversion audit report.
-
Event Pace Report β Two-section commercial pace and pickup tracking report.
Cross-Pillar Deep Dives:
-
π§Ή Rooms & Facilities: Cross-reference banquet furniture inventory (
Stackable Banquet Chair) with Facilities Maintenance and Room Setup logs to ensure equipment repairs and routine cleanings are completed. -
π Financial & Cost Accounting: Reconcile consumable product usage (
Current Consumption) and spoilage write-offs (Expired) with monthly Food & Beverage inventory valuation and Cost of Goods Sold (COGS) reports.