MGMT430 Chapter 15-Case 15.3

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 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?

-
Rating:
5/
Solution: MGMT430 Chapter 15-Case 15.3