Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A software company is trying to determine which of 36 program ideas it should develop and release this year. The table below gives the following
A software company is trying to determine which of 36 program ideas it should develop and release this year. The table below gives the following information about each program: - Projected revenue and costs - Hours required to code -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. Coding Hours Used 3830 Program Coding hours 1 2 3 4 5 6 7 8 Ooo thousands Cost Revenue Accounting software 911 177.98 29.15 1 266 47.88 99.52 1 418 83.24 94.19 1 535 104.3 85.76 1 359 78.62 68.98 1 391 76.38 41.78 1 212 56.16 96.97 1 259 50.62 68.20 1 678 130.04 71.32 1 723 142.14 91.55 1 395 40.55 60.82 527 53.43 186.35 857 81.13 174.39 789 80.01 129.90 0 66.23 8.59 210 18.9 32.28 769 71.21 38.72 804 73.36 158.37 583 61.47 184.70 897 80.73 133.53 789 72.01 63.63 293 27.37 105.87 455 45.95 174.76 262 30.58 116.21 0 424 41.16 157.58 798 78.82 3.07 798 80.82 151.72 168 18.12 44.24 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 647 OOOOOOOOO OOOO A B G H K L Coding Hours Used 383067 1 Program Coding hours 1 2 3 4 1 1 5 6 7 1 8 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 1 1 1 D E F thousands Cost Revenue Accounting software 911 177.98 29.15 1 266 47.88 99.52 1 418 83.24 94.19 1 535 104.3 85.76 1 359 78.62 68.98 1 391 76.38 41.78 1 212 56.16 96.97 1 259 50.62 68.20 1 678 130.04 71.32 1 723 142.14 91.55 1 395 40.55 60.82 0 527 53.43 186.35 0 857 81.13 174.39 0 789 80.01 129.90 0 647 66.23 8.59 0 210 18.9 32.28 0 769 71.21 38.72 0 804 73.36 158.37 0 583 61.47 184.70 0 897 80.73 133.53 0 789 72.01 63.63 0 293 27.37 105.87 0 455 45.95 174.76 0 262 30.58 116.21 0 424 41.16 157.58 0 798 78.82 3.07 0 798 80.82 151.72 0 168 18.12 44.24 0 417 38.53 136.70 0 484 46.56 10.13 0 703 70.27 124.69 796 72.64 69.87 459 48.31 4.28 381 36.29 99.06 643 62.87 138.95 913 83.17 58.63 27 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 OOOOOO
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started