This A ssignment is a individual and group assignment.I have hsared the question of the assignment and also mentioned my part AS RED BOLD MARKED . please let me know what else you need to fininsh this...

This A ssignment is a individual and group assignment.I have hsared the question of the assignment and also mentioned my part AS RED BOLD MARKED . please let me know what else you need to fininsh this assesment thanks.


Strategic Supply Chain Management Infographic + Dashboard Report Assessment – Assessment has individual as well as group tasks. The Unit Learning Outcomes for this assessment are: · Assess and communicate supply chain business strategies based on conceptual frameworks and case studies · Analyse and evaluate business environments to prompt strategic supply chain decisions to assist an organisation’s performance Assessment Brief: Infographics: a visual representation of information or data, e.g. as a chart or diagram. "a good infographic is worth a thousand words" (Oxford dictionary) Dashboard: A dashboard is a way of displaying various types of visual data in one place. Usually, a dashboard is intended to convey different, but related information in an easy-to-digest form. (Tableau.com) https://www.tableau.com/learn/articles/dashboards/what-is#:~:text=Benefits-,Dashboard%20definition,easy%2Dto%2Ddigest%20form. Tools: For this assignment, you can use the following tools for the dashboard: · Microsoft Excel · Power BI · Or any other suitable tool Based on the provided dataset in the Fresh Connection, answer the following questions in report format. Submit one Word document through Turnitin. Task 1 – Read data (compulsory task) You have to work individually for this task. Answer the following questions. Question 1: What are the KPIs in your role? Explain. (2 marks) Question 2: Identify and name chart types in your role in the Fresh Connection? (Please attach screenshot of each chart type) (2 marks) Question 3: Can you link KPIs to necessary data and suggest chart types for better understanding (for the chart types that do not exist in the Fresh Connection dashboard)? Show your working in form of screenshots. (2.5 marks) Question 4: What new infographic can you add to the existing dashboard in your role? Show infographics. (3.5 marks) Task 2 – Analyse data (Marks: 30) You have to work in your team to analyse the data for the following scenarios in the game. Answer what and why for each scenario. Support your answer linking with the dashboard. Create a dashboard to explain the situation in each scenario. Scenario 1 – Message from the CEO (Bob McLaren): we throw away too many finished products. (10 marks)(NOT MY TASK) Scenario 2 – Message from the CEO: our customers are screaming at us because we deliver too late (NOT MY TASK) Scenario 3 – Message from the CEO: our capacity and demand does not seem to match. -MY TASK IS SCENARIO 3 (THIS ONE IS THE TASK). Note: More marks will be given for better data representation. 0 | @ fresh connection login - Goo SS CRG £3 Import favorites (5) New tab PE I VALIIET PY game.thefreshconnection.eu, [EY InPrivate My Company eo 0 oe 2 oe 3 Rankings e 4 iO os Information ® 6 oe 7 @o 8 LITE ET = Finance S88 © Type here to search WW : oR i ROUND 1 Purchasing Operations dashboard customer product customer product i ROI (%) 5 0 -3.8% 5 7.5% -10 Round: 2 -1 0 1 i Obsolete products (%) product customer analysis Supply Chain decision log i Gross margin (customer) 1400k 1 200k 1 000k 800k Round: 1057 741 907 767 i Service level outbound order lines & 10°C Partly cloudy i ROI (%) The company is making a loss. Measures must quickly be taken. i Obsolete products (%) The finished products Fressie Orange/Mango 1 liter, Fressie Orange PET and Fressie Orange/Mango PET have a high obsoletes percentage. i Service level outbound order lines A lower service level than agreed to is being provided to Food & Groceries, LAND Market and Dominick's. 23:19 ~ [5 ) ENG = 7% 11-05-2023 { | @ fresh connection login - Google x | @ My Inchainge FE EE SN] a] game.thefreshconnection.eu REC £3 Import favorites (5) New tab Ww : ROUND 2 Se oR i My Company Purchasing Operations Sales eo 0 dashboard component product analysis decision log LL of 1 i ROI (%) i Availability components (%) i ROI (%) (HE The company is making a loss. [] = Measures must quickly be taken. Rankings 10 150 eo 4 i Availability components (%) 99.4% 99.2% ©) ® 5 0 38% 100 There is a low level of availability for = 75% component Vitamin C for production. Information ® 6 -10 50 i Stock components (weeks) [1] Vitamin C, Pack 1 liter and PET have a 20 oOo — high level of stock. of 8 Round: 2 “A 0 1 2 Round: 2 - 0 1 2 LITE ET = i Stock components (weeks) i Stock products (weeks) Finance A 0 3 2 23:26 88 © Type here to search Ei gi Qe = a a B i 10°C Partly cloudy ~ [El 7Z <0) eng="" pi="" 2="" 0="" |="" @="" fresh="" connection="" login="" -="" goo="" x="" |="" @="" my="" inchainge="" fe="" ee="" sn]="" a]="" game.thefreshconnection.eu="" [ls="" £3="" import="" favorites="" (5)="" new="" tab="" ww="" :="" round="" 2="" se="" or="" i="" my="" company="" purchasing="" operations="" supply="" chain="" eo="" 0="" dashboard="customer" product="" customer="" product="" product="" customer="" analysis="" decision="" log="" eo="" 1="" i="" roi="" (%)="" i="" gross="" margin="" (customer)="" i="" roi="" (%)="" il="" as="" the="" company="" is="" making="" a="" loss.="" []="Measures" must="" quickly="" be="" taken.="" [ee="" 10="" 1="" 400k="" eo="" 4="" i="" obsolete="" products="" (%)="" ©)="" ®="" 5="" 0="" 38%="" 1200k="" the="" finished="" products="" fressie="" 75%="" 1057="" 741="" orange/mango="" 1="" liter,="" fressie="" orange="" mn="" ol="" 6="" 10="" 1="" 000k="" pet="" and="" fressie="" orange/mango="" pet="" 07757="" have="" a="" high="" obsoletes="" percentage.="" o="" 7="" i="" service="" level="" outbound="" order="" 20="" —="" 800k="" lines="" o="" 8="" round:="" -2="" “1="" 0="" 1="" 2="" round:="" 2="" -1="" 0="" 1="" 2="" lite="" et="" .="" a="" a="" lower="" service="" level="" than="" agreed="" to="" is="" being="" provided="" to="" food="" &="" groceries.="i" obsolete="" products="" (%)="" i="" service="" level="" outbound="" order="" lines="" finance="" py="." 23:25="" 88="" ©="" type="" here="" to="" search="" ei="" gi="" qe="a" a="" b="" i="" 10°c="" partly="" cloudy="" ~="" [el="" 7z=""><0) eng="" pi="" 2="" {="" |="" @="" fresh="" connection="" login="" -="" google="" x="" |="" @="" my="" inchainge="" fe="" ee="" &="" cg="" a]="" game.thefreshconnection.eu,="" £3="" import="" favorites="" (5)="" new="" tab="" eo="" 4="" .="" 20%="" 20%="" i="" rejection="" components="" (%)="" ©)="" ®="" 5="" 0="" 38%="" the="" rejection="" percentage="" for="" 75%="" 2="" components="" supplied="" by="" supplier="" trio="" i="" pet="" plc="" is="" high.="" information="" ®="" 6="" 10="" g="" 1="" i="" delivery="" reliability="" suppliers="" oe="" 7="" -20="" 0="" trio="" pet="" plc="" is="" significantly="" less="" o="" 8="" round:="" -2="" -1="" 0="" 1="" 2="" round:="" -2="" -1="" 0="" 1="" 2="" reliable="" than="" was="" agreed="" to.="" lite="" et="i" raw="" material="" costs="" (%)="" i="" delivery="" reliability="" suppliers="" finance="" 60="" 150="" 40="" 37.0%="" 305%="" 100="" 92.1%="" 91.9%="" production="" interval="" tool="" 20="" 50="" 0="" 0="" round:="" -2="" -1="" 0="" 1="" 2="" round:="" -2="" -1="" 0="" 1="" 2="" 4="" pn="" a="" i="l" a)="" 23:22="" 88="" ©="" type="" here="" to="" search="" £="" i="" gi="" qe="a" a="" b="" i="" 10°c="" partly="" cloudy="" ~="" [el="" 7z=""><0) eng pi 2 eng="" pi="">