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 20% to 55% in increments of 5%. Click here to view the Markdown Pricing Model spreadsheet model with numbers. Click here to view the Markdown Pricing Model spreadsheet model with Excel functions. Fill in the two-way data table below. (Round to the nearest dollar as needed.) Intermediate Markdown Days at 20% 25% 30% 35% 40% 45% full Retail 50% 55% 20 i Markdown Pricing Model spreadsheet model with Excel functions A B 1 Markdown Pricing Model 2 3 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=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+B17"B22 24 Days at retail price =B7 25 Units sold at retail =B23*B24 26 Retail revenue 27 Discount Sales 28 Discount =B8 29 Discount price =B22*(1-B28) =B25*B22 i Markdown Pricing Model spreadsheet model with Excel functions 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+B17"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+B17*B29 Unit sold =MIN(B30*(B6-B24),B5-B25) 32 Discount revenue =B31*B29 33 Clearance Sales 34 Clearance price =B4*(1-B9) 35 Units sold at clearance =MAX(O,B5-B25-B31) 36 Clearance revenue =B34"B35 37 38 Total revenue =C26+C32+C36 31 Print Done