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
$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	322
	Discount revenue	$15,778.00
Clearance Sales
Clearance price	21
Units sold at clearance	398
	Clearance revenue	$8,358.00
	Total revenue	$43,736.00

PLEASE HELP! THE DATA TABLES ARE REPEATING THE SAME VALUES FOR ME AND I DON'T KNOW HOW TO FIX IT! PLEASE HELP ME SOLVE THE ABOVE QUESTION THANK YOU

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 25 to 45 in increments of 5 and the intermediate markdown varies from 20% to 55% 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.) Days at full Retail 25 20% Intermediate Markdown 35% 25% 30% $ 40% 45% $ 50% 55% $ C 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 25 to 45 in increments of 5 and the intermediate markdown varies from 20% to 55% 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.) Days at full Retail 25 20% Intermediate Markdown 35% 25% 30% $ 40% 45% $ 50% 55% $ C