Category: Supply Chain

Assignment Prompt:
For Project 4, your assignment will be in Chapters 8 and 9. F

Assignment Prompt:
For Project 4, your assignment will be in Chapters 8 and 9. For the next two weeks, you will be using the attached Excel Spreadsheet workbook to answer 6 data analysis questions. There are 6 tabs on the excel workbook, one for each of the 6 questions you will be answering. The first three tabs (1, 2, & 3) relate to Chapter 8 (Forecasting and demand planning) while tabs 4, 5, and 6 relate to calculations you will be completing regarding chapter 9 (Inventory management). The 6 calculation problems you will complete are all referenced back to an example in chapters 8 and 9. For most of the tabs, there are multiple tasks to complete, all are sequential, so complete them in order. The point values for each problem are in the instructions.
Instructions:
To receive credit, you must use formulas to calculate all answers. If your Excel formulas skills are rusty, a hyperlink is provided below to short tutorials in GCFLearnFree.org where you can brush up on inserting formulas, summing tables of data, etc. It is recommended that you review these early in Week 7.
Finally, there are detailed instructions for how to complete each problem in the Excel template below. Download the template, store it in your computer, then, please read the instructions carefully. Upload the completed excel file to this week when you are ready for it to be graded. Use the following naming convention JSmith_Project4
https://edu.gcfglobal.org/en/excelformulas/

I CAN SUPPLY DATA SET VIA EXCEL
You are a real estate and property management bu

I CAN SUPPLY DATA SET VIA EXCEL
You are a real estate and property management business analyst in a big city. Your company’s leadership team supports building reasonably priced housing in areas that have well-performing schools with low school dropout rates (home price and dropout rate are the key factors). You wish to commission a consulting team of business and data analysts to build a full dashboard that will address the best locations for new construction projects within the five boroughs of the city based on the company’s mission and various performance metrics.
You decide to build a basic prototype model of the dashboard using the home price and dropout rate data for one borough. This prototype model will help you explain the project to your company’s leadership before you meet with the consultants who will build the full dashboard with many other predictive factors. You also want to be able to clearly report a data story about the project to the leadership team using your prototype.
To ensure you understand the data that will be included in the dashboard model, you will first need to connect your Excel data with Tableau and look at it visually.
Use the provided “D466 Task 1 Data Set” to complete this task.
Provided model data for the borough:
average three-bedroom home prices by year
average dropout % by year
Requirements
Your submission must be your original work. No more than a combined total of 30% of the submission and no more than a 10% match to any one individual source can be directly quoted or closely paraphrased from sources, even if cited correctly. The similarity report that is provided when you submit your task can be used as a guide.
You must use the rubric to direct the creation of your submission because it provides detailed criteria that will be used to evaluate your work. Each requirement below may be evaluated by more than one rubric aspect. The rubric aspect titles may contain hyperlinks to relevant portions of the course.
Tasks may not be submitted as cloud links, such as links to Google Docs, Google Slides, OneDrive, etc., unless specified in the task requirements. All other submissions must be file types that are uploaded and submitted as attachments (e.g., .docx, .pdf, .ppt).
A. Describe the two main factors—home price and dropout rate—in the scenario.
1. Explain, using data from the “D466 Task 1 Data Set,” the current state of home prices.
a. Use Tableau to create an appropriate data visualization that shows the current state of home prices.
b. Identify one design technique you used in the visualization from part A1a and explain how it addresses a common accessibility issue.
c. Identify one design technique different than the one identified in part A1b and explain how it contributes to effective representation of the information in the data set.
2. Explain, using data from the “D466 Task 1 Data Set,” how a change in school dropout rates would affect home prices.
a. Use Tableau to create an appropriate data visualization that shows how a change in school dropout rates (independent variable) would affect home prices (dependent variable).
b. Identify one design technique you used in the visualization from part A2a and explain how it addresses a common accessibility issue.
c. Identify one different design technique than the one used in part A2b and explain how it contributes to effective representation of the information in the data set.

