Questions from Spreadsheet Modeling


Q: Throughout this chapter, we assumed that a project manager identifies and

Throughout this chapter, we assumed that a project manager identifies and organizes the activities in a project, estimates the time required for each activity, then determines how quickly the project...

See Answer

Q: A national accounting firm has identified the following set of activities that

A national accounting firm has identified the following set of activities that must occur to carry out an audit for one of their major clients a. Draw the CPM network for this problem. b. Create a sp...

See Answer

Q: Refer to the previous question. Suppose that each of the audit

Refer to the previous question. Suppose that each of the audit activities can be crashed by the amounts indicated in the following table. a. What is the earliest the audit could be completed and what...

See Answer

Q: A partner in the national accounting firm mentioned in the previous questions

A partner in the national accounting firm mentioned in the previous questions does not believe the time estimates for each activity can be specified with certainty. Instead, she prefers to specify a m...

See Answer

Q: Refer to the previous question. Create a spreadsheet model to simulate

Refer to the previous question. Create a spreadsheet model to simulate the completion times for the auditing project. Assume that activity times follow a triangular distribution and perform 500 replic...

See Answer

Q: The activities summarized in the following table must be performed by the

The activities summarized in the following table must be performed by the promoter of a country music concert in Dallas. a. Draw the activity network for this problem. b. According to PERT, what is t...

See Answer

Q: A cosmetics company has identified a set of activities that must be

A cosmetics company has identified a set of activities that must be performed in order to bring a new product to market. The activities, their precedence relations, and time estimates to complete each...

See Answer

Q: Refer to the previous problem. Suppose that the maximum time listed

Refer to the previous problem. Suppose that the maximum time listed for each activity is actually its normal completion time. Further assume that the maximum number of crash days per activity and cost...

See Answer

Q: Anyone who has suffered with an acute or chronic illness is probably

Anyone who has suffered with an acute or chronic illness is probably very appreciative for whatever drugs are available to cure or manage the disease. In the United States, the Food and Drug Administr...

See Answer

Q: In illustrating how to simulate an activity network, we used a

In illustrating how to simulate an activity network, we used a triangular distribution based on three time estimates to generate random activity times. What problem might be encountered if we assume t...

See Answer