Markdown Pricing Model Data Retail Price $70.00 Inventory 1000 Selling Season (days) 50 Days at full retail 40 Intermediate markdown 30% Clearance markdown 70% Sales Data Price(X) Average Daily Sales (Y) $70 7.00 $49 32.20 Demand function parameters Intercept 91 Slope -1.2 Model Full Retail Sales Retail price $70.00 Daily sales 7.00 Days at retail price 40 Units sold at retail 280 Retail revenue $19,600.00 Discount Sales Discount 30% Discount price $49.00 Daily sales 32.20 Unit sold 322 Discount revenue $15,778.00 Clearance Sales Clearance price 21.00 Units sold at clearance 398 Clearance revenue $8,358.00 Total revenue $43,736.00

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 10 to 30 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 10 45% 50% 55% 60% 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 10 to 30 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 10 45% 50% 55% 60%