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 Numbers Given , Values in Table Are Incorrect

Intermediate Markdown Days at 15% 20% 25% 30% 35% 40% 45% 50% full Retail 15 $ 52,556 $ 55,300 $ 54,338 $ 51,205 $ 48,073 $ 44,940 $ 41,808 $ 38,675 20 $ 50,498 $ 52,850 $ 54,320 $ 51,940 $ 48,930 $ 45,920 $ 42,910 $ 39,900 25 $ 48,440 $ 50,400 $ 51,625 $ 52,115 $ 49,788 $ 46,900 $ 44,013 $ 41,125 30 $ 46,382 $ 47,950 $ 48,930 $ 49,322 $ 49,126 $ 47,880 $ 45,115 $ 42,350 35 $ 44,324 $ 45,500 $ 46,235 $ 46,529 $ 46,382 $ 45,794 $ 44,765 $ 43,295 nap Use the Markdown Pricing Model spreadsheet model and a two-way data table to find the total revenue days of Milf retail vary from 2019 40 in increments of 5 and the intermediate marcovaries from -20% to 55% in increments of 5% ou Click bere to view the Markdown Pricing Model spreadsheet model with numbers Click here to view the Markdown Pricing Model spreadsheet model with Excel functions os Fill in the two-way data table below. Intermediate Markdown Days at 15% 20% 25% 30% 35% 40% 45% 50% full Retail 15 $ 52,556 $ 55,300 $ 54,338 $ 51,205 $ 48,073 $ 44,940 $ 41,808 $ 38,675 20 $ 50,498 $ 52,850 $ 54,320 $ 51,940 $ 48,930 $ 45,920 $ 42,910 $ 39,900 25 $ 48,440 $ 50,400 $ 51,625 $ 52,115 $ 49,788 $ 46,900 $ 44,013 $ 41,125 30 $ 46,382 $ 47,950 $ 48,930 $ 49,322 $ 49,126 $ 47,880 $ 45,115 $ 42,350 35 $ 44,324 $ 45,500 $ 46,235 $ 46,529 $ 46,382 $ 45,794 $ 44,765 $ 43,295 nap Use the Markdown Pricing Model spreadsheet model and a two-way data table to find the total revenue days of Milf retail vary from 2019 40 in increments of 5 and the intermediate marcovaries from -20% to 55% in increments of 5% ou Click bere to view the Markdown Pricing Model spreadsheet model with numbers Click here to view the Markdown Pricing Model spreadsheet model with Excel functions os Fill in the two-way data table below