Comprehensive supply chain analytics project

Assignment Help Other Subject

Reference no: EM133766364

Assessment: Comprehensive supply chain analytics project

Part A: Network Design Problem with Constraint (500 words)

In the first part of this assessment, you are asked to revisit the TelecomOptic production facility location example discussed HERE. Using the input data provided in HERE (see Figure 1) along with the solution you obtained to the production facility location model in activity 2 and 3, answer the following questions:

Question 1: How would the network design obtained in Activity 3 change if a new constraint is introduced which states that all five plants must stay open? Run this in solver and obtain the new production allocation. Attach the input and output tables as image files to your report and explain your observations.

Question 2: Is there a major difference in total cost between the optimal network design for TelecomOne and HighOptic individually (see activity 2), for TelcomOptic (see activity 3), and for the design requiring all the TelecomOptic plants to remain open (your answer to above Question 1)? What is another way to determine whether this is an efficient solution or not? Attach the input and output tables as image files to your report and explain your observations.

You may refer to the information in your workbook as well as pg. 139-140 of the required reading as needed.

Part B: Log-Hub Network Design (1000 words)

In the second part of this assessment, you are asked to use the Network Design Log Hub Module (tutorial provided HERE) and write an analytical report by addressing the following problem:

Problem Statement: Coolies Australia has decided to manufacture some Coolies brand products within the state for the Victorian market. They have identified two locations to set up factories that manufacture non-perishable high demand products in the state. Coolies wants to obtain an optimized network for this setup to ensure they have selected ideal locations for their factories. In particular, they want to ensure these factories are appropriately established to i) support all the GHPL warehouses and ii) serve customers falling under ZIP codes ranging from 3000-3130. Using the Coolies data set provided here run the network design module to determine the ideal supply chain network. You might be required to add to or sort the data, or rename certain columns to successfully run the model:

Question 1: Set the minimum number of warehouses as 1 and the maximum as 35. What is the optimal network you obtain? Show the entire network on the map and copy it as image files to your final MS word file report. Also provide the factories to warehouses connections, and the warehouses to customers connections. Explain your observations with the appropriate dashboard visualizations.

Question 2: Is there any selected warehouse that can be simply merged into one of the existing factories? If any, determine which factory and warehouse, clearly naming the factory and the warehouse. Explain your observations with the appropriate dashboard visualizations.

Question 3: Focusing on the total costs incurred and the number of customers served by 23GHPL and 29GHPL warehouses, which of the two warehouses do you believe is operating more efficiently? Among all selected warehouses, which warehouse(s) completely utilize their capacity in terms of volume? Among all selected warehouses, which warehouse(s) completely utilize their capacity in terms of weight? Explain your observations with the appropriate dashboard visualizations.

Important Note: After preparing the data and running the relevant Log-Hub module, students are required to attach their output tables, as well as any relevant dashboards and network visualizations generated by Log-Hub as image files to their MS word file report to support their answers.

The referencing style for this subject is APA7.

This assessment is continuation of Activity 2 (Digital Supply Chain Conceptualization - TSC Identification) and Activity 3 (Network visualization - Loghub) discussed HERE. Students are asked to use the Supply Chain Map Log Hub Module (tutorial provided here on the Supply Chain Map) and write an analytical report to address the following problem:

Problem Statement:

Coolies has heard about the advantages that digitization brings to supply chains, and is keen to get started on the transformation. Coolies decided that this would be a great time to visualize its global network, and identify how this transformation can move forward. After identifying their traditional KPI-SCs for each node (discussed in Activity 2 HERE), Coolies plan to develop three digital supply chain KPIs (KPI-SCs) for all nodes (Step 1), based on the information provided in this Workbook and the DSCI paper.

Visualizing the traditional and digital KPI-SCs (Step 2) will help Coolies understand how far along the digital transformation they have come and how the remaining tasks should be planned.

Generally, their supply chain network consists of multiple nodes across Australia, including DCs and retail outlets, as well as a few international factories.

Using the network nodes and traditional KPI-SCs data provided HERE, students are required to answer the following questions by referring to the contents of this workbook. As part of data cleaning process, you might be required to adjust the data or rename certain columns to successfully run the Supply Chain Map LogHub module:

1. Based on the traditional KPI-SCs provided for each node in the data set, identify 3 Digital KPI-SCs for the same nodes--3 KPI-SCs for each node (read the DSCI paper). (300 words)

2. Following the template tables provided in Tab 3 and 5 of the provided dataset, explain how the KPI-SCs is calculated and why it is chosen for that specific node. Justify your selection of digital KPI-SCs and identify the source of information/data for each digital KPI. (900 words)

3. Adjust the provided data set based on your findings and answer to Q2, and visualize the entire network for Coolies using the Supply Chain Map LogHub module, incorporating both traditional and digital KPI-SCs (total of 6 KPIs) for each node in the visualization. Note: It is assumed that the same KPI-SCs will apply to all similar node type in the data set. Explain the visualisation. (300 words)

Reference no: EM133766364

Questions Cloud

Exertional dyspnea and symmetric bilateral lower : Ms. AH is a 48-year-old woman who presents with a 3-month history of progressively worsening exertional dyspnea and symmetric bilateral lower extremity edema.

Determine whether the classification system in use : How would you determine whether the classification system in use is performing as it should or unnecessarily contributing to the overcrowding problem?

Organizational culture-resistance to change : Organizational culture, resistance to change, a lack of resources, time restrictions and inadequate training can all be obstacles to implementing evidence-based

What ideas or pieces of information does the author present : What ideas or pieces of information does the author present? What other ways does the author tell the audience about the key message(s)?

Comprehensive supply chain analytics project : Comprehensive supply chain analytics project - How would the network design obtained in Activity 3 change if a new constraint is introduced which states

Treatment of wound infection on her right leg : Laboure Case study simulation pack, Anna Parker is a 26-year-old female coming to the ED for treatment of a wound infection on her right leg.

Who are the two theorists that you chose : Who are the two theorists that you chose? What time period did each theorist live in? How did each theorist view child development/growth/education?

Gram positive bacteremia and septic shock : The Nurse Practitioner is caring for a patient with gram positive bacteremia and septic shock.

Describe how stress impacts the immunity of a person : What are the different types of immunities and give an example of each? Describe how stress impacts the immunity of a person.

User Account

All Pages