spreed sheet

spreed sheet Order Description This task requires candidates to prepare a program evaluation and review technique (PERT) chart and apply critical path method (CPM) techniques. Scenario: Company A is in" rel="nofollow">installin" rel="nofollow">ing a web-based customer feedback system to meet customer needs for quick response when rollin" rel="nofollow">ing out new products. A new product lin" rel="nofollow">ine is rollin" rel="nofollow">ing out in" rel="nofollow">in 48 weeks, and the customer feedback system must be in" rel="nofollow">installed and runnin" rel="nofollow">ing in" rel="nofollow">in time for the new product launch. Table 1.1 in" rel="nofollow">in the attached “QAT1 Task 4 Spreadsheet” shows three estimates of the time it will take Company A to complete each of the project activities in" rel="nofollow">in the customer feedback system project: optimistic, probable, and pessimistic. Company B is in" rel="nofollow">installin" rel="nofollow">ing a similar feedback system to accompany a new product lin" rel="nofollow">ine and just announced that its new product lin" rel="nofollow">ine is ahead of schedule and will be launched in" rel="nofollow">in 45 weeks. Because the web-based customer feedback system must be in" rel="nofollow">installed and runnin" rel="nofollow">ing in" rel="nofollow">in time for the revised date of the product launch in" rel="nofollow">in 45 weeks, somethin" rel="nofollow">ing must be done to shorten implementation time required for the customer feedback system project. Refer to Table 1.2 in" rel="nofollow">in the attached “QAT1 Task 4 Spreadsheet” that lists the time it will take to complete the activities usin" rel="nofollow">ing normal resources (normal time), the expected time it will take to complete the activities if shortened as much as possible (crash time), the cost to complete the activity usin" rel="nofollow">ing normal resources (normal cost), and the cost of completin" rel="nofollow">ing the activity on an accelerated basis (crash cost). A. Use the estimates for Company A in" rel="nofollow">in Table 1.1 from the attached “QAT1 Task 4 Spreadsheet” to do the followin" rel="nofollow">ing: 1. Determin" rel="nofollow">ine the expected completion time for each of the nin" rel="nofollow">ine project activities. a. Include all your answers for part A1 in" rel="nofollow">in Table 1.1, showin" rel="nofollow">ing all of your work for one activity. 2. Determin" rel="nofollow">ine the variance for each of the nin" rel="nofollow">ine project activities. a. Include all your answers for part A2 in" rel="nofollow">in Table 1.1, showin" rel="nofollow">ing all of your work for one activity. 3. Develop a PERT chart showin" rel="nofollow">ing the network diagram with the activities and their expected times. a. Identify the critical path. Note: Any additional numbers (e.g. start and fin" rel="nofollow">inish times) in" rel="nofollow">included in" rel="nofollow">in the PERT chart will not be evaluated for correctness. Note: If you don’t have software to build a PERT chart, use text boxes and lin" rel="nofollow">ines with arrows in" rel="nofollow">in a word processin" rel="nofollow">ing program or a spreadsheet program. 4. Determin" rel="nofollow">ine the value of each of the followin" rel="nofollow">ing, showin" rel="nofollow">ing all of your work or reasonin" rel="nofollow">ing: a. expected duration of the entire project, showin" rel="nofollow">ing all of your work or reasonin" rel="nofollow">ing. b. slack for project Activity E, showin" rel="nofollow">ing all of your work or reasonin" rel="nofollow">ing. c. slack for project Activity C, showin" rel="nofollow">ing all of your work or reasonin" rel="nofollow">ing. d. earliest start time for project Activity F, showin" rel="nofollow">ing all of your work or reasonin" rel="nofollow">ing. e. latest fin" rel="nofollow">inish time for project Activity G, showin" rel="nofollow">ing all of your work or reasonin" rel="nofollow">ing. Note: Work or reasonin" rel="nofollow">ing must be in" rel="nofollow">included along with each response for credit. Referencin" rel="nofollow">ing a value in" rel="nofollow">in the PERT chart is not considered showin" rel="nofollow">ing work. Please explain" rel="nofollow">in how each value was determin" rel="nofollow">ined. 5. Determin" rel="nofollow">ine the probability of completin" rel="nofollow">ing this project in" rel="nofollow">in time for the product launch in" rel="nofollow">in 48 weeks, showin" rel="nofollow">ing all of your work. Note: you may want to use, with appropriate citation, the "Fin" rel="nofollow">indin" rel="nofollow">ing Probabilities from Z-Scores." Web lin" rel="nofollow">ink below. B. Use the data for Company B in" rel="nofollow">in Table 1.2 from the attached “QAT1 Task 4 Spreadsheet” to do the followin" rel="nofollow">ing: 1. Determin" rel="nofollow">ine the maximum reduction in" rel="nofollow">in time for each of the ten project activities. a. Include your answers for part B1 in" rel="nofollow">in Table 1.2, showin" rel="nofollow">ing all of your work for one activity. 2. Determin" rel="nofollow">ine the crash cost per week for each of the ten project activities. a. Include your answers for part B2 in" rel="nofollow">in Table 1.2, showin" rel="nofollow">ing all of your work for one activity. C. Use your results from part B (i.e., Table 1.2, given PERT diagram, activities L-U) to do the followin" rel="nofollow">ing: 1. Identify the activities, considerin" rel="nofollow">ing all paths, to be crashed to meet the followin" rel="nofollow">ing criteria: • completion of the project within" rel="nofollow">in 22 weeks • achievement of the lowest possible cost 2. Determin" rel="nofollow">ine the number of weeks each of the activities identified in" rel="nofollow">in part C1 should be crashed. 3. Determin" rel="nofollow">ine the sum of the in" rel="nofollow">individual costs of crashin" rel="nofollow">ing each activity identified in" rel="nofollow">in part C1. D. When you use sources, in" rel="nofollow">include all in" rel="nofollow">in-text citations and references in" rel="nofollow">in APA format.