Unit 5 AS: Industry Analysis

Sheet1

census.gov
Cells in Yellow have made up numbers and need you to import data from census.gov
Cells in Green has formulas as examples
Cells in Grey need to be calculated with formulas as shown in the examples
Geographic Area Name			NAICS Code	Meaning of NAICS Code	Year	Number of Establishments	Sales, Value of Shipments, or Revenue ($1,000)	Annual Payroll ($1,000)	Number of Employees
U.S.			722511	Full Service Restaurants	2017	231,927	$224,320,799	$74,086,843	4,772,294
U.S.			722511	Full Service Restaurants	2012	220,089	$192,258,833	$63,259,045	4,603,747
					Increase/ Decrease	11,838
					Increase/ Decrease %	5.4%
New Jersey			722511	Full Service Restaurants	2017	6,906	$6,203,769	$1,829,403	108,442
New Jersey			722511	Full Service Restaurants	2012	6,268	$5,301,608	$1,600,699	103,528
					Increase/ Decrease	638
					Increase/ Decrease %	10.2%
Average Revenue per Establishment			U.S.	New Jersey
		2017	$967,204
		2012	$873,550
Increase/ Decrease $			$93,654
Increase/ Decrease %			10.7%
Average # of Employees per Establishment			U.S.	New Jersey
		2017	20.58
		2012	20.92
Increase/ Decrease			-0.34
Increase/ Decrease %			-1.6%
Average Cost of Payroll per Employee			U.S.	New Jersey
		2017	$15,524
		2012	$13,741
Increase/ Decrease $			$1,784
Increase/ Decrease %			13.0%