Scribd
Upload
6 views2 pages

Westmount Yearbook Sales Analysis 2012-2014

The document analyzes yearbook sales and expenses for a 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 increased over this period despite lower advertising sales in 2014. Expenses generally increased each year, with printing costs being the largest expense each year. The school earned a profit each year, with the highest profit of $17470 in 2012.

Uploaded by

Eshaan Prashar
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
6 views2 pages

Westmount Yearbook Sales Analysis 2012-2014

The document analyzes yearbook sales and expenses for a 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 increased over this period despite lower advertising sales in 2014. Expenses generally increased each year, with printing costs being the largest expense each year. The school earned a profit each year, with the highest profit of $17470 in 2012.

Uploaded by

Eshaan Prashar
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

Eshaan Prashar 4/18/2017

Yearbook Sales

2012 2013 2014 Westmount Yearbook Sales 2012 - 2014


Yearbooks Sold 925 754 1067
Selling Price 40 38 36 40000
35000
Revenue
30000

Yearbooks Sold
Yearbook Sales 37000 28652 38412
25000 Yearbook Sales
Advertising Sales 8574 9885 7650
20000
Total Revenue 45574 38537 46062
15000
Expenses 10000
Printing Costs 20000 16000 24000 5000
Salaries 4500 3540 4980 0
Advertising Expense 560 643 899 2012 2013 2014
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 245 245


Largest Expense 20000 16000 24000
Average Expense 4684 3772.833 5458.5
Yearbook Sales

2012 2013 2014

Yearbooks 925 754 1067


Selling Pri 40 38 36

Revenue
Yearbook S 37000 28652 38412
Advertisin 8574 9885 7650
Total Rev 45574 38537 46062

Expenses
Printing Co 20000 16000 24000
Salaries 4500 3540 4980
Advertisin 560 643 899
Travel Exp 366 478 245
Camera Ex 698 526 885
Photo Dev 1980 1450 1742
Total Exp 28104 22637 32751

Profit 17470 15900 13311

Smallest 366 245 245


Largest E 20000 16000 24000
Average E 4684 3772.833 5458.5

You might also like