Monday, December 12, 2011

Salon Management System for Coiff It Up Salon Cetre

SALON MANAGEMENT SYSTEM
FOR COIFF IT UP SALON CENTRE
A System Proposal Presented to the Faculty of the
Information Technology Education Program
University of the Immaculate Conception
Fr. Selga St., Davao City
_________________

In Partial Fulfilment of the
Academic Requirements for the Subject
SYSTEMS ANALYSIS AND DESIGN
(SAD)

Alvar, Winwin
Donato,Rea Mae
Orquillas, Jun Ray

December 12, 2011
__________________________________________________________________________________

Part I

SYSTEMS ANALYSIS REPORT



Innovations in computer technologies have revitalized businesses both local markets and worldwide. It enables those small companies to expand into large markets because of its multitasking capabilities that help businesses to handle those complex tasks by the use of computer software. Undeniably, the fast advancement of computer technology is a big help in our society.
            Every business of today has its own secret of success. Even those large companies have their own top-secret on how they got that far. A common problem in most businesses is the proper way of monitoring data from their everyday transactions. Through the help of computer technology, this dilemma will quite diminish. Computers have the ability to organize data according to your needs with the aid of computer programs. By this, it will be easier for the company to trace the flaws in their business and be able to respond to it immediately. Therefore, computer technology plays a gigantic role in every business in the community.
            Nowadays, most of the salons still used manual transactions in managing their transactions. Computers of today work not only to those big businesses. It is practical to say that using a computer in managing such records for a salon is a good alternative than manually doing it. Salon management helps you to eliminate your stress in running your salon. Salon management systems have this ability to take control on the inventory, run advanced reports to keep track on your progress. It will make your salon more organized, profitable and efficient.  
There were some salons that wonder about their unexplainable loss of profit, this reason is mainly because they do not have enough information about their point of sales. Point of sales information system is also helpful to a business where it helps you to record a customer’s information, when a product is purchased and what are the purchased products. By having this information system, you will be able to analyze and generate the needed report quickly for the improvement of the business.
            The proponent’s objective is to help the company to improve their way of keeping records and to help them to analyze the data for the generation of reports needed based on their sales and inventory reports so they will be able to improve their customer service and improve their marketing.
Coiff It Up salon centre is located at the ground floor of the D’Leonor Hotel in Bajada, Davao City. It started to operate last May 2010, a year ago. They believed that a world class, personalized service and cutting edge innovation are must haves of the dream salon. The salon itself is modern and fully equipped with a comfortable and relaxed atmosphere. All the staff is up to date with the latest salon equipments and hairdressing techniques through the Alex B. Monton creative team. They also stock a range of high end hair products such as L’Oreal, Kerastase, Davines, TIGI, Bed head, S Factor and RedKen. They also cater high end nail polish brands such as Chanel, Shu eumura, Revlon and Orly. Lastly, they also bring the signature make up products that were known globally particularly Bobbi Brown, Shu eumura, Shishiedo, Yves Saint Laurent, Mac, Lancome and Make up Forever.



            Our long-term plans are to continue expanding in all over Philippines especially in Davao City as opportunities present themselves. We envisage Coiff it Up Salon Centre in all the key cities around the Philippines and in every reasonable sized town and city in the country. Our long term plans will not be possible unless we strive to implement and accomplish our short term goals.


The reason for setting up Coiff it Up Salon Centre is to make money for the company, and for the staff. Coiff it Up Salon Centre also wishes to create a business enterprise that is a leader in the field. The company would like its staff to be happy at work, not only because of monetary benefits but because they are happy to work in a professional environment.

            The Coiff it Up Salon Centre should be well known as a company that provides consistently good service, in a pleasant environment by a friendly professional staff. We can assure of the high standard and quality of work.

           
            Coiff it Up salon centre can be found at the ground floor of the D’Leonor Hotel in JP. Laurel Street, Bajada, Davao City. The salon has a modern and a very comfortable atmosphere that makes the customers feel comfortable while waiting. . To entertain you as you enter the said salon, the front desk representative will be guiding you on your purpose for entering the salon. There is also a private room for the manager for her to focus more on her works. Each stylist has his/her own working cubicle for them to concentrate on their works.
             Unlike other salon centres, they also have products available for the customers to buy if they want to. This will enable their customer to continue their hair care even at home.
