Questions from Spreadsheet Modeling


Q: Aerobatic, Inc. custom designs and manufactures light aircraft. The

Aerobatic, Inc. custom designs and manufactures light aircraft. The activities involved in this process are summarized in the following table. a. Draw the activity network for this problem. b. Create...

See Answer

Q: A software company is moving its helpdesk operations center from Newark,

A software company is moving its helpdesk operations center from Newark, New Jersey to Plano, Texas. Some of its employees will be moved to Plano and others will be terminated and replaced by new work...

See Answer

Q: Linda Madison owns Creations, a business that provides hair and nail

Linda Madison owns Creations, a business that provides hair and nail care services in a small college town. Recently, Linda has decided to expand her business to include tanning and massage services f...

See Answer

Q: Refer to the previous question. Suppose that Linda’s lease on her

Refer to the previous question. Suppose that Linda’s lease on her current facility expires in 20 days. The normal and crash times and costs for each activity in her moving project ar...

See Answer

Q: The activities required to service a car at Zippy-Lube can

The activities required to service a car at Zippy-Lube can be viewed as a mini-project as summarized in the following table. The variability in the time required to perform each activity is due to th...

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 servicing cars. Assume that activity times follow a triangular distribution, and perform 500 replication...

See Answer

Q: Koene Technology is a rapidly growing nanotechnology firm. The company is

Koene Technology is a rapidly growing nanotechnology firm. The company is moving into a new building that will allow it more research lab space and improved computing facilities. The lease on the new...

See Answer

Q: I hope this goes better than last time,” thought Craig Rooney

I hope this goes better than last time,” thought Craig Rooney as he thought about having to walk into the city council’s chambers next week. Craig is the assistant chief of police in Newport, VA and,...

See Answer

Q: Refer to the previous question. Suppose a partner in Koene Technology

Refer to the previous question. Suppose a partner in Koene Technology does not believe the time estimates for each activity can be specified with certainty. Instead, he prefers to specify a minimum, 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 Koene’s move. Assume that activity times follow a triangular distribution and perform...

See Answer