Economic Base Analysis of a Local Community-Broward County and State Florida
Order Description
If need more pages, you may add. I have a sample assignment from other student attached. I expect have this assignment similar as sample. Please use that following. Census Data link is
www.census.gov. any data , use CENSUS. VERY IMPORTANT TO FOLLOW ALL STEPS BY STEPS. DON’T MISS ANYTHING INSTRUCTION. USE BROWARD COUNTY & STATE FLORIDA.
Economic Base Analysis of a Local Community In this assignment students are expected to write a short report to profile a local community’s basic vs. non-basic sectors. Use the same county that you
selected for your first assignment. The report should follow the structure indicated below and must have an electronic copy submitted to Canvas. All the student assignments are subject to check for
originality. All the charts, tables and maps should be sequentially numbered and named (e.g. Figure 1: Racial composition of the county; Table 1: Historic population counts, etc.). Sources of the
data should be properly credited following the charts/tables/maps. Sparely cite the charts/tables/maps from other sources and create them yourself if possible. Use APA citation format for all your
references. Use 1.15 line spacing and appropriate font types. Either landscape or portrait page orientation is acceptable. Organize the tables, graphs, maps, and the text in a way that is nether
cluttered nor with too much space. Align your texts, tables, graphs, maps, and the text. Insert page numbers. Use headings and subheadings, which will be useful for creating the Table of Contents
automatically. Headings and subheadings should be stressed with either bold, larger font sizes, different colors, or a combination of these techniques. Maps should have all the map elements, such
as the map itself, legend, north arrow, scale bar, creator, and creation date. Page margins should be 1” all around. You can use Microsoft Publisher or Photoshop Illustrator to format your report
if you choose to do so. Otherwise, please submit a Microsoft Word or Adobe pdf file to Canvas. Adobe pdf files are highly suggested since Word files sometimes shift when opening in a different
version, different computer, or different operating system. Learning objectives of the assignment: ? Format and techniques of professional report writing ? The use of secondary data sources in
profiling a local community ? Basic techniques in creating professional charts and tables ? The calculation of Location Quotients to measure economic strength of an area Structure of the report: 1.
Cover page: topic, student name, course name and number, date Topic: e.g. Economic Base Analysis of Palm Beach County, Florida 2 2. Table of Contents, List of Tables, and List of Figures 3.
Executive Summary: main findings should be in this section. 4. Introduction Briefly introduce the county’s economic characteristics. Then mention that you will focus on economic base analysis by
using the Census data. Explain your methodology. 5. Economic Base Analysis In this section you need to find the employment data by different industries for your county, compare the data with those
at the state level and calculate Location Quotients and Base Multipliers. Most of the aggregated data on business establishment, employment and payroll can be obtained from the American FactFinder
(https://factfinder2.census.gov/faces/nav/jsf/pages/index.xhtml.) and the County Business Patterns (https://www.census.gov/econ/cbp/index.html). Some data can be also retrieved from the Bureau of
Labor Statistics. In this assignment we use data from the County Business Patterns website. Go to https://www.census.gov/econ/cbp/index.html, choose Data, and “CBP Data Tables”. Choose “U.S.,
States, Counties, Puerto Rico and Island Areas Tables – 2014”. Choose the state where your county is located at. Then either copy and paste the data, or down load the data table to Excel.
Downloading is recommended to preserve all the data information. After you download the state-level data and save them to an Excel file, on the same webpage, choose “add/remove geographies” and
find your county. Remove the state information if you prefer and download the county information to another Excel file. Or you can keep the state and the county information together, save it to one
Excel file and then reorganize the data based on the following assignments. Two-digit NAICS (North American Industrial Classification System) industry code is sufficient. 5.1 Calculate the
percentage share of employment for each industry among total employment at the county and state levels. Create two radar/rose diagrams to delineate the shares at both the county and the state
levels. Include the charts in your report and describe your findings and comparisons. 5.2. Calculate the percentage share of annual payroll for each industry among all industries at the county and
state levels. Create two radar/rose diagrams to delineate the shares at both the county and the state levels. Include the charts in your report and describe your findings and comparisons. 5.3.
Calculate the annual payroll per employee for each industry at the county and state levels. Create a clustered bar chart to delineate the annual payroll per employee for each industry at the county
and the state levels. Include the chart in your report and describe your findings and comparisons. 3 5.4. Create a few new worksheets and organize your county and state data in Excel based on the
Excel file “Assumption and LQ Model”. Calculate the basic employment of the county based on Assumption approach, Location Quotients approach, and Simple Combination approach. Create a radar/rose
diagram of the LQs for each industry in the county. Explain what the LQ means for each industry. Include all three tables (assumption, LQ, and simple combination) and the LQ chart in your report.
5.5. Calculate the employment base multiplier for the county based on the simple combination approach. Explain what it means. 6. References 7. Appendices (if applicable).