Critical Success Factors
           
Success they say is where preparation and opportunity meet. So for you to achieve that opportunity you must have a very good preparation.  .  How does this Coiff It Up Salon Centre prepared for their success? How are they able to maintain this success within the past year?
Competition in a business is normal. What matters is how you will deal with your competitors and stand-out from them. How does the salon continue to operate until now? The reason behind are the following:
1) They are able to give quality service to their customers
2) They have promo(s) options for their customers, and lastly
3) They have good marketing strategy that convinces the customers to take them.


The Coiff it Up salon centre is doing a manual way of keeping their records. They keep their records in a cabinet and retrieve when doing a report. This way of keeping files is time-consuming when files are needed to be retrieved. Aside from that, this process may lead to loss of data. Some data might be misplaced and lost and it causes misleads in generating data to a report.
As a customer comes in the receptionist greets them politely and asks if this is his/her first time to the salon, unless recognized by the receptionist. Then the customer should be asked what he/she would like to have done today. The next thing that a receptionist should do is to decide which senior stylist will do the customer. If the customer request a particular senior stylist by name or description then it is easy for the receptionist. However, if it is the customers first time to the salon and she has not been recommended to any stylist, the receptionist should follow the schedule of passing on the new customer to whichever senior’s turn it is to have a new customer.

            Once the stylist is decided and the information of the customer is recorded together with the senior stylist details, the customer is then asked to take a seat in the reception area. If there is time, they offer magazine, and tea or coffee (if available). They insure that the customer must feel as if they are being worked on immediately, because otherwise they might lose a customer. Upon the senior stylist is already available they will then be fetched by the senior stylist and escorted into the salon. When the customer is seated the senior will then talk to the customer and decide what service the customer will have. The junior will take out the docket and ask the customer on what service he/she wanted. The junior will now check the box on the docket that corresponds to the customers’ chosen service.

            When the customer is finished he/she should be escorted to the reception preferably by the senior or if the senior is busy then the junior stylist. The customer should not be allowed to wander around the salon not knowing where to go. The receptionist will then give the official receipt to the customer with corresponding amount to be paid based upon the docket that the junior stylist gave before the service was performed. For cases that the customer wants to buy products the receptionists will ask a junior stylist to grab the item and hand it to the customer and receptionist will then write the product name and price at the back of the docket. Also there is a possibility that a customer comes in and buys product directly without any services wanted. For this case the receptionist will write the product name and price at the back of the duplicate copy of the official receipt. At the end of the day, the receptionist will be generating a daily report based on the appointment sheets. After a month, they will be generating the commission report that each employee will be receiving based on their daily reports. The commission that each employee will be receiving varies on how many clients they have catered every day.


Activity Diagram of the Current System






Figure 1.1 – Activity Diagram of the Current System when
Performing Service to the Customer

Context Level Data Flow Diagram



Figure 1.2 – Contextual Level Data Flow Diagram
Level 0 Data Flow Diagram

Figure 1.3 – Level 0 Data Flow Diagram

The current system is time consuming. They write records on an appointment sheet then rewrite this again to another sheet for generating daily report. As stated in the company’s processes, the following problems, causes and effects are being defined:
Table 1.0 Problem-Opportunity Definition Matrix

Problem
Opportunities
Cause(s)
Effect(s)
Performance
-       Generating daily sales report takes time











-       Generating monthly commission report for employees takes time

-       They have to manually search the records from the drawer where all their daily sales and other files are stored before generating a report.


-       Before computing the commission,
they have to gather all appointment sheets and sum up the total sales for each employee

-       The closing time of the salon is 9 pm but because of reports reported late they extend till 10 pm or later.






-       Retrieving all the records for each employee takes time.
Information
-       It is difficult to produce the commission of every employee








-       Recording of items sold are not recorded in an appropriate file


