I do not need the answers to this problem. I need to build a model in Solver in Excel to determine the maximum revenue based on the data given. I cannot get my model to work and need assistance in figuring out what to enter in the fields in Solver. I am learning Solver but not getting any assistance in the classroom or textbook.

The exercise states $"$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,$ Day $2,$ and Day $5$: P$=10-0\mathrm{.}01$Q $($valid for prices between $$3$ and $$8).$

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)$

I have columns for each day with the units sold set as the variable and the curve demand formulas entered in price. The constraints entered are total units sold $=3,000.$

Each day constraints to set values $<=$ and $>=$ for the valid price range.