You need to solve part b in two different ways: first, using the PSISIMParam function, and second as a simulation$-$NLP combination. Please include Excel sheet as well.

QUESTION: WVTU is a television station that has $20$ thirty$-$second advertising slots during the

regularly scheduled programming each evening. The station is now selling adver

tising for the first few days in November. They could sell all the slots immediatel

for $$4,500$ each, but because November $7$ will be an election day, the station man

ager knows she may be able to sell slots at the last minute to political candidate

in tight races for a price of $$8,000$ each. The demand for these last minute slots is

estimated as follows:

Slots not sold in advance and not sold to political candidates at the last minute car

be sold to local advertisers at a price of $$2,000.$

a$.$ If the station manager sells all the advertising slots in advance, how much reve

nue will the station receive?

b$.$ How many advertising slots should be sold in advance if the station manager

wants to maximize expected revenue?

c$.$ If the station manager sells in advance the number of slots identified in the pne$-$

vious question, what is the probability that the total revenue received will exceed

the amount identified in part a where all slots are sold in advance?

You need to solve part b in two different ways: first, using the PSISIMParam function, and second as a simulation$-$NLP combination. Solve it in EXCEL sheet and include the image of EXCEL sheet with all the formulas in cells.