Cell Phone Rentals

Company Background
The Cell Phone Office is a service provided by Brigham Young University. The main responsibility of the Cell Phone Office is to manage the cellular lines for faculty, staff, and their families. The Cell Phone Office also manages international and domestic rental phones and Mi-Fi devices, which are available to faculty and staff.

System Overview
The VBA project manages these international and domestic rental phones and Mi-Fi devices, keeps track of and prepares billing journal entries, and reduces the manual steps needed to reserve and complete a rental transaction. The VBA project includes 9 functions for the Cell Phone Office to utilize, all conveniently located on a custom ribbon tab titled “Rentals”. Behind these functions there are 6 modules and 28 user forms used to automate the rental process. We estimate that between our combined efforts, over 100 hours were spent working on this project.

Project Write-Up
VBA Project

By: Jake Taylor and Adam Turner