ch07ex01_excel_file-pg220.xlsx

Sheet1

Hospital Seminars Revenues and Expenses
Revenue
Registration Fees $16,800
Parking Fees $800
Subtotal $17,600
Expenses
Speakers' Fees $6,000
Tech support $1,800
Marketing $3,000
Room rental $3,000
Subtotal $13,800
Net Profit/Loss $3,800
Variables
Speaker's Fee (per session) $500
Tech Support cost per session $150
Seminars per year 12
Registration fee $35
Attendees per seminar 40
Room rental per seminar $250
Parking fee $5
Average # attendees per car 3 < rounded up to 3.0
Marketing cost per seminar $250