Excel 2010 Project

Done with 6 hour please.

Documentation

Creator: Date: Purpose: 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

Week 1

6

86 86

2

108 108

9

16 16 12

16 16

64 64 64

54 64 68 68 68

2

32

46 46

44

44 44 49

Totals

Seating

Sunday Wednesday Friday Saturday Matinee Saturday Evening

Orchestra Front

Orchestra Middle

Orchestra Back

Box Seats

Mezzanine Level 1

Mezzanine Level 2

Balcony Level 1

Balcony Level 2

Totals

			Home				Number of Seats Sold per Day
									Seating					Available										Sunday										Wednesday										Friday										Saturday Matinee										Saturday Evening	Weekly									Totals
									Orchestra Front											8		88				84									86	4	30
									Orchestra Middle		1																			16	1			12			100			114												116	120			56
									Orchestra Back												108		96	83			104		49
									Box Seats	17	77
									Mezzanine Level 1																							64	50		54	296
									Mezzanine Level 2															68			32
									Balcony Level 1													46						42																44	210
									Balcony Level 2	24					40	201
4		72	479	5		41						548	557	2,597
			Revenue per Day
				Seat Price								Weekly Totals
				$ 168
				$ 158
				$ 148
				$ 250
				$ 155
				$ 125
				$ 95
				$ 75

Week 2

Home Number of Seats Sold per Day
Seating Available Sunday Wednesday Friday Saturday Matinee Saturday Evening Weekly Totals

Orchestra Front 86 84 86 86 86 86

Orchestra Middle 116

116 116 116

Orchestra Back 108

106 108 108

2

Box Seats 16 16 8 16 16 16 72
Mezzanine Level 1 64 64 64 64 64 64

Mezzanine Level 2 68

63 68 68 68

Balcony Level 1 46 41 41 46 46 46

Balcony Level 2 44

30 44 44 44

Totals

548 548

Revenue per Day
Seating Seat Price Sunday Wednesday Friday Saturday Matinee Saturday Evening Weekly Totals
Orchestra Front $ 168
Orchestra Middle $ 158
Orchestra Back $ 148
Box Seats $ 250
Mezzanine Level 1 $ 155
Mezzanine Level 2 $ 125
Balcony Level 1 $ 95
Balcony Level 2 $ 75
Totals

428
113			102	5		63
		106	94		52
320
	60	327
220
36	198
520	488	546	2,650

Week 3

Home Number of Seats Sold per Day
Seating Available Sunday Wednesday Friday Saturday Matinee Saturday Evening Weekly Totals

Orchestra Front 86

72 86 86 86

Orchestra Middle 116 104 100 116 116 116

Orchestra Back 108 96

102 108 108

Box Seats 16 12 8 16 16 16 68
Mezzanine Level 1 64

64 64 64 64

Mezzanine Level 2 68

52 68 64 68

Balcony Level 1 46 40 40 40 40 46

Balcony Level 2 44 42 32

38 44

Totals

548

Revenue per Day
Seating Seat Price Sunday Wednesday Friday Saturday Matinee Saturday Evening Weekly Totals
Orchestra Front $ 168
Orchestra Middle $ 158
Orchestra Back $ 148
Box Seats $ 250
Mezzanine Level 1 $ 155
Mezzanine Level 2 $ 125
Balcony Level 1 $ 95
Balcony Level 2 $ 75
Totals

80	410
552
92		506
53	309
67	319
206
	38	194
494	460	530	532	2,564

Week 4

Home Number of Seats Sold per Day
Seating Available Sunday Wednesday Friday Saturday Matinee Saturday Evening Weekly Totals

Orchestra Front 86 86 84 86 84 86

Orchestra Middle 116 114 102 114 116 116 5

Orchestra Back 108 100 88 106 104 108 506
Box Seats 16 12 16 16 16 16

Mezzanine Level 1 64 56 60 64 62 64

Mezzanine Level 2 68 64 64

63 68

Balcony Level 1 46 44 46 42 44 46

Balcony Level 2 44 42 44 42 42 44

Totals

548

Revenue per Day
Seating Seat Price Sunday Wednesday Friday Saturday Matinee Saturday Evening Weekly Totals
Orchestra Front $ 168
Orchestra Middle $ 158
Orchestra Back $ 148
Box Seats $ 250
Mezzanine Level 1 $ 155
Mezzanine Level 2 $ 125
Balcony Level 1 $ 95
Balcony Level 2 $ 75
Totals

426
62
76
306
66	325
222
214
518	504	536	531	2,637

October

Seating Available Sunday Wednesday Friday Saturday Matinee Saturday Evening

Orchestra Front 86
Orchestra Middle 116
Orchestra Back 108
Box Seats 16
Mezzanine Level 1 64
Mezzanine Level 2 68
Balcony Level 1 46
Balcony Level 2 44

548

Seating Seat Price Sunday Wednesday Friday Saturday Matinee Saturday Evening Weekly Totals
Orchestra Front $ 168
Orchestra Middle $ 158
Orchestra Back $ 148
Box Seats $ 250
Mezzanine Level 1 $ 155
Mezzanine Level 2 $ 125
Balcony Level 1 $ 95
Balcony Level 2 $ 75
Totals

