Executive Summary
Over the past year I have had the opportunity to
interact with a fellow MBA student by the name of Derek Johnson. Derek founded
and, until coming to the MBA program, operated a small-town bakery called
Cowboy Donuts. He was very efficient with his operations and as the bakery
began to grow he began to keep track of all the supplies he ordered. He did
this by entering the product, ID, cost, and various other things into excel.
He then began entering all the products he sold
through the bakery as well. He used many V-Lookups and other formulas that
allowed everything to update when the cost of a supply went up. This created
messy worksheets that he wasn’t comfortable letting others use. He was worried
that by letting others enter the information that they may mess up the code and
ruin the whole workbook. So when Derek left to come back to school, the
updating of the workbook stopped.
What my project entails is the simplifying of
all this data. I wanted to go in and create user forms that would allow any
knowledgeable employee to update and add information as necessary. Part of my
objective was to eventually have no formulas in any cells. I wanted all the
calculations to take place behind the scenes and hide all the data sheets. The
end result was to be user proof Excel workbook that would allow easy updating
of both supplies and products for sale.
No comments:
Post a Comment