In the Operating Expense Budget Section otherwise called OPEX, the details you may include are the following: o Advertising Costs o Delivery Costs o Other Employee Benefits o Insurance o Interests o Office Supplies o Postage o Maintenance and repairs o Telephone and other utilities o Rent and mortgage o Taxes _ There are other operating expenses you encounter and you have to put all of them in the template. Budgeting on a per period basis is likewise necessary herewith. If you are already in operation for a while, you must review the average periodical expenses and budget for operating expenses accordingly. Based on your average monthly or quarterly operating expenses, budget two period when necessary. If this is not possible, use the average based on the past 3 months or three quarters. Ensure that you pickup the highest period cost to ensure that your budgeting is enough to cover any spike on your costs.
Customer Reminders: This is clever. Excel can be programmed to send an Email when a cell gets beyond a certain limit __ so if you're doing oil changes that should be done every few months, just collect the customer's Email address and have Excel use it to send them a helpful Email a few months after they had their oil changed last! The powers that Excel can offer your auto shop stretch so far beyond merely watching the profit margins that if you're not using it for more advanced functions, you're losing out. Stretch it's wings! Set some automatic alarms for your inventory and some automatic Emails for your customers, and see what Excel can do for you!