I CAN SUPPLY DATA SET VIA EXCEL
You are a real estate and property management bu

I CAN SUPPLY DATA SET VIA EXCEL
You are a real estate and property management business analyst in a big city. Your company’s leadership team supports building reasonably priced housing in areas that have well-performing schools with low school dropout rates (home price and dropout rate are the key factors). You wish to commission a consulting team of business and data analysts to build a full dashboard that will address the best locations for new construction projects within the five boroughs of the city based on the company’s mission and various performance metrics.
You decide to build a basic prototype model of the dashboard using the home price and dropout rate data for one borough. This prototype model will help you explain the project to your company’s leadership before you meet with the consultants who will build the full dashboard with many other predictive factors. You also want to be able to clearly report a data story about the project to the leadership team using your prototype.
To ensure you understand the data that will be included in the dashboard model, you will first need to connect your Excel data with Tableau and look at it visually.
Use the provided “D466 Task 1 Data Set” to complete this task.
Provided model data for the borough:
average three-bedroom home prices by year
average dropout % by year
Requirements
Your submission must be your original work. No more than a combined total of 30% of the submission and no more than a 10% match to any one individual source can be directly quoted or closely paraphrased from sources, even if cited correctly. The similarity report that is provided when you submit your task can be used as a guide.
You must use the rubric to direct the creation of your submission because it provides detailed criteria that will be used to evaluate your work. Each requirement below may be evaluated by more than one rubric aspect. The rubric aspect titles may contain hyperlinks to relevant portions of the course.
Tasks may not be submitted as cloud links, such as links to Google Docs, Google Slides, OneDrive, etc., unless specified in the task requirements. All other submissions must be file types that are uploaded and submitted as attachments (e.g., .docx, .pdf, .ppt).
A. Describe the two main factors—home price and dropout rate—in the scenario.
1. Explain, using data from the “D466 Task 1 Data Set,” the current state of home prices.
a. Use Tableau to create an appropriate data visualization that shows the current state of home prices.
b. Identify one design technique you used in the visualization from part A1a and explain how it addresses a common accessibility issue.
c. Identify one design technique different than the one identified in part A1b and explain how it contributes to effective representation of the information in the data set.
2. Explain, using data from the “D466 Task 1 Data Set,” how a change in school dropout rates would affect home prices.
a. Use Tableau to create an appropriate data visualization that shows how a change in school dropout rates (independent variable) would affect home prices (dependent variable).
b. Identify one design technique you used in the visualization from part A2a and explain how it addresses a common accessibility issue.
c. Identify one different design technique than the one used in part A2b and explain how it contributes to effective representation of the information in the data set.

I CAN SUPPLY DATA SET VIA EXCEL
You are a real estate and property management bu

