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 25% to 60% in increments of 5%.
Fill in the two-way data table below.
Days at full retail Intermediate Markdown
20 25% 30% 35% 40% 45% 50% 55% 60%
25
30
35
40
. 
11 of 11 (10 complete) data Markdown pricing model spreadsheet model numbers rme with n with E BC 1 Markdown Pricing Model 3 Data 0% $70.00 1000 50 Retail Price Inventory Selling Season (days) Days at full retail Intermediate markdown Clearance markdown 30% 70% 11 Sales Data Average Daily Sales (Y) 7.00 Price(X) 13 $70 $49 15 Demand function parameters Intercept 17 Slope 32.20 16 91 - 1.2 19 Model 21 Full Retail Sales Retail price Daily sales Days at retail price Units sold at retail $70.00 7.00 40 280 Refail revenue $19.600.00 ver. Print Done ork 11 of 11 (10 complete) vay data Markdown pricing model spreadsheet model numbers rmediate markdown va el with el with E 15 Demand function parameters 16 Intercept 17 Slope 12 18 50% 19 Model 20 21 Full Retail Sales Retail price Daily sales 24 Days at retail price Units sold at retail 22 $70.00 23 7.00 25 40 280 Retail revenue $19,600.00 27 Discount Sales Discount Discount price Daily sales Unit sold 30% $49.00 32.20 322 Discount revenue $15.778.00 32 Clearance Sales Clearance price Units sold at clearance 21.00 398 Clearance revenue $8,358.00 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. swer. Print Done 11 of 11 (10 complete) data Markdown pricing model spreadsheet model numbers rme with n with E BC 1 Markdown Pricing Model 3 Data 0% $70.00 1000 50 Retail Price Inventory Selling Season (days) Days at full retail Intermediate markdown Clearance markdown 30% 70% 11 Sales Data Average Daily Sales (Y) 7.00 Price(X) 13 $70 $49 15 Demand function parameters Intercept 17 Slope 32.20 16 91 - 1.2 19 Model 21 Full Retail Sales Retail price Daily sales Days at retail price Units sold at retail $70.00 7.00 40 280 Refail revenue $19.600.00 ver. Print Done ork 11 of 11 (10 complete) vay data Markdown pricing model spreadsheet model numbers rmediate markdown va el with el with E 15 Demand function parameters 16 Intercept 17 Slope 12 18 50% 19 Model 20 21 Full Retail Sales Retail price Daily sales 24 Days at retail price Units sold at retail 22 $70.00 23 7.00 25 40 280 Retail revenue $19,600.00 27 Discount Sales Discount Discount price Daily sales Unit sold 30% $49.00 32.20 322 Discount revenue $15.778.00 32 Clearance Sales Clearance price Units sold at clearance 21.00 398 Clearance revenue $8,358.00 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. swer. Print Done
