Problem #1 (10 points) The manager of a shopping mall has noticed a continuous drop in overall mall sales in the last few years. Therefore, she decided that she might need to attract some new tenant shops. Her quick glance at the tenant mix indicated that shops selling clothing and footwear appear to be underrepresented in her tenant clientele. She knows that the majority of shoppers who come to her mall are people between 25 and 34 years old. The manager would like to identify the best rent per square foot of leasable area that she should offer to new tenants in the clothing and footwear sector. For that, she hired you as a real estate market analyst and asked you to calculate the purchasing potential of consumers in this age bracket for 2021. a. On the Bureau of Labor Statistics (BLS) website go to Data Tools. Under Data Retrieval Tools select "One Screen. Once there, search for the database on consumer spending collected from BLSs Consumer Expenditure (CE) Survey, which is under the Spending Time Use section. Both the one-screen data search" (green button) and "multi-screen data search (yellow button), among others, should be able to help you find the data needed to solve this problem (I personally think one screen is much easier to navigate). Spending on clothing and footwear is labeled as apparel and services. What are the annual expenditures for 2010-2020 for the group noted above? Show results in a table and in a time series graph. b. Forecast the expenditure for 2021 using the four moving-average (MA) methods below. 1. 2-year simple MA, 2. 3-year simple MA, 3. 2-year weighted MA, 4. 3-year weighted MA Problem #1 (10 points) The manager of a shopping mall has noticed a continuous drop in overall mall sales in the last few years. Therefore, she decided that she might need to attract some new tenant shops. Her quick glance at the tenant mix indicated that shops selling clothing and footwear appear to be underrepresented in her tenant clientele. She knows that the majority of shoppers who come to her mall are people between 25 and 34 years old. The manager would like to identify the best rent per square foot of leasable area that she should offer to new tenants in the clothing and footwear sector. For that, she hired you as a real estate market analyst and asked you to calculate the purchasing potential of consumers in this age bracket for 2021. a. On the Bureau of Labor Statistics (BLS) website go to Data Tools. Under Data Retrieval Tools select "One Screen. Once there, search for the database on consumer spending collected from BLSs Consumer Expenditure (CE) Survey, which is under the Spending Time Use section. Both the one-screen data search" (green button) and "multi-screen data search (yellow button), among others, should be able to help you find the data needed to solve this problem (I personally think one screen is much easier to navigate). Spending on clothing and footwear is labeled as apparel and services. What are the annual expenditures for 2010-2020 for the group noted above? Show results in a table and in a time series graph. b. Forecast the expenditure for 2021 using the four moving-average (MA) methods below. 1. 2-year simple MA, 2. 3-year simple MA, 3. 2-year weighted MA, 4. 3-year weighted MA
