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:
- Technology, Aging Facilities Impacting Education Facility Budgets
- 4 Ways To Avoid LED Lighting Failure
- Question of the Week: How Can I Protect Employees From Zika Virus?
- VARIDESK Debuts Pro Desk 60 On HBO’s “Silicon Valley”
- Facility Management Critical To Infection Control
- Lunetta Exterior Lighting By Amerlux
- Infographic: The Healthcare Speech Privacy Crisis
- SkyBEAM UAV From Tremco FAA Approved For Nighttime Operation
- Spray Kleen Multi-Surface & All-Purpose by Sunburst Chemicals
- Energy Upgrades And Renovations: What To Know About Windows
- Look, Listen, And Learn To Find Leaks
- Fire Rated Flood Door from PS DOORS
- President Obama Proclaims May National Building Safety Month
- Energy Storage Solution From Northern Power
- Five Things To Consider When Starting A Predictive Maintenance Program