Scribd
Upload
8 views3 pages

Westmount Yearbook Sales Analysis 2012-2014

The document summarizes yearbook sales and expenses for Westmount Yearbook from 2012 to 2014. It shows that yearbook sales peaked at 1067 in 2014 after declining from 925 in 2012 to 754 in 2013. Total revenue ranged from $45574 in 2012 to $46062 in 2014. Printing costs were the largest expense each year, ranging from $16000 to $24000. Profits declined over the period from $17470 in 2012 to $13311 in 2014.

Uploaded by

Anita Mohammadi
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
8 views3 pages

Westmount Yearbook Sales Analysis 2012-2014

The document summarizes yearbook sales and expenses for Westmount Yearbook from 2012 to 2014. It shows that yearbook sales peaked at 1067 in 2014 after declining from 925 in 2012 to 754 in 2013. Total revenue ranged from $45574 in 2012 to $46062 in 2014. Printing costs were the largest expense each year, ranging from $16000 to $24000. Profits declined over the period from $17470 in 2012 to $13311 in 2014.

Uploaded by

Anita Mohammadi
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

Anita April 8, 2017

Yearbook Sales

2012 2013 2014

Yearbook Sold 925 754 1067


Selling Price 40 38 36

Revenue
Yearbook Sales 37000 28652 38412
Advertising Sales 8574 9885 7650
Total Revenue 45574 38537 46062

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

Profit 17470 15900 13311

Smallest Expense 366


Largest Expense 20000 16000 24000
Average Expense 4684 3772.833333333 5458.5

Westmount Yearbook Sales 2012-2014

1200
Yearbooks Sold
1000
Yearbook Sold
800
600
400
200
0
2012 2013 2014
Anita April 8, 2017

Yearbook Sold
Anita April 18, 2017

Yearbook Sales

2012 2013 2014

Yearbook Sol 925 754 1067


Selling Price 40 38 36

Revenue
Yearbook Sal 37000 28652 38412
Advertising S 8574 9885 7650
Total Revenu 45574 38537 46062

Expences
Printing Costs 20000 16000 24000
Salaries 4500 3540 4980
Advertising E 560 643 899
Travel Expen 366 478 245
Camera Expe 698 526 885
Photo Develo 1980 1450 1742
Total Expens 28104 22637 32751

Profit 17470 15900 13311

Smallest Exp 366


Largest Expe 20000 16000 24000
Average Exp 4684 3772.833333333 5458.5

You might also like