Dynamic Pricing problem Price of Week 10 ticket by week Variable name Description Lower Lower deck (1 if yes, 0 otherwise) Rival In-state rival (1 if yes, 0 otherwise) Conf Conference opponent (1 if yes, 0 otherwise) Ticket price OneStrk One game winning streak (1 if yes, 0 otherwise TwoStrk Two game winning streak (1 if yes, 0 otherwise) ThreeStrk Three or more game winning streak (1 if yes, 0 otherwise Rain Forecast for rain (1 if yes, 0 otherwise) 1 2 4 5 6 7 8 9 10 Dynamic price of a ticket for your Week 10 game in the weeks leading up to the game Seat in the lower deck. [Data for Column E; same for all weeks.] Week of the season Not your rival, but a conference opponent. [Data for Columns F and G; same for all weeks.] Enter an equation in Column C that calculates the current ticket priced based on the model just below, the data you entered in the blue, orange, and green cells, and the given B's. Current price = Bo + B,Lower + BzRival + B;Conf + B,OneStrk + ByTwoStrk + B;ThreeStrk + B,Rain Bo B1 Bz B3 BA P5 BE B7 30 30 50 20 3 10 20 -25 Current Week price na Lower Rival Conf OneStrk TwoStrk ThreeStrk Rain Winning streak and rain forecast by week [Data in Columns H-K can change by week.] 1 First game of the year, so no wins or losses. Week 10 too far off for a rain forecast. 1 No winning streak. Week 10 too far off for a rain forecast. One game winning streak. Week 10 too far off for a rain forecast No winning streak. Week 10 too far off for a rain forecast. One game winning streak. Week 10 too far off for a rain forecast. OLD CO V G UI A W N H No winning streak. Week 10 too far off for a rain forecast. No winning streak. Week 10 too far off for a rain forecast. One game winning streak. Week 10 forecast is no rain. No winning streak. Week 10 forecast is no rain. One game winning streak. Week 10 forecast is no rain