Submit an Excel file for this homework.

Question $1($Hybrid of Product Mix and Investment & Marketing Problem$)$:

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 staff's estimates of the number of votes

gained per dollar spent for the various programs are as follows: