You are investing in a new Broadway play, Insect in the Light. You are given the following

information about the play:

The fixed cost of opening the play is $$5$ million.The average ticket price is $$100.$

The theater seats $2,000$ people and there are $365$ performances per year.

The cost per performance is $$1,000.$

Use a data table to determine how total profit generated by the play changes as the length of

the play run varies between one and five years, and average occupancy rates vary between

$70$ percent and $90$ percent. $($A$)$ write the syntax used to calculate i$)$ total revenue$($TR$),$ ii$)$ total variable cost iii$)$total profit$($P$).$ use the column name $($A$,$B$,$C$,,,)$ and row name $(123,,,)$ as shown in the report while writing the syntax.

$($B$)$ according to the report what is the recommended Occupancy rate$($OR$)$ and the length of the game run$($Y$)$ and the amount$$of$$profit

C$)$ briefly narrate how was the two way sensitivity report developed$$using$$MS$$Excel