Enter A B D E F G H Stadium Pricing problem This is the function for attendance (A) based on price (P) You are in charge of pricing seats for a special event in your for the upper level in the form of an Excel equation: stadium. The stadium set-up for this event allows you to =(1-1/(1+exp(2.76-0.1*p)))*27500 charge one price for lower level seats and another for upper level seats. where for "P" in the equation you type in the cell reference where the price is (the price for which you You contracted out the concessions, parking, merchandise, want to find the attendance) etc. for a flat fee - so all you have to worry about is choosing prices that maximize total ticket revenue. This is the function for attendance (A) based on price (P) for the lower level in the form of an Excel equation: Fill in your prices and resulting projections in the blue, =(1-1/(1+exp(5.78-0.1*p)))*22600 yellow and green cells guided by the data provided. where for "P" in the equation you type in the cell reference where the price is ( the price for which you want to find the attendance) Upper level ticket price (P) attendance (A revenue per person (R) 0