Use the below table to complete the assignment. Put all of this in one excel file and label the tabs Part 1, Part 2, Part 3. Save the file with the name Market.anaylsis.assign2-yourname, where your name is replaced with your actual last name. Take pride in the formatting and presentation of your submission, this should look as professionally done as possible.
New York MSA(1) Philadelphia MSA(1) New Jersey(2)
Total expenditures $65,764 $60,504 $63,099
Food 9,190 8,649 8,641
Housing 24,308 20,047 23,617
Apparel 1,645 1,119 1,491
Transportation 6,828 8,188 7,295
Healthcare 4,260 4,800 5,239
Entertainment 2,277 2,496 2,097
Education 2,171 2,081 2,182
Go to the US Census Bureau’s website and download the most recent demographics for Essex county, new jersey. Find the most recent projected population growth for that area.
Search the NJ DCA website and find the most recent YTD statistics for building permits issued in your county. Find the total square footage of retail properties that have filed building permits. Using the table on page 136 in your text, calculate the average sales per square foot for all retail center types for the East region. Multiply this number by the total square feet of retail being built to find total projected sales. Using the information from the above table, calculate the average expenditures per person using the latest population projections from part 1. Separately, divide the total sales calculation by the total expenditures in the table to calculate the number of consumers it would take to absorb the projected spending. Is this number in line with the population growth estimates?
Using the information from Part 2 find the number of jobs being created. Use a rule of thumb of 2.5 jobs per 1,000 square feet for retail.