I can't upload worksheet here, so i give u some instructions which help u to make desired workbook by your own:
In brackets there are cell references like Column C and Row 6 is C6.
Instructions
Write following in there place as instructed :
Type of Seat in (C6) and Orchestra in (D6)
Age in (C7) and 88 in (D7)
Ticket Price in (C8) and in D8 paste below mentioned formula
=IFERROR(VLOOKUP(IF(OR(D6="Orchestra",D6="Mezzanine",D6="Balcony"),D6,"Seat")&"#"&IF(D7="","Age",IF(D7<=12,"A<=12",IF(D7>=65,"A=>65","12>A<65"))),$J$6:$K$15,2,0),IF(OR(D6="Orchestra",D6="Mezzanine",D6="Balcony"),IF(D7="","Please fill the age",0),"Type of seat is not correct"))
And now i give you a table which you need to put in manner so that it's cover H6 to H15 vertically and H6 to K6 horizontally.
Table is as follows
Seat Age Uniquekey Price
Orchestra A<=12 Orchestra#A<=12 30
Mezzanine A<=12 Mezzanine#A<=12 20
Balcony A<=12 Balcony#A<=12 10
Orchestra A=>65 Orchestra#A=>65 55
Mezzanine A=>65 Mezzanine#A=>65 35
Balcony A=>65 Balcony#A=>65 15
Orchestra 12>A<65 Orchestra#12>A<65 60
Mezzanine 12>A<65 Mezzanine#12>A<65 40
Balcony 12>A<65 Balcony#12>A<65 20
11-7. At the Downtown Theater: Orchestra seats are $60, Mezzanine seats are $40, and Balcony seats...
Question 7 Madeleine is the owner-manager of a small 200-seat theater for improv-comedy shows in downtown Chicago. The usual ticket price for the evening 90-minute show is $17, and this usually fills up about 65% of the capacity. You suggest experimenting with a discounted price of $13 for a while, and this improves attendance to about 85% of theater capacity. Madeleine's marginal cost of each patron attending the show is zero. Assuming demand is linear, and assuming all other demand...