Question: please solve using excel solver tool As a result of a recently passed bill, a congressman's district has been allocated $4 million for programs and
please solve using excel solver tool
As a result of a recently passed bill, a congressman's district has been allocated $4 million for programs and projects. It is up to the congressman to decide how to distribute the money. The congressman has decided to allocate the money to four ongoing programs because of their importance to his district - a job training program, a parks project, a sanitation project, and a mobile library. However, the congressman wants to distribute the money in a manner that will please the most voters, or, in other words, gain him the most votes in the upcoming election. His staffs estimates of the number of votes gained per dollar spent for the various programs are as follows: In order also to satisfy several local influential|citizens who financed his election, he is obligated to observe the following guidelines: - None of the programs can receive more than 38% of the total allocation. - The amount allocated to parks cannot exceed the total allocated to both the sanitation project and the mobile library. - The amount allocated to job training must at least equal the amount spent on the Sanitation project Any money not spent in the district will be returned to the government; therefore, the congressman wants to spend it all. The congressman wants to know the amount to allocate to each program to maximize his votes. (a) Formulate a linear programming model for this problem. (b) Solve the model using Excel

Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
