Summarize And Present Data For Client Expansion Feasibility

Summarize & present data for client expansion feasibility

Applying Managerial Decision Making U2 Individual Projectxxxxxxxxxxx Applied Managerial Decision Making U2 Individual Projectxxxxxxxxxxx Summarize & present data for client expansion feasibility Prepared for big d management 1 Analyzing Market Data Lots of markets to choose from Is this the right one? How do we know? Good question Data driven decisions Maximize opportunities for success Welcome Big D management. Today we are trying to establish the feasibility of a new market for our client. Of course, with a world marketplace, business’s today have lots of choices.

Where should they invest their time and energy? Of course, there is no way to know with 100% certainty but data can be a critical decision driver. Growing a new market is like growing a you seedling, you want to plant in the most fertile soil under the most advantageous moisture and sunlight conditions. This careful attention to the environment you start in maximizes your chances for success. 2 Data Evaluation – Part I Proposed new market – Chicago “Control†population – US Evaluated based on potential for outdoor sporting goods Our client has proposed Chicago as a potential new market.

We have evaluated US Census data for 2000 in this area and in the overall US population. For our purposes, the US serves as the control population. Compared to the “average†US population, how does this area compare for purposes of characteristics we may find beneficial for effective marketing and sales our target product, outdoor sporting goods. First data set we look at is gender. Our client could make a determination based on the outdoor sporting good categories they specialize in and the gender that prefers those products.

While you can see there is not a significant variance between Chicago and the US, Chicago does have a slightly higher percentage of females when compares to the overall country (US Census). 3 Gender US Female Male 0.. Chicago Female Male 0.. Data Evaluation – Part I Next we look at Marital Status. This is an indicator of lifestyle, available resources and priorities.

Clearly this data set is not a driver in and of itself but it could be useful to correlate other data with that we evaluate. Chicago has roughly 20 percentage points more never married individuals than the US as a whole (US Census). What other data could we look at to determine if this is a good or a bad thing for our client? 4 Marital Status US Divorced Never Married Now Married Separated Widowed 9.E-2 0...E-2 6.E-2 Chicago Divorced Never Married Now Married Separated Widowed 7.E-2 0..3095 3.E-2 3.E-2 Data Evaluation – Part 2 Employment information is added to what we know about our market. The big difference you notice in this chart is that Chicago has roughly 20% more individuals in the Labor Force vs Not in the Labor Force compared to the US (US Census).

This indicates as you would expect that the never married individuals from the prior data set are in the labor force. This is a good indicator that these individuals have both the time and the resources for extra curricular activities. While this might not mean they would choose to spend money in a sporting good store, it would indicate that researching the market further is warranted. If the population is inclined to an outdoor lifestyle, they would not have resource nor familial constraints. Let’s explore further.

5 Employment US Not in Labor Force In Labor Force Employed Unemployed In Armed Forces 0....E-2 8.E-3 Chicago Not in Labor Force In Labor Force Employed Unemployed In Armed Forces 0.189 0...E-2 0 Data Evaluation – Part 3 For me, this is the chart that sells the market. Chicago household income over $200,000 is a staggering 11 percentage points greater than the national average (US Census). Chicago has greater percentages of household income averages all the way down to $75,000 and greater (US Census). In simple terms of disposable income, this is a huge indicator. With a product that is purely optional such as outdoor sporting goods, your market has to have money to spend on nice to haves and this market has that.

6 Household Income US $ 0 - $9,999 $ 10,000 - $14,999 $ 15,000 - $19,999 $ 20,000 - $24,999 $ 25,000 - $29,999 $ 30,000 - $34,999 $ 35,000 - $39,999 $ 40,000 - $44,999 $ 45,000 - $49,999 $ 50,000 - $59,999 $ 60,000 - $74,999 $ 75,000 - $99,999 $100,000 - $124,999 $125,000 - $149,999 $150,000 - $199,999 $200,000 + 9.E-2 6.E-2 6.25E-2 6.E-2 6.E-2 6.E-2 5.91E-2 5.E-2 4.E-2 9.E-2 0.1043 0.1023 5.E-2 2.52E-2 2.E-2 2.E-2 Chicago $ 0 - $9,999 $ 10,000 - $14,999 $ 15,000 - $19,999 $ 20,000 - $24,999 $ 25,000 - $29,999 $ 30,000 - $34,999 $ 35,000 - $39,999 $ 40,000 - $44,999 $ 45,000 - $49,999 $ 50,000 - $59,999 $ 60,000 - $74,999 $ 75,000 - $99,999 $100,000 - $124,999 $125,000 - $149,999 $150,000 - $199,999 $200,000 + 7.E-2 3.15E-2 3.E-2 3.04E-2 3.1E-2 4.E-2 4.E-2 4.E-2 3.E- 2 7.E-2 9.E-2 0.1147 8.E-2 5.E-2 7.E-2 0.

