Description
Follow the instructions and perform them in the workbook.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Hi! Here is your workbook. Have a nice day.
Creator:
Date:
Purpose:
Exploring Series
21-Jun-17
Store daily ticket sales by seating group.
Calculate daily and weekly revenue.
Calculate monthly seating revenue.
Worksheets:
Week 1
Week 2
Week 3
Week 4
October Summary Worksheet
Documentation
20170621190315e09c1theater10_lastfirst.xlsx
Home
Seating
Orchestra Front
Box Seats
Mezzanine Level 1
Balcony Level 1
Totals
Seating
Orchestra Front
Box Seats
Mezzanine Level 1
Balcony Level 1
Totals
Available
86
16
64
46
Sunday
86
16
50
32
$ 184,00
Number of Seats Sold per Day
Saturday Saturday
Matinee Evening Weekly Totals
Wednesday
Friday
84
86
86
86
428
12
16
16
16
76
54
64
64
64
296
42
44
46
46
210
$
192,00 $ 210,00 $ 212,00 $ 212,00 $
1.010,00
Seat Price Sunday Wednesday
$
168 $ 14.448 $
14.112
$
250
2.688
2.016
$
155
8.400
9.072
$
95...