I have posted the Assignment . We need to create a Dashboard using Excel or power BI. Excel is preferred as the last assignment by yours was done by excel. My profile is of SALES. Please go through the assignment brief . Also i need speech for my presentation I have mentioned all the Information in the assignment brief thanks.
UNIT NAME- STRATEGIC SUPPLY CHAIN MANAGEMENT Assessment – Assessment is an individual assignment. The Unit Learning Outcomes for this assessment are: · Evaluate the strategic role and characteristics of supply chain management in a national and international business context · 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 Assignment Brief: You have to present strategies and actions you have taken in your role to CEO of the Fresh Connection, In particular, you need to answer the following questions. 1: In your area, what was the situation when you took over? 2: What do you think was the reason for the problems associated with low ROI? 3: What strategies did you suggest ? 4: What actions have you taken to implement those strategies? 5: What was the result of those actions ? Prepare a dashboard for your presentation. Keep your presentation limited to 5 minutes. Bob is very busy. He likes concise presentation. Be ready to answer any question from the CEO. NOTE- PROVIDE ME THE SPEECH FOR THE PRESENTATION AS WELL AS WHAT I NEED TO EXPLAIN ABOUT EACH CHART AND GRAPH IN THE DASHBOARD. (SPEECH SHOULD BE SIMPLE AND FOR LESS THAN 5 MINUTES INCLUDING INFO ABOUT EACH GRAPH IN THE DASHBOARD- LIKE THE SITUATION WHEN I TAKEN OVER , PROBLEMS WITH LOW ROI, STRATEGIES FOR EXAMPLE LOW INVENTORY, ACTIONS TO IMPLEMENT THOSE STRATEGIES, RESULTS OF THOSE ACTIONS EITHER NEGATIVE OR POSITIVE RESULT)- MY PROFILE IS SALES Standards Criteria Below Expectations (Fail) 0-49 Meets Expectations (Pass) 50-59 Meets Expectations (Credit) 60-69 Exceeds Expectations (Distinction) 70-79 Exceeds Expectations (High Distinction) 80-100 Identification of Issues (7 marks) Did not sufficiently identify the key practices, principles or concepts applicable to resolving business issues and/or problems. Identifies some of the key practices, principles or concepts applicable to resolving straightforward business issues and/or problems. Identifies the key practices, principles or concepts applicable to resolving straightforward business issues and/or problems. Identifies some of the key practices, principles or concepts applicable to resolving business issues and/or problems with complex interrelationships. Identifies the key practices, principles or concepts applicable to resolving business issues and/or problems with complex interrelationships. Evidence-based Dashboard (7 marks) The dashboard is not coherent and is based on irrelevant information and chart types. A coherent dashboard based on partial use of relevant information and chart types. A coherent dashboard based on thorough use of relevant information and chart types. A coherent and comprehensive dashboard based on thorough use of the most relevant information and chart types. A coherent and complete dashboard based on complete use of all relevant information and chart types. Central Message (Story) (8 marks) Central message (story) is unclear and is not explicitly stated in the presentation. Central message (story) is sufficiently clear and is stated in the presentation. Central message (story) is substantially clear and consistent with the supporting material. Central message (story) is substantially clear and effectively stated; it is reinforced with the supporting material. Central message (story) is compelling; it is precisely stated, reinforced, memorable, and strongly supported. Context and Purpose (8 marks) Did not demonstrate adequate consideration of context, audience, and purpose and a clear focus on the assigned task(s) (e.g., the task does not align with audience, purpose, and context). Demonstrates some consideration of context, audience, and purpose and attempts to focus on the assigned task(s) (e.g., the task aligns with audience, purpose, and context). Demonstrates adequate consideration of context, audience, and purpose and a clear focus on the assigned task(s) (e.g., the task aligns with audience, purpose, and context). Demonstrates a good understanding of context, audience, and purpose and fully aligns with the assigned task(s) (e.g., the task aligns with audience, purpose, and context). Demonstrates a thorough understanding of context, audience, and purpose that is responsive to the assigned task(s) and focuses all elements of the work. Visually Appealing Dashboard (3.5 marks) The dashboard is not visually appealing, inconsistent and/or contains errors. The dashboard is visually appealing, but inconsistent and/or contains errors. The dashboard is visually appealing and consistent with some errors. The dashboard is visually appealing, consistent and error free. The dashboard stand out as being very visually appealing and is consistent and error free. Confidence and Enthusiasm (2.5 marks) The presenter is not confident and appears nervous throughout the entire presentation. The enthusiasm level is low which makes for an uninspiring presentation. The presenter is not confident throughout the entire presentation. The enthusiasm level is adequate. The presenter is confident throughout the presentation. A good enthusiasm level is maintained. The presenter is very confident. High enthusiasm is present for some of the presentation. The presenter exudes confidence. High enthusiasm is maintained throughout the entire presentation. Verbal Communication (Language and Clarity) (2 marks) Language choices are inappropriate or inadequate for the task. Numerous errors cause difficulty in understanding for the audience. Language choices are appropriate for the task. Expression is sufficiently clear for audience understanding. Language choices are appropriate for the task. Expression is substantially clear for audience understanding. Language choices are appropriate and effectively used for the task. Expression errors rarely cause difficulty for the audience’s understanding. Language choices are flexibly and effectively used and appropriate for the task. The presentation is crystal clear and virtually error free. Non-Verbal Communication (2 marks) Presenter does not maintain eye contact with the audience and/or has negative body language. Presenter’s delivery techniques detract from the presentation. Some eye contact is maintained with the audience and/or body language is inconsistent. Presenter’s delivery techniques adequately convey information. Eye contact and/or body language is good. Presenter’s delivery techniques convey relevant information. Eye contact and/or body language is good. Presenter’s delivery techniques clearly convey relevant information. Good eye contact and body language is maintained for the entire presentation. Presenter’s delivery techniques strongly convey the most relevant information. Component ComponentRoundDelivery reliability (%)Rejection (%)Order lines previous roundPurchase value previous roundTransport costs previous roundDemand per week (piece or liter)Purchase priceOrder sizeStock (pieces or liters)Stock (weeks)Stock valueEconomic inventory (weeks)Obsoletes (%)Component availability (%)BiasAmount purchased previous round (piece or liters) Pack 1 liter092.3%3.6%5.711069245521322570.03106196365644404.31755390.0%99.5%0.1%3559348 Pack 1 liter192.5%3.6%5.910980345161308230.03106024905483354.21705390.0%99.7%0.1%3530773 Pack 1 liter292.5%3.7%5.811031845371314070.03106083255516774.21715790.0%99.5%0.1%3547317 Pack 1 liter392.5%3.7%5.811359246711355360.03106263795632254.21751690.0%99.8%0.1%3652593 Pack 1 liter492.7%3.6%5.911337346621353980.03106220805636754.21753090.0%99.8%0.1%3645575 Pack 1 liter592.4%3.7%5.811303046481352810.03106232846524784.820291100.0%99.9%0.1%3634546 Pack 1 liter692.4%3.7%5.811303046481352810.03106232846524784.820291100.0%99.9%0.1%3634546 Pack 1 liter792.4%3.7%5.811303046481352810.03106232846524784.820291100.0%99.9%0.1%3634546 PET084.1%5.9%5.93079311453932042970.05469516128516674.24656680.0%99.5%-0.0%5631948 PET183.3%5.7%5.93091541454752043780.05499513698226994.04517280.0%99.3%-0.0%5630507 PET284.0%5.8%6.03107871462462055860.05499470938457144.14643680.0%99.3%-0.0%5660153 PET393.9%3.9%5.93134231465742104260.05529632418971964.34957080.0%100.0%-0.0%5672824 PET493.9%3.9%5.93135961466442103780.05529686048953944.24946780.0%100.0%-0.0%5676308 PET594.1%4.1%7.73131461466712087860.05537390135728882.73169570.0%99.6%-0.0%5660103 PET694.1%4.1%7.73131461466712087860.05537390135728882.73169570.0%99.6%-0.0%5660103 PET794.1%4.1%7.73131461466712087860.05537390135728882.73169570.0%99.6%-0.0%5660103 Orange097.8%1.0%5.440904235046353600.43921725811607574.570610110.0%99.3%0.0%931265 Orange198.0%1.0%5.440476834529350900.44121709191584954.569934110.0%99.0%0.0%917340 Orange297.7%1.0%5.440822534826352610.44121705351591684.570232110.0%99.5%0.0%925173 Orange397.8%1.2%5.442048435843362830.44121775681621384.571537110.0%99.0%0.0%953024 Orange498.0%1.1%5.342048035839362530.44121785331614364.471227110.0%99.0%0.0%953024 Orange597.3%0.8%7.041879635912361520.44141351241399873.961798100.0%98.9%0.0%948672 Orange697.3%0.8%7.041879635912361520.44141351241399873.961798100.0%98.9%0.0%948672 Orange797.3%0.8%7.041879635912361520.44141351241399873.961798100.0%98.9%0.0%948672 Mango093.7%0.5%5.381658331431650.992415497140894.41398380.0%100.0%0.0%82276 Mango193.8%0.6%5.481956333631550.992615219142804.51417480.0%100.0%0.0%82566 Mango293.6%0.5%5.382090333231730.992415495142854.51417780.0%100.0%0.0%82711 Mango393.7%0.5%5.584218341632590.992415559147524.51464180.0%100.0%0.0%84858 Mango493.5%0.5%5.484208340632590.992315811147874.51467480.0%100.0%0.0%84858 Mango593.6%1.4%5.484329341632360.992415663144064.51429690.0%99.9%0.0%84974 Mango693.6%1.4%5.484329341632360.992415663144064.51429690.0%99.9%0.0%84974 Mango793.6%1.4%5.484329341632360.992415663144064.51429690.0%99.9%0.0%84974 Vitamin C081.5%1.2%4.7229515921840.472810327694.2364180.0%84.3%0.2%4852 Vitamin C188.9%0.0%0.530447791820.1942300001770397.53440138226.4%72.1%0.2%15666 Vitamin C288.9%0.0%0.530447791830.1942300001772897.13444138224.4%73.2%0.2%15666 Vitamin C398.2%0.0%4.9237516321910.480110157533.9362170.0%98.5%0.2%4946 Vitamin C498.2%0.0%4.8236416241910.479910167493.9360170.0%98.4%0.2%4925 Vitamin C598.3%2.9%4.8247116881950.473910767463.8354180.0%93.8%0.2%5215 Vitamin C698.3%2.9%4.8247116881950.473910767463.8354180.0%93.8%0.2%5215 Vitamin C798.3%2.9%4.8247116881950.473910767463.8354180.0%93.8%0.2%5215 Supplier SupplierRoundDelivery reliability (%)Rejection (%)Deliveries previous roundOrder lines previous roundPurchase value previous roundTransport costs previous round Mono Packaging Materials092.3%3.6%5.75.71106924552 Mono Packaging Materials192.5%3.6%5.95.91098034516 Mono Packaging Materials292.5%3.7%5.85.81103184537 Mono Packaging Materials392.5%3.7%5.85.81135924671 Mono Packaging Materials492.7%3.6%5.95.91133734662 Mono Packaging Materials592.4%3.7%5.85.81130304648 Mono Packaging Materials692.4%3.7%5.85.81130304648 Mono Packaging Materials792.4%3.7%5.85.81130304648 Trio PET PLC084.1%5.9%5.95.9307931145393 Trio PET PLC183.3%5.7%5.95.9309154145475 Trio PET PLC284.0%5.8%6.06.0310787146246 Trio PET PLC393.9%3.9%5.95.9313423146574 Trio PET PLC493.9%3.9%5.95.9313596146644 Trio PET PLC594.1%4.1%7.77.7313146146671 Trio PET PLC694.1%4.1%7.77.7313146146671 Trio PET PLC794.1%4.1%7.77.7313146146671 Seitan Vitamins081.5%1.2%4.74.722951592 Seitan Vitamins188.9%0.0%0.50.53044779 Seitan Vitamins288.9%0.0%0.50.53044779 Seitan Vitamins398.2%0.0%4.94.923751632 Seitan Vitamins498.2%0.0%4.84.823641624 Seitan Vitamins598.3%2.9%4.84.824711688 Seitan Vitamins698.3%2.9%4.84.824711688 Seitan Vitamins798.3%2.9%4.84.824711688 NO8DO Mango093.7%0.5%5.35.3816583314 NO8DO Mango193.8%0.6%5.45.4819563336 NO8DO Mango293.6%0.5%5.35.3820903332 NO8DO Mango393.7%0.5%5.55.5842183416 NO8DO Mango493.5%0.5%5.45.4842083406 NO8DO Mango593.6%1.4%5.45.4843293416 NO8DO Mango693.6%1.4%5.45.4843293416 NO8DO Mango793.6%1.4%5.45.4843293416 Miami Oranges097.8%1.0%5.45.440904235046 Miami Oranges198.0%1.0%5.45.440476834529 Miami Oranges297.7%1.0%5.45.440822534826 Miami Oranges397.8%1.2%5.45.442048435843 Miami Oranges498.0%1.1%5.35.342048035839 Miami Oranges597.3%0.8%7.07.041879635912 Miami Oranges697.3%0.8%7.07.041879635912 Miami Oranges797.3%0.8%7.07.041879635912 Supplier - Component Supplier ComponentRoundRejection (%)Order lines previous roundPurchase value previous roundTransport costs previous roundDemand per week (piece or liter)Amount purchased previous round (piece or liters)Purchase priceOrder size Mono Packaging MaterialsPack 1 liter03.6%5.7110692455213225735593480.0310619636 Mono Packaging MaterialsPack 1 liter13.6%5.9109803451613082335307730.0310602490 Mono Packaging MaterialsPack 1 liter23.7%5.8110318453713140735473170.0310608325 Mono Packaging MaterialsPack 1 liter33.7%5.8113592467113553636525930.0310626379 Mono Packaging MaterialsPack 1 liter43.6%5.9113373466213539836455750.0310622080 Mono Packaging MaterialsPack 1 liter53.7%5.8113030464813528136345460.0310623284 Mono Packaging MaterialsPack 1 liter63.7%5.8113030464813528136345460.0310623284 Mono Packaging MaterialsPack 1 liter73.7%5.8113030464813528136345460.0310623284 Trio PET PLCPET05.9%5.930793114539320429756319480.0546951612 Trio PET PLCPET15.7%5.930915414547520437856305070.0549951369 Trio PET PLCPET25.8%6.031078714624620558656601530.0549947093 Trio PET PLCPET33.9%5.931342314657421042656728240.0552963241 Trio PET PLCPET43.9%5.931359614664421037856763080.0552968604 Trio PET PLCPET54.1%7.731314614667120878656601030.0553739013 Trio PET PLCPET64.1%7.731314614667120878656601030.0553739013 Trio PET PLCPET74.1%7.731314614667120878656601030.0553739013 Seitan VitaminsVitamin C01.2%4.72295159218448520.47281032 Seitan VitaminsVitamin C10.0%0.53044779182156660.194230000 Seitan VitaminsVitamin C20.0%0.53044779183156660.194230000 Seitan VitaminsVitamin C30.0%4.92375163219149460.48011015 Seitan VitaminsVitamin C40.0%4.82364162419149250.47991016 Seitan VitaminsVitamin C52.9%4.82471168819552150.47391076 Seitan VitaminsVitamin C62.9%4.82471168819552150.47391076 Seitan VitaminsVitamin C72.9%4.82471168819552150.47391076 NO8DO MangoMango00.5%5.38165833143165822760.992415497 NO8DO MangoMango10.6%5.48195633363155825660.992615219 NO8DO MangoMango20.5%5.38209033323173827110.992415495 NO8DO MangoMango30.5%5.58421834163259848580.992415559 NO8DO MangoMango40.5%5.48420834063259848580.992315811 NO8DO MangoMango51.4%5.48432934163236849740.992415663 NO8DO MangoMango61.4%5.48432934163236849740.992415663 NO8DO MangoMango71.4%5.48432934163236849740.992415663 Miami OrangesOrange01.0%5.440904235046353609312650.4392172581 Miami OrangesOrange11.0%5.440476834529350909173400.4412170919 Miami OrangesOrange21.0%5.440822534826352619251730.4412170535 Miami OrangesOrange31.2%5.442048435843362839530240.4412177568 Miami OrangesOrange41.1%5.342048035839362539530240.4412178533 Miami OrangesOrange50.8%7.041879635912361529486720.4414135124 Miami OrangesOrange60.8%7.041879635912361529486720.4414135124 Miami OrangesOrange70.8%7.041879635912361529486720.4414135124 Bottling line Bottling lineRoundRun time per week (hours)Changeover time per week (hours)Breakdown time per week (hours)Unused capacity per week (hours)Overtime per week (hours)Run time (%)Changeover time (%)Breakdown time (%)Unused capacity (%)Overtime (%)Start up productivity loss (value)Production plan adherence (%)Outsourced (hours)Outsourced (%) Swiss Fill 2062.612.1113.99.478.2%15.1%13.6%4.9%11.7%843578.7%0.00.0% Swiss Fill 2162.013.6113.49.777.6%17.0%13.5%4.2%12.2%1008373.9%0.00.0% Swiss Fill 2256.610.5106.73.670.8%13.2%12.3%8.4%4.5%1080480.1%0.00.0% Swiss Fill 2358.310.7348.30.048.5%8.9%2.4%40.3%0.0%1168792.5%0.00.0% Swiss Fill 2458.210.7348.30.048.5%8.9%2.4%40.3%0.0%1169491.7%0.00.0% Swiss Fill 2558.19.8447.90.048.4%8.2%3.6%39.9%0.0%1022592.4%0.00.0% Swiss Fill 2658.19.8447.90.048.4%8.2%3.6%39.9%0.0%1022592.4%0.00.0% Swiss Fill 2758.19.8447.90.048.4%8.2%3.6%39.9%0.0%1022592.4%0.00.0% Mixers MixerRoundCleaning time (%)Average lot size MegaChurn 20529.5%17436 MegaChurn 20629.5%17436 MegaChurn 20729.5%17436 Fruitmix MQ014.5%11022 Fruitmix MQ116.6%10893 Fruitmix MQ216.6%10893 Fruitmix MQ316.4%10916 Fruitmix MQ416.4%10915 Customer CustomerRoundAttained contract indexService level (pieces)Service level (order lines)Service level (orders)Revenue per weekGross margin per weekShipments per weekOrder lines per weekPallets per weekDays in warehouseAttained shelf life (%)OSACarbon footprintDistribution costs Food & Groceries00.90494.8%91.2%85.5%44745185107.77.0168.714.785.9%91.2%1.1694368 Food & Groceries10.82094.2%89.5%82.6%40581143157.77.0168.714.586.3%90.6%1.1794368 Food & Groceries20.96596.5%92.9%88.1%47785222657.77.0168.714.985.8%92.1%1.1794368 Food & Groceries31.02298.2%97.4%95.6%50570230717.77.0168.715.085.3%93.6%1.2194368 Food & Groceries41.02098.1%97.2%95.3%50503230127.77.0168.715.085.4%93.6%1.2094368 Food & Groceries51.02398.5%97.6%95.9%50652234777.77.0168.715.185.0%93.6%1.1994368 Food & Groceries61.02398.5%97.6%95.9%50652234777.77.0168.715.185.0%93.6%1.1994368 Food & Groceries71.02398.5%97.6%95.9%50652234777.77.0168.715.185.0%93.6%1.1994368 LAND Market00.92694.4%92.1%86.9%23452100845.26.988.615.185.3%90.7%1.1152623 LAND Market10.89493.9%90.5%84.4%2262492505.26.988.614.985.6%90.1%1.1352623 LAND Market20.95396.8%93.9%89.8%24113111365.26.988.615.385.3%91.6%1.1352623 LAND Market31.00598.5%97.8%96.2%25441114105.16.887.013.186.9%92.6%1.1651715 LAND Market41.00498.3%97.6%96.0%25418113925.16.887.013.286.9%92.6%1.1651715 LAND Market51.00498.4%97.6%95.9%25406115545.16.887.013.387.0%92.7%1.1451715 LAND Market61.00498.4%97.6%95.9%25406115545.16.887.013.387.0%92.7%1.1451715 LAND Market71.00498.4%97.6%95.9%25406115545.16.887.013