Business Analysis Consulting: STS Realty

About STS Realty

• Small realty group specialized in renting & selling properties in the Southwest Florida Region

• Started in 2007 as a partnership, with only 2 employees

• Focused only on renting and managing other people’s properties

About STS Realty(cont`d)

• Today, 6 employees total

• Increased portfolio of houses managed by its consultants

• Now RENTS, RESELLS and MANAGES its own properties

Value Adding Activities

• The company grew activities based on core competency of managing properties:

• Assured client’s properties were in good conditions when a new tenant entered or left.

Current System

• Excel Spreadsheets to create & keep files of all properties & clients

• Property list contains: address, proprietor name, & current status of property

• Client list contains: name, address, phone #, client type, credit history and check status & comment section

Issues with current system

• Current Microsoft Excel® system no longer efficient

• Previously simple categories began to overlap & became too complex

• Limited scaling

Managerial Input

• New system must account for all client types & must be much more efficient.

• New software must be simple & user friendly; minimal training of staff.

• Solution should connect & make easily accessible all required business operations data.

• It should fit a budget of $5000

1.Introduce a DBMS or ERP or CRM to achieve better integration of information (two iterations compared: Compiere ERP&CRM OR Oracle Database 11g Standard Edition)

Our Business Analysis

2.Expand the ‘seasonal clients’ market by investing in better SEO

-taking advantage of trends, i.e. Canadian Baby Boomers vacationing in Florida

Our Business Analysis

• 3.Proposed solution should combine 1 and 2

Our Business Analysis cont`d

Proposed Solution 1:Compiere

• Open source ERP specialized in small and medium businesses

• Provides CRM, SCM, and Accounting systems

• Applications to manage orders, and finance among the rest

Proposed Solution 1:Compiere (cont`d)

• Straightforward (meets simplicity requirements)

• Simple implementation &Use

• Integration of documents is simple thanks to multiple functionality of the software

Proposed Solution 2: Oracle Database 11g• $350/user (min 5 users)

• Ability to scale up as business grows

• Enterprise-class performance, security, and availability at an affordable price

Proposed Solution 2:Oracle 11g (cont`d)

• Needs to run on 4 socket servers

• Licences can have different terms and conditions

• No over deployment

• Has an ability to run on Windows, Linux, and Unix operating systems and easily manage with automated, self-managing capabilities

Collaborate with Search Engine

• Search Engine People SEP (Toronto-based company) to implement SEO strategy for STS.

• Two Proposed solutions: In-page strategy & content positioning.

• SEO Strategy: Combination of the two

Search Engine Optimization

Search Engine Optimization

• $475/month for:

-Monitoring traffic,

-Conducting a forecast of keywords,

-Changing content on the web site,

-Adjusting meta tags,

-Linking to more reputable sources on the internet.

Conclusion

• Alternative 1: Make a combination of the Compiere open source try out that offers ERP and CRM combined with SEP`s SEO for 6 months (budget of $5000 not used up, only $2850).

• Alternative 2: Oracle Standard Database 11g and SEP`s SEO, using up the budget on hand, $4950.

• We choose Alternative 1

• In case of later increase in traffic and more ‘seasonal clients’ from international markets will upgrade to a standard edition at Compiere (purchase a license) or go with Oracles Standard Edition Database 11g.

Conclusion

Time’s Up!

• About your speaker:– Name: – Company: STS Realty – Tel: Bunch of phones – Email: Bunch of emails– Social Media: Bunch of Social Media– Quick bio: Bunch of quick bios