What Else? This is just the first step Other questions: What are the trends in disposable income expenditures? What is the household makeup of the married households? How much free time do the work force participants have? While the market looks very viable, there are more questions about the data we have crunched.

Additionally, we should ask the client what other markets are being considered? How do those markets compare to this one? In conclusion, we can offer our client value in their research. Here at Big D, we have the experience sorting through extensive data to derive information and present it in a meaningful way to help our clients make excellent decisions. We can help them take this set of data on their suggested market and further refine it to focus in on the legitimacy of this option.

We also have the experience to guide them to ask questions outside of this data set and pin point within the data set. While we are comparing to the entire US population data set here, that might not be the most useful comparison. An individual living outside of a major market for instance, might not matter as much to this client as individuals in major markets. I’m confident our whole team can help us turn this market expansion into a success for our client. 7 References Colorado Technical University. (2018).

Visual Aids [MUSE]. Retrieved from Colorado Technical University Virtual Campus, MGMTA-02 : Colorado Technical University. (2018). Presenting Business Statistics [MUSE]. Retrieved from Colorado Technical University Virtual Campus, MGMTA-02 : Colorado Technical University. (2018). Summarizing and Presenting Data [MUSE].

Retrieved from Colorado Technical University Virtual Campus, MGMTA-02 : Scott, M. (2018). MGMT600 Unit 2 live chat [Multimedia presentation]. Retrieved from Colorado Technical University Virtual Campus, MGMTA-02: US Census Data 8 When submitting any assignment that has any source code or scripts, please cite accordingly as follows. You will need to adjust the syntax for the comments as appropriate for the programming or scripting language you are using. 1.

If this was an individual assignment as directed by your instructor, please include the following citation in the comments above your code. // Student Name // Course Number // Date // This is my own work. 2. If this was an individual assignment as directed by your instructor and source code was used from an external source, such as a website or text book, please include the following citation in the comments above your code. // Student Name // Course Number // Date // I used source code from the following websites to complete this assignment: please list the URL here and what it was used for. 3. If this was a group/partner assignment as directed by your instructor, please include the following citation in the comments above your code. // Student Name // Course Number // Date // This assignment was completed in collaboration with student name, student name 2, student name // We used source code from the following websites to complete this assignment: please list the URL here and what it was used for (if applicable) Assignment Python: Pick and Show - Variables, Data Types, Functions Details: The purpose of this assignment is to allow you to become familiar with the JES programming environment by creating your first program.

Download and install JES (Jython Environment for Students) from the Media Computation Teachers Website. Assignment Instructions: 1. Search the Internet and find a photograph of an antelope. 2. Similarly, search the Internet for a sound file (WAV) associated with an antelope.

3. Create a program that prompts the user for each of these files, and displays them. Submit the following in a compressed, zip file format: 1. Your Python program; naming convention is: firstInitial+lastName+PickAndShow.py. Example: dharalsonPickAndShow.py 2.

At least one screen caputre demonstrating that your program was functional 3. ZIP file naming convention is: firstInitial+lastName+PickAndShow.zip For this assignment, you will need to become familiar with specialized business intelligence (BI) software, then download the software. Complete the following steps to begin: · Step 1: Watch an instructional video on the BI software. · Step 2 : Review various BI Software options including Tableau; Excel or other Business Intelligence. Search the CTU Library and the internet to learn about optional software. · Step 3 : If you choose Tableau, download the Tableau BI software. After you select the link, look for the orange icon in the middle portion of your screen to begin the download or use any Business Intelligence software to create at least 2 graphs illustrating at least 2 comparisons between the US and zip code data.

Consider the following scenario, continued from the Unit 1 Individual Project: Big D Incorporated needs to prepare an assessment regarding the feasibility of making a recommendation for expansion into another market. As the Business Analyst, your assignment is to prepare a short presentation for the Board of Directors that apply concepts learned in Unit 1 and concepts from Unit 2 to make the necessary recommendations and justifications for those recommendations. You will need to compare and contrast the varying markets in order to make the best recommendation possible. Complete the following: · Click here to download the reports for the United States. The Web site provides free demographical services where one can choose from a variety of criteria and generate reports based on the U.S.

Census data. This particular file contains 4 reports: General Summary, Census Trend 1980 to 2000 Summary, Occupation and Employment Summary, and Income Summary based on the entire United States. · Click here to download the reports for zip code 60614. This particular file contains 4 reports: General Summary, Census Trend 1980 to 2000 Summary, Occupation and Employment Summary, and Income Summary based on the U.S. zip code 60614. · Using all 4 demographic reports (General Summary, Census Trend 1980 to 2000 Summary, Occupation and Employment Summary, and Income Summary) for the United States and zip code 60614, prepare a 1-page memo explaining how your territory differs from the national profile.

