Kyle is searching for the solver function but cannot seem to find it anywhere, not even under the Where can't be found?
Iftis not on the ribbon, it has not been activated, Kyle needs to activate it under Add-ins in the Excel Options dialog bol.
It is not under the Data tab because it is a formula, Kyle needs to look under the Formula tab on the ribbon in the Add-ins
group.
It is not a function that is usually displayed on the ribborr, Kyle can add it to the ribbon as a macro function.
Solver is a separate program: Kyle needs to launch it from his operating system's Start menu.

Suppose there are three types of consumers who attend concerts at your university’s performing arts center: students, staff, and faculty. each of these groups has a different willingness to pay for tickets; within each group, willingness to pay is identical. there is a fixed cost of $1,000 to put on a concert, but there are essentially no variable costs. for each concert: i. there are 140 students willing to pay $20. (ii) there are 200 staff members willing to pay $35. (iii) there are 100 faculty members willing to pay $50. a) if the performing arts center can charge only one price, what price should it charge? what are profits at this price? b) if the performing arts center can price discriminate and charge two prices, one for students and another for faculty/staff, what are its profits? c) if the performing arts center can perfectly price discriminate and charge students, staff, and faculty three separate prices, what are its profits?