By James C. Elledge, IFMA Fellow, CFM, FMA, RPA, RIAQM
Published in the February 2008 issue of Today’s Facility Manager
QIn my position, I oversee 40restaurants in the Mid-Atlantic. I have yet to find an organizationaltool that helps me keep their gazillion problems in an organized manneryet reminds me to follow up. I’ve tried Outlook, calendars, andtraditional notebooks, but I need your advice. We already use a thirdparty call center for the daily issues. I’m concerned about all theother issues that are my responsibility.
Regional Facilities Manager
AIt sounds like you have the right idea, but possibly not the propersolution. If you want something you can create and customize yourself,I would recommend Microsoft Access. As a database, it can performseveral functions and still interact between Word, Excel, and Outlook,and provide some Web capabilities.
If you decide to go theAccess route, I would suggest starting out by creating a database ofall the restaurants you oversee and then defining a corresponding“problems database” to track all of the items.
You could adda “completed” checkbox, which would allow you to generate a reportdisplaying all “open” items. You could even sort the report bylocation, to see the number of items for each unit. I would alsoconsider adding your service providers to the database, so you cantrack who is assigned to each issue or task.
As I previouslymentioned, Access interfaces seamlessly with Word, so you can use themail merge feature in Word to create custom work orders, bid requests,or RFPs as needed. In addition, Access allows you to post forms andreports on the Web, which comes in handy if you have an intranet.Depending on your network, the stores could check the status of theirrequests at any time.
Costs would also be easy to track, asyou could record invoices by vendor and by store. This would then allowyou to view the number of requests and costs for each restaurant.Depending on how much information you need to keep, you can add thingslike equipment, finishes, and other specific details to the database.
Anothersolution would be to purchase a general CMMS system. A listing ofdifferent programs is available from the TFM Quick Product Search (under the “Computer Software” heading) or use a Web-based application hosted by a service provider. Yourdecision will be influenced by the volume of calls you receive and thebudget you have.
Elledge,facility/office services manager for Dallas, TX-based Summit AllianceCompanies, is the recipient of the Distinguished Author Award from theInternational Facility Management Association (IFMA), is an IFMA Fellow, and isa member of TFM’sEditorial Advisory Board. All questions have been submitted via the “Ask TheExpert” portion of the magazine’s Web site. To pose a question, visit this link.
You might like:
- Four Types Of Concrete Damage And How To Address Them
- Rise Of IoT Prompts Facility Professionals To Invest In Analytics
- Facility Management Critical To Infection Control
- 4 Ways To Avoid LED Lighting Failure
- Question Of The Week: What Best Practice Boosts Your Bottom Line?
- Friday Funny: The Dirty Truth About Public Bathrooms
- New Vikings Football Stadium First In U.S. With Transparent Roof
- Look, Listen, And Learn To Find Leaks
- FM Alert: OSHA Offering $4.6M In Safety And Health Training Grants
- Best Practices For Data Center Management
- Applying Lean Principles To Facility Cleaning Programs
- Technology, Aging Facilities Impacting Education Facility Budgets
- Energy Upgrades And Renovations: What To Know About Windows
- U.S. Employers Suffer Largest Talent Shortage In Skilled Trades
- Preventive Maintenance, Proactive Facility Management