3-4

profileqkiii123
ch07excel_-solutions.xlsx
Home>Business & Finance homework help>Accounting homework help>3-4

start

Hospital Seminars Revenues and Expenses
Revenue
Registration Fees $16,800
Parking Fees $800 with average number of attendees at 3 not 2.5
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 with average number of attendees at 3 not 2.5
Marketing cost per seminar $250

q1

Hospital Seminars Revenues and Expenses
Revenue
Registration Fees $18,900
Parking Fees $900
Subtotal $19,800
Expenses
Speakers' Fees $6,000
Tech support $1,800
Marketing $3,000
Room rental $3,000
Subtotal $13,800
Net Profit/Loss $6,000 starting net profit $ 3,800.00
$ 2,200.00 increased net profit if attendance increases to 45
Variables
Speaker's Fee (per session) $500
Tech Support cost per session $150
Seminars per year 12
Registration fee $35
Attendees per seminar 45
Room rental per seminar $250
Parking fee $5
Average # attendees per car 3
Marketing cost per seminar $250

q2

Hospital Seminars Revenues and Expenses
Revenue
Registration Fees $14,700
Parking Fees $700
Subtotal $15,400
Expenses
Speakers' Fees $6,000
Tech support $1,800
Marketing $3,000 starting net profit $ 3,800.00
Room rental $3,000 $ 2,200.00 reduction in profit if attendance drops to 35 attendees
Subtotal $13,800
Net Profit/Loss $1,600
Variables
Speaker's Fee (per session) $500
Tech Support cost per session $150
Seminars per year 12
Registration fee $35
Attendees per seminar 35
Room rental per seminar $250
Parking fee $5
Average # attendees per car 3
Marketing cost per seminar $250

q3

Hospital Seminars Revenues and Expenses
Revenue
Registration Fees $16,800
Parking Fees $480
Subtotal $17,280
Expenses
Speakers' Fees $6,000
Tech support $1,800
Marketing $3,000 starting net profit $ 3,800.00
Room rental $3,000 $ 3,480.00 decreased net profit if parking fee reduced to $3
Subtotal $13,800 difference of $ 320.00
Net Profit/Loss $3,480
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 $3
Average # attendees per car 3
Marketing cost per seminar $250

q4

Hospital Seminars Revenues and Expenses
Revenue
Registration Fees $16,800
Parking Fees $800
Subtotal $17,600
Expenses
Speakers' Fees $6,600
Tech support $1,800
Marketing $3,000 starting net profit $ 3,800.00
Room rental $3,000 $ 3,200.00 reduced net profit after speaker fees increase
Subtotal $14,400 difference of $ 600.00
Net Profit/Loss $3,200
Variables
Speaker's Fee (per session) $550
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
Marketing cost per seminar $250

q5

Hospital Seminars Revenues and Expenses
Revenue
Registration Fees $21,000
Parking Fees $1,000
Subtotal $22,000
Expenses
Speakers' Fees $6,000
Tech support $1,800
Marketing $4,200 starting net profit $ 3,800.00
Room rental $3,000 $ 3,200.00 increase over starting net profit w/ more attendees, minus marketing cost increase
Subtotal $15,000
Net Profit/Loss $7,000
Variables
Speaker's Fee (per session) $500
Tech Support cost per session $150
Seminars per year 12
Registration fee $35
Attendees per seminar 50
Room rental per seminar $250
Parking fee $5
Average # attendees per car 3
Marketing cost per seminar $350

q6

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 starting net profit $ 3,800.00
Room rental $3,600 $ 600.00 net profit decreases
Subtotal $14,400
Net Profit/Loss $3,200
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 $300
Parking fee $5
Average # attendees per car 3
Marketing cost per seminar $250

q7

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 starting net profit $ 3,800.00
Room rental $1,920 $ 1,080.00 increase over starting net profit if room rental price decreases to $160
Subtotal $12,720
Net Profit/Loss $4,880
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 $160
Parking fee $5
Average # attendees per car 3
Marketing cost per seminar $250

q8

Hospital Seminars Revenues and Expenses
Revenue
Registration Fees $16,800
Parking Fees $800
Subtotal $17,600
Expenses
Speakers' Fees $6,000
Tech support $0
Marketing $3,000 starting net profit $ 3,800.00
Room rental $3,000 $ 1,800.00 increase over starting net profit with zero tech fees
Subtotal $12,000
Net Profit/Loss $5,600
Variables
Speaker's Fee (per session) $500
Tech Support cost per session $0
Seminars per year 12
Registration fee $35
Attendees per seminar 40
Room rental per seminar $250
Parking fee $5
Average # attendees per car 3
Marketing cost per seminar $250

goal seek-q1

Hospital Seminars Revenues and Expenses
Revenue
Registration Fees $18,423
Parking Fees $877 with average number of attendees at 3 not 2.5
Subtotal $19,300
Expenses
Speakers' Fees $6,000
Tech support $1,800
Marketing $3,000
Room rental $3,000
Subtotal $13,800
Net Profit/Loss $5,500
Variables
Speaker's Fee (per session) $500
Tech Support cost per session $150
Seminars per year 12
Registration fee $35
Attendees per seminar 44
Room rental per seminar $250
Parking fee $5
Average # attendees per car 3 with average number of attendees at 3 not 2.5
Marketing cost per seminar $250

goal seek-q2

Hospital Seminars Revenues and Expenses
Revenue
Registration Fees $16,800
Parking Fees $1,150 with average number of attendees at 3 not 2.5
Subtotal $17,950
Expenses
Speakers' Fees $6,000
Tech support $1,800
Marketing $3,000
Room rental $3,000
Subtotal $13,800
Net Profit/Loss $4,150
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 $7.19
Average # attendees per car 3 with average number of attendees at 3 not 2.5
Marketing cost per seminar $250

goal seek-q3

Hospital Seminars Revenues and Expenses
Revenue
Registration Fees $18,750
Parking Fees $800 with average number of attendees at 3 not 2.5
Subtotal $19,550
Expenses
Speakers' Fees $6,000
Tech support $1,800
Marketing $3,000
Room rental $3,000
Subtotal $13,800
Net Profit/Loss $5,750
Variables
Speaker's Fee (per session) $500
Tech Support cost per session $150
Seminars per year 12
Registration fee $39
Attendees per seminar 40
Room rental per seminar $250
Parking fee $5
Average # attendees per car 3 with average number of attendees at 3 not 2.5
Marketing cost per seminar $250