final project

Part 1: Essay (100 points)

Use APA in-text citation and references.

ChatGPT: You can use Chat GPT to assist you in doing this assignment, but Don’t copy and paste from ChatGPT to avoid plagiarism. If two students use ChatGPT to complete and submit the same sentences/paragraphs (detected by Turnitin), both students will

Add references at the end of the report using APA style (with the link to the article if available) (Submission without references will get 0 points for all essay questions)

Part 1: All references should be from reliable sources. Accepted news, articles, and data should be, but not limited to, Wall Street Journal, Business Insider, Financial Times, New York Times, Bloomberg, Forbes, Reuters, Statista, education sites (.edu), government website (.gov), Census Bureau, Yahoo Finance, UNO databases, official company sites, etc. (Note: Wiki, blog, social media, etc. are not reliable sources)

Question 1. Discuss the impacts (pros and cons) of AI technology and Generative AI on logistics and supply chains (LSCM) around the world. What is AI technology and Generative AI? Show the impact on real companies and provide data/evidence to support your argument. (at least 700 words) (50 points)

Suggested articles:

linkedin.comfuture-now-how-generative-ai-transforming-trucking-industry https://www.ey.com/en_us/coo/how-generative-ai-in-…

https://www.ibm.com/thought-leadership/institute-business-value/en-us/report/Generative-AI- supplychain

https://www.forbes.com/sites/forbestechcouncil/2023/06/29/how-generative-ai-is-transforming-supply- chain-and-procurement-roles/

Question 2. Discuss the impact of one among different issues on Supply Chain Management. (at least 700 words). Choose only one topic to discuss: (50 points)

1. The impact of the ongoing Russia-Ukraine War on LSCM

1. The impact of Drones on LSCM
2. The impact of Autonomous Cars and Electric Vehicle on LSCM

(Bonus Question) Question 3. “Amazon is offering to cover the full cost of college degrees for more than 750,000 US hourly employees”. Why did Amazon do it for their employees? What are the costs and benefits? (20 extra points – 700 words)

Suggested Articles:

https://www.businessinsider.com/amazon-will-pay-for-bachelors-degrees-for-750000-us-workers- 2021-9

plagiarism).

Do not use direct quotation in this assignment. Use your

own words to paraphrase all the info from sources. (All direct quotations will be considered

get 0 points for this

final project.

1

https://www.forbes.com/sites/zackfriedman/2021/07/29/walmart-makes-college-tuition-free-for-its- associates-which-is-a-major-step-to-help-reduce-student-loans/?sh=7ecf96a4486d

https://www.businessinsider.com/target-will-help-w…

Part 2: Math (100 points)

1. A manufacturer in Nebraska ships finished products to the ocean port in San Diego, California. New loading facilities will be needed to accommodate the expected growth in sales for their new product. In 2023, the company shipped 5 million pounds of product through several areas in San Diego. The logistic Costs in 2023 are given in the table. Due to growth in emerging markets, the company expects a growth rate of 8% per year through this port for the next five years. (Show all steps, submission with results only will not gain any credit! If you don’t know how to type your answer, you can take a picture of your handwriting and paste it in the answer section.) (40 points)

Rail

Truck

Transportation Variable Cost

$ 250,000 $ 275,000

Inventory Costs

Carrying

45,000 27,000

handling

35,000 43,000

Ordering

15,000 17,000

Fixed Cost

170,000 140,000

Total Cost

$ 505,000 $ 492,000

1. What is the total variable cost of the Rail shipping method? (5 points)
2. What is the total variable cost per pound of the Rail shipping method? (Round the answer to 4 decimal places) (5 points)
3. What is the total cost of shipping 6 million pounds of products via the Rail shipping method? (Note: Round the variable cost per pound to 4 decimal places) (5 points)
4. At what level of demand per year would these two transportation methods be equal in terms of total costs? (Round the answer to 2 decimal places) (Note: Round the variable cost per pound to 4 decimal places) (5 points)(Question 2: Next page)

2

2. PPE Inc. produces toys for kids from 1 to 3 years old. The toy sales data is shown as follows: (Take a screenshot of your Excel spreadsheet and paste it to the answer section) (30 points)

Period

1. 2017 September OctoberNovemberDecember
2. 2018 JanuaryFebruary March April May June July August September October November December

Demand

 9299
 10619
 7304
 5976
 9700
 9226
 9717
 11226
 9718
 9135
 10702
 11289
 10210
 10703
 12179
 11683

1. What is the forecasted demand of April 2018, using the four-period moving average technique? (10 points)
2. What is the forecasted demand of April 2018, using the weighted four-period moving averagetechnique? Use weights of 0.5, 0.3, 0.1, and 0.1 for the most recent period, the second most recent period, the third most recent period, and the fourth most recent period, respectively. (10 points)
3. What is the forecasted demand of April 2018, using the exponential smoothing method? Assume the forecast for period 1 (January 2018) is 9500 and alpha = 0.5. (10 points) (Note: the period 1 is Jan 2018, not Sep 2017)

(Question 3: Next Page)

3

3. Audi Ltd. has 8 general stores in different cities in the U.S. The company manager hires you to help her decide the location to build the distribution center. Using the data below and the grid technique to find the Grid Center Coordinates. (Take a screenshot of your Excel spreadsheet and paste it to the answer section) (30 points)

Note: Type your full name on the cell A1 (Deduct 5 points without name)

Sources/Markets Rate $/ ton-mile Tons (B) (A)

Buffalo	400	0.5
Omaha	300	0.6
St. Louis	250	0.7
Atlanta	250	1
Boston	100	2
Jacksonville	100	1
Philadelphia	300	2
New York	500	3

(Administrative requirements: next Page)

4

Administrative requirements

• Late assignments will not receive any credit for this assignment.
• Please answer all questions in only one Microsoft Word file and submit it on Canvas. (There willbe a 10-point penalty for using different file format such as pdf)
• The report should be developed in APA format. Guidelines by the American PsychologicalAssociation (APA) should be used for all written assignments in this class. The following link can be used to review APA guidelines:
  http://owl.english.purdue.edu/owl/resource/560/01/. Each report should be typed, double-spaced with one-inch margins using a Times New Roman-12-point font. Use justified text to align your manuscript evenly between the marginsRubric for Essay Questions