Question

In: Operations Management

NOT using Excel, please show all steps. A bank is planning to install a new computerized...

NOT using Excel, please show all steps.

A bank is planning to install a new computerized accounts system. Bank management has determined the activities required to complete the project, the precedence relationships of the activities, and activity time estimates as follows: NOT using Excel, please show all steps.

Activity

Description

Predecessor

a

m

b

a

Position recruiting

5

8

17

b

System development

3

12

15

c

System training

a

4

7

10

d

Equipment training

a

5

8

23

e

Manual system test

b, c

1

1

1

f

Preliminary system changeover

b, c

1

4

13

g

Computer-personnel interface

d, e

3

6

9

       h               Equipment                       d, e                 1          2.5              7

                      modification

       i               Equipment                       h                     1           1                1

                          testing

       j               System                            f, g                  2            2               2

                    debugging and

                      installation

      k             Equipment                         g, i                  5            8              11

                      changeover

a. Draw the precedence diagram.

b. Determine the earliest and latest activity times, the expected completion time and standard     

    deviation.

c. What is the probability that the project will be completed in 40 weeks or less?

d. The following table provides the crash data for the project network. The normal activity times are

     considered to be deterministic and not probabilistic.

                          Activity Time (weeks) Activity Cost ($)

Activity

Normal

Crash

Normal

Crash

a

9

7

4,800

6,300

b

11

9

9,100

15,500

c

7

5

3,000

4,000

d

10

8

3,600

5,000

e

1

1

0

0

f

5

3

1,500

2,000

g

6

5

1,800

2.000

h

3

3

0

0

i

1

1

0

0

j

2

2

0

0

k

8

6

5,000

7,000

Crash the network the maximum amount, indicate how much it would cost the bank, and identify the new critical path(s).

Solutions

Expert Solution


Related Solutions

The Farmer’s American Bank of Leesburg is planning to install a new computerized accounts system. Bank...
The Farmer’s American Bank of Leesburg is planning to install a new computerized accounts system. Bank management has determined the activities required to complete the project, the precedence relationships of the activities, and activity time estimates as follows: TIME ESTIMATES (WEEKS) ACTIVITY DESCRIPTION ACTIVITY PREDECESSOR a m b A Position recruiting — 5 8 17 B System development — 3 12 15 C System training A 4 7 10 D Equipment training A 5 8 23 E Manual system test...
M5_A2. The Mountaineers American Bank of Carolina is planning to install a new computerized accounts system....
M5_A2. The Mountaineers American Bank of Carolina is planning to install a new computerized accounts system. Bank management has determined the activities required to complete the project, the precedence relationships of the activities, and the activity time estimates, as shown in the table below. activity optim time (a) most likely time (m) pessim time (b) immediate Pred A 5 8 17 --- B 3 12 15 --- C 4 7 10 A D 5 8 23 A E 1 1...
Question 3 The Consolidated Bank of Ghana (CBG) is planning to install a new computerized accounts...
Question 3 The Consolidated Bank of Ghana (CBG) is planning to install a new computerized accounts system. Bank management has determined the activities required to complete the project, the precedence relationships of the activities, and activity time estimates as follows: Time Estimates (weeks) Activity Description Predecessor a m b A Position Recruiting - 5 8 17 B System Development - 3 12 15 C System Training A 4 7 10 D Equipment training A 5 8 23 E Manual System...
Please show all steps using data set below and excel. By using a bivariate regression trend...
Please show all steps using data set below and excel. By using a bivariate regression trend line model, forecast total houses sold for the next five years. Prepare a time series plot of these data (years are on the x axis, THS is on the y axis) that shows both actual and forecast THS for the next five years. Total Houses Sold Year Northeast 1996         74.00 1997         78.00 1998         81.00 1999         76.00 2000         71.00 2001...
Please show formulas using excel Build a spreadsheet: Construct an Excel spreadsheet to solve all of...
Please show formulas using excel Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements. Show how the solution will change if the following data change: the April 1 work-in-process costs were $66,000 for direct material and $18,000 for conversion. Work in process, April 1—10,000 units: Direct material: 100% complete, cost of .........................................................................................................$ 22,000 Conversion: 20% complete, cost of ................................................................................................................. 4,500 Balance in work in process, April 1 ..................................................................................................................$  26,500 Units started during April ......................................................................................................................................100,000 Units...
PLEASE COMPLETE IN EXCEL AND SHOW ALL STEPS AND EXCELL EQUATIONS USED In our class example,...
PLEASE COMPLETE IN EXCEL AND SHOW ALL STEPS AND EXCELL EQUATIONS USED In our class example, I simplified the “annuity” prize option by assuming level, equal annual payments. Actually, this annuity prize option us now on an annuitized prize payment schedule with 30 beginning of year payments that start at a lower amount with each successive payment being 5% higher than the previous annual payment. The sum of these 30 annuitized payments equal the announced estimated jackpot amount with a...
Please solve using EXCEL SOLVER and show steps 1 – A company requires during the next...
Please solve using EXCEL SOLVER and show steps 1 – A company requires during the next four months, respectively, 50, 65, 100, and 70 units of a commodity (no backlogging is allowed). Production costs are $5, $8, $4, and $7 per unit during these months. The storage cost from one month to the next is $2 per unit (assessed on ending inventory). It is estimated that each unit on hand at the end of month 4 could be sold for...
***PLEASE SHOW ALL ANSWERS, FORMULAS, STEPS DONE THROUGH EXCEL!!!*** Joey is on a diet. Daily, she...
***PLEASE SHOW ALL ANSWERS, FORMULAS, STEPS DONE THROUGH EXCEL!!!*** Joey is on a diet. Daily, she needs three dietary supplements, A, B and C as follows: at least 32 units of A, 30 units of B, and 40 units of C. These can be found in either of two marketed products Squabb I and Squabb II. The Squabb I pill cost $1.50 and the Squabb II pill costs $12.25. How many of each pill should Joey buy to satisfy her...
Please answer all parts of the question. Please show all work and all steps. 1a.) Show...
Please answer all parts of the question. Please show all work and all steps. 1a.) Show that the solutions of x' = arc tan (x) + t cannot have maxima 1b.) Find the value of a such that the existence and uniqueness theorem applies to the ivp x' = (3/2)((|x|)^(1/3)), x(0) = a. 1c.) Find the limits, as t approaches both positive infinity and negative infinity, of the solution Φ(t) of the ivp x' = (x+2)(1-x^4), x(0) = 0
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a polling station at an average of 4 per minute (Poisson) where the service rate is 50 per hour (Poisson). a. What is the average number of voters in the system with 5 voter booths? (10 pts) b. What is the minimum number of voting booths needed to keep the average time in the system under three minutes? (10 pts) PLEASE SHOW ALL WORK IN...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT