Cost Sheet Format In Excel 41365 | Businessload Event Management Project Tracker Template

Partial file snippet.

Sheet 1: PROJECT PARAMETERS

	
	
	
	
	
	
	
	
	
		[Company Name]
		

		

		

		

		

		

		

	
	
		Event Management Project Tracker
		

		

		

		

		

		

		

	
	
		Company Confidential
		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		Shaded cells are calculated for you. You do not need to enter anything into them.
		

		

		

		

		

		

		

	
	
		PROJECT TYPE
		ACCOUNT MANAGER
		PROJECT MANAGER
		STRATEGY MANAGER
		DESIGN SPECIALIST
		EVENT STAFF
		ADMIN STAFF
		Total
	
	
		Event strategy development
		20%
		10%
		60%
		0%
		0%
		10%
		100%
	
	
		Event planning
		20%
		50%
		10%
		10%
		0%
		10%
		100%
	
	
		Event design
		20%
		20%
		0%
		50%
		0%
		10%
		100%
	
	
		Event logistics
		20%
		60%
		0%
		0%
		10%
		10%
		100%
	
	
		Event staffing
		20%
		10%
		0%
		0%
		60%
		10%
		100%
	
	
		Event assessment
		20%
		20%
		20%
		20%
		0%
		20%
		100%
	
	
		Blended rates
		$180
		$120
		$150
		$100
		$80
		$60
		

	
	
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		

		ACCOUNT MANAGER
		PROJECT MANAGER
		STRATEGY MANAGER
		DESIGN SPECIALIST
		EVENT STAFF
		ADMIN STAFF
		

	
	
		PLANNED COST
		$272,340.00
		$319,320.00
		$123,450.00
		$106,000.00
		$49,320.00
		$53,490.00
		

	
	
		ACTUAL COST
		$273,960.00
		$324,540.00
		$126,150.00
		$104,950.00
		$48,160.00
		$53,460.00
		

	
	
		PLANNED HOURS
		1,513.00
		1,774.00
		685.83
		588.89
		274.00
		297.17
		

	
	
		ACTUAL HOURS
		1,522.00
		1,803.00
		700.83
		583.06
		267.56
		297.00
		

	
	
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

	

 
 




