Office Update to keep up-to- A1 x fx Markdown Pricing Model D E A $70.00 1000 50 40 30% 70% Average Daily Sales (V) 7 32.2 91 -1.2 3 Data 4 Retail Price 5 Inventory 6 Selling Season (days) 7 Days at full retail 8 Intermediate markdown 9 Clearance markdown 10 11 Sales Data 12 Price(X) 13 $70 14 $49 15 Demand function parameters 16 Intercept 17 Slope 18 19 Model 20 21 Full Retail Sales 22 Retail price 23 Daily sales 24 Days at retail price 25 Units sold at retail 26 27 Discount Sales 28 Discount 29 Discount price 30 Dally sales 31 Unit sold 32 33 Clearance Sales 34 Clearance price 35 Units sold at clearance 36 37 38 $ 70.00 7 40 280 $19,600.00 Retail revenue 30% $49.00 32.2 322 $15,778.00 Discount revenue 21 398 $8,358.00 Clearance revenue Total revenue $43,736.00 + JUN 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 Markdown Pricing Model spreadsheet model with Excel functions - X rm 16 Intercepe=INTERCEPT(B13:B14, AT3 AT4) 17 Slope =SLOPE(B13:B14,A13:A14) 18 19 Model 20 21 Full Retail Sales 22 Retail price =B4 23 Daily sales =B16+B117*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 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(O,B5-B25-B31) 36 Clearance revenue =B34-B35 37 38 Total revenue=C26+C32+C36 nuint nane 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 15% to 50% 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 15% 20% 25% full Retail 30% 35% 40% 45% 50% 20 S $ $ S