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 25% to 60% 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 25% 30% 35% 40% full Retail 45% 50% 55% 60% 30 $ $ $ Markdown pricing model spreadsheet model numbers B C A 1 Markdown Pricing Model 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 $70.00 1000 50 40 30% 70% Average Daily Sales (Y) 7.00 32.20 91 - 1.2 12 Price(X) 13 $70 14 $49 15 Demand function parameters 16 Intercept 17 Slope 18 19 Model 20 21 Full Retail Sales Retail price 23 Daily sales 24 Days at retail price 22 $70.00 7.00 40 Markdown pricing model spreadsheet model numbers Intercepi 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 When using this model, replace the appropriate values in cell A14 and in columns B and C with formulas. Markdown pricing model spreadsheet model with excel functions 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 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 23 Daily sales =B16+B17*B22 24 Days at retail price =B7 25 Units sold at retail =B23*B24 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 23 Daily sales =B16+B17*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 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 25% to 60% 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 25% 30% 35% 40% full Retail 45% 50% 55% 60% 30 $ $ $ Markdown pricing model spreadsheet model numbers B C A 1 Markdown Pricing Model 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 $70.00 1000 50 40 30% 70% Average Daily Sales (Y) 7.00 32.20 91 - 1.2 12 Price(X) 13 $70 14 $49 15 Demand function parameters 16 Intercept 17 Slope 18 19 Model 20 21 Full Retail Sales Retail price 23 Daily sales 24 Days at retail price 22 $70.00 7.00 40 Markdown pricing model spreadsheet model numbers Intercepi 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 When using this model, replace the appropriate values in cell A14 and in columns B and C with formulas. Markdown pricing model spreadsheet model with excel functions 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 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 23 Daily sales =B16+B17*B22 24 Days at retail price =B7 25 Units sold at retail =B23*B24 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 23 Daily sales =B16+B17*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