I need help figuring out what to plug into the solver on excel. (must use solver to answer) thanks!

A B C D E F Income Statement \begin{tabular}{|l|l|r|r|r|r|r|} \hline 14 & & & & & & \\ 15 & Fixed Expenses & Regular & High Flyer & Tournament & Supreme & Total \\ \hline 16 & Insurance and maintenance & $3,000.00 & $5,000.00 & $6,000.00 & $10,000,00 & $24,000.00 \\ \hline 17 & Other Overhead & $6,000.00 & $8,500.00 & $12,000.00 & $18,000.00 & $44,500.00 \\ \hline 18 & Advertising & $1,000.00 & $1,000.00 & $1,000.00 & $1,000.00 & $4,000.00 \\ \hline 19 & Total & $10,000.00 & $14,500.00 & $19,000.00 & $29,000.00 & $72,500.00 \\ \hline \end{tabular} 20 21 Income Summary \begin{tabular}{|r|r|} \hline 22 & Total Revenue \\ \hline 23 & Total Expenses \\ \hline \end{tabular} 23 Total Expenses 24 Net Income 25 \begin{tabular}{|r|r|r|r|c|} \hline \multicolumn{1}{|c|}{ Regular } & High Flyer & Tournament & \multicolumn{1}{c|}{ Supreme } & \multicolumn{1}{c|}{ Total } \\ \hline$27,664.60 & $45,107.67 & $46,929.21 & $38,572.28 & $158,273.76 \\ \hline$22,679.61 & $39,309.22 & $53,414.75 & $55,518.44 & $170,922.02 \\ \hline$4,984.99 & $5,798.45 & ($6,485.54) & ($16,946.16) & ($12,648.26) \\ \hline \end{tabular} what should be spent on advertising for each disk type in order to maximize the Net Income for the whole company (i.e., for Disks, Inc.)? The constraints are as follows. The total advertising budget is limited to $15000 and the company wants to spend at least $2000 towards promoting each disk type. But, the company can only make a maximum of 5000 Supreme disks to sell. Mr. Smith also wants none of the individual disk types to make a loss. a. What is the amount spent on advertising for each disk type? (6 points) b. What is the number of units produced to cover demand for High Flyer disks? (6 points) c. What is the net income for Tournament disks? (6 points) d. What is number of units sold based on advertising for Supreme disks? (6 points) e. What Excel feature did you use to answer these questions? (2 points)