Answered step by step
Verified Expert Solution
Question
1 Approved Answer
AAU Press is trying to determine which of 36 books it should publish this year. The data in Problem2 worksheet gives the following information about
- AAU Press is trying to determine which of 36 books it should publish this year. The data in Problem2 worksheet gives the following information about each book:
- Projected revenue and development costs
- Pages in each book
- Whether each book is geared toward an audience of software developers (indicated by a 1 in column E)
AAU Press can publish books totaling up to 8,500 pages this year, and must publish at least 5 books geared toward software developers. How can AAU Press maximize its PROFIT (is profit the same as revenue)? To avoid points to be taken away, please make sure that you set this up so that the constraint can be seen next to data as it is shown in the exercise above (see the figures from the previous page).
Plan Shot 2013 Sanal photo + Add to & Edit & Culo Stur IO I 2 Book 3 4 5 6 7 8 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 37 38 39 40 41 42 Pages Cost Revenue Developer book 1 911 177.98 29.15 1 2 266 47.88 99.52 1 3 418 83.24 94. 19 1 4 535 104.3 85.76 1 1 5 359 78 62 68.98 1 6 391 36 38 41.78 1 7 7 212 56.16 96.97 1 1 8 259 50.62 68.20 1 9 678 130.04 71.32 1 10 723 142 14 91 55 1 11 395 40.55 60.82 0 12 527 53.43 186.35 0 0 13 857 81.13 174.39 0 14. 789 80 01 129.90 0 15 647 66.23 8.59 0 16 210 18.9 32.28 0 0 17 769 71.21 38.72 0 18 804 73 36 158 37 0 19 583 61.47 184.70 0 20 897 80.73 133.53 0 0 21 789 72.01 63.63 0 22 293 2737 105 87 0 23 455 45.95 174.76 0 24 262 30.58 116.21 0 25 424 41.16 157.58 0 26 798 78 82 3.07 0 0 27 798 80.82 151.72 0 28 16B 18.12 44.24 0 29 417 30.53 136.70 0 30 484 46 56 10 13 0 31 703 70.27 124.69 0 32 72.64 69.87 0 33 459 48.31 4.28 0 34 381 36.29 99.06 0 0 35 643 62 87 138.95 0 36 913 83.17 58.63 0 796 Type here to search 22 3:41 PM 734 Rain coming A 2222 7/12/001
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