Examine the table once completely filled-in and decide which site is better for this retail operator. You cannot recommend both as they only have funding a for a single store.
Fill in the Urban Store Location Requirement table with relevant information from attached ESRI one-mile radius reports.
Examine the table once completely filled-in and decide which site is better for this retail operator. You cannot recommend both as they only have funding a for a single store.
Prepare a memo summarizing your decision and why you chose the selected site. In addition to the data in the table, describe the Tapestry segments that are represented at both sites and comment on how that impacted your recommendation.
Submit the memo AND your filled-in urban store location requirements table as a PDF file to submission folder on D2L.
Follow all directions, the table HAS to be filled out based on the data provided (I have attached all reports)
USE THE RUBRIC PROVIDED
NO AI NO PLAGERISM
I have added the instructions below as well.
Requirements: 1-2 Pages
ACS Key Population & Household Facts701 N Orleans St, Chicago, Illinois, 60654Prepared by EsriRing: 0.5 mile radiusLatitude: 41.89481Longitude: -87.637072017-2021ACS EstimatePercentMOE(±)ReliabilityTOTALSTotal Population28,8551,544Total Households17,404990Housing Units20,1401,026POPULATION 15+ BY MARITAL STATUSTotal27,372100%1,456Never married16,69961.0%1,174Married 8,92432.6%788Widowed5331.9%152Divorced1,2164.4%209POPULATION 25+ BY EDUCATIONAL ATTAINMENTTotal23,487100%1,348No schooling 540.2%52Nursery School00.0%0Kindergarden00.0%01st to 4th Grade00.0%65th to 8th Grade810.3%64Some High School2080.9%166High School Diploma6852.9%207GED710.3%34Some College1,7517.5%317Associates degree3551.5%149Bachelors degree 10,92646.5%1,015Masters degree 5,23522.3%619Professional school degree3,36914.3%609Doctorate degree7503.2%205Source: U.S. Census Bureau, 2017-2021 American Community SurveyReliability:highmediumlowSeptember 20, 2023©2023 EsriPage 1 of 7
ACS Key Population & Household Facts701 N Orleans St, Chicago, Illinois, 60654Prepared by EsriRing: 0.5 mile radiusLatitude: 41.89481Longitude: -87.637072017-2021ACS EstimatePercentMOE(±)ReliabilityCIVILIAN EMPLOYED POPULATION 16+ BY OCCUPATIONTotal22,489100%1,356Management4,68820.8%704Business and financial operations4,09518.2%549Computer and mathematical1,6557.4%373Architecture and engineering3551.6%147Life, physical, and social science3571.6%187Community and social services2381.1%127Legal1,4976.7%439Education, training, and library8914.0%195Arts, design, entertainment, sports, and media8103.6%203Healthcare practitioner, technologists, and technicians2,1399.5%435Healthcare support870.4%97Protective service1000.4%49Food preparation and serving related6843.0%192Building and grounds cleaning and maintenance1190.5%56Personal care and service1650.7%58Sales and related2,87312.8%543Office and administrative support9614.3%224Farming, fishing, and forestry100.0%23Construction and extraction 390.2%39Installation, maintenance, and repair 750.3%44Production 1860.8%98Transportation and material moving4652.1%192CIVILIAN EMPLOYED POPULATION 16+ BY INDUSTRYTotal22,489100%1,356Agriculture, forestry, fishing and hunting 100.0%23Mining, quarrying, and oil and gas extraction 640.3%75Construction1430.6%78Manufacturing1,4126.3%361Wholesale trade3751.7%158Retail trade1,3025.8%400Transportation and warehousing5162.3%189Utilities900.4%56Information 7013.1%160Finance and insurance3,70816.5%587Real estate and rental and leasing8843.9%355Professional, scientific, and technical services5,75125.6%641Management of companies and enterprises60.0%14Administrative and support and waste management services5982.7%181Educational services1,8848.4%312Health care and social assistance2,86112.7%482Arts, entertainment, and recreation2761.2%69Accommodation and food services1,0114.5%343Other services, except public administration5802.6%248Public administration3171.4%254Source: U.S. Census Bureau, 2017-2021 American Community SurveyReliability:highmediumlowSeptember 20, 2023©2023 EsriPage 2 of 7
ACS Key Population & Household Facts701 N Orleans St, Chicago, Illinois, 60654Prepared by EsriRing: 0.5 mile radiusLatitude: 41.89481Longitude: -87.637072017-2021ACS EstimatePercentMOE(±)ReliabilityHISPANIC OR LATINO ORIGIN BY RACETotal28,855100%1,544Not Hispanic or Latino 26,72792.6%1,436White alone20,29470.3%1,231Black or African American alone 1,6595.7%301American Indian and Alaska Native alone310.1%74Asian alone3,63912.6%581Native Hawaiian and Other Pacific Islander alone00.0%0Some other race alone 580.2%53Two or more races1,0453.6%394Hispanic or Latino 2,1287.4%549White alone7152.5%156Black or African American alone 950.3%89American Indian and Alaska Native alone10.0%4Asian alone610.2%138Native Hawaiian and Other Pacific Islander alone20.0%9Some other race alone 7432.6%459Two or more races5101.8%263RACETotal28,855100%1,544White alone21,00972.8%1,228Black or African American alone 1,7556.1%303American Indian and Alaska Native alone330.1%72Asian alone3,70012.8%582Native Hawaiian and Other Pacific Islander alone20.0%9Some other race alone 8012.8%462Two or more races1,5555.4%455TOTAL POPULATION BY AGETotal Population28,855100%1,544Under 5 years 8112.8%2315 to 9 years4221.5%16210 to 14 years2490.9%8615 to 19 years8723.0%28020 to 24 years3,01310.4%60725 to 29 years6,64623.0%70330 to 34 years4,94917.2%59335 to 39 years2,7779.6%46040 to 44 years1,6595.7%41945 to 49 years1,2654.4%26350 to 54 years1,5825.5%45255 to 59 years1,2484.3%32360 to 64 years8392.9%19365 to 69 years1,1694.1%25870 to 74 years6662.3%18975 to 79 years1870.6%8580 to 85 years2821.0%13885 years and over2170.8%111Source: U.S. Census Bureau, 2017-2021 American Community SurveyReliability:highmediumlowSeptember 20, 2023©2023 EsriPage 3 of 7
ACS Key Population & Household Facts701 N Orleans St, Chicago, Illinois, 60654Prepared by EsriRing: 0.5 mile radiusLatitude: 41.89481Longitude: -87.637072017-2021ACS EstimatePercentMOE(±)ReliabilityPOPULATION BY SEX BY AGETotal28,855100%1,544Male Population14,34549.7%997Under 5 years 4131.4%1825 to 9 years3191.1%14810 to 14 years2210.8%9215 to 19 years1960.7%5720 to 24 years1,7466.1%51825 to 29 years3,11310.8%43030 to 34 years2,4078.3%43635 to 39 years1,4415.0%32240 to 44 years8422.9%31945 to 49 years5001.7%14850 to 54 years1,0523.6%41055 to 59 years5521.9%21260 to 64 years4661.6%11965 to 69 years5001.7%15570 to 74 years2610.9%10575 to 79 years1060.4%7480 to 85 years1960.7%13585 years and over160.1%24Female Population14,51050.3%951Under 5 years 3981.4%1425 to 9 years1030.4%6510 to 14 years280.1%3515 to 19 years6772.3%27220 to 24 years1,2684.4%31925 to 29 years3,53312.2%55630 to 34 years2,5428.8%40135 to 39 years1,3374.6%33040 to 44 years8162.8%28545 to 49 years7662.7%21950 to 54 years5301.8%19355 to 59 years6962.4%24360 to 64 years3741.3%14765 to 69 years6692.3%20370 to 74 years4051.4%15875 to 79 years820.3%4180 to 85 years860.3%3785 years and over2010.7%116Source: U.S. Census Bureau, 2017-2021 American Community SurveyReliability:highmediumlowSeptember 20, 2023©2023 EsriPage 4 of 7
ACS Key Population & Household Facts701 N Orleans St, Chicago, Illinois, 60654Prepared by EsriRing: 0.5 mile radiusLatitude: 41.89481Longitude: -87.637072017-2021ACS EstimatePercentMOE(±)ReliabilityTOTAL HOUSEHOLDS BY INCOMETotal17,404100%990Less than $10,000 7804.5%287$10,000 to $14,9994902.8%93$15,000 to $19,9993422.0%108$20,000 to $24,999 3041.7%63$25,000 to $29,9993582.1%232$30,000 to $34,9991610.9%86$35,000 to $39,9991711.0%80$40,000 to $44,9992981.7%188$45,000 to $49,9993892.2%262$50,000 to $59,9994152.4%110$60,000 to $74,9999695.6%295$75,000 to $99,999 1,97611.4%374$100,000 to $124,999 1,77310.2%452$125,000 to $149,9991,2627.3%286$150,000 to $199,9992,62615.1%440$200,000 or more5,09129.3%661Median Household Income$129,810N/AAverage Household Income$183,954$18,816HOUSEHOLDS WITH HOUSEHOLDER AGE <25 YEARS BY INCOMETotal1,432100%405Less than $10,000 23516.4%189$10,000 to $14,999412.9%42$15,000 to $19,999433.0%56$20,000 to $24,999 1117.8%60$25,000 to $29,99915610.9%163$30,000 to $34,999191.3%21$35,000 to $39,999261.8%34$40,000 to $44,999271.9%40$45,000 to $49,99928219.7%242$50,000 to $59,999523.6%36$60,000 to $74,999674.7%35$75,000 to $99,999 876.1%53$100,000 to $124,999 755.2%93$125,000 to $149,9991047.3%100$150,000 to $199,999231.6%35$200,000 or more855.9%132Median Household Income for HHr <25$45,830N/AAverage Household Income for HHr <25N/AN/ASource: U.S. Census Bureau, 2017-2021 American Community SurveyReliability:highmediumlowSeptember 20, 2023©2023 EsriPage 5 of 7
ACS Key Population & Household Facts701 N Orleans St, Chicago, Illinois, 60654Prepared by EsriRing: 0.5 mile radiusLatitude: 41.89481Longitude: -87.637072017-2021ACS EstimatePercentMOE(±)ReliabilityHOUSEHOLDS WITH HOUSEHOLDER AGE 25-44 YEARS BY INCOMETotal10,708100%842Less than $10,000 550.5%39$10,000 to $14,999700.7%50$15,000 to $19,999350.3%42$20,000 to $24,999 560.5%40$25,000 to $29,999900.8%84$30,000 to $34,9991151.1%81$35,000 to $39,9991031.0%69$40,000 to $44,999950.9%54$45,000 to $49,999750.7%102$50,000 to $59,9992772.6%106$60,000 to $74,9996656.2%287$75,000 to $99,999 1,55414.5%345$100,000 to $124,999 1,18811.1%321$125,000 to $149,9999929.3%244$150,000 to $199,9991,94218.1%372$200,000 or more3,39631.7%592Median Household Income for HHr 25-44$149,521N/AAverage Household Income for HHr 25-44N/AN/AHOUSEHOLDS WITH HOUSEHOLDER AGE 45-64 YEARS BY INCOMETotal3,494100%545Less than $10,000 3429.8%207$10,000 to $14,999762.2%54$15,000 to $19,9991484.2%122$20,000 to $24,999 651.9%46$25,000 to $29,999842.4%136$30,000 to $34,999240.7%23$35,000 to $39,999401.1%40$40,000 to $44,9991604.6%175$45,000 to $49,99920.1%12$50,000 to $59,999631.8%38$60,000 to $74,9991073.1%59$75,000 to $99,999 2497.1%89$100,000 to $124,999 42412.1%307$125,000 to $149,9991474.2%86$150,000 to $199,99944612.8%202$200,000 or more1,11832.0%264Median Household Income for HHr 45-64$122,369N/AAverage Household Income for HHr 45-64N/AN/ASource: U.S. Census Bureau, 2017-2021 American Community SurveyReliability:highmediumlowSeptember 20, 2023©2023 EsriPage 6 of 7
ACS Key Population & Household Facts701 N Orleans St, Chicago, Illinois, 60654Prepared by EsriRing: 0.5 mile radiusLatitude: 41.89481Longitude: -87.637072017-2021ACS EstimatePercentMOE(±)ReliabilityHOUSEHOLDS WITH HOUSEHOLDER AGE 65+ BY INCOMETotal1,769100%261Less than $10,000 1498.4%124$10,000 to $14,99930317.1%70$15,000 to $19,9991176.6%57$20,000 to $24,999 724.1%35$25,000 to $29,999271.5%42$30,000 to $34,99930.2%21$35,000 to $39,99910.1%12$40,000 to $44,999160.9%25$45,000 to $49,999301.7%77$50,000 to $59,999221.2%26$60,000 to $74,9991317.4%43$75,000 to $99,999 854.8%72$100,000 to $124,999 864.9%40$125,000 to $149,999201.1%11$150,000 to $199,99921512.2%147$200,000 or more49227.8%189Median Household Income for HHr 65+$78,360N/AAverage Household Income for HHr 65+N/AN/AData Note: N/A means not available.2017-2021 ACS Estimate: The American Community Survey (ACS) replaces census sample data. Esri is releasing the 2017-2021 ACS estimates, five-year period data collected monthly from January 1, 2017 through December 31, 2021. Although the ACS includes many of the subjects previously covered by the decennial census sample, there are significant differences between the two surveys including fundamental differences in survey design and residency rules.Margin of error (MOE): The MOE is a measure of the variability of the estimate due to sampling error. MOEs enable the data user to measure the range of uncertainty for each estimate with 90 percent confidence. The range of uncertainty is called the confidence interval, and it is calculated by taking the estimate +/- the MOE. For example, if the ACS reports an estimate of 100 with an MOE of +/- 20, then you can be 90 percent certain the value for the whole population falls between 80 and 120.Reliability: These symbols represent threshold values that Esri has established from the Coefficients of Variation (CV) to designate the usability of the estimates. The CV measures the amount of sampling error relative to the size of the estimate, expressed as a percentage.High Reliability: Small CVs (less than or equal to 12 percent) are flagged green to indicate that the sampling error is small relative to the estimate and the estimate is reasonably reliable.Medium Reliability: Estimates with CVs between 12 and 40 are flagged yellow-use with caution.Low Reliability: Large CVs (over 40 percent) are flagged red to indicate that the sampling error is largerelative to the estimate. The estimate is considered very unreliable.Source: U.S. Census Bureau, 2017-2021 American Community SurveyReliability:highmediumlowSeptember 20, 2023©2023 EsriPage 7 of 7
9/26/23, 6:56 PMMarket Research Memo – REAL ESTATE ANALYSIS – DePaul Universityhttps://d2l.depaul.edu/d2l/lms/dropbox/user/folder_submit_files.d2l?db=843676&grpid=0&isprv=0&bp=0&ou=9673231/6Mkt Research Paper Rubric (30 pts.)Course: REAL ESTATE ANALYSISCriteriaExcellentGoodSatisfactoryUnsatisfactoryCriterion Score
9/26/23, 6:56 PMMarket Research Memo – REAL ESTATE ANALYSIS – DePaul Universityhttps://d2l.depaul.edu/d2l/lms/dropbox/user/folder_submit_files.d2l?db=843676&grpid=0&isprv=0&bp=0&ou=9673232/6CriteriaExcellentGoodSatisfactoryUnsatisfactoryCriterion ScoreAppearance/Grammar/Syntax/ 55 pointsPaper is in abusiness memoformat: • To:,From:, Re:, andDate: linesused at top ofmemo • singlespaced wthand extraspace betweenparagraphs • numberedpages • headersused toidentifysectionsPaper useshighlyprofessionalwriting style: • no slang,colloquialspeech, orcontractions • correctspelling andpunctuation • paragraphstructure • correctword usage4 pointsPaper followsthe majority ofstyleconventions,but is missingone majorelement.Paper usesprofessionalwriting style,correct spellingandpunctuation,paragraphstructure, andcorrect wordusage for themost part; nomore than twowords aremisspelled.3 pointsPaper followssome styleconventions,but is missingmore than onemajor element.Paper uses acasual writingstyle, andincludesinconsistentspelling andpunctuation,paragraphstructure, andcorrect wordusage; morethan twowords aremisspelled.2 pointsPaper does notfollow styleconventions asoutlined in theinstructions.Paper does notfollowprofessionalwriting style,and containsnumerouserrors inspelling, wordusage andpunctuation.
9/26/23, 6:56 PMMarket Research Memo – REAL ESTATE ANALYSIS – DePaul Universityhttps://d2l.depaul.edu/d2l/lms/dropbox/user/folder_submit_files.d2l?db=843676&grpid=0&isprv=0&bp=0&ou=9673233/6CriteriaExcellentGoodSatisfactoryUnsatisfactoryCriterion ScoreMechanics/ 55 pointsPaperuploaded todropbox ontime, and allSTDB reportsare referencedby name in thepaper whendata isprovided. Datatable isincluded in thememo. At theend of thememo, there isa list of eachreport used.Each reporthas been savedas a PDF anduploaded tothe dropbox.4 pointsPaper andSTDB reportsare uploadedto dropbox ontime and datatable iscomplete, butdata ispresented inthe memowithoutreferencingwhich report itcame from. 3 pointsSTDB reportsare notuploaded tothe dropboxand/or datatable isincomplete.0 pointsDid not useSTDB. Datatable ismissing.
9/26/23, 6:56 PMMarket Research Memo – REAL ESTATE ANALYSIS – DePaul Universityhttps://d2l.depaul.edu/d2l/lms/dropbox/user/folder_submit_files.d2l?db=843676&grpid=0&isprv=0&bp=0&ou=9673234/6CriteriaExcellentGoodSatisfactoryUnsatisfactoryCriterion ScoreIntroduction/ProblemDefinition/ 55 pointsPaper includesa clear andconciseintroductionthat states thepurpose of thememo andidentifies thelocation of thesites, name oftheneighborhoods, where theyare located inthe city, accesstotransportation,etc.4 pointsPaper includesan introductionthat isorganized butmissing at leastone key point.3 pointsPaper includesan introductionthat is unclearor is missingmajor points.2 pointsPaper does notinclude anintroduction oris incomplete.
9/26/23, 6:56 PMMarket Research Memo – REAL ESTATE ANALYSIS – DePaul Universityhttps://d2l.depaul.edu/d2l/lms/dropbox/user/folder_submit_files.d2l?db=843676&grpid=0&isprv=0&bp=0&ou=9673235/6CriteriaExcellentGoodSatisfactoryUnsatisfactoryCriterion ScoreDemographicAnalysis/ 1010 pointsMemo usesandsummarizesrelevant STDBreports,including RetailSupply &Demand andTapestrySegments.Data table isincluded inmemo andreferencedwithcommentary.Analysisidentifieshighly relevantdata, which isorganized andpresented well.8 pointsMemo usesandsummarizesrelevant STDBreports. Analysisidentifiesmostly relevantdata, which ismoderatelywell organizedand presented.6 pointsMemo usesandsummarizesSTDB reports. Analysisincludesunrelated data,which is thinlyorganized andpresented.4 pointsMemo doesnot includedata analysis,or analysis isincomplete.
9/26/23, 6:56 PMMarket Research Memo – REAL ESTATE ANALYSIS – DePaul Universityhttps://d2l.depaul.edu/d2l/lms/dropbox/user/folder_submit_files.d2l?db=843676&grpid=0&isprv=0&bp=0&ou=9673236/6Total/ 30Overall ScoreCriteriaExcellentGoodSatisfactoryUnsatisfactoryCriterion ScoreRecommendations/ 55 pointsMemo includesarecommendations sectionwhich is clear,focused, andpersuasive, andmakes use ofrelevant datagathered in thedemographicanalysis.Identifies whattype of centerand what typeof retailer willbe optimalbased on theresearch.4 pointsMemo includesarecommendations sectionwhich issomewhatpersuasive, andmakes use ofrelevant datagathered in thedemographicanalysis.3 pointsMemo includesarecommendations sectionwhich containsbasic logicalflaws.2 pointsMemo doesnot includerecommendations, or isincomplete.Excellent27 points minimumGood24 points minimumSatisfactory21 points minimumUnsatisfactory0 points minimum
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
