0% found this document useful (0 votes)
10 views9 pages

CRM System Requirements for Resort Project

Uploaded by

huybyhoang
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
10 views9 pages

CRM System Requirements for Resort Project

Uploaded by

huybyhoang
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Software Requirement Engineering – Exercise Week 04

Group Work

Group Name:
Deadline: 11:59pm Friday 18/10/2024 – by submitting into dropbox on E-Learning system
File name format: SRE – Exercise Week 04 – Group [Link] (or .pdf)
Academic integrity: please writing each member name as mean to acknowledge that the below work is your
group’s work only.
(1) Group member 1:lê Minh Khoa
(2) Group member 2:Trần Gia Nguyên Phong
(3) Group member 3:Vũ Hoàng Huy

 The purpose of this exercise is to helps you go through all steps of requirement for gathering with the
CRM system to generate the Statement of work. A statement of work is about managing and
documenting expectations including detailed specification. From the business perspective, this will
eliminate the possibility for misalignment, ineffectiveness and aid all parties in achieving a successful
project.
 Imagine your team works that at a large resort and wants to build a CRM system to boost your sale.
The software company who will implement this CRM system has sent you a set of questions prior to
requirement discovering meeting. Answer all the below questions to help the software company to
understand more about your company and what are your needs.

1
I. SCOPE OF PROJECTS
1. UNDERSTAND BUSINESS REQUIREMENTS
a) Company Overview:
❏ Describe your business overview, revenue model.
- Our business is a large resort offering premium vacation services. We generate revenue by selling
vacation packages and additional services such as spa, dining, and entertainment.
b) STP/ Service/ Product/ Values:
❏ Who is your target customer? B2B, B2C … Segmented by Demographic
- Our target customers include both B2B and B2C, mainly families and business professionals aged
30-50.
❏ Describe more about the product you are selling, your average deal size, current number of
customers, percentage of repeated sales?
- We offer a variety of vacation packages with an average transaction value of around 5,000 USD,
currently serving about 2,000 customers, with a repeat rate of 40%.
c) End-users and related departments:
❏ Who will use this CRM system? Users by department
- The CRM will be used by the Sales, Marketing, and Customer Service departments. Specific roles
include Sales Representatives and Marketing Managers.

2. GOAL/ PAIN-POINTS AND MEASUREMENT

b) Identify and prioritize your Business Objectives:


❏ Mission Statement questions:

❏ What will your business look like in three to five years?

- In the next three to five years, our business aims to become a leading resort destination in the
region, renowned for exceptional customer service and innovative offerings. We plan to expand
our facilities, increase our market share, and enhance our digital presence to attract a broader
audience.

❏ What future customer needs do you want to satisfy?

2
We aim to satisfy future customer needs by offering personalized vacation experiences, seamless online booking
systems, and diverse recreational activities that cater to different age groups and preferences. Our focus will be on
sustainability and providing eco-friendly options to align with growing environmental concerns.

❏ Answer (Example)

c) Build and maintain long-term relationships with valuable customers by creating


personalized experiences across all touchpoints, anticipating customer needs, and
providing customized service

d) Customer loyalty is our highest priority

e) Provide the highest level of personalized service and give customers the
communication channels they want

❏ Goals questions:

❏ What does your executive team hope to get out of the CRM system?

❏ What do your managers hope to get out of the CRM system?

❏ What are the goals for your CRM end users?

❏ Examples:

f) Identify top performers/ customers


g) Centralize Lead from Omnichannel.
h) Better visibility into the pipeline
i) Increase close rate
j) Use my time wisely

k) Pain-points:
❏ Pain-points questions:
❏ What is the biggest challenge your company is currently facing?

3
❏ What does your BOD care most about?
❏ Give me some of the main reasons why you are losing deals?
❏ Answers (Sample):

❏ Need better pipeline visibility


❏ Difficult to quantify why deals are lost to key competitors
❏ Unable to track forecasted revenue from all profit cent
❏ Limited knowledge of the last time I spoke to someone — I end up repeating the
same information
❏ Didn’t follow up when promised.

Answer:
· Biggest challenge: Lack of pipeline visibility and inaccurate revenue forecasting.
· Reasons for lost deals:
· Difficulty identifying why deals are lost to competitors.
· Failure to follow up on time, resulting in lost opportunities.

3. INTEGRATION/ DATA IMPORT

❏ Integration:
❏ Integration Questions
❏ Do you have any software that you want to integrate with the CRM system?
❏ What is the structure, no of table, no of field, format, and size of the data?
❏ What is the general quality of the data? Is it accurate? Complete? Recent? Unique
or redundant?
❏ Excel / File Import:
❏ Integration Questions
❏ Do you have any excel/ svc that you want to migrate to the CRM system?
Yes, we need to integrate with:
· Hotel Management System (HMS) for booking data and customer profiles.
· Payment Gateway for seamless payment processing.
· Email Marketing Tool to manage campaigns and newsletters.
· Accounting Software to generate invoices and financial reports.

