jagomart
digital resources
picture1_Roi Calculator Excel Template 43225 | Smm Roi Calculator


 239x       Filetype XLSX       File size 0.52 MB       Source: www.cvent.com


File: Roi Calculator Excel Template 43225 | Smm Roi Calculator
sheet 1 calculator cvent roi calculator instructionschoose if you are basing your calculation on company revenue or company transient t amp e spend initial assumptions if corporate revenue1 type quot ...

icon picture XLSX Filetype Excel XLSX | Posted on 16 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Calculator

Cvent ROI Calculator


Instructions:
Choose if you are basing your calculation on company revenue or company transient T&E spend








Initial Assumptions If Corporate Revenue:
1. Type "Revenue" in A4
2. Input Annual Corporate Revenue in cells C5 - E5
3. Chose industry from drop down box in cell B6
4. Insert Total Annual Meetings in cell C11
5. Potential Savings per year automatically calculates in Row 65
6. Insert Annual cost of Cvent in line 77
7. Technology ROI will calculate in Row 80
If Company Transient T&E Spend:
1. Type "Spend" in A4
2. Insert annual T&E spend in cell C7, if available
3. Insert Total Annual Meetings in cell C11
4. Insert Total Cost of Cvent Meetings Management Technology in cell C77
5. Potential Savings per year automatically calculates in Row 65
6. Insert Annual cost of Cvent in line 77
7. Technology ROI will calculate in Row 80
revenue Corporate Budget - Overall Year 1 Year 2 Year 3


Annual Corporate Revenues - U.S.





Financial Services - 3.9% $0 $0 $0


Annual Transient T&E Spend - U.S.





Spend Data Year 1 Year 2 Year 3


Annual Meeting Spend $0 $0 $0


Meetings Data





Estimated Annual Meetings





Estimated Annual Meeting Attendees 0 0 0









Annual Adoption Rate 25% 50% 75%


Managed Spend (based on adoption rate) $0 $0 $0
















Likely Benchmark Savings Over a Three Year Period









Value Drivers - Likely Benefits












Create Efficiencies Through Automating Manual Processes
Average Savings/Benefit




Year 1 Year 2 Year 3


TOTAL Annual Benefit $0 $0 $0









Sourcing/Procurement
Average Savings/Benefit




Year 1 Year 2 Year 3


TOTAL Annual Benefit $0 $0 $0









Enhanced Visibility and Controls
Intangible Benefits




Year 1 Year 2 Year 3


TOTAL Annual Benefit $0 $0 $0









Increase in Compliance / Reduction in Risk
Average Savings/Benefit




Year 1 Year 2 Year 3


TOTAL Annual Benefit $0 $0 $0
















TOTAL SOLUTION VALUE $0 $0 $0
















ROI ANALYSIS












Cvent Platform Costs






Year 1 Year 2 Year 3


TOTAL Cost - Cvent Meetings Management Technology Solution













Year 1 Year 2 Year 3


Net Return on Investment $0 $0 $0


ROI as a % of Total Cost for Technology #DIV/0! #DIV/0! #DIV/0!


Sheet 2: Additional Resources
Additional Resources
Full SMM Starter Kit Package
Making the Case for Meetings Management eBook
Meeting Policy Template
Meetings Management Business Case Template
Presentation Template
Meeting Communication Policy Template

Sheet 3: Detailed Items into Savings
Create Efficiencies Through Automating Manual Processes
Create electronic RFP's; identify appropriate properties/suppliers in one place; compare costs of multiple destinations; RFP responses populate into a side by side comparison; ability to attach Terms & Conditions to the RFP to reduce time spent in legal review
Registration Websites - automating attendee registration and speaker management processes and event reporting
Reduced time spent on budgets and reconciliation though Cvent's budget tool and integration capabilities with Concur. Ability to easily forecast meeting costs.
Manage attendee invitation and response activities, ongoing communications and reminders
Reduction in onsite staff through self service onsite kiosk for attendee check-in, badges and payments
Deploying Crowd Compass mobile apps at events
Online booking tool integration for travel management. Seamless interface for attendees (register for meeting and book travel at one time. Ability to manage Arrival and Departures through booking tool vs. Arrival/Departure dates from hotel.

Sourcing/Procurement
Supplier consolidation through enablement of a preferred supplier program; ability to prioritize preferred suppliers in Supplier Network database
Strategic Hotel Sourcing; negotiated savings from "first rate quoted"
Ability to attach standard Terms & Conditions to RFP's; Ability to compare historical rates at venues previously sourced
Re-use of cancelled space credits
Manage attendee room block for attrition purposes
Rebates related to implementation of CV Meeting Card

Enhanced Visibility and Controls

Approval routing to reduce the likelihood of cancelled meetings and ensure a budget has been established
Cost savings from reduction in number of annual meetings (due to approvals, ability to identify any overlap, cancelled meetings due to calendar conflicts) and visibility to cancelled meetings and reuse of space)
Real-time visibility into spend and reduce budget overuns.
Implementation of meeting policies
Report on key metrics at the end of each meeting and key meeting data at the end of each month, year, etc.

Increase in Compliance / Reduction in Risk
Preferred suppliers helps to eliminate conflicts of interest by driving site selection to preferred suppliers
Proactive regulatory compliance
Adherance to Personally Identifiable Information regulations.
Visibility of attendee location to Risk Management group enables the ability to quickly identify the location of all meeting attendees - Global Duty of Care compliance
Reduction in cancellation and attrition penalties due to standard contract Terms & Conditions
Store and retain contracts; locate contracts for audit purposes
Compliance to document retention policies
Adequate insurance coverage in place due to visibility to meetings

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet calculator cvent roi instructionschoose if you are basing your calculation on company revenue or transient t amp e spend initial assumptions corporate type quot in a input annual cells c chose industry from drop down box cell b insert total meetings potential savings per year automatically calculates row cost of line technology will calculate available management budget overall revenues us financial services data meeting estimated attendees adoption rate managed based likely benchmark over three period value drivers benefits create efficiencies through automating manual processes average savingsbenefit benefit sourcingprocurement enhanced visibility and controls intangible increase compliance reduction risk solution analysis platform costs net return investment as for div additional resources full smm starter kit package making the case ebook policy template business presentation communication detailed items into electronic rfp s identify appropriate propertiessuppliers one place...

no reviews yet
Please Login to review.