I CAN SUPPLY DATA SET VIA EXCEL
You are a real estate and property management business analyst in a big city. Your company’s leadership team supports building reasonably priced housing in areas that have well-performing schools with low school dropout rates (home price and dropout rate are the key factors). You wish to commission a consulting team of business and data analysts to build a full dashboard that will address the best locations for new construction projects within the five boroughs of the city based on the company’s mission and various performance metrics.
You decide to build a basic prototype model of the dashboard using the home price and dropout rate data for one borough. This prototype model will help you explain the project to your company’s leadership before you meet with the consultants who will build the full dashboard with many other predictive factors. You also want to be able to clearly report a data story about the project to the leadership team using your prototype.
To ensure you understand the data that will be included in the dashboard model, you will first need to connect your Excel data with Tableau and look at it visually.
Use the provided “D466 Task 1 Data Set” to complete this task.
Provided model data for the borough:
average three-bedroom home prices by year
average dropout % by year
Requirements
Your submission must be your original work. No more than a combined total of 30% of the submission and no more than a 10% match to any one individual source can be directly quoted or closely paraphrased from sources, even if cited correctly. The similarity report that is provided when you submit your task can be used as a guide.
You must use the rubric to direct the creation of your submission because it provides detailed criteria that will be used to evaluate your work. Each requirement below may be evaluated by more than one rubric aspect. The rubric aspect titles may contain hyperlinks to relevant portions of the course.
Tasks may not be submitted as cloud links, such as links to Google Docs, Google Slides, OneDrive, etc., unless specified in the task requirements. All other submissions must be file types that are uploaded and submitted as attachments (e.g., .docx, .pdf, .ppt).
A. Describe the two main factors—home price and dropout rate—in the scenario.
1. Explain, using data from the “D466 Task 1 Data Set,” the current state of home prices.
a. Use Tableau to create an appropriate data visualization that shows the current state of home prices.
b. Identify one design technique you used in the visualization from part A1a and explain how it addresses a common accessibility issue.
c. Identify one design technique different than the one identified in part A1b and explain how it contributes to effective representation of the information in the data set.
2. Explain, using data from the “D466 Task 1 Data Set,” how a change in school dropout rates would affect home prices.
a. Use Tableau to create an appropriate data visualization that shows how a change in school dropout rates (independent variable) would affect home prices (dependent variable).
b. Identify one design technique you used in the visualization from part A2a and explain how it addresses a common accessibility issue.
c. Identify one different design technique than the one used in part A2b and explain how it contributes to effective representation of the information in the data set.

I CAN SUPPLY DATA SET VIA EXCEL
You are a real estate and property management bu

I CAN SUPPLY DATA SET VIA EXCEL
You are a real estate and property management business analyst in a big city. Your company’s leadership team supports building reasonably priced housing in areas that have well-performing schools with low school dropout rates (home price and dropout rate are the key factors). You wish to commission a consulting team of business and data analysts to build a full dashboard that will address the best locations for new construction projects within the five boroughs of the city based on the company’s mission and various performance metrics.
You decide to build a basic prototype model of the dashboard using the home price and dropout rate data for one borough. This prototype model will help you explain the project to your company’s leadership before you meet with the consultants who will build the full dashboard with many other predictive factors. You also want to be able to clearly report a data story about the project to the leadership team using your prototype.
To ensure you understand the data that will be included in the dashboard model, you will first need to connect your Excel data with Tableau and look at it visually.
Use the provided “D466 Task 1 Data Set” to complete this task.
Provided model data for the borough:
average three-bedroom home prices by year
average dropout % by year
Requirements
Your submission must be your original work. No more than a combined total of 30% of the submission and no more than a 10% match to any one individual source can be directly quoted or closely paraphrased from sources, even if cited correctly. The similarity report that is provided when you submit your task can be used as a guide.
You must use the rubric to direct the creation of your submission because it provides detailed criteria that will be used to evaluate your work. Each requirement below may be evaluated by more than one rubric aspect. The rubric aspect titles may contain hyperlinks to relevant portions of the course.
Tasks may not be submitted as cloud links, such as links to Google Docs, Google Slides, OneDrive, etc., unless specified in the task requirements. All other submissions must be file types that are uploaded and submitted as attachments (e.g., .docx, .pdf, .ppt).
A. Describe the two main factors—home price and dropout rate—in the scenario.
1. Explain, using data from the “D466 Task 1 Data Set,” the current state of home prices.
a. Use Tableau to create an appropriate data visualization that shows the current state of home prices.
b. Identify one design technique you used in the visualization from part A1a and explain how it addresses a common accessibility issue.
c. Identify one design technique different than the one identified in part A1b and explain how it contributes to effective representation of the information in the data set.
2. Explain, using data from the “D466 Task 1 Data Set,” how a change in school dropout rates would affect home prices.
a. Use Tableau to create an appropriate data visualization that shows how a change in school dropout rates (independent variable) would affect home prices (dependent variable).
b. Identify one design technique you used in the visualization from part A2a and explain how it addresses a common accessibility issue.
c. Identify one different design technique than the one used in part A2b and explain how it contributes to effective representation of the information in the data set.

