Please answer the question and also complete the excel part! Thanks!

A B D E F G H J Markdown Pricing Model 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 $70.00 1000 50 40 40% 70% 20.00 25.00 30.00 35.00 40.00 A NADAL AAAAAAAAAAAA a two-way data table $43,246.00 15% 20% 25% 30% 35% 40% 45% 50% 91 1.2 3 Data 1 Retail price Inventory 5 Selling season (days) - Days at full retail 3 Intermediate markdown Clearance markdown 0 Demand function 1 a 2 b 3 4 Model 5 6 Full Retail Sales 7 Retail price 8 Daily sales 9 Days at retail price 0 Units sold at retail 1 2 Discount Sales 3 Discount 4 Discount price 5 Daily sales 6 Unit sold 7 8 Clearance Sales 9 Clearance price 0 Units sold at clearance 1 2 3 4 5 $70.00 7.00 40 280 Retail revenue $19,600.00 40% $42.00 40.60 406 Discount revenue $17,052.00 Please set up the two-way data table in D16:124 $21.00 314 Clearance revenue $6,594.00 Total revenue $43,246.00