【正文】 ales WriteOffs) Risk Status C S 1 C S 5S T 1S T 8S T 2M D 2M D 1 5 M D 2 1M D 1 9M D 1M D 1 1M D 2 6M D 2 9M D 3 3S C 1S C 4S C 3S C 5S C 7M D 3 2S C 1 1 R T 4 aR T 4 bPP2C S 2M D 3 1M D 3 4S T 7R T 5R T 3E M 1M D 1 8E M 6IIIIIIIIIIPP7IIE M 3E M 4E M 5E M 7S F 1 1SF8S T 9 S T 1 0PP5C S 4R T 6M D 6M D 2 7E M 2M D 3 78 . Kearney BTR Deck Page The BTR has been continuously developed over the last three years Brief Project Description Tools Used/Major Enhancements Comments NiSource 12/01 – 02/01 Utilities pany undergoing cost reduction initiatives ? Online BTR system for front end ? Excel and Power Point for backend ? Customized with dedicated DMG resource Lucent 07/01 – 10/01 Communications pany underwent a significant corporate wide restructuring program ? BTR (nonweb based version) via Excel templates ? Backend used an Access database and PowerPoint ? Increased detail of financial descriptions ? Customized with dedicated DMG resource ? Input quality checked manually Interland 05/0109/01 MI project focused on identifying and realizing cost and revenue synergies associated with bining two web hosting panies ? Excel linked to an Access database using PowerPoint for presentations ? Scalability increased ? Needed Access database developer ? Difficult to customize without dedicated resource IFF/BBA 10/0005/01 Pre and Post Merger Integration of two flavors and fragrances panies while implementing a global reanization ? Excel linked to an Access database using PowerPoint for presentations ? Significant enhancement of detail of financials tracked in: ? Savings ? Implementation costs ? Capital expenditures ? Automation streamlined for report from input to output ? Enhanced milestone and cost savings tracking ? Input quality check and ad hoc reporting done manually Nalco/ Aquazur/ Calgon 05/0009/00 Post merger integration program management approach and strategic sourcing in an international environment ? Excel and PowerPoint ? Automatic links between Excel and PowerPoint presentation ? Auto generation of PowerPoint slides ? Not able to handle large scale engagements Rohm Haas 03/9911/00 Pre and post merger integration with prehensive approach across all value capture initiatives ? Excel with limited use of Access database ? PowerPoint was used for output with manual manipulation ? Foundation of tool development 1999 2023 9 . Kearney BTR Deck Page The most recent development was moving the tool to a web format which solved many of the shortings of the Excel/Access based tool Common issues with Excel/Access Tool Large file size difficult to send via in time and mail box limitations ? Corporate firewalls blocked files due to macros in Excel template ? Large amounts of storage space needed to archive data ? Data manually transferred from Excel template to Access database by PMO ? Templates submitted by client were not pletely filled out ? Templates were pleted using text in fields designed for numbers ? Clients overwrote formulas with text in pleting the templates ? Head count reduction information was often requested both at a high level and at a very detailed level within the same anization ? Change to PMO input templates after cutoff date required plete rerun of database which increased cycle time ? Clients often requested additional ad hoc reports outside the reporting cycle ? No longer sent via Manual transfer no longer necessary Ability to run own reports Programmed, so formula cannot be overwritten Programmed, so cell accepts appropriate format Web pages do not have macros Files stored on server, not locally Programmed to check key parameters for pleteness Users have access to screens based security level determined at log in Web allows download of most current information on demand Solved with Web Format 10 . Kearney BTR Deck Page ATK has used different Project Management tools over recent ye