[go: up one dir, main page]
Scribd
Upload
65 views4 pages

Practical Excel Test

The document summarizes yearbook sales and revenue figures for Westmount High School from 2012 to 2014. It shows that yearbook sales increased from 925 in 2012 to 1067 in 2014 while the selling price decreased from $40 to $36. Total revenue also fluctuated over this period, peaking at $10145 in 2013 due to higher advertising sales. Printing costs were consistently the largest expense, ranging from $16000 to $24000, while travel expenses were smallest. Overall profit decreased from $323416 in 2012 to $246969 in 2014.

Uploaded by

chegg the egg
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
65 views4 pages

Practical Excel Test

The document summarizes yearbook sales and revenue figures for Westmount High School from 2012 to 2014. It shows that yearbook sales increased from 925 in 2012 to 1067 in 2014 while the selling price decreased from $40 to $36. Total revenue also fluctuated over this period, peaking at $10145 in 2013 due to higher advertising sales. Printing costs were consistently the largest expense, ranging from $16000 to $24000, while travel expenses were smallest. Overall profit decreased from $323416 in 2012 to $246969 in 2014.

Uploaded by

chegg the egg
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 4

Westmount Yearbook Sales 2012~2014

2012 2013 2014

Yearbooks Sold 925 754 1067


Selling Price 40 38 36

Revenue
Yearbook Sales 214 260 210
Advertising Sales 8574 9885 7560
Total Revenue 8788 10145 7770

Expenses
Printing Costs 20000 16000 24000
Salaries 4500 3540 4980
Advertising Expence 560 643 899
Travel Expense 366 478 245
Camera Expense 698 526 885
Photo Development 1980 1450 1742
Total Expenses 28104 22637 32751

Profit 323416 362873 246969

Smallest Expense Travel Travel Travel


Largest Expense Printing Printing Printing
Average Expense Photo Photo Photo
12000

10000

8000

Yearbook Sales
6000
Yearbooks Sold Advertising Sales
Total Revenue
4000

2000

0
1 2 3
Yearbook Sales
Advertising Sales
Total Revenue

You might also like