The problem for the R&D group is to generate the maximum level of potential profit from its limited expense budget and its available programmers. What Games should be selected and what is the maximum level expected profit?

Provide the complete linear programing formulation. Clearly specify decision variables, objective function and constraints.

Create a spreadsheet model for the problem and use Solver to find the optimal solution. Separate input data from calculations. Include all the input data provided in the Word problem and use Excel to perform calculations.

Provide a screenshot of the model. Use =FORMULATEXT to show the calculation for the objective function and the left hand side of the constraints.

Provide a screenshot of the Answer Report including the top section with the log from Solver.

What Games should be selected for development? What is the maximum expected profit? Communicate the recommendation in plain English. It is acceptable to use tables for clarity.