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:
- Psychology Of The Office Space
- Webinar: Making Sense of Smart Buildings – 6 Steps to Maximize Investments
- Stadium Maintenance: Would Better Field Upkeep Have Kept The Rams In St. Louis?
- Friday Funny: Super Bowl Time Warp
- Webinar: 6 Workplace Technology Predictions for 2016 – Are You Ready?
- China’s First Green Skyscraper
- Winter Roof Maintenance: Ounce of Prevention Worth Pound of Cure
- New Product Flash: Drone Detector By Drone Labs
- New Shade Fabric Boosts Energy Efficiency 50% At Automotive Facility
- Survey Reveals Dirty Little Restroom Secrets
- Friday Funny: A Valentine’s Day Look At Office Romance
- Facility Executive of the Year 2016: Keeping Costs In Check
- Question Of The Week: Utilizing Universal Design?
- Cyber Security In Real Estate
- Waterproof Your Facility: Maintenance And Water Damage Prevention