Inventory and Ordering: With a little bit of wizardry, Excel can not only keep track of how much inventory you should have, but it can Email you an alert when you get too low on a particular product, making ordering a breeze. Doing the Schedule: Of course, Excel can be used to graphically display what times any given employee will be on the clock and thus make it easy to ensure that all of the necessary coverage is there for you. Customer Tracking: Few businesses need to track customers more accurately over a longer period of time than an auto shop; Excel offers you the power to do just that. By setting up an entry form that gathers the necessary information and then stores it deep in another sheet, you can easily keep records on hundreds of customers and their vehicles over months and years. Receipts: Because of an auto shop's specific needs when it comes to breaking down parts, labor, taxes, and other charges, Excel makes for an excellent receipt_making program.
In the Personnel Expense Budget Section include the salaries for the following: o Office Personnel o Store Personnel o Sales People o Other personnel necessary in the operations. Ideally, you budget expenses for a quarter in the personnel expense budget. This is for the first three months of operations where you are not expecting profits to come in as yet. You may have receivables during the first few months of operations but they may need to be earmarked for other operating expenses and thus your budget needs to be sufficient for the first quarter. Even if you are budgeting for the year and is already in full operations budgeting for three months is still a good rule of thumb. If you are already comfortable with your budgeting and timing of receivables, only then can you budget two months for personnel expense budget.