Markdown Pricing Model
Data
Retail Price	$70.00
Inventory	1000
Selling Season (days)	55
Days at full retail	40
Intermediate markdown	30%
Clearance markdown	70%
Sales Data
Price(X)	Average Daily Sales (Y)
$70	7
$49	32.2
Demand function parameters
Intercept	91
Slope	-1.2
Model
Full Retail Sales
Retail price	$70.00
Daily sales	7
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.2
Unit sold	483
	Discount revenue	$23,667.00
Clearance Sales
Clearance price	21
Units sold at clearance	237
	Clearance revenue	$4,977.00
	Total revenue	$48,244.00

The answer for days at full retail 35 is all correct. Please show workings in excel with varying days full at full retail thanks.

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 35 to 55 in increments of 5 and the intermediate markdown varies from 20% to 55% in increments of 5%. Fill in the two-way data table below. (Round to the nearest dollar as needed.) Intermediate Markdown Days at 20% 25% 30% 35% 40% 45% 50% 55% full Retail 35 $ 49,665 $ 50,645 $ 51,037' $ 50,841 $ 48,860 $ 46,218 $ 43,575 $ 40,933 40 $ $ $ $ $ $ $ $