# Economic Base Analysis of a Local Community-Broward County and State Florida

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;

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).