-       The daily sales for each employee is recorded in different appointment sheets and they have to compile all appointment sheets before they can generate commission reports


-       They input data in just about any piece of paper whether a scratch paper, at the back of the OR, and the like.
-       It would take them an hour to generate commission reports








-       Loss of data that results to wrong information
Economics
-       Waste of materials

-       The company tends to reprint the sheets again because they will be needing it for their transactions
-       Waste of money
Control
-       Anyone can access files and/or information

-       The place where the appointment sheet is placed is in a drawer in the front desk surrounded by an open space where anyone can go past it and  is not secured
-       Tampering of data might happen
Efficiency
-       Data Redundancy

-       The front desk representative inputs data to the appointment sheets then rewrite some of these again at the sales report
-       It cost a lot of time
-       Produces more work
As seen in the table above, we can say that Coiff It Up salon centre has this difficulty in generating their reports because they are still doing the manual processing of keeping records.  They have to manually search records one by one for them to generate their reports. As said, this process is time consuming because they are making the same procedure again and again. They also have difficulty in calculating the commission that their employees will be receiving in one (1) year because in that case, they will have to review that 365 appointment sheets for them to determine whether an employee reached the quota or not. Aside from this process is time consuming, the reprinting of sheets cost a lot as well. As you imagine, the company will have to reprint the sheets repeatedly and it is not that easy to spend money just for reprinting those sheets.


            As seen on the problems stated in table 1.0 most problems encountered by the company came from the processing of their customers’ transaction, sales and inventory. The major problem was that they were unable to track the payments and their corresponding sales. This is because the transactions themselves were not accurately recorded, and their means of recording is made by using a sheet of paper called appointment sheets. There are tendencies that these sheets are getting lost. The more appropriate solution for this is to have a transaction processing system that accurately tracks customers’ transaction, sales and inventory. To support the needs of the manager, some features should also be included. The following are functionalities that are needed based on the interviews conducted on both the manager and the staff:
Appointment Management
I.          Manage Appointment for the day
a.       For non-existing customer the system must be able to add a new customer record.
b.      The system must be able to load all the employees that perform services in the company.
c.       The system must be able to add appointment for stylist or manicurist in line with the time and date.
d.      The system must have an interface that looks the same with the company’s current appointment sheet.
e.       To produce more security, the system must be able to block alterations and needs verification of the manager to continue.
f.       The data needed should compose of the following details:
                                                                                      i.      Customer Details
                                                                                    ii.      Date
                                                                                  iii.      Time
                                                                                  iv.      List of stylist and manicurists’ name
                            II.            Transfer customer
a.       The system must be able to transfer a customer to another stylist or manicurist
b.      The data needed should compose of the following details:
                                                                                      i.      Previous Stylist Details
                                                                                    ii.      Stylist Details the customer to be transferred on
                                                                                  iii.      Date
                                                                                  iv.      Time
                         III.            Cancel appointment
a.       For customer’s change of mind, the system must allow a cancel of daily or future appointments but with the manager’s verification.
                         IV.            Add future appointment
a.       For customer’s future appointments, the system must be able to add future appointments. This will also serve as a reservation.
b.      The system must be able to block conflict schedules.
c.       The data needed should compose of the following details:
                                                                                      i.      Date of appointment
                                                                                    ii.      Description of appointment
                                                                                  iii.      Time of appointment
                                                                                  iv.      Customer details
                                                                                    v.      Stylist or manicurists’ details
                            V.            Add Docket
a.       The system must be able to attach docket or an invoice for the services offered in the company to each appointment.
b.      The data needed should compose of the following details:
                                                                                      i.      Docket number
                                                                                    ii.      Service number
                                                                                  iii.      Service name
                                                                                  iv.      Service description
                                                                                    v.      Service Price
                         VI.            Update Docket
a.       The system must be able to update docket with the following data:
                                                                                      i.      Service number
                      VII.            Cancel Docket
a.       The system must be able to cancel an attached docket.
                   VIII.            Notification for incoming appointments
