Description of this paper

Loading

I want the answer for this question to be done by the excel file-(Answered)

Description

Instant Solution ? Click "Buy button" to Download the solution File


Question

I want the answer for this question to be done by the excel file formulas:

  • Joseph King has ambitions to be mayor of Williston, North Dakota. Joe has determined the breakdown of the steps to the nomination and has estimated normal and crash costs and times for the campaign as follows (times are in weeks).

Normal

Crash

Immediate

Activity

Time

Cost

Time

Cost

Predecessors

A.

Solicit Volunteers

6

$5,000

4

$? 9,000

---

B.

Initial "Free" Exposure

3

$4,000

3

$? 4,000

---

C.

Raise Money

9

$4,000

6

$10,000

A

D.

Organize Schedule

4

$1,000

2

$? 2,000

A

E.

Hire Advertising Firm

2

$1,500

1

$? 2,000

B

F.

Arrange TV Interview

3

$4,000

1

$? 8,000

B

G.

Advertising Campaign

5

$7,000

4

$12,000

C,E

H.

Personal Campaigning

7

$8,000

5

$20,000

D,F

Joe King is not a wealthy man and would like to organize a 16-week campaign at minimum cost.

  • 1- Draw a network diagram
  • 2- Write and solve a linear program to accomplish this task.
  • 3- Solve the model and find the solution

 

Paper#9209470 | Written in 27-Jul-2016

Price : $19
SiteLock