Question $7.[$Submit answer on spreadsheet tab $"$Q$7."]$ Ignore Q$6.$ A product mix!? The Presi$$dent of the Print Division would like to grow the business into $3$ different print products using the exiting capacity indicated in Table $2.$ In addition to the demand forecast for $78$ textbook titles next year, she sees demand for $45$ new "paperback" titles next year as well as $20$ "journal" titles$3$ The process to produce any of the $3$ products is identical to that indicated in Table $1$ and Figure $1,$ except that the unit loads $($i$.$e$.,$ flow times$)$ are significantly less for paperbacks and jour$$nals$.$ The estimated unit loads for the proposed new products are given in Table $3.$ Contribution margins$4$ for each type of title $-$ a measure of unit profits $-$ and the demand for each title are summarized at the bottom of Table $3.$ Note that the unit loads for outsourced activities are not available at this time, so ignore them in the analysis. With the internal resources shown in Table $2,$ there is not enough capacity to produce all $78+45+20=143$ titles of these three products. How many of each of the three products should you produce to maximize annual contribu$$tion margin, considering the internal process capacity? $($ Hint: I will give fill credit for any feasible solution to this question. However, any student$/$team who submits a spreadsheet showing the Solver solution that proves the optimal annual product mix will get $5$ bonus points.$)$