a.       The system must be able to notify the user about an incoming appointment.
b.      The system must be able to set when to notify the user about an incoming appointment
c.       The data needed should compose of the following:  
                                                                                      i.      Stylist name
                                                                                    ii.      Date of appointment
                                                                                  iii.      Time of appointment
                                                                                  iv.      Customers Details
                                                                                    v.      Description of appointment
a.       The system should allow the user to add new finished product in the inventory.
b.      The data needed should compose of the following:
                                                                    i.            Product Number
                                                                  ii.            Product Name
                                                                iii.            Description
                                                                iv.            Inventory Quantity
                                                                  v.            Price
                                                                vi.            Minimum Quantity
                                                              vii.            Status (available or not)
                            II.            Update Product
a.       The system should allow the user to update the following details:
                                                                    i.            Quantity
                                                                  ii.            Price

a.       The system must be able to attach docket and/or add an invoice for item.
b.      The system must be able to cancel a docket or an invoice in case mistakes are done.
c.       The system must allow update of invoice.
d.      The system must be able to add discount for each item, each service and/or total amount.
e.       The system must allow update of docket.
f.       The system must be able to add new payment.
g.      The data needed should compose of the following:
                                                                                  vi.      Docket Number and/or Invoice Number
                                                                                vii.      Docket Details and/or Invoice Details
                                                                              viii.      Customer Details
                                                                                  ix.      Stylist / Manicurists Details
                                                                                    x.      Subtotal Price
                                                                                  xi.      Total Price
                                                                                xii.      Date
                II.            Generate Sales Report
a.       The system must be able to generate daily, monthly, annual and user defined sales report.
                                                                          i.      List of stylist and manicurists with commission
Service Management
                               I.            Add Service
a.       The system must be able to create services offered in the company.
b.      The data needed should compose of the following:
                                                                                      i.      Service Number
                                                                                    ii.      Service Name
                                                                                  iii.      Service Description
                                                                                  iv.      Status (available or not)
                                                                                    v.      Service Price
                            II.            Update Service
a.       The system must be able to update services with the following data:
                                                                                      i.      Service Name
                                                                                    ii.      Service Description
                                                                                  iii.      Service Price
                                                                                  iv.      Status
User Management
                               I.            Create User
a.       The system must be able to create user accounts
b.      The data needed should compose of the following:
                                                                                      i.      User number
                                                                                    ii.      Username
                                                                                  iii.      Password
                                                                                  iv.      User Type
1.      Admin
2.      Non-admin
c.       The system must be able to appoint the user account to an employee.
                            II.            Update User Details
a.       The system must be able to update a user account with the following data:
                                                                                      i.      Username
                                                                                    ii.      Password
                                                                                  iii.      User Type
                         III.            Delete User
a.       The system must be able to delete an existing user account.
Employee Management
                               I.            Add Employee
a.       The system must be able to add employee records
b.      The data needed is composed of the following:
                                                                                      i.      Employee number
                                                                                    ii.      Name
                                                                                  iii.      Birth date
                                                                                  iv.      Address
                                                                                    v.      Contact number
                                                                                  vi.      Employee type
                                                                                vii.      Employee picture
                            II.            Update Employee Details
a.       The system must be able to update employee records
b.      The data needed is composed of the following:
                                                                                      i.      Name
                                                                                    ii.      Birth date
                                                                                  iii.      Address
                                                                                  iv.      Contact number
                                                                                    v.      Employee type
                                                                                  vi.      Employee picture
                         III.            View Transactions
a.       The system must be able to view past transactions of the employee.
b.      The system must be able to view the generated reports
                         IV.            Generate commission report
a.       The system must be able to generate monthly commission report based on every sales of the employee.

 Use Cases
Table 1.1Use Case Glossary

Use-Case Glossary
Use-Case Name
Use-Case Description
Participating Actors and Roles
Inventory Management:


  1. Add Customer
This use case describes the new additional customer in the  system
Receptionist
Manager
  1. Update Customer
This use case describes the updating details of the existing customer
Manager
Receptionist
  1. Add Product
This use case describes the recording of new products
Manager
  1. Update Product

This use case describes the updating details of an existing product
Manager
  1. Add  Service

