#### Description of this paper

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

Description

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 : \$22