use the markdown pricing decisions 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%.

I need this to be done in Excel.

Markdown Pricing Model Data Retail Price Inventory Selling Season (days) Days at full retail Intermediate markdown Clearance markdown Demand Function a b 70 1000 50 40 30% 70% 91 1.2 Model Full Retail Sales Retail Price $ DailySales $ Days at Retail Price Units sold at Retail 70.00 7.00 40 280 Retail Revenue $ 19,600.00 30% 49.00 32.20 322 Discount Revenue $ 15,778.00 21.00 398 Clearence Revenue $ 8,358.00 Total Revenue $ 43,736.00 Discount Sales Discount Discount Price $ Daily Sales $ Unit Sold Clearance Sales Clearance price $ Units sold at clearance