A movie theater has a normal ticket price of $12. For shows that start between 7

Question

A movie theater has a normal ticket price of $12. For shows that start between 7 pm and 1 am, there no discount. For shows that start at other times, there are special prices for the following age ranges: individuals whose under 12 pay only $8; individuals, whose age is between 12 and 16 inclusive, pay only $10; individuals whose age is 65 or over pay $9.50. VBA function that gets the individual's age from the worksheet and retums the ticket i cost. Your function can get the current time of day in hours (on a 24 hour clock) by a statement like timeHr For example f the time was between 7 pm and 7:59:59 pm, the statement tmeHrs Hour(Now) would return a valua of You must Use an if -elseif- else -endif structure. Call m o Problem 3

Explanation / Answer

Let the discount offered on adult tickets be x
Let the discount offered on child tickets be y

sum of the two discount rates is 15%
x+y=0.15
y=0.15-x ---------------------1

On a regular day, 3 adults would pay
3*12=36
But, with a discount of x, adults would have to pay 36x less
Likewise, with discounts, 8 children would have to pay 8*6y=48y less

3 adults and 8 children spends a total of $6 less
36x+48y=6
Divide by 6
6x+8y=1-------------------------2

Substituting the value of y from 1 in 2:

6x+8(0.15-x)=1
6x+1.2-8x=1
-2x=-0.2
x=0.2/2=1/10=0.1=10%

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

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