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 30 to 50 in increments of 5 and the intermediate markdown varies from 10% to 45% 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 full 10% 15% 20% 25% Retail 30 $0 $0 $0 $0 30% $0 35% $0 40% $0 45% $J 1 Markdown Pricing Model 3 Data Retail Price Inventory Selling Season (days) Days at full retail Intermediate markdown Clearance markdown $70.00 1000 50 40 30% 70% 11 Sales Data Price(X) Average Daily Sales (Y) 7.00 32.20 $70 $49 Demand function parameters Intercept Slope 91 - 1.2 19 Model 20 22 23 40 25 21 Full Retail Sales Retail price $70.00 Daily sales 7.00 Days at retail price Units sold at retail 280 26 Retail revenue $19,600.00 27 Discount Sales 28 Discount 30% Discount price $49.00 Daily sales 32.20 Unit sold Discount revenue $15,778.00 33 Clearance Sales Clearance price 21.00 Units sold at clearance 398 Clearance $8,358.00 revenue 322 32 Total revenue $43,736.00 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 30 to 50 in increments of 5 and the intermediate markdown varies from 10% to 45% 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 full 10% 15% 20% 25% Retail 30 $0 $0 $0 $0 30% $0 35% $0 40% $0 45% $J 1 Markdown Pricing Model 3 Data Retail Price Inventory Selling Season (days) Days at full retail Intermediate markdown Clearance markdown $70.00 1000 50 40 30% 70% 11 Sales Data Price(X) Average Daily Sales (Y) 7.00 32.20 $70 $49 Demand function parameters Intercept Slope 91 - 1.2 19 Model 20 22 23 40 25 21 Full Retail Sales Retail price $70.00 Daily sales 7.00 Days at retail price Units sold at retail 280 26 Retail revenue $19,600.00 27 Discount Sales 28 Discount 30% Discount price $49.00 Daily sales 32.20 Unit sold Discount revenue $15,778.00 33 Clearance Sales Clearance price 21.00 Units sold at clearance 398 Clearance $8,358.00 revenue 322 32 Total revenue $43,736.00