CP Use the Markdown Pricing Model spreadsheet model and a two-way data table to find the total revenue if days at ful 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 datatable below (Round to the nearest dollar as needed) Intermediate Markdown Days at 20% 25% 30% 35% full Retail 40% 45% 50% 55% 25 10 11 13 14 15 16 17 31 23 39 Enter your answer in the fields and then co Check Answer 37 38 T 4 parts remaining Show Won Markdown pricing model spreadsheet model numbers - X 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 91 17 Slope -1.2 18 19 Model 20 21 Full Retail Sales 22 $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 Retail price Print Done Markdown Pricing Model spreadsheet model with Excel functions - X5 to 45 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) 70 700 14 49 32.20 Demand function 15 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 =B25B22 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-825-B31 Clearance revenue =B34'B35 37 38 Total revenue =C26+C32+C36 Print Done ISITOWIWIK CP Use the Markdown Pricing Model spreadsheet model and a two-way data table to find the total revenue if days at ful 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 datatable below (Round to the nearest dollar as needed) Intermediate Markdown Days at 20% 25% 30% 35% full Retail 40% 45% 50% 55% 25 10 11 13 14 15 16 17 31 23 39 Enter your answer in the fields and then co Check Answer 37 38 T 4 parts remaining Show Won Markdown pricing model spreadsheet model numbers - X 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 91 17 Slope -1.2 18 19 Model 20 21 Full Retail Sales 22 $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 Retail price Print Done Markdown Pricing Model spreadsheet model with Excel functions - X5 to 45 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) 70 700 14 49 32.20 Demand function 15 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 =B25B22 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-825-B31 Clearance revenue =B34'B35 37 38 Total revenue =C26+C32+C36 Print Done ISITOWIWIK