23 Apr This assignment is designed to expand your knowledge of the Small Business Strategy Process by focusing on Step 3 of the process: Industry Dynamics and Analysis.
This assignment is designed to expand your knowledge of the Small Business Strategy Process by focusing on Step 3 of the process: Industry Dynamics and Analysis. Industry Analysis is a tool used to provide an overview of the industry. This assignment will be performed on the industry you have identified for your business idea. This assignment has two parts: the excel calculations and an analysis of the industry based on your calculations.
This assignment may be a good starting point to use when you write the Industry Analysis section of your business plan. Upon completion of this assignment, you will have identified the size of the industry for your business idea both in terms of dollars, number of establishments and number of employees. In addition, you will do calculations using the data to give you further insights regarding averages per establishment.
https://learn-us-east-1-prod-fleet02-xythos.content.blackboardcdn.com/5fda9d7e7f5d0/2129478?X-Blackboard-S3-Bucket=learn-us-east-1-prod-fleet01-xythos&X-Blackboard-Expiration=1682067600000&X-Blackboard-Signature=LMmX3854YXgkVuJC9VucM2gncCUHxWWEopwb5wo2PU4%3D&X-Blackboard-Client-Id=476776&X-Blackboard-S3-Region=us-east-1&response-cache-control=private%2C%20max-age%3D21600&response-content-disposition=inline%3B%20filename%2A%3DUTF-8%27%27MGS3013_U5_AS_Example.pdf&response-content-type=application%2Fpdf&X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKT%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCXVzLWVhc3QtMSJHMEUCICr3NeUzzzkM8ZuHz%2FInv2EpDJpqRYWxxhir1NfpSneeAiEAt6GMg%2FjKjJHWQHz%2BtJ2b1qM1NLdi8d8rhmJEJWaQBqsqvQUInf%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FARADGgw2MzU1Njc5MjQxODMiDNGe7PF5XueCVQLbFiqRBbIm2D%2BjZckWZHSG3cDwR25m32y%2Fw%2FEdKC4TRE3wVzSJHOQ%2FdvSvB8yMTn8WWcROER3Cs4%2Fx6yHJRxgeS94lSZ1qjEWTSbx5YW%2Bs2KyaCa4u5xcQzTd2U7762BU6nXVksc2h52t2KOeGWYDZKzPPk06D4kfjOgg6eH4eny3l7HSpp%2FeY%2B673jZgoOsjF09CM92UnQOu3HX1%2BkwYQaDaD4kmSh04s%2Fx9gO6BJqinGwEE4CGrbpSxl%2FanD6ddtchGZdi5hgYIAfFF%2Fg11qU8zMsVxIIrUib2xGIIRvdJRmvmAEZ4jymMMMtw3zFlLUHjfrWp9lHGQAP8%2BDd51thNXxG20zhwEo9voYLufaFc1Y0E0ocF7LvdrFdN63uE3nH7ujNr9YyxgaQ18F1gSD2OW3FRJN%2B%2BCqpNtG5tZYDWCXkIKFMB8KlsBvApqY7dNqwDdxrJSbUaeJfX%2B9OBbsl6prom3gc%2BKo2YamYolmQB6qCc0wST8weHRFtvfCCzthjJS2iK3HGgYHePXxg%2F3m67u%2Bwpf%2BYN%2BG5AAeOGlxmNnuVEJMbfS2Mv8qHy2fNdV7Ujv%2F6eq2%2Bkvqa9HLBtu81M%2Btj5frPoIL6hPnf%2FSfEHh1HxYNKw%2BlR2l9FGUUoH02g%2FT8JWEis8lgSu3cie2OOIqqoR4%2B7cFRKFx03h%2F%2FxN41de9AzguEbScKzpLn%2FwvFEp5Yo1VJUfcZauXBOzadbB8TlUHlFi4M6unKCCIKI2i2yO8WJ640YQLw%2BusNu%2B1asJT4%2Fsjhx03mOew4m%2BGOpuUsQ1LvBrLocTc3yFq5Z9Daw7SBUqPRSi9EebhChBeohMrwShN7%2FUggTA6jAdp%2Boj1tFtmjSI7vUKLrt0ZMi0o4500aZTDxiYiiBjqxAcJF0IAy4LpDk%2BhGegTnsUYOrpPDUKASaJaVPn2RyYXHy6gyP7FIIZ4xVxQcmzJQTeLMkNYKbXAgNJ8lHnJHleQhGu%2B8d%2FSzkJYvoBhNO89bOYDYErGDaP%2FOUf5%2FNvCrjsKHIW11QEhbtfwMaXWPX5H%2FcWaSIXbyUxmwDtwdATAtYIsL8IDcOMP5RgyxHM79%2Fi0xVdnGqCriirAP0oJLFPIScoVQgP77iVdslTw64nA8WQ%3D%3D&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20230421T030000Z&X-Amz-SignedHeaders=host&X-Amz-Expires=21600&X-Amz-Credential=ASIAZH6WM4PLRBNJFUGC%2F20230421%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Signature=c4206f6b3c3d99b2eeeeea2b1a05b7caadbf8c43308c84cc3ee3f0b4cf4edc3a
Sheet1
| census.gov | |||||||||
| Cells in Yellow have made up numbers and need you to import data from census.gov | |||||||||
| Cells in Green has formulas as examples | |||||||||
| Cells in Grey need to be calculated with formulas as shown in the examples | |||||||||
| Geographic Area Name | NAICS Code | Meaning of NAICS Code | Year | Number of Establishments | Sales, Value of Shipments, or Revenue ($1,000) | Annual Payroll ($1,000) | Number of Employees | ||
| U.S. | 722511 | Full Service Restaurants | 2017 | 231,927 | $224,320,799 | $74,086,843 | 4,772,294 | ||
| U.S. | 722511 | Full Service Restaurants | 2012 | 220,089 | $192,258,833 | $63,259,045 | 4,603,747 | ||
| Increase/ Decrease | 11,838 | ||||||||
| Increase/ Decrease % | 5.4% | ||||||||
| New Jersey | 722511 | Full Service Restaurants | 2017 | 6,906 | $6,203,769 | $1,829,403 | 108,442 | ||
| New Jersey | 722511 | Full Service Restaurants | 2012 | 6,268 | $5,301,608 | $1,600,699 | 103,528 | ||
| Increase/ Decrease | 638 | ||||||||
| Increase/ Decrease % | 10.2% | ||||||||
| Average Revenue per Establishment | U.S. | New Jersey | |||||||
| 2017 | $967,204 | ||||||||
| 2012 | $873,550 | ||||||||
| Increase/ Decrease $ | $93,654 | ||||||||
| Increase/ Decrease % | 10.7% | ||||||||
| Average # of Employees per Establishment | U.S. | New Jersey | |||||||
| 2017 | 20.58 | ||||||||
| 2012 | 20.92 | ||||||||
| Increase/ Decrease | -0.34 | ||||||||
| Increase/ Decrease % | -1.6% | ||||||||
| Average Cost of Payroll per Employee | U.S. | New Jersey | |||||||
| 2017 | $15,524 | ||||||||
| 2012 | $13,741 | ||||||||
| Increase/ Decrease $ | $1,784 | ||||||||
| Increase/ Decrease % | 13.0% | ||||||||
,
MGS3013 Unit 5 AS: Industry Analysis
This assignment is designed to expand your knowledge of the Small Business Strategy Process by focusing on Step 3 of the process which is Industry Dynamics and Analysis. The Industry Analysis is a tool used to provide an overview of the industry.
This assignment showcases a good starting point when writing the Industry Analysis section of a business plan. Upon completion of this assignment, you will have identified the size of your industry both in terms of dollars, number of establishments and number of employees. In addition, you will do calculations using the data to give you further insights regarding averages per establishment. You will complete this exercise by writing an analysis of the industry based on your calculations.
Please use the NAICS code that is for your industry. You can find this information via Google Search. In rare cases, census.gov does not provide the full set of data for your industry, you should use NAICS code 722511 to do this assignment.
Directions (NAICS code 722511 is used below as an example– please replace with your NAICS code):
1) Go to www.census.gov, click on "Explore Data", then "Explore Data Main". Click the search box (in the center of the screen) and choose “Advanced Search”.
2) Under “Find a Filter”, enter “722511” and choose “722511 – Full-service restaurants” as “Industries”. Click “Search” on the right bottom corner.
3) Your research is going to result in a large number of reports. Click “Filter” on the left upper corner. You need to make two filters: one for “Geography” and one for “Years”.
Step 1: Choose “Geography” > “Nation” > “United Stated”;
Step 2: Choose “Years” > 2017
Click “Search” or “Done”
4) Now you are about to retrieve the restaurant business data for “US” in the year of “2017”. Choose the table with the ID of “EC1700BASIC”. Using the data from the resultant table, copy the data into the excel template file provided.
5) Next, Click “Filter” on the left upper corner, next to “Download”. Choose “Years”. Unclick “2017” and click “2012” and “Search”. Now you are about to retrieve the restaurant business data for “US” in the year of “2012”. Choose the table with the ID of “EC1200A1”. Using the data from this new resultant table, copy the data into the excel file.
6) Click “Filter” on the left upper corner, next to “Download”. Deselect “US” as one of the “Selected Filters” (located on the bottom of the page) and go back up to adjust your filters. Choose “Geography” > “State” > “New Jersey”. Click “Search”. Now you are about to retrieve the restaurant business data for “NJ” in the year of “2012”. On the left menu bar, choose the table with the ID of “EC1200A1”. Using the data from this new resultant table, copy the data into the excel file.
7) Click “Filter” on the left upper corner, next to “Download”. Choose “Years”. Unclick “2012” and click “2017”. Click “Search”. Now you are about to retrieve the restaurant business data for “New Jersey” in the year of “2017”. On the left menu bar, choose the table with the ID of “EC1700BASIC”. Copy the data into the excel file.
8) Prepare your spreadsheet using the example as a guide. You may not use a calculator to do this assignment. All calculations must be done using Excel formulas.
9) After completion of your spreadsheet, upload it by clicking on this assignment link and under “Write Submission” prepare a one-paragraph written analysis of the industry describing its size, trends, averages, etc.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Wridemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.