Sheet 2: PROJECT DETAILS

	
	
	
	
	
	
	
	
	
		[Company Name]
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Event Management Project Tracker
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Company Confidential
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		
 
		
		
	
		PROJECT NAME
		PROJECT TYPE
		ESTIMATED START
		ESTIMATED FINISH
		ACTUAL START
		ACTUAL FINISH
		ESTIMATED WORK
		ACTUAL WORK
		ESTIMATED DURATION
		ACTUAL DURATION
		
	
		A. Datum Corporation
		Event strategy development
		6/9/2013
		8/7/2013
		6/29/2013
		9/3/2013
		200
		220
		58
		64
		
	
		Adventure Works
		Event planning
		6/25/2013
		7/27/2013
		7/15/2013
		8/25/2013
		400
		390
		32
		40
		
	
		Alpine Ski House
		Event design
		7/12/2013
		9/19/2013
		8/7/2013
		10/10/2013
		500
		500
		67
		63
		
	
		Baldwin Museum of Science
		Event logistics
		7/30/2013
		9/28/2013
		9/14/2013
		11/13/2013
		150
		145
		58
		59
		
	
		Blue Yonder Airlines
		Event staffing
		8/11/2013
		8/21/2013
		9/14/2013
		9/25/2013
		250
		255
		10
		11
		
	
		City Power & Light
		Event assessment
		8/22/2013
		10/2/2013
		9/28/2013
		10/27/2013
		300
		310
		40
		29
		
	
		Coho Vineyard
		Event planning
		9/13/2013
		9/23/2013
		10/26/2013
		10/13/2013
		500
		510
		10
		-13
		
	
		Coho Winery
		Event logistics
		9/21/2013
		10/15/2013
		10/23/2013
		11/18/2013
		750
		790
		24
		25
		
	
		Coho Vineyard & Winery
		Event assessment
		10/15/2013
		11/25/2013
		11/30/2013
		1/10/2014
		450
		430
		40
		40
		
	
		Contoso, Ltd.
		Event staffing
		10/26/2013
		12/24/2013
		11/26/2013
		1/19/2014
		250
		235
		58
		53
		
	
		Contoso Pharmaceuticals
		Event planning
		11/17/2013
		1/15/2014
		12/28/2013
		2/26/2014
		200
		235
		58
		58
		
	
		Consolidated Messenger
		Event strategy development
		12/3/2013
		2/2/2014
		1/14/2014
		3/2/2014
		180
		190
		59
		48
		
	
		Fabrikam, Inc.
		Event staffing
		6/21/2013
		1/18/2014
		8/5/2013
		3/4/2014
		250
		230
		207
		209
		
	
		Fourth Coffee
		Event logistics
		12/20/2013
		2/4/2014
		1/27/2014
		3/25/2014
		240
		225
		44
		58
		
	
		Graphic Design Institute
		Event design
		12/28/2013
		3/5/2014
		1/17/2014
		4/10/2014
		320
		305
		67
		83
		
	
		Humongous Insurance
		Event planning
		1/4/2014
		3/6/2014
		2/3/2014
		4/6/2014
		550
		565
		62
		63
		

		

		

		

		

		

	
	
		Litware, Inc.
		Event design
		1/23/2014
		3/7/2014
		3/7/2014
		4/8/2014
		350
		350
		44
		31
		

		

		

		

		

		

	
	
		Lucerne Publishing
		Event strategy development
		2/5/2014
		4/17/2014
		3/7/2014
		6/3/2014
		200
		205
		72
		86
		

		

		

		

		

		

	
	
		Margie's Travel
		Event planning
		2/15/2014
		4/30/2014
		3/26/2014
		6/9/2014
		220
		230
		75
		73
		

		

		

		

		

		

	
	
		Northwind Traders
		Event assessment
		3/17/2014
		5/25/2014
		4/29/2014
		7/1/2014
		600
		560
		68
		62
		

		

		

		

		

		

	
	
		Proseware, Inc.
		Event logistics
		3/29/2014
		5/19/2014
		5/18/2014
		6/19/2014
		525
		540
		50
		31
		

		

		

		

		

		

	
	
		School of Fine Art
		Event planning
		4/9/2014
		4/29/2014
		5/2/2014
		6/4/2014
		180
		190
		20
		32
		

		

		

		

		

		

	
	
		TOTAL
		

		

		

		

		

		7565
		7610
		1223
		1205

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet project parameters event management tracker company confidential shaded cells are calculated for you do not need to enter anything into them type account manager strategy design specialist staff admin total development planning logistics staffing assessment blended rates planned cost actual hours details name estimated start finish work duration a datum corporation adventure works alpine ski house baldwin museum of science blue yonder airlines city power amp light coho vineyard winery contoso ltd pharmaceuticals consolidated messenger fabrikam inc fourth coffee graphic institute humongous insurance litware lucerne publishing margie s travel northwind traders proseware school fine art...

Related files

Share

Help

[Company Name]
Event Management Project Tracker
Company Confidential

Shaded cells are calculated for you. You do not need to enter anything into them.
PROJECT TYPE	ACCOUNT MANAGER	PROJECT MANAGER	STRATEGY MANAGER	DESIGN SPECIALIST	EVENT STAFF	ADMIN STAFF	Total
Event strategy development	20%	10%	60%	0%	0%	10%	100%
Event planning	20%	50%	10%	10%	0%	10%	100%
Event design	20%	20%	0%	50%	0%	10%	100%
Event logistics	20%	60%	0%	0%	10%	10%	100%
Event staffing	20%	10%	0%	0%	60%	10%	100%
Event assessment	20%	20%	20%	20%	0%	20%	100%
Blended rates	$180	$120	$150	$100	$80	$60


	ACCOUNT MANAGER	PROJECT MANAGER	STRATEGY MANAGER	DESIGN SPECIALIST	EVENT STAFF	ADMIN STAFF
PLANNED COST	$272,340.00	$319,320.00	$123,450.00	$106,000.00	$49,320.00	$53,490.00
ACTUAL COST	$273,960.00	$324,540.00	$126,150.00	$104,950.00	$48,160.00	$53,460.00
PLANNED HOURS	1,513.00	1,774.00	685.83	588.89	274.00	297.17
ACTUAL HOURS	1,522.00	1,803.00	700.83	583.06	267.56	297.00

Related files

Share

Share to social media

Help

Login Area