Excel Concepts Summary 1
The 2006 summer concert tour has completed for a singing artist. You need to create a
worksheet showing Percentage of Tickets Sold, Gross Ticket Sales and Net Profit Per Concert.
Then chart the concert city and net profit per concert columns, with the chart title: Concert Tour
Ticket Sales Summary. Once you have completed the activity,print and turn in.
Be sure to format the spread EXACTLY the way it is presented. Make
sure to use the wrap text feature, shading, borders and horizontal and
vertical alignment.
1. Create the following spreadsheet.
2006 Concert Tour Ticket Sales Summary
Seating Price Per Tickets Cost To Hold
Concert City
Capacity Ticket Sold Concert
(You decide the 95,000 $65.00 88,655 $1,205,648
city names) 150,000 $56.00 146,953 $2,006,590
36,000 $37.00 27,560 $323,560
79,833 $45.50 74,000 $960,234
56,852 $76.00 56,662 $1,008,502
Average Ticket
Price
2. Add a column for Percentage of Tickets Sold (one decimal space) to the right of the Tickets Sold
column, Gross Ticket Sales (no decimals) to the right of the Percentage of Tickets Sold column and a Net
Profit Per Concert (no decimals) at the end. (only the price per ticket column needs to be averaged, your
title needs to be centered over the entire spreadsheet)
3. Write formulas to calculate:
Percent of tickets sold per concert
Gross ticket sales
Net profit per concert
Average ticket price (shade all cells in this row that are not ticket price column)
4. Chart
Graph Style: you choose
Title: Concert Tour Ticket Sales Summary
Y-axis: Net Profit
X-axis: Concert City
5. Type a sentence below the chart, stating which concert city was the most profitable and the city that
was least profitable in 2006.
Note: You may need to change page set-up, check print preview, you can select shrink to fit 1 page, but
make sure information is readable.
Remember to put the below information at the top of your page.
Name:
Class Period:
File Name: Concert Tour
Excel Concepts Summary 1
The 2006 summer concert tour has completed for a singing artist. You and your partner need to create a
worksheet showing Percentage of Tickets Sold, Gross Ticket Sales and Net Profit Per Concert. Then
chart the concert city and net profit per concert columns, with the chart title: Concert Tour Ticket Sales
Summary. You and your partner will turn in one printout with both your names on it.
1. Create the following spreadsheet.
2006 Concert Tour Ticket Sales Summary
Percentage Net Profit
Seating Price Per Tickets Gross Ticket Cost To Hold
Concert City of Tickets Per
Capacity Ticket Sold Sales Concert
Sold Concert
95,000 $65.00 88,655 $1,205,648
150,000 $56.00 146,953 $2,006,590
36,000 $37.00 27,560 $323,560
79,833 $45.50 74,000 $960,234
56,852 $76.00 56,662 $1,008,502
Average Ticket
Price
2. Add a column for Percentage of Tickets Sold, Gross Ticket Sales and Net Profit Per Concert
(Some columns may need to be inserted, Your title needs to be centered over the entire spreadsheet)
3. Write formulas to calculate:
Percent of tickets sold per concert
Gross ticket sales
Net profit per concert
Average ticket price (shade all cells in this row that are not ticket price column)
4. Chart
Graph Style: you choose
Title: Concert City Ticket Sales Summary
Y-axis: Net Profit
X-axis: Concert City
5. Type a sentence below the chart, stating which concert city was the most profitable and the city that
was least profitable in 2006.
Note: you may need to change page set-up, check print preview.
Remember to put the below information on at the top of your page.
Name:
Partner:
Class Period: Concert Tour
File Name:
2006 Concert Tour Ticket Sales Summary
Percentage Net Profit
Seating Price Per Tickets Gross Ticket Cost To Hold
Concert City of Tickets Per
Capacity Ticket Sold Sales Concert
Sold Concert
Tokyo, Japan 95,000 $65.00 88,655 93.3% $5,762,575 $1,205,648 $4,556,927
Sydney, Austraila 150,000 $56.00 146,953 98.0% $8,229,368 $2,006,590 $6,222,778
Chicago, Illinois 36,000 $37.00 27,560 76.6% $1,019,720 $323,560 $696,160
Los Angeles, Califonia 79,833 $45.50 74,000 92.7% $3,367,000 $960,234 $2,406,766
Athens, Greece 56,852 $76.00 56,662 99.7% $4,306,312 $1,008,502 $3,297,810
Average Ticket
Price $55.90
Concert Tour Ticket Sales Summary
$7,000,000
$6,000,000
Net Profit
$5,000,000
$4,000,000
$3,000,000
$2,000,000
$1,000,000
$0
Tokyo, Japan Sydney, Chicago, Los Angeles, Athens,
Austraila Illinois Califonia Greece
Concert City
The most profitable concert city was Sydney, Austraila.
The least profitable concert city was Chicago, Illinois