must be used using solver

L22 X fo K E D B H F G A software company is trying to determine which of 36 program ideas it should develop and release this year. 1 The table below gives the following information about each program: 2 - Projected revenue and costs 3 Hours required to code 4 Whether the program is geared towards accountants (indicated by a 1) The company has up to 8,500 coding hours they can utilize this year and must publish at least four software programs geared towards accountants. Use Solver to determine which programs the company should develop for the company to maximize profit. 5 6 7 thousands B Cost Program Coding hours Profit Revenue Accounting software 1 9 911 177.98 29.15 1 -148.83 10 2 266 47.88 99.52 1 51.64 3 71 418 83.24 94.19 1 10.95 4 535 12 104.3 1 85.76 -18.54 S 359 13 78.62 1 68.98 -9.64 6 14 391 76.38 1 41.78 -34.60 15 7 212 56.16 96.97 1 40.81 16 8 259 50.62 68.20 1 17.58 17 9 678 130.04 71.32 1 -58.72 18 10 723 142.14 91.55 1 50.59 19 11 395 40.55 60.82 0 20.27 20 12 527 53.43 186.35 0 132.92 21 13 857 81.13 174.39 0 93.26 22 14 789 80,01 129.90 0 49.89 23 15 647 66.23 8.59 0 457.64 24 16 210 18.9 32.28 0 13.38 25 17 769 71.21 38.72 0 -32.49 26 18 73.36 158.37 O 25.01 27 19 583 61.47 114.70 0 123.23 28 897 10.73 0 52,30 29 21 789 72.01 63.63 O 30 22 293 27.87 105.87 0 78.50 31 23 455 45.95 174.76 0 128.81 32 24 262 30.58 116.21 0 85.63 25 424 41.16 157.58 0 116.42 34 26 798 78.82 3.07 75.75 15 151.72 0 70.90 O 0 95 SE 151.72 41.24 136 0 8 168 417 42-4 03 796 0 0 27 28 30 31 32 33 34 31 39 0.82 18.12. 38.53 45.56 0.27 2.64 18:31 36.29 62.87 B3.17 www 0.90 25.12 9.17 - 36.43 54.42 -2. -4.1.03 52.77 75.08 -24 Ep1 10.13 126.9 59.8 B 99.06 138.95 56,03 459 361 3 913 0 0 6 0 0 36