Based on the information contained in the Ariba Case, complete the template (AribaStudent.xls) andsubmit the template along with short answers(3-5 sentences) to the following questions.
What is preventing the project from hitting the original October 1 go-live date?
Why didn’t Terry notice earlier?
What should the PM have done differently?
What should the PM do going forward?
NB: The "rolling status" is the cumulative status of the project to-date. For May, the rolling status is the same as monthly status. For June, it's May + June. For July, it's May + June + July, etc.
Protip: You can copy a COLUMN of values in Excel and paste them as a ROW of values by right-clicking in the cell you are pasting into, and then choosing "Paste Special >> Transpose."
Ariba Exhibits Copyright These spreadsheet exhibits relate to the case Ariba Implementation at MED-X: Managing Earned Value, Case #KEL224. ©2006 by the Kellogg School of Management, Northwestern University. This case was prepared by Alex Gershbeyn ’03 and Derek Yung ’03 in collaboration with Joseph F. Norton, PMP, Senior Fellow, Center for Research on Technology and Innovation, Kellogg School of Management, and Principal, SOCHIN Consulting Group, under the supervision of Professor Mark Jeffery. To order copies or request permission to reproduce materials, call 800-545-7685 (or 617-783-7600 outside the United States or Canada) or e-mail
[email protected]. No part of this publication may be reproduced, stored in a retrieval system, used in a spreadsheet, or transmitted in any form or by any means—electronic, mechanical, photocopying, recording, or otherwise—without the permission of the Kellogg School of Management. Exhibit 5 Exhibit 5 Technical Infrastructure Plan MonthDollar Amount May$120,000 June$192,000 July$192,000 August$192,000 September$192,000 October$60,000 Software Customization Plan MonthDollar Amount May$120,000 June$192,000 July$192,000 August$192,000 September$192,000 October$60,000 Exhibit 6 Exhibit 6 Technical Infrastructure Actual Cash Burn MonthDollar Amount May$120,000 June$215,000 July$192,000 August$216,500 September$170,000 Software Customization Actual Cash Burn MonthDollar Amount May$119,000 June$187,000 July$165,000 August$189,000 September$186,000 Exhibit 7 Exhibit 7 Technical Infrastructure Actual Performance MonthDollar Amount May$120,000 June$170,000 July$173,000 August$190,000 September$185,000 Software Customization Actual Performance MonthDollar Amount May$133,250 June$197,000 July$220,000 August$215,000 September$240,000 Exhibit 8 MayJuneJulyAugSepOct Software CustomizationMonthly Plan Monthly StatusPlanBCWS (same as planned value) Actual BurnACWP (same as actual cost) Actual PerformBCWP (same as EV) Rolling StatusPlanBCWS Actual BurnACWP Actual PerformBCWP Rolling RatiosSchedule ImpactSV = BCWP – BCWS SPI = BCWP / BCWS Cost ImpactCV = BCWP – ACWP CPI = BCWP / ACWP Control RatioCR = SPI × CPI Technical Infrastructure Monthly StatusPlanBCWS Actual BurnACWP Actual PerformBCWP Rolling StatusPlanBCWS Actual BurnACWP Actual PerformBCWP Rolling RatiosSchedule ImpactSV = BCWP – BCWS SPI = BCWP / BCWS Cost ImpactCV = BCWP – ACWP CPI = BCWP / ACWP Control RatioCR = SPI × CPI Combined Projects Monthly StatusPlanBCWS Actual BurnACWP Actual PerformBCWP Rolling StatusPlanBCWS Actual BurnACWP Actual PerformBCWP Rolling RatiosSchedule ImpactSV = BCWP – BCWS SPI = BCWP / BCWS Cost ImpactCV = BCWP – ACWP CPI = BCWP / ACWP Control RatioCR = SPI × CPI