Time

X

Scope Cost

X

X

$*$ Cliff Gray, Erik Larson, & Pinyarat Sirisomboonsuk, doctoral candidate at Rawls College of Business, Texas Tech University.

Constrain Enhance Accept

$616$

Appendix $2$ Computer Project Exercises $617$ Connor Gage, the project manager, has formed his project team and the members

have come up with the following work breakdown structure.

$1\mathrm{.}0$ POM$+$Project

$1\mathrm{.}1$ R&D product development

$1\mathrm{.}1\mathrm{.}1$ Need survey $1\mathrm{.}1\mathrm{.}2$ Set product specs $1\mathrm{.}1\mathrm{.}3$ Shelf life report $1\mathrm{.}1\mathrm{.}4$ Nutrition report

$1\mathrm{.}2$ Secure fruit suppliers

$1\mathrm{.}3$ Initial Production

$1\mathrm{.}3\mathrm{.}1$ Equipment rehab $1\mathrm{.}3\mathrm{.}2$ Production trials $1\mathrm{.}3\mathrm{.}3$ Quality trials $1\mathrm{.}3\mathrm{.}4$ Quality metrics $1\mathrm{.}3\mathrm{.}5$ Quality training

$1\mathrm{.}4$ Distribution

$1\mathrm{.}4\mathrm{.}1$ Market testing $1\mathrm{.}4\mathrm{.}2$ Package design $1\mathrm{.}4\mathrm{.}3$ Select distributors

$1\mathrm{.}5$ Legal

$1\mathrm{.}5\mathrm{.}1$ Complete FDA certification $1\mathrm{.}5\mathrm{.}2$ Register trademark

$1\mathrm{.}6$ Prepare product launch

Part $1$

$1.$ Develop the WBS outline using the software available $($save your file$).$

$2.$ Use this file and the information provided below to create a project schedule.

$3.$ The following holidays are observed: January $1,$ Martin Luther King Day $($third Monday in January$),$ Memorial Day $($last Monday in May$),$ July $4$th$,$ Labor Day $($first Monday in September$),$ Thanksgiving Day $(4$th Thursday in November$),$ December $25$ and $26.$

$4.$ If a holiday falls on a Saturday then Friday will be given as an extra day off, and if it falls on a Sunday then Monday will be given off.

$5.$ The project team works eight$-$hour days, Monday through Friday.

$6.$ The project will begin on January $3,2012.$

$7.$ Based on this schedule, submit a memo that answers the following questions:

a$.$ When is the project estimated to be completed? How many working days will it take?

b$.$ What is the critical path?

c$.$ Which activity has the most total slack?

d$.$ How sensitive is this network?

e$.$ Identify two sensible milestones and explain your choice.

$618$ Appendix $2$

Computer Project Exercises

Include the following $($one page$)$ printouts:

$$ A Gantt chart.

$$ A network diagram highlighting the critical path.

$$ A schedule table reporting ES$,$ LS$,$ EF$,$ LF$,$ and slack for each activity.

Hints: Change the timescale to months and weeks. The estimated duration of the project is $135$ days.

Remember: Save your files for future exercises!

The following information has been derived from the WBS$.$ Note that the activity number is what appears in the software with the complete WBS entered.

#$*$ Activity Duration

Predecessor$($s$)$

None $3$

$4$

$45,647,9$

$101112$

$5,615$

$5,67,157,15$

$13,16,17,19$FS $+25$ days, $20$FS $+15$ days

$3$ Need survey

$4$ Set product specs

$5$ Shelf life report

$6$ Nutrition report

$7$ Select fruit suppliers

$9$ Equipment rehab

$10$ Production trials

$11$ Quality trials

$12$ Quality metrics

$13$ Quality training

$15$ Market testing

$16$ Package design

$17$ Select distributors

$19$ Complete FDA certification

$20$ Register trademark

$21$ Prepare product launch

FS $=$ Finish to Start lag

Part $2$

$201510$

$5$

$20$

$30$

$15$

$20$

$5$

$15$

$30$

$15$

$25$

$15$

$5$

$15$

Remember the old saying, $$A project plan is not a schedule until resources are com$-$ mitted.$$ This exercise illustrates this sometime subtle, but important point.

Using your files from Part $1,$ input resources and their costs if you have not already done so$.$ All information is found in Tables A$2\mathrm{.}1$ and A$2\mathrm{.}2.$

Prepare a memo that addresses the following questions:

$1.$ Which if any of the resources are overallocated?

$2.$ Assume that the project is time constrained and try to resolve any overallocation

problems by leveling within slack. What happens?

$3.$ What is the impact of leveling within slack on the sensitivity of the network?

Include a Gantt chart with the schedule table after leveling within slack.

$4.$ Assume the project is resource constrained and resolve any overallocation problems by leveling outside of slack. What happens?

TABLE A$2\mathrm{.}1$

Resource Assignments

TABLE A$2\mathrm{.}2$

Resources Availability and Pay Rates

Appendix $2$

Computer Project Exercises $619$

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 $(400\%),$ MRKT $(200\%)$

R&D $(300\%)$

R&D $(300\%)$

PURCH $(100\%)$

ENG $(1,000\%),$ PROD $(2,000\%)$

PROD $(1,500\%),$ PURCH $(100\%),$ ENG $(1,000\%)$ QUAL $(300\%),$ PROD $(500\%)$

QUAL $(300\%),$ PROD $(100\%)$

QUAL $(300\%),$ PROD $(1,500\%)$

MRKT $(500\%)$

DESIGN $(300\%),$ MRKT $(100\%)$

MRKT $(500\%)$

LEGAL $(300\%)$

LEGAL $(300\%)$

QUAL $(300\%),$ PURCH $(200\%),$ PROD $(1,500\%),$ MRKT $(500\%),$ ENG $(500\%),$ R&D $(100\%)$

Resource

Marketing staff R&D

Engineering Purchasing Quality engineers Designers

Legal staff Production

Abbrev Available

MRKT $5$ R&D $5$ ENG $10$ PURCH $2$ QUAL $3$ DESIGN $3$ LEGAL $3$ PROD $20$

Hourly rate

$ $80/$hr $ $80/$hr $$100/$hr $ $60/$hr $ $80/$hr $ $60/$hr $$120/$hr $ $60/$hr

Include a Gantt chart with the schedule table after leveling outside of slack.

Note: No splitting of activities is allowed.

Note: No partial assignments $($e$.$g$.,50$ percent$).$ All resources mu