These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Monday, April 13, 2015

Nails & Spa Too

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.

No comments:

Post a Comment

Blog Archive