This use case describes the recording of the created new service
Manager
  1. Update Service
This use case describes the service available for the customer
Manager
  1. Manage Appointment
This use case describes the recording of the new appointment transactions
Receptionist
Manager
  1. Cancel Appointment
This use case describes the cancelling of an appointment
Receptionist
Manager
  1. Add Docket
This use case describes the recording of new services available
Receptionist
Manager
  1. Update Docket
This use case describes the updating of docket
Receptionist
Manager
  1. Cancel Docket
This use case describes the cancelling of an existing docket
Receptionist
Manager
Sales Management


  1. Use Point of Sales
This use case describes the daily point of sales of the salon
Receptionist
Manager
  1. Generate Sales Report
This use case describes the generating of sales report
Manager
User Management


  1. Create User
This use case describes the adding of new user in the system
Manager
  1. Update User
This use case describes the updating of the user profile existing in the system
Manager
  1. Delete User
This use case describes the cancelling an existing account of a user
Manager
  1. Set Appointment Notification
This use case describes the notification of an appointment set
Manager
Reception
  1. Transfer Customers Appointment
This use case describes the transferring of a customers’ appointment
Manager
Receptionist
  1. Generate Sales Report
This use case describes the summary of sales report
Manager
  1. Add Employee
This use case describes the adding of a new employee in the system
Manager
  1. Update Employee
This use case describes the updating of the profile of an existing employee
Manager
  1. Generate Employee Commission
This use case describes the commission that an employee will be receiving
Manager



Figure 1.4 Use Case Diagram
Feasible Alternatives

After analysing and understanding the problems of the company, the proponents came up with three (3) different solutions. Either they can purchase existing Software, use Vagaro or build customized software that best fits their needs.


  1. Purchase existing software
    • Purchasing software would be costly and the organization will not be able to personalize the system. The company will just have to purchase, implement, and continue with their daily transactions. An example of such is HairMax Salon Software. The pricing starts at $497 for single operator, $997 for 2-5 employees, $1,497 for unlimited stylist. For the case of Coiff it Up Salon Centre, the company holds more than 5 employees so the price for them would be $1,497 (Php 63,593.88).

  1. Use Vagaro
·         This solution is a website that caters salon management online. It has multitasking capabilities like online booking, generate reports, generate payroll to the employee, customer tracking and other functionalities that will help your business to be more organized. Vagaro also allows you to create your own website where your latest promotions are posted automatically. It also accepts online reservation from the customers and you can send them an official receipt through email. Accepting the fact that you cannot monitor your business 24 hours a day, and then by using Vagaro, this will no longer be impossible. The user can now use their mobile phone by simply adding and view appointments on their calendar and charge their customers for services (credit cards optional), they can also view customer notes and contact information, and more. The user will be paying $25/month or Php1 150. The first 30 days will be free so the user will no longer worry for the initial payments.
  1. Build customized software that best fits their needs.
    • This solution is to develop a system that will be based upon the company’s requirements, where the company itself will undergo the software development cycle; Analysis, design, production, implementation and operation.


            The three (3) solutions given can answer the problem of the company. Is the company willing to change the current business process to accommodate the software? Practically, most of the companies will say yes if it will help them on their current problems about the business.
            Most of the companies nowadays, rely on purchased software than customized software. This is mainly the installation takes less time than designing one.

Other businesses choose to have this customized software because it fits to the requirements of the company. They will be given enough knowledge about the software because the developer and the user are in the same place. Although packaged software solution may be better in adapting to changing business requirements, you still have to determine if its flexibility is worth the cost. Your business may not need those fundamental changes in the future and you spent too much for that software. Even though customized software takes time to develop, it costs less compared to other and the maintenance of the software will be much easier because the developer is within reach. The fact that certain software is made for your company assures you that it will meet the requirements of the business because it is analysed and designed based on the needs of your business.
Operational Feasibility
When the three alternative solutions will be used, the company will be able to manage their customers’ appointment, sales and inventory accurately. The three alternatives have similarities in providing solutions for the process of the company. These include the recording of the transactions of the customer, recording and tracking the sales, and automatically updating the inventory whenever a customer purchases products. The company’s employee has the capability to use the alternative solutions since the three systems are user friendly and easy to understand.



