Executive Summary
Nails
and Spa Too is a local beauty salon located in Highland, UT. Over the course of
12 years, their humble business expanded from a single salon in American Fork,
UT to the opening of a second store in Highland. Recently their original store
in American Fork was sold to other owners. As a small business, many of the technological
amenities commonly found in larger franchised salons are not available. One
such example is a balance sheet to track the services being completed by each
technician. As a result of not having this data recorded, each employee must
keep track of their work completed on slip of paper and total the service
charges and tips at the end of the day. Through personal experiences viewing this
procedure, approximately 30 minutes are spent waiting while each employee
totals and records their work for the day. This process was the inspiration for
my final project. My goal was to replicate the current procedure in the simplest
way possible while giving the owner the tools necessary to track what services
were completed by each technician, the amount charged to the customer and
applicable tips given by the customer. This process needed to be general enough
to capture all work completed by each employee, while being specific enough for
each employee to track daily work and expected pay. The solution was through a
simple to understand UserForm and multiple worksheets to record the data being
entered through the UserForm.
- http://files.gove.net/shares/files/15w/wighta/NailsSpaToo.pdf
- http://files.gove.net/shares/files/15w/wighta/FinalProject.xlsm
No comments:
Post a Comment