Percentage of Seats Sold by Weekday for Month

Avg Daily %

Avg. Daily Capacity %

Total Revenue by Weekday for Month

November

0.0%

93.3%

96.8% 94.0% 100.0%

16

.8%

100.0%

68

93.8%

95.1%

89.7%

77.8%

98.3%

0

90.6%

99.2% 94.5%

Seating

Sunday Wednesday Friday Saturday Matinee Saturday Evening

Orchestra Front

Orchestra Middle

Orchestra Back

Box Seats

Mezzanine Level 1

Mezzanine Level 2

Balcony Level 1

15,675

Balcony Level 2

10,275

Totals

					Percentage of Seats Sold by Weekday for Month
	Seating	Available		Sunday		Wednesday		Friday		Saturday Matinee		Saturday Evening	Avg Daily %
	Orchestra Front	86		93.3%	94.8%	97.7%	99.4%			1	0	97.0%
	Orchestra Middle	1	16		94.0%		98.3%	98.7%	99.8%		96.8%
	Orchestra Back	108		95.1%	86.6%		94.5%
	Box Seats		68	81.3%	85.9%		93.8%	96.9%	85.3%
	Mezzanine Level 1	64	91.0%	96.1%	96.5%		99.2%	96.6%
	Mezzanine Level 2	87.9%	95.2%	100.7%	98.2%
	Balcony Level 1	46		89.7%	86.4%	95.7%	96.7%	91.6%
	Balcony Level 2	44		77.8%	86.9%	89.8%	86.1%
Avg. Daily Capacity %		90.6%	96.0%	96.2%
Total Revenue by Weekday for Month
Seat Price	Weekly	Totals
$ 168	$ 53,928	$ 54,768	$ 56,448	$ 57,456	$ 57,792	$ 280,560
$ 158	68,888	68,414	72,048	72,364	73,154	354,868
$ 148	60,828	55,352	61,864	60,088	63,936	302,068
$ 250	11,000	13,000	13,750	15,000	15,500	68,250
$ 155	36,115	38,130	38,285	39,370	39,680	191,580
$ 125	29,875	32,375	34,250	31,875	33,375	161,750
$ 95		15,675	15,105	16,720	16,910	80,085
$ 75		10,275	11,475	11,850	12,975	56,850
$ 286,584	$ 287,419	$ 303,795	$ 304,723	$ 313,322	ERROR:#REF!

December

98.3%

100.0%

97.7%

100.0%

16

96.9% 90.6%

100.0%

96.9% 97.7% 100.0%

89.3% 96.3%

100.0%

100.0% 96.2%

100.0%

94.3% 96.4% 96.7% 100.0%

Seating

Sunday Wednesday Friday Saturday Matinee Saturday Evening

Orchestra Front

Orchestra Middle

Orchestra Back

Box Seats

14,500

Mezzanine Level 1

Mezzanine Level 2

30,375

Balcony Level 1

Balcony Level 2

Totals

					Percentage of Seats Sold by Weekday for Month
	Seating	Available		Sunday		Wednesday		Friday		Saturday Matinee		Saturday Evening	Avg Daily %
	Orchestra Front	86	99.4%	95.9%		98.3%			97.7%									100.0%
	Orchestra Middle	1	16	97.0%	93.5%	96.6%	97.4%			96.9%
	Orchestra Back	108		96.3%	94.2%	98.1%	97.3%
	Box Seats		90.6%	93.8%	94.4%
	Mezzanine Level 1	64	94.5%	93.0%		96.4%
	Mezzanine Level 2	68		89.3%	93.4%	93.7%
	Balcony Level 1	46	95.7%		96.7%	92.4%		96.2%
	Balcony Level 2	44	88.1%	98.9%	95.5%		94.3%	95.3%
Avg. Daily Capacity %	548	95.0%	96.5%
Total Revenue by Weekday for Month
Seat Price	Weekly	Totals
$ 168	$ 57,456	$ 55,440	$ 56,784	$ 56,448	$ 57,792	$ 283,920
$ 158	71,100	68,572	70,784	71,416	73,312	355,184
$ 148	61,568	60,236	62,456	62,752	63,936	310,948
$ 250		14,500	15,500	15,000	16,000	75,500
$ 155	37,510	36,890	38,440	38,750	39,680	191,270
$ 125		30,375	32,750	31,750	34,000	159,250
$ 95	16,720	16,910	16,150	16,815	17,480	84,075
$ 75	11,625	13,050	12,600	12,450	13,200	62,925
$ 300,854	$ 296,973	$ 304,464	$ 305,381	$ 315,400	$ 1,523,072

Fourth Quarter

		Total Revenue by Month
Seating	Seat Price	October	November	December
Orchestra Front	$ 168
Orchestra Middle	$ 158
Orchestra Back	$ 148
Box Seats	$ 250
Mezzanine Level 1	$ 155
Mezzanine Level 2	$ 125
Balcony Level 1	$ 95
Balcony Level 2	$ 75
Totals