www.ExcelDataPro.
com
Event Expenses Estimate v/s. Actual
Estimated Estimated Actual Actual Estimated Actual
Particualrs
Quantity Rate/Unit Quantity Rate/Unit Amount Amount
Venue Expenses
Plot / Hall / Room Rent 1000 100 1000 110 $100,000 $110,000
Furniture Rent 3000 10 3000 9 $30,000 $27,000
Electric and Other Electronic Equipements $12,000 $15,000
Tent / Decoration Expenses 1000 20 1000 15 $20,000 $15,000
Other Miscelanious Expenses $10,000 $8,000
Total $172,000 $175,000
Refreshment Expenses
Food 3000 200 3000 180 $600,000 $540,000
Drink 3000 20 3000 15 $60,000 $45,000
Others
Total $660,000 $585,000
Program Expenses
Presenters / Performers / Staff Remuneration 100 1000 100 900 $100,000 $90,000
Presenters/Performers/Staff Travelling Expenses 100 200 100 185 $20,000 $18,500
Presenters/Performers/Staff Accommodation 100 100 100 85 $10,000 $8,500
www.ExcelDataPro.com
Event Expenses Estimate v/s. Actual
Estimated Estimated Actual Actual Estimated Actual
Particualrs
Quantity Rate/Unit Quantity Rate/Unit Amount Amount
Presenters/Performers/Staff Dress/Clothing
100 50 100 35 $5,000 $3,500
Expenses.
Total $135,000 $120,500
www.ExcelDataPro.com
Event Expenses Estimate v/s. Actual
Estimated Estimated Actual Actual Estimated Actual
Particualrs
Quantity Rate/Unit Quantity Rate/Unit Amount Amount
Promotional Expenses
Web Development 1 25000 1 22000 $25,000 $22,000
Social Media Advertisement Expenses 5 5000 5 3800 $25,000 $19,000
Print Media Advertisement Expenses 12 10000 12 8500 $120,000 $102,000
Electronic Media Advertisement Expenses 25 1000 25 750 $25,000 $18,750
Gifts / Momentous / Giveaways 2000 15 2000 18 $30,000 $36,000
Total $225,000 $197,750
Misceleneous Expenses
Name Tags / badges 100 50 100 50 $5,000 $5,000
Literature Printing 2000 5 2000 4.5 $10,000 $9,000
Stickers / Banners 30 100 30 100 $3,000 $3,000
Postage & Courier Charges 0 0 $0 $0
Stationery Expenses 2000 1 2000 0.85 $2,000 $1,700
Telephone Charges 0 0 $0 $0
Others Transportation Exp. 1 5000 1 3500 $5,000 $3,500
Other Miscelanious Expenses 0 0 $0 $0
Total $25,000 $22,200
www.ExcelDataPro.com
Event Expenses Estimate v/s. Actual
Estimated Estimated Actual Actual Estimated Actual
Particualrs
Quantity Rate/Unit Quantity Rate/Unit Amount Amount
Grand Total Of Expenses $1,217,000 $1,100,450
www.ExcelDataPro.com
Event Expenses Estimate v/s. Actual
Estimated Estimated Actual Actual Estimated Actual
Particualrs
Quantity Rate/Unit Quantity Rate/Unit Amount Amount
Admission Fee Income
VVIP Class Entry 100 5000 100 5000 $500,000 $500,000
VIP Class Entry 300 4000 300 4000 $1,200,000 $1,200,000
1st Class Entry 700 3000 700 3000 $2,100,000 $2,100,000
2nd Class Entry 900 2000 900 2000 $1,800,000 $1,800,000
Total $5,600,000 $5,600,000
Sponsors Income
LED Advertisement Display 5 10000 5 9000 $50,000 $45,000
Banner Advertisement 20 3000 20 3000 $60,000 $60,000
Other Advertisement $20,000 $30,000
Space Rent Receipts $10,000 $10,000
Rent for Stalls Alloted 10 2000 10 2000 $20,000 $20,000
Rent for Canopies Alloted 5 1000 5 1000 $5,000 $5,000
Total $165,000 $170,000
Other Incomes
Sale of Items 500 100 700 100 $50,000 $70,000
Other Misc. Incomes $5,000 $3,500
Total $55,000 $73,500
www.ExcelDataPro.com
Event Expenses Estimate v/s. Actual
Estimated Estimated Actual Actual Estimated Actual
Particualrs
Quantity Rate/Unit Quantity Rate/Unit Amount Amount
Grand Total Of Income $5,820,000 $5,843,500
www.ExcelDataPro.com
Event Budget With Comparison Charts
Estimated Actual
Particulars
Amount Amount
Venue Expenses $172,000 $175,000
Refreshment Expenses $660,000 $585,000
Program Expenses $135,000 $120,500
Promotional Expenses $225,000 $197,750
Misceleneous Expenses $25,000 $22,200
Grand Total Of Expenses $1,217,000 $1,100,450
Actual Vs Estiamted Expenses Chart
$1,400,000
$1,200,000
$1,000,000
$800,000
$600,000
$400,000
$400,000
$200,000
$0
Estimated Amount Actual Amount
Venue Expenses Refreshment Expenses Program Expenses Promotional Expenses Misceleneous Expenses
Income Charts
Estimated Actual
Particulars
Amount Amount
Admission Fee Income $5,600,000 $5,600,000
Sponsors Income $165,000 $170,000
Other Incomes $55,000 $73,500
Grand Total Of Income $5,820,000 $5,843,500
Actual Vs Estiamted Income Chart
$5,900,000
$5,850,000
$5,800,000 $73,500
$55,000
$5,750,000
Other Incomes
$5,700,000 Sponsors Income
$165,000 $170,000 Admission Fee Income
$5,650,000
$5,600,000
$5,550,000
$5,600,000 $5,600,000
$5,500,000
$5,450,000
Estimated Amount Actual Amount
$5,450,000
Estimated Amount Actual Amount
Income Vs Expenses
Expenses Incomes Profit / Loss
Estimate $1,217,000 $5,820,000 $4,603,000
Actual $1,100,450 $5,843,500 $4,743,050
Est. % of Profit / Loss 378.23%
Actual % of Profit / Loss 431.01%
Income Vs Expenses Chart
$8,000,000
$7,000,000
$6,000,000
$5,000,000
Incomes
$5,820,000 Expenses
$4,000,000 $5,843,500
$3,000,000
$2,000,000
$1,000,000
$1,217,000 $1,100,450
$0
Estimate Actual
Profit / Loss Chart
$4,800,000
$4,750,000
$4,700,000
$4,750,000
$4,700,000
Profit/Loss
$4,650,000
$4,743,050
$4,600,000
$4,550,000 $4,603,000
$4,500,000
Estimate Actual