❏ What is the structure, no of table, no of field, format, and size of the data?

4
Data Structure:
· Around 5-10 tables, depending on the system (e.g., Customers, Bookings, Transactions).
· Each table contains 10-50 fields.
· Formats: SQL database, JSON from APIs, or CSV/Excel files.
· Size: Typically between 5-15 GB across systems.

❏ What is the general quality of the data? Is it accurate? Complete? Recent? Unique or
redundant?
· Accuracy: High, but may require validation.
· Completeness: Mostly complete but might need some cleanup for older records.
· Recency: Regularly updated, but historical data spans 3-5 years.
· Uniqueness: Possible redundancies, especially in customer data from different channels.

4. BUSINESS PROCESS GATHERING

The purpose of business process gathering is to ensure that the vendor and user are on the same
page. You will describe daily activities related to the current sales process of your company. This
includes steps, stages, involved departments, the person in charge, and the specific timeframe (if
any).

❏ Approach:
❏ You will walk through all of your sales cycles/ processes.
❏ For each stage, go into more detail about the activities with the following:
❏ Goal/ KPIs for each stage
❏ Data source
❏ Person/ group in charge
❏ Function/ Action
❏ Notification, reminder, alarm or validation criteria of each stage (if any)
❏ Provide some additional non-process activities (task, meeting, call) .
❏ Answer (Example):

5
l) Current sales process: Leads can come from many channels, including website,
events, Facebook, etc. Sales representative to follow-up, but there is no clear
process and the Lead be forgotten or lost. Managers can not know sales
productivity.

m) Each stage has a specific success rate (%), ex. when a new lead is captured, the
success rate equals to 10 %.

n) Lead information can be captured by Marketing Team, Sales Rep or


Receptionist, etc.

o) Need to send email to remind sales rep to follow up on a lead.

Below is an example of a sales process in the insurance area and its related activities.

p) It can be seen that at each stage, we do have many steps and it can be done based on a specific
rule-based system.

Answer:
Our sales process begins with lead generation through various channels: website, social media, and events. Leads
are handled by Sales Representatives and Marketing teams.
· Stage 1: Lead Capture
· Goal: Capture all potential leads from different channels.
· In charge: Marketing Team

6
· Function: Record leads in CRM and assign to sales reps
· Reminder: Send automated follow-up reminders to sales reps.
· Stage 2: Lead Qualification
· Goal: Identify high-potential leads.
· In charge: Sales Representatives
· Function: Qualify leads based on interest and budget.
· Stage 3: Follow-up & Conversion
· Goal: Convert leads into bookings.
· In charge: Sales Representatives
· Function: Schedule meetings, send proposals, and close deals.
· Non-process activities:
· Weekly meetings with sales managers to discuss pipeline.
· Calls and follow-up emails for hot leads.

5. REPORTS

List out the necessary reports for a typical position or department.


❏ Report questions:
❏ How do you track your lead status?
❏ What type of reports do you currently get out of the system?
❏ What reports do you use to report your management board?

❏ Answers (Sample): You can fill in the table as below.

No. Position/ Report Name


Department

1 Sales Rep - Lead status report


- Lead source report
- Pipeline/deal stage report
- Activity report
- Wins/Losses Report
- Quantity: 05

2 Sales Manager - Pipeline/deal stage report


- Revenue reports
- Accounts and Deals report
- Quantity: 03

3 Sales Director - Sales Funnel Analysis report


- Sales Forecasting report
- Sales Revenue report
- Quantity: 03

7
4 Marketing Director - Lead Source
- Deal Source
- Quantity: 02

II. PROJECT COST AND TIMELINE

1. BUDGET
a. Budget questions
❏ What is your budget for this Project?

Our budget for this Project is about 10K SGD

❏ How much do you invest for licenses? Implementation?


For a one-off implementation fee, we can spend about 2K SGD

8
b. Answer (sample)

q) Our budget for this Project is about 20K SGD


r) Currently we have 30 sales reps and 20 marketing executives plus 5 managerial
positions. So we need roughly 50 licences per year. Our budget limits at 7K SGD
per year for the licence.

s) For a one-off implementation fee, we can spend about 60K SGD.

2. TIMELINE
a. Timeline questions
❏ When would you like to start the project?

We would like to start this project as soon as possible.

❏ How much time per week can you work with us on the project?
Our team can spare sessions per week and 3 hours per session on this project.
b. Answer (sample)

t) We would like to start this project as soon as possible.


u) Our team can spare 2 sessions per week and 3 hours per session on this project.

Common questions

Powered by AI

Integrating the CRM system with existing systems such as the Hotel Management System, payment gateways, email marketing tools, and accounting software can significantly streamline business operations and improve efficiency at the resort. Such integration allows for real-time data exchange between different platforms, reducing duplication and discrepancies in customer profiles and transaction records. It enables seamless booking processes and personalized marketing campaigns, enhancing guest experiences. Efficient data management reduces manual workload, enabling staff to focus on high-value tasks. Moreover, integration with accounting and financial reporting systems ensures accurate financial tracking and improved revenue management, aligning with the resort's strategic goal of expanding its market presence and ensuring customer satisfaction .

