Questions from Spreadsheet Modeling


Q: Consider the CPM network for the following set of activities:

Consider the CPM network for the following set of activities: Is it necessary to draw an arc from the node for activity A to the node for activity C? Why or why not?

See Answer

Q: Consider the following set of activities: / a

Consider the following set of activities: a. Draw the CPM network for this problem. b. Manually determine the earliest and latest start and finish times for each activity and the amount of slack for...

See Answer

Q: Consider the following set of activities: / a

Consider the following set of activities: a. Draw the CPM network for this problem. (Remember that a CPM network requires unique start and finish nodes.) b. Manually determine the earliest and latest...

See Answer

Q: Consider the following set of activities: / a

Consider the following set of activities: a. Draw the CPM network for this problem. b. Identify each path through the network and its expected length. c. What is the critical path?

See Answer

Q: Consider the following set of activities: / a

Consider the following set of activities: a. Draw the CPM network for this problem. b. Create a spreadsheet to calculate and summarize the earliest and latest start and finish times, the slack for ea...

See Answer

Q: The following data summarizes the per-day cost of crashing the

The following data summarizes the per-day cost of crashing the activities in the problem described in the previous question. a. Create an LP model to determine the least costly way of crashing the pr...

See Answer

Q: Refer to question 23 at the end of Chapter 2. Implement

Refer to question 23 at the end of Chapter 2. Implement a spreadsheet model for this problem and solve it using Solver Data from question 23 chapter 2: Zippy motorcycle manufacturing produces two po...

See Answer

Q: Refer to question 24 at the end of Chapter 2. Implement

Refer to question 24 at the end of Chapter 2. Implement a spreadsheet model for this problem and solve it using Solver. Data from question 24 chapter 2: The Quality Desk Company makes two types of...

See Answer

Q: Refer to question 25 at the end of Chapter 2. Implement

Refer to question 25 at the end of Chapter 2. Implement a spreadsheet model for this problem and solve it using Solver. Data from question 25 chapter 2: A farmer in Georgia has a 100-acre farm on wh...

See Answer

Q: In a summer plagued by drought and heat, many Southern crops

In a summer plagued by drought and heat, many Southern crops are withering in the fields, taking farmers’ profits down with them. Some farmers are fighting to break even. But others have had to give u...

See Answer