ad_agency_expenses.xlsx

Sheet1

Advertising Expenses
Type Inv Date Placed with Cost ea. Quantity Ext. Cost
Newspaper 01-Jan-10 Village Reader 65.11 8 $ 520.88
Radio spot 07-Jan-10 WHAT 11.00 15 $ 165.00
Subway 20-Jan-10 Advertising Concepts 37.50 30 $ 1,125.00
Yellow Pages 01-Jan-10 NYNEX 232.64 5 $ 1,163.20
Blow-in cards 13-Jan-10 Advertising Concepts 0.22 350 $ 77.00
Magazine 07-Jan-10 Young Upstart 100.92 12 $ 1,211.04
Pens 05-Jan-10 Mass Appeal, Inc. 0.12 275 $ 33.83
Radio spot 15-Jan-10 WHAT 11.00 15 $ 165.00
Billboard 12-Jan-10 Advertising Concepts 101.87 9 $ 916.83
Billboard 28-Jan-10 Advertising Concepts 101.87 14 $ 1,426.18
Total 662.25 733 $ 6,803.96
Summary Amount
Billboard $ 2,343.01
Blow-in cards $ 77.00
Pens $ 33.83
Radio Spots $ 330.00
Subway $ 1,125.00
Yellow Pages $ 1,163.20
Newspaper $ 520.88
Magazine $ 1,211.04
Total $ 6,803.96

Sheet2

Sheet3