Focusing on sustainable and eco-friendly options alongside deploying a CRM system allows the resort to tap into the growing demand for green tourism, potentially expanding its market reach and enhancing its brand reputation as an environmentally conscious destination. This focus can lead to increased customer loyalty, as modern consumers often prefer businesses that align with their values. The CRM system will enable personalized marketing of eco-friendly services and measure customer sentiment regarding sustainability initiatives, thereby refining offerings to better meet customer expectations. Together, these strategies can differentiate the resort from competitors and contribute to long-term strategic success by attracting a niche market segment interested in sustainability .

To ensure the successful implementation of the CRM system at the resort, critical integration considerations include connecting the CRM with existing systems like the Hotel Management System for customer profiles, payment gateways for transaction processing, and email marketing tools for campaign management. The data structure requires careful handling of multiple tables with different fields and formats across systems such as SQL databases, JSON from APIs, and CSV/Excel files. In terms of data quality, the CRM project must address the accuracy, completeness, and recency of data, requiring validation and potential cleanup of older records. It's important to reduce redundancies in customer data originating from various channels to maintain its uniqueness .

Integrating a CRM system can enhance customer relationship management for both B2B and B2C segments by enabling detailed tracking and analysis of customer interactions across different channels, such as digital platforms and in-resort experiences. This integration will allow the resort to offer personalized vacation experiences tailored to the preferences of families and business professionals, helping them build stronger relationships with these target demographics. For B2B clients, the CRM can streamline communication processes and manage complex accounts by ensuring timely and personalized engagement. Additionally, the CRM's ability to manage and analyze customer data will aid in the creation of customized marketing strategies and service offers, thereby enhancing overall engagement and satisfaction .

The critical challenges facing the resort's current business operations include a lack of pipeline visibility and inaccurate revenue forecasting, difficulty in quantifying reasons for lost deals to competitors, and failure in follow-up which results in lost opportunities . The CRM system aims to resolve these challenges by providing better pipeline visibility, tracking forecasted revenue accurately, and ensuring timely follow-ups to avoid lost deals. By centralizing data from all channels and integrating it with existing systems, the CRM system will improve data accuracy and usage, thus addressing these operational challenges .

CRM implementation is likely to have a significant positive impact on customer satisfaction levels and repeat sales at the resort. By creating a centralized repository of customer data, the CRM system can provide insights into customer preferences, enabling the resort to offer more personalized services and enhance the customer experience. The ability to streamline communication and follow-ups through automated processes will ensure timely service, thereby increasing satisfaction. Additionally, the CRM system's focus on personalized interactions and anticipatory service is expected to enhance customer loyalty, contributing to a higher repeat sales percentage, currently at 40% . This strategic improvement in customer relationship management is crucial for the resort's aim to become a leading destination with exceptional service .

The main business objectives for implementing the CRM system include becoming a leading resort destination in the region renowned for exceptional customer service and innovative offerings, expanding facilities, increasing market share, and enhancing digital presence to attract a broader audience. These objectives will be achieved by focusing on personalized vacation experiences, seamless online booking systems, and diverse recreational activities that cater to different age groups and preferences while emphasizing sustainability and eco-friendly options . Additionally, building long-term relationships with valuable customers through personalized experiences will enhance customer loyalty, which is critical for achieving these future plans .

The CRM system should generate a variety of reports to support decision-making processes at different management levels within the resort. For sales representatives, reports like lead status, lead source, and pipeline/deal stage are crucial for day-to-day operations . Sales managers would benefit from reports such as pipeline/deal stages, revenue summaries, and accounts and deals analysis to understand team performance and forecast sales outcomes. At the director level, sales funnel analysis, sales forecasting, and sales revenue reports are essential to guide strategic planning and long-term decision-making. Moreover, marketing directors need reports focused on lead and deal sources to optimize marketing efforts .

The proposed CRM system aims to address inefficiencies in the current sales process by centralizing lead information captured from various channels such as the website, social media, and events. It will assign leads to sales representatives efficiently and ensure follow-up through automated reminders. The CRM will also help identify high-potential leads for targeted follow-up, tracking the effectiveness of each employee through metrics like success rates at different stages in the sales process . This systematic approach is expected to prevent leads from being forgotten or lost, thereby improving overall lead management and sales productivity .

The planned CRM system investment, with a budget of approximately 20K SGD and a flexible timeline with potential weekly engagement sessions, aligns well with the strategic goal of enhancing digital presence and operational efficiency at the resort. The investment in the CRM system supports the resort’s objective to provide personalized and eco-friendly services by allocating resources for licenses and implementation that can facilitate better customer data management and service customization. Starting the project as soon as possible ensures that the resort remains competitive and meets its goal of becoming a leading destination with exceptional service offerings .

You might also like