project management class

628 Appendix 2 Computer Project Exercises TABLE A2.1 Resource Assignments Activity Need survey Set product specs Shelf life report Nutrition report Select fruit suppliers Equipment rehab Production trials Quality trials Quality metrics Quality training Market testing Package design Select distributors Complete FDA certification Register trademark Prepare product launch Resources MRKT 500% R&D (0%, MRKT (2009) RSD 1300%) R&D (300%) PURCH (100% ENG (1.000%I, PROO (2,000%) PROO (1.500%. PURCH (100%, ENG (1,000% QUAL (300%), PROD1500%) QUAL (300%, PROD (100%) QUAL (300%. PROD (1.500%) MRKT 1500% DESIGN (390%, MRKT (100%) MAKT (500%) LEGAL (300%) LEGAL (300% QUAL (300%. PURCH (200%, PROD (1,500%). MAKT (500%). ENG (500%, R&D (100%) TABLE A22 Resources Availability and Pay Rates Available Resource Marketing statt R&D Engineering Purchasing Quality engineers Designers Legal staff Production Abbrev MRKT R&D ENG PURCH QUAL DESIGN LEGAL PROD 10 2 Bunun Hourly rate $ 80/hr $ 80/hr $100/hr $ 80/hr $ 8hr $ 60/hr $120/ht $ 60/hr 20 Include a Gantt chart with the schedule table after leveling outside of slack. Note: No splitting of activities is allowed. Note: No partial assignments (1.6., 50 percent). All tesources must be assigned 100 percent m Part 3 Top management has accepted the July 19th completion schedule created at the end of Part 2. Prepare a brief memo that addresses the following questions: 1. How much will the project cost? What is the most expensive activity? 2. What does the cash flow statement tell you about how costs are distributed over the life span of the project? Include a monthly cash flow for the project. Once you are confident that you have the final schedule, save the file as a base- line. Hint: Save a backup file just in case without baseline