Assessment 1: Supply Chain Network Design and Analysis
Contribution: Individual
Percentage: 20%
Required Length: 1000 words
Format: Individual written | MS Word
Intended Learning Outcome(s): SILOT, SILO4, SILOS
This assessment is about the supply chain mapping and geocoding modules of the Log hub add-in. Students are required to submit their answers in a single Mli word file using relevant headings for each question. Students are required to attach their output, including relevant dashboards and visualizations generated by Log-Hub as image fles to their MS word file report to support their anseers.
Problem Statement: Coolies Australia wants to gain a better understanding of the facilities in their Victorian network. They decide the best way to do this is to visualize the locations of retail outlets and distribution centers in their supply chain within the Victoria state. Using the data set provided here run these modules and submit your answer to the following questions. You might be required to add to the data or rename certain columns to successfully run the modet
Question 1. To obtain the location of each facility with a high level of accuracy, first run the geocoding module. Convert each address to a coordinate and include the relevant visualization indicating the accuracy of this conversion as image files to your MS word report Briefly explain your observations.
Question 2. Using the newly obtained coordinates for each location, run the supply chain mapping module. Clearly indicate which locations are DCs and which ones are retail outlets. Include the visualization of the map generated using these locations as image files to your MS word report. Briefly explain your observations.
Question 3. Based on the visualization obtained, which region’s (North East, etc.) retail store(s) do you think are most likely to experience the longest lead times between when they order inventory and when they receive it form the DCs in Victoria? To mitigate the risks associated with such long lead times, suggest a change of location for at least one of the existing DCs. Provide these suggestions as a textbox on the map visualization tab in your report and add it to your MS word report. Briefly explain your observations
Before you start this task, students should refer to the tutorial videas on the Supply Chain Map and Geocoding Log Hub Modules and the related activity 3 discussed HERE
Important Hints
1-When anawering the above questions, students should support their recommendations and insights by using relevant and appropriate sources of academic literature. The referencing style for this subject is APA7. 2- Students are required to submit their reports using only a single MS-Word fie, which should contain their analysis, results, and discussion. No other format is acceptable
3-Make sure that the final results of your MS Excel analysis (relevant graphs and tabies) are integrated into your MS-Word report using screenshots. Your MS Excel usarmame and student ID as indicated in your LMS account, should be clearly visible at the top of all these screenshots.
4- Please be anare that students may be randomly selected to present their reports and analysis during onilline or
face-to-face sessions after submission