Solve using excel. Perishable Product Pricing

We have $3,000$ units of product to sell over a five$-$day period. From historical sales data, we have estimated the following demand curves:

P $=$ price$/$unit in $$,$ Q $=$ number of units sold.

Day $1$: P $=10-0\mathrm{.}01$ Q

valid for prices between $$3$ and $$8.$

Day $2$: same as Day $1.$

Day $3$: P $=15-0\mathrm{.}01$ Q

valid for prices between $$6$ and $$10$

Day $4$: P $=20-0\mathrm{.}01$ Q

valid for prices between $$6$ and $$12$

Day $5$: same as Day $1.$

Question:

Formulate as a Solver problem in Excel. What are the revenue maximizing prices for days $15?$ What is the maximum possible revenue?