I CAN SUPPLY DATA SET VIA EXCEL
You are a real estate and property management bu

I CAN SUPPLY DATA SET VIA EXCEL
You are a real estate and property management business analyst in a big city. Your company’s leadership team supports building reasonably priced housing in areas that have well-performing schools with low school dropout rates (home price and dropout rate are the key factors). You wish to commission a consulting team of business and data analysts to build a full dashboard that will address the best locations for new construction projects within the five boroughs of the city based on the company’s mission and various performance metrics.
You decide to build a basic prototype model of the dashboard using the home price and dropout rate data for one borough. This prototype model will help you explain the project to your company’s leadership before you meet with the consultants who will build the full dashboard with many other predictive factors. You also want to be able to clearly report a data story about the project to the leadership team using your prototype.
To ensure you understand the data that will be included in the dashboard model, you will first need to connect your Excel data with Tableau and look at it visually.
Use the provided “D466 Task 1 Data Set” to complete this task.
Provided model data for the borough:
average three-bedroom home prices by year
average dropout % by year
Requirements
Your submission must be your original work. No more than a combined total of 30% of the submission and no more than a 10% match to any one individual source can be directly quoted or closely paraphrased from sources, even if cited correctly. The similarity report that is provided when you submit your task can be used as a guide.
You must use the rubric to direct the creation of your submission because it provides detailed criteria that will be used to evaluate your work. Each requirement below may be evaluated by more than one rubric aspect. The rubric aspect titles may contain hyperlinks to relevant portions of the course.
Tasks may not be submitted as cloud links, such as links to Google Docs, Google Slides, OneDrive, etc., unless specified in the task requirements. All other submissions must be file types that are uploaded and submitted as attachments (e.g., .docx, .pdf, .ppt).
A. Describe the two main factors—home price and dropout rate—in the scenario.
1. Explain, using data from the “D466 Task 1 Data Set,” the current state of home prices.
a. Use Tableau to create an appropriate data visualization that shows the current state of home prices.
b. Identify one design technique you used in the visualization from part A1a and explain how it addresses a common accessibility issue.
c. Identify one design technique different than the one identified in part A1b and explain how it contributes to effective representation of the information in the data set.
2. Explain, using data from the “D466 Task 1 Data Set,” how a change in school dropout rates would affect home prices.
a. Use Tableau to create an appropriate data visualization that shows how a change in school dropout rates (independent variable) would affect home prices (dependent variable).
b. Identify one design technique you used in the visualization from part A2a and explain how it addresses a common accessibility issue.
c. Identify one different design technique than the one used in part A2b and explain how it contributes to effective representation of the information in the data set.

I CAN SUPPLY DATA SET VIA EXCEL
You are a real estate and property management bu

