Hi, could you please just fill out the data table I provided on the bottom. I really just need the answers for this specific question. Thank you so much!

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 25 to 45 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.) 17 A B C 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) 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 Retail revenue =B25*B22 27 Discount Sales 28 Discount =B8 29 Discount price =B22*(1-B28) 30 Daily sales =B16+B17*B29 31 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(0,B5-B25-B31) 36 Clearance revenue =B34*B35 37 38 Total revenue =C26+C32+C36 26 mncolo o 12 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 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 Clearance 36 $8,358.00 revenue 37 38 Total revenue $43,736.00 Intermediate Markdown 40% 45% 50% Days at full retail 20% 25% 30% 35% 55% 25 30 35 40 45