Question: SOLVE IT USING EXCEL DATA SOLVER LINEAR PROGRAMMING AND WRITE DOWN CONSTRAINTS if you can upload your excel file it would be good Problem 1

SOLVE IT USING EXCEL DATA SOLVER LINEAR PROGRAMMING AND WRITE DOWN CONSTRAINTS

if you can upload your excel file it would be good

SOLVE IT USING EXCEL DATA SOLVER LINEAR

Problem 1 A congressman of United States is responsible for allocation of $250000 for programs and projects in his district. 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 staff's estimates of the expected number of votes gained per dollar spent for the various programs are as follows. Program Votes/$ Job training 0.08 Parks 0.06 Sanitation 0.03 Mobile library 0.03 In order also to satisfy several local influential citizens who financed his election, he is obliged to observe the following guidelines. None of the programs can receive more than 45% and less than 4% of the total allocation. The amount allocated to sanitation can not exceed the total allocated to the parks and mobile library programs. The amount allocated to job training must at least equal the amount spent on the sanitation. What is the maximal expected number of votes the congressman can gain by distributing the money among the programs? (The answer can be fractional)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!