I CAN SUPPLY DATA SET VIA EXCEL
You are a real estate and property management business analyst in a big city. Your company’s leadership team supports building reasonably priced housing in areas that have well-performing schools with low school dropout rates (home price and dropout rate are the key factors). You wish to commission a consulting team of business and data analysts to build a full dashboard that will address the best locations for new construction projects within the five boroughs of the city based on the company’s mission and various performance metrics.
You decide to build a basic prototype model of the dashboard using the home price and dropout rate data for one borough. This prototype model will help you explain the project to your company’s leadership before you meet with the consultants who will build the full dashboard with many other predictive factors. You also want to be able to clearly report a data story about the project to the leadership team using your prototype.
To ensure you understand the data that will be included in the dashboard model, you will first need to connect your Excel data with Tableau and look at it visually.
Use the provided “D466 Task 1 Data Set” to complete this task.
Provided model data for the borough:
average three-bedroom home prices by year
average dropout % by year
Requirements
Your submission must be your original work. No more than a combined total of 30% of the submission and no more than a 10% match to any one individual source can be directly quoted or closely paraphrased from sources, even if cited correctly. The similarity report that is provided when you submit your task can be used as a guide.
You must use the rubric to direct the creation of your submission because it provides detailed criteria that will be used to evaluate your work. Each requirement below may be evaluated by more than one rubric aspect. The rubric aspect titles may contain hyperlinks to relevant portions of the course.
Tasks may not be submitted as cloud links, such as links to Google Docs, Google Slides, OneDrive, etc., unless specified in the task requirements. All other submissions must be file types that are uploaded and submitted as attachments (e.g., .docx, .pdf, .ppt).
A. Describe the two main factors—home price and dropout rate—in the scenario.
1. Explain, using data from the “D466 Task 1 Data Set,” the current state of home prices.
a. Use Tableau to create an appropriate data visualization that shows the current state of home prices.
b. Identify one design technique you used in the visualization from part A1a and explain how it addresses a common accessibility issue.
c. Identify one design technique different than the one identified in part A1b and explain how it contributes to effective representation of the information in the data set.
2. Explain, using data from the “D466 Task 1 Data Set,” how a change in school dropout rates would affect home prices.
a. Use Tableau to create an appropriate data visualization that shows how a change in school dropout rates (independent variable) would affect home prices (dependent variable).
b. Identify one design technique you used in the visualization from part A2a and explain how it addresses a common accessibility issue.
c. Identify one different design technique than the one used in part A2b and explain how it contributes to effective representation of the information in the data set.

Complete the assignment contained in the attached Excel document. Submit your co

Complete the assignment contained in the attached Excel document. Submit your completed Excel document to this dropbox. There are two tabs to the workbook, “Productivity Calculations” and “What-If Analysis”. Complete all yellow highlighted questions. There are a total of 10 questions.
Please see the attachment and do the qouations

Discussion Prompt:
In this week’s Discussion chose a discussion topic from the f

Discussion Prompt:
In this week’s Discussion chose a discussion topic from the following list (lifted from Sanders, p. 157):
Also you will have t respond to 2 of my peers work I will attach that once assigned
Identify a nontraditional business event, such as forecasting demand for T-shirts following the Super Bowl, or the amount of relief aid needed following an earthquake. What do you think would be the best way to forecast such an event—qualitative or quantitative—and why? What are the implications of forecast error on supply chain management?
Think of a product you have recently purchased. How many different forecasts do you think the retailer had to make in order to decide how much product to stock? What are the consequences for that particular retailer if they had over-forecast versus under-forecast?
Imagine that you are starting an online retail business. What type of forecasting model would you use to decide how many different products you will be selling? Would you use the same forecasting model after you have been in business five years? Why or why not?
Identify an example where large errors would be extremely costly. Which forecast error metric would be best for this environment?
Identify the differences between the two methods of collaboration discussed in the chapter: CPFR and S & OP. How are they similar, and how are they different? Explain the differences in the organizational objectives they are trying to achieve.
Sanders, Nada R. Supply Chain Management, 2nd Edition. Wiley, 2017-09-18. VitalBook file.

Global competition that has reduced jobs and earnings in many U.S. jurisdictions

Global competition that has reduced jobs and earnings in many U.S. jurisdictions has impacted a far wider range of industries than automotive. State and local economic development officials, legislators, and administrators must continue to look at the use of economic development tools that address the retention needs of the highly valuable automotive industry along with corporations within all competitive industries well in advance of events that necessitate corporate decisions resulting in unfavorable jobs consequences. But how much is too much because there comes a point in an auction where you don’t want to be the one with your hand in the air. I want to see your research on this topic, laying out the positives and negatives, the benefits and the costs, and the point where offering incentives no longer makes sense. This paper should be not less than 8 pages and not more than 12 pages and be double-spaced (references and title page do not count towards the total pages).
Required Texts / Materials: Supply Chain Management: Strategy, Planning, and Operation, 7th Edition Sunil Chopra. ISBN-13: 9780134731889. Include additional resources.