Question 5 1 pts On worksheet Markdown, use the Markdown Pricing Model spreadsheet model and a two-way data table to find the total revenue if days at full retail vary from 20 to 40 in increments of 5 and the intermediate markdown varies from 15% to 50% in increments of 5%. The maximum total revenue is 20.00 25.00 30.00 35.00 40 00 50 40 40% 70% $43 246 00 15% 20% 25% 30% 3596 a two-way data table 40 91 1.2 45% 5096 Selling season (days) Days at full retail Intermediate markdown 3 Clearance markdown 0 Demand function 1 a 2 b L3 14 Model 15 16 Full Retail Sales 17 Retail price 18 Daily sales 19 Days at retail price 20 Units sold at retail 21 22 Discount Sales 23 Discount 24 Discount price 25 Daily sales 26 Unit sold 27 28 Clearance Sales 29 Clearance price 30 Units sold at clearance 31 32 $70.00 7.00 40 280 Retail revenue $19,600.00 $43,246.00 20 25 30 35 15% 50498 48440 46382 44324 20% 52850 50400 47950 45500 25% 54320 51625 48930 46235 30% 51940 52115 49322 46529 35% 48930 49787.5 49126 46382 40% 45920 46900 47880 45794 45% 42910 44012.5 45115 44765 50% 39900 41125 42350 43295 Please set up the two-way datatable in D16:124 40 42266 43050 43540 43736 43638 43246 42560 41580 40% $42.00 40.60 406 Discount revenue $17,052.00 $21.00 314 Clearance revenue $6,594.00 Total revenue $43,246.00