Feel free to note anything that you found surprising in this data. · Use the business intelligence software you choose to depict information from these reports. · Prepare a presentation of 5–6 slides of your major findings. You may group a category of data from the Total United States and zip code 60614, and create a graph to show how they differ. The presentation should have at least two graphs and a headline that summarizes a key takeaway from the graph. The last page should contain at least 3 questions that you would want answered based on what you've seen in this comparison. Your presentation should include 5–6 slides in PowerPoint, plus title and reference slides with speaker notes (200–250 words per slide).

For assistance with the usage of Tableau for analysis and reporting, review and use the following instructions. This should be helpful if you are having problems with the software usage or with problems with the data. But, you do not need to use Tableau. For BI software usage such as Excel, resort to using the Help functions and other resources on the internet and in videos to learn how to use Excel to create graphical presentations including table usage. Instructions to Create Bar Graph in Tableau (optional) or in another BI Software.

1. Open the assignment CTU instructions. 2. Download Business Intelligence Software. 3.

Create your Tableau Public Account. 4. Click the download link for the zip code (60614) file (file will open in Excel). 5. Click the download link for the US file (file will open in Excel).

6. The following are some options: 1. Create separate demographical worksheets. For example: Education Attainment File - Worksheet (include both Zip Code and U.S. data); Household Income (include both Zip Code and U.S. data) · See a sample of the file available with column headings and extraneous blanks. Household Income Chicago U.S. to to Median Household Income 18,,.,.,902 Average household Income 24,,.,.,382 Per Capita Income 13,,.,.,321 · See a sample of the file available with column headings and extraneous blanks.

2000 Educational Attainment U.S. Chicago College: Associates Degree 6.3% 1.9% College: Bachelor's Degree 15.5% 44.2% College: Graduate Degree 8.9% 34.0% College: Some College, no Degree 21.1% 8.7% School: 9th to 11th grade, no diploma 12.1% 3.2% School: Grade K-.1% 2.0% School: High School Graduate 28.6% 5.6% 2. Create a file with data organized without extraneous rows and columns but including headings. 3. The idea is to clean up the file before usage.

Separating files and worksheets may be the best way to make this happen 4. Note in the real situation, when using BI software, you will want to ensure your data are clean and you have similar data in your files. 8. Save the file(s) on your computer. 9.

Open Tableau. Then do a File > Open > Open your saved file. 10. At the bottom of the screen on the left, click on the little box next to Sheet 1 (looks like a bar graph with a plus in the top left corner). 11.

Under Measures (on left), you should see Chicago and U.S. Click on U.S. and pull it into rows at the top of the screen. Then click on Chicago and pull it over into rows. 12. Under Dimensions on the left, you should see Household Income.

Click on Household Income and pull it into column. 13. Now in the second column from the left, you should see measures. 14. In the top right corner, you should see a “show me†box illustrating ways you can view the data based on the values you have chosen.

To do side-by-side comparisons, put your cursor over the rightmost picture on the third line with the side-by-side blue and orange bars. Click on it. Your graph should appear on the page. You can play around with how you want to portray your data. 15.

To save in Tableau Public, click File > Save to Tableau Public as… > give the file a descriptive name. You will be asked to log into Tableau Public using your e-mail and password. 16. When your graph is saved in public, at the bottom right, there is a download button. Decide how you will save the file. (You can create an image and name the .png file.

It will be saved in tableau public.) 17. After the file is saved, open the .png file, and edit or copy the graph. 18. Open your PowerPoint file, then paste (special) it on the slide. You can adjust the size.

19. Repeat the same in Tableau opening of any other prepped and cleaned file. Note: Measure values are your number fields; measure names are the descriptors. Please submit your assignment. For more information on creating PowerPoint Presentations, please visit the Microsoft Office Applications Lab.

Sample Paper For Above instruction

The feasibility of expanding into a new market is a critical consideration for any business aiming to grow sustainably. This paper evaluates the market potential of Chicago as a target location for outdoor sporting goods, using extensive demographic data analysis to inform decision-making. The comprehensive assessment includes a review of gender distribution, marital status, employment figures, household income levels, and other relevant demographic indicators, benchmarked against national US data to determine Chicago’s attractiveness for market entry.

Firstly, gender demographics reveal that Chicago’s population has a slightly higher percentage of females compared to the national average. This indicates potential marketing advantages if the company’s product line resonates more with women or if targeted advertising strategies are tailored accordingly. Gender alone, however, is insufficient to determine market viability, but it serves as an initial point for further deep analysis.

Marital status data shows that Chicago has approximately 20% more individuals who have never married compared to the US as a whole. The implications for outdoor sporting goods marketing are mixed; single individuals might have more disposable income and free time, possibly increasing potential sales, but they might also have different outdoor activity preferences. Further analysis of household composition and lifestyle preferences would help clarify this point.

Employment data indicates that Chicago has roughly 20% more individuals actively participating in the labor force than the national average. This suggests that a significant portion of the population has regular income and available leisure time. The correlation between employment status and disposable income underscores a promising market where consumers are more likely to afford and invest in outdoor recreational equipment.

House