***PLEASE SOLVE IN EXCEL AND DO NOT JUST COPY THE ANSWER FROM OTHERS, THEY ARE ALL WRONG***

A software-support division of Blain Information Services has eight projects that can be performed. Each project requires different amounts of development time and testing time. In the coming planning period, 1,150 hours of development time and 900 hours of testing time are available, based on the skill mix of the staff. The internal transfer price (revenue to the support division) and the times required for each project are shown in the table. Which projects should be selected to maximize revenue?

\begin{tabular}{|l|c|c|c|} \hline Project & Development Time & Testing Time & Transfer Price \\ \hline 1 & 80 & 67 & $23,520 \\ \hline 2 & 248 & 208 & $72,912 \\ \hline 3 & 41 & 180 & $62,054 \\ \hline 4 & 10 & 92 & $32,340 \\ \hline 5 & 240 & 202 & $70,560 \\ \hline 6 & 195 & 164 & $57,232 \\ \hline 7 & 269 & 226 & $19,184 \\ \hline 8 & 110 & 92 & $32,340 \\ \hline \end{tabular}