Technological Feasibility
Alternative #1 – Purchase an existing software
Purchasing software would be costly and the organization will not be able to personalize the system. The company will just have to purchase, implement, and continue with their daily transactions. An example of such is HairMax Salon Software. The pricing starts at $497 for single operator, $997 for 2-5 employees, $1,497 for unlimited stylist. For the case of Coiff it Up Salon Centre, the company holds more than 5 employees so the price for them would be $1,497 (Php 63,593.88).
Alternative #2 – Use Vagaro
The company already have four computer units for the implementation of the system. They are using different computers for the owner, the manager, the receptionist and for the server. They have 3mpbs internet connection which is capable to run Vagaro in their computer units. The salon is also connected via wifi so there will be no problem in transferring of data.
Alternative #3 – Build Customized Software that fits to their needs
            The system only needs 1 gigabyte RAM and a fast processor to handle all the important data. For the salon has four computer units that have strong software specifications, then the system will run efficiently upon installation. For their computer units are already networked via wifi then it will be easier for them to pass the data to one another.

Economic Feasibility
Alternative #1 – Purchasing existing software
ALTERNATIVE 1


Deployment Cost



P63 593.88
Purchase Software
1
P63593.88
P63 593.88



Annual Maintenance Cost (Alternative 1)




P4 440.00
1
Electricity (add on)

P250.00/month
P3 000.00/year
2
Printing of receipts
4 pad of receipts per month
P120.00/month
P1 440/year



Implementing a Purchased Software

Year 0
Year 1
Year 2
Year 3
Year 4
Initial Investment
P63 593.88




Annual Cost

P4 440.00
P4 440.00
P4 440.00
P4 440.00
Total Cost
P63 593.88
P4 440.00
P4 440.00
P4 440.00
P4 440.00
Discount Factor (10%)
1
0.909
0.826
0.751
0.683
Discount Cost
P63 593.88
P4 035.96
P3 667.44
P3 334.44
P3 032.52
Benefit

P21 120.00
P21 120.00
P21 120.00
P21 120.00
Discount Factor (10%)
1
0.909
0.826
0.751
0.683
Discounted Benefit
P0.00
P19 198.08
P17 445.12
P15 861.12
P14 424.96
Discounted benefit - discounted cost

(P63 593.9)
P15 162.12
P13 777.68
P12 526.68
P11 392.44
Cumulative benefits – cost


(P63 593.9)
(P48 431.78)
(P34 654.1)
(P22 127.42)
(P10 734.98)
Alternative #2 – Use of Vagaro
            There will be no deployment cost for this proposal because system registration is free and there is no any initial investment needed 


Annual Maintenance Cost (Alternative 2)




P18 240.00
1
Electricity (add on)

P250.00/month
P3 000.00/year
2
Printing of receipts
4 pads of receipt per month
P120.00/month
P1 440/year
3
Maintenance
Monthly payment for the software
P1 150.00/month
P13 800.00year


Implementing the Vagaro

Year 0
Year 1
Year 2
Year 3
Year 4
Initial Investment
P0.00




Annual Cost

P18 240.00
P18 240.00
P18 240.00
P18 240.00
Total Cost
P0.00
P18 240.00
P18 240.00
P18 240.00
P18 240.00
Discount Factor (10%)
1
0.909
0.826
0.751
0.683
Discount Cost
P0.00
P16 580.16
P15 066.24
P13 698.24
P12 457.92
Benefit

P21 120.00
P21 120.00
P21 120.00
P21 120.00
Discount Factor (10%)
1
0.909
0.826
0.751
0.683
Discounted Benefit
P0.00
P19 198.08
P17 445.12
P15 861.12
P14 424.96
Discounted benefit - discounted cost

P0.00
P2 617.92
P2 378.88
P2 162.88
P1 967.04
Cumulative benefits - cost

P0.00
( P2 617.92)
(P239.04)
P1 923.84
P3 890.88