This case is based on Chapter 15, Case 15.3 which is found on Page 15-50. Remember, this reading material is not included in the textbook. Please refer to the Cengage Brain website. Read the problem carefully.

On the tab labeled "Solutions", there are 5 questions about the problem that will require you to either make an input to the Excel file model or interpret the results of the model upon entering the required information. You will also be required to validate your responses using Microsoft Project. Each question is worth 16 points: 8 points for producing the correct technical information and 8 points for a clear, concise, grammatically answer to the question. Questions should be answered on the "Solutions" tab and typed in unboldedblack fontright after the statement of the question.


Forward Pass Backwards Pass

Activity Description Predecessors Days Req'd EST EFT LST LFT Slack

A Collect Info

B Prototype

C Marketing Program

D Instructions

E Design Packaging

F Get Approval

G Training

H Info Guide

I Hire Actors

J POS Racks

K Finish G,H,I,J 0


Question 1 (16 Points) On the tab labeled "CPM Network", you will find a skeleton AON network model for Case 15.3. The layout includes the activities required to complete the project discussed in the case. Based on the reading of the problem, enter the arcs (lines) to connect the activities according to the problem. In the model you will note I left a single arc (line) for you. You may copy/paste this as many times as required to assemble your model. You can adjust the slope and length of the line as required by clicking your mouse on the line itself. Do not change any other formatting in the CPM Network tab, just enter the arcs according to the statement of the problem. In the network model I have provided on the CPM Network tab, what do the lines you entered represent?

Question 2 (16 Points) On the tab labeled "CPM Calculation" you will find a matrix where I have listed the activities for the project. By reading the problem carefully, enter the predecessors and the associated durations (Days Required) for each task. Do not change the predecessors I have entered for the "Finish" activity. What is the definition of a predecessor?

Question 3 (16 Points) On the tab labeled "CPM Calculation" complete the calculations necessary to show the early start (EST) and early finish (EFT) times for each activity. Please note the spreadsheet is not set up with formulas for calculations; you must manually complete these calculations and enter the appropriate values in the spreadsheet. What is the duration of the project?

Question 4 (16 Points) On the tab labeled "CPM Calculation" complete the calculations necessary to show the late finish (LFT) and late start (LST) times for each activity. Please note the spreadsheet is not set up with formulas for calculations; you must manually complete these calculations and enter the appropriate values in the spreadsheet. Does the duration of the project differ from the duration found in the forward pass?

Question 5 (16 Points) After completing Questions 3 and 4, go back to the "CPM Calculation" tab and in the Critical Path column (column J), compute the slack for each activity. What activities are on the critical path? Using the information you have assembled in the "CPM Calculation" tab, enter this information in Microsoft Project. On Line 1 of your Project file, title this summary task as Case 15.3 Duration and ensure all subsequent tasks are entered as subtasks (indented). Do the critical path and duration match what you calculated here in the Excel file?