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 10 to 30 in increments of 5 and the intermediate markdown varies from 15% to 50% in increments of 5%. Fill in the two-way data table below.\f6/25/22, 8:19 AM Markdown pricing model spreadsheet model numbers A B C 1 Markdown Pricing Model 2 Data 4 Retail Price $70.00 5 Inventory 1000 6 Selling Season (days) 50 7 Days at full retail 40 8 Intermediate markdown 30% 9 Clearance markdown 70% 10 11 Sales Data 12 Price(X) Average Daily Sales (Y) 13 $70 7.00 14 $49 32.20 15 Demand function parameters 16 Intercept 91 17 Slope -1.2 18 19 Model 20 21 Full Retail Sales 22 Retail price $70.00 23 Daily sales 7.00 24 Days at retail price 40 25 Units sold at retail 280 26 Retail revenue $19,600.00 27 Discount Sales 28 Discount 30% 29 Discount price $49.00 30 Daily sales 32.20 31 Unit sold 322 32 Discount revenue $15,778.00 33 Clearance Sales 34 Clearance price 21.00 35 Units sold at clearance 398 36 Clearance $8,358.00 revenue 37 38 Total revenue $43,736.00 When using this model, replace the appropriate values in cell A14 and in columns B and C with formulas.6/25/22, 9:20 AM Markdown Pricing Model spreadsheet model with Excel functions A B C 1 Markdown Pricing Model 3 Data 4 Retail Price 70.00 Inventory 1000 Selling Season (days) 50 Days at full retail 40 Intermediate markdown 30% 9 Clearance markdown 70% 10 11 Sales Data 12 Price (X) Average Daily Sales (Y) 13 70 7.00 14 49 32.20 15 Demand function parameters 16 Intercept =INTERCEPT(B13:B14,A13:A14) 17 Slope =SLOPE(B13:B14,A13:A14) 18 19 Model 20 21 Full Retail Sales 22 Retail price =B4 23 Daily sales =B16+817*B22 24 Days at retail price =B7 25 Units sold at retail -B23*B24 26 Retail revenue =B25*B22 27 Discount Sales 28 Discount =B8 29 Discount price =B22*(1-B28) 30 Daily sales =B16+817*B29 31 Unit sold =MIN (B30*(86-B24),85-B25) 32 Discount revenue -B31*B29 33 Clearance Sales 34 Clearance price =B4*(1-89) 35 Units sold at clearance =MAX(0,85-B25-B31) 36 Clearance revenue =B34*835 37 38 Total revenue =C26+C32+C36