excel project management

630 Appendix 2 Computer Project Exercises TABLE A24 Status Report May 31, 2012 Activity Need survey Set product specs Shelf life report Nutrition report Select fruit suppliers Equipment rehab Production trials Quality trials Market testing Package design Select distributors Complete FDA certification Actual Start 1/3/12 2/3/12 2/29/12 3/14/12 4/3/12 2/29/12 4/17/12 5/7/12 4/4/12 5/10/12 5/28/12 Actual Finish 2/2/12 2/28/12 3/13/12 3/19/12 4/30/12 4/11/12 5/4/12 5/31/12 5/9/12 5/25/12 Remaining Duration 0 0 0 0 0 Actual Duration 22 18 10 4 20 31 14 18 26 12 4 but w#4BH OOOOO 0 18 5/11/12 5/31/12 14 0 Blue Zuma Project The ARC Company specializes in developing and selling a wide range of high-quality scooters. Sales representatives report that there is a growing demand for racing scooters ARC's president, Robin Lane, is excited about the possibilities and predicts that one day these kinds of razor scooters will be featured in X-Game events. ARC is a small company and uses a strong matrix to optimally utilize limited manpower. The Project Priority Matrix for the Blue Zuma Project is: Time Cost Scope Constrain Enhance Accept X Part 1 You are a member of a project team assigned to develop the new razor scooter code named "Blue Zuma." Table A2.5 contains the information necessary to cre- ate a project schedule. For the purpose of this case assume the following: 1. The project begins January 2, 2008. 2. The following holidays are observed: January 1, Memorial Day (last Monday in May), July 4th, Labor Day (first Monday in September), Thanksgiving Day (4th Thursday in November), December 25 and 26. 3. If a holiday falls on a Saturday, then Feday will be given as an extra day off, and if it falls on a Sunday, then Monday will be given as a day off. 4. The project team works eight-hour days, Monday through Friday, Construct a network schedule for this project and prepare a memo that answers the following questions: 1. When is the project estimated to be completed? How long will the project take? 2. What is the critical path for the project