Downtown theater. The theater’s musical show tickets are priced as follows: for

Question

Downtown theater. The theater’s musical show tickets are priced as follows: for ages 16 and over, premier ticket $80, floor ticket $50, and balcony ticket $40; 35% discount for under 16; and $10 discount for seniors (65 and over). Discount amounts are always deducted first before applying discount percentages when they are both present. Listed prices and totals are to be rounded to the nearest 10 cents. In support of family bonding, the theater is offering a three-generation family discount of 15%. This 6-ticket package is for grandpa, grandma, dad, mom, and two children. Children here refer to family relationship rather than age. a. Construct a spreadsheet model for an extended family to evaluate its ticketing options. The family is composed of a grandfather (age 78), grandmother (76), father (45), mother (43), child 1 (17), and child 2 (15). b. Design a separate table to show the overall costs with and without the family discount. c. The spreadsheet should be flexible enough for the theater management to design and evaluate future discount packages.

Explanation / Answer

Ticket type

Ticket type

premier ticket floor ticket balcony ticket for ages 16 and over $80 $50 $40 under 16 $52 $32.50 $26 65 and over $70 $40 $30 Here, family has grandpa, grandma(2 people above the age of 65), dad, mom, and one child(who will fall in the age bracket of 16-65), and one child under the age of 16 So Cost = (2*ticket price of 65 and above) +( 3* ticket price for 16-65) + (1*16 and below) FAMILY charges(without family discount)(this is the row No.6) $432 $263 $206 family discount(15%) = B6 * 0.85 = C6 * 0.85 = D6 * 0.85 $367.20 $223.13 $175.10

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.