Monday, September 19, 2011

excel-week 2


Being proficient in excel will really help maintain, organize, and predict the financial aspects of the restaurant.  In order to keep track of the operating budget, and all the components that make up the operating budget, it will be much easier to record and adjust numbers if you can use excel.  Pivot tables will help assist in seeing how many transactions we have on a monthly basis. Additionally, they will help see how much we owe our vendors.  Charts will be useful in comparing month-to-month spending and earnings. We will be able to adjust how we spend according to the graphs.
            Another helpful aspect that excel will help our business with is monitoring how well our marketing and advertising techniques work. There will be a system where we can track how many people come in due to our tweets and ads in various places. This will then be recorded in excel and we will be able to see which tweets and ads bring in the most customers. It may be difficult to find a way to track how many people exactly come in due to the social media and advertisements, however we will still be able to monitor the increase or decrease in business via excel.
            Overall, with the use of excel in our restaurant it will be much more efficient and we will be able to alter our ways accordingly. 

No comments:

Post a Comment