Problem set based on the book: Managerial Decision Modeling with Spreadsheets by Nagraj Balakrishnan, Barry Render & Ralph M. Stair, JR.
*Problems maybe answered in any Microsoft Office format ie Word, Excel, etc*
1) A certification program consists of a series of activities that must be accomplished in a certain order. The activities, their immediate predecessors, and estimated durations appear in the following table (see attachment labeled 'problem 12.jpg'
(a) Develop a project network for the certification program.
(b) Determine the EST, EFT, LST, LFT, and slack for each activity. Also determine the total program completion time and the critical path(s).
2) The Pickett Marketing Firm is developing a new Web-based media campaign for a client. The following table describes the relationships between the activities that need to be completed (see attachment labeled 'problem 14.jpg').
(a) Develop a project network for this problem.
(b) Determine the EST, EFT, LST, LFT, and slack for each activity. Also determine the total project completion time and the critical path(s).
3) An office complex is to be renovated. Before the job can be completed, various tradespeople and skilled workers must install their materials. The table describes the relationships between the activities that need to be completed (see attachment labeled 'problem 16.jpg').
(a) Develop a project network for this problem.
(b) Determine the EST, EFT, LST, LFT, and slack for each activity. Also determine the total project completion time and the critical path(s).