+1(669)289-8683
Manage your orders
Manage your orders
Order Now

Excel 2010 Project

Done with 6 hour please.

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

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

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

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
Order your essay today and save 25% with the discount code: STUDYSAVE

Order Now

Order a unique copy of this paper

600 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
Top Academic Writers Ready to Help
with Your Research Proposal
Order Now or Free Inquiry

Order your essay today and save 25% with the discount code GREEN

Order Now