This assignment is realted to fresh connection game. You need to create a DASHBOARD using power BI tool. I have shared the data also. My Role in the Fresh connection game is of SALES . I will also...

This assignment is realted to fresh connection game. You need to create a DASHBOARD using power BI tool. I have shared the data also. My Role in the Fresh connection game is of SALES . I will also share you the screenshots of the game result of sales from ROUND 0 TO ROUND 7 . if you need any help feel free to contact otherwise each and every information is shared by me already. Thank You Best of luck Last time you made this got me fail please make it correctly. As you only need to focus on the sales part . please go through the assignment brief I have shared. Thanks


Presentation 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. Question 1: In your area, what was the situation when you have taken over? Question 2: What do you think was the reason for the problems associated with low ROI? Question 3: What strategies did you suggest ? Question 4: What actions have you taken to implement those strategies? Question 5: What was the result of those actions ? Prepare a DASHBOARD( USING POWER BI tool ) 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- MY ROLE IN THE FRESH CONNECTION GAME IS OF ‘’SALES’’. PLEASE FOCUS THE DASHBOARD AND PREPARE THE DASHBOARD ACCORDING TO SALES ONLY. ALSO PROVIDE ME THE PITCH TO EXPLAIN EACH GRAPH IN THE DASHBOARD AND ALSO THE POSSIBLE QUESTIONS WHICH CAN BE ASKED RELATED TO MY ROLE WHICH IS “SALES’’ ALSO FOR YOUR HELP I WILL SHARE ALL THE SCREENSHOTS OF THE DASHBOARD OF SALES IN THE FRESH CONNECTION GAME FROM ROUND 0 TO ROUND 7 WHICH WILL HELP YOU CREATE THE DASHBOARD. I REPEAT ONCE AGAIN ONLY FOCUS ON SALES IN THE DASHBOARD LIKE ROI, GROSS MARGIN(CUSTOMER), OBSOLETE PRODUCTS , SERVICE LEVELS OUTBOUND ORDER LINES. Thank you . 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 liter-292.6%3.6%5.611225146161341350.03106480005877344.41827890.0%99.5%2.7%3609480 Pack 1 liter-192.3%3.6%5.711069245521322570.03106196365644404.31755390.0%99.5%0.1%3559348 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 PET-283.8%5.8%5.93095911461932048410.05469661198691714.24752780.0%99.7%0.7%5661745 PET-184.1%5.9%5.93079311453932042970.05469516128516674.24656680.0%99.5%-0.0%5631948 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 Orange-298.3%1.1%5.141244035299357250.43911828811691534.774290110.0%99.3%2.0%939098 Orange-197.8%1.0%5.440904235046353600.43921725811607574.570610110.0%99.3%0.0%931265 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 Mango-293.8%0.5%5.383026335732070.992315846147744.61466180.0%99.9%2.5%83669 Mango-193.7%0.5%5.381658331431650.992415497140894.41398380.0%100.0%0.0%82276 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 C-282.1%1.2%4.7231016011860.471910428254.4389190.0%85.1%2.5%4896 Vitamin C-181.5%1.2%4.7229515921840.472810327694.2364180.0%84.3%0.2%4852 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 Materials-292.6%3.6%5.65.61122514616 Mono Packaging Materials-192.3%3.6%5.75.71106924552 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 PLC-283.8%5.8%5.95.9309591146193 Trio PET PLC-184.1%5.9%5.95.9307931145393 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 Vitamins-282.1%1.2%4.74.723101601 Seitan Vitamins-181.5%1.2%4.74.722951592 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 Mango-293.8%0.5%5.35.3830263357 NO8DO Mango-193.7%0.5%5.35.3816583314 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 Oranges-298.3%1.1%5.15.141244035299 Miami Oranges-197.8%1.0%5.45.440904235046 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 liter-23.6%5.6112251461613413536094800.0310648000 Mono Packaging MaterialsPack 1 liter-13.6%5.7110692455213225735593480.0310619636 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 PLCPET-25.8%5.930959114619320484156617450.0546966119 Trio PET PLCPET-15.9%5.930793114539320429756319480.0546951612 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 C-21.2%4.72310160118648960.47191042 Seitan VitaminsVitamin C-11.2%4.72295159218448520.47281032 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 MangoMango-20.5%5.38302633573207836690.992315846 NO8DO MangoMango-10.5%5.38165833143165822760.992415497 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 OrangesOrange-21.1%5.141244035299357259390980.4391182881 Miami OrangesOrange-11.0%5.440904235046353609312650.4392172581 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 2-263.312.1113.810.079.1%15.1%13.7%4.7%12.5%850478.3%0.00.0% Swiss Fill 2-162.612.1113.99.478.2%15.1%13.6%4.9%11.7%843578.7%0.00.0% 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 MQ-214.4%11015 Fruitmix MQ-114.5%11022 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 & Groceries-20.92994.9%91.8%86.5%46007194757.77.0168.714.985.7%91.6%1.1894368 Food & Groceries-10.90494.8%91.2%85.5%44745185107.77.0168.714.785.9%91.2%1.1694368 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 Market-20.93394.6%92.4%87.5%23618100875.26.988.615.385.1%90.9%1.1452623 LAND Market-10.92694.4%92.1%86.9%23452100845.26.988.615.185.3%90.7%1.1152623 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.387.0%92.7%1.1451715 Dominick's-21.00696.9%93.6%91.8%26583121554.13.977.214.486.5%97.1%1.5745124 Dominick's-11.00196.7%93.2%91.2%26452120894.13.977.214.386.6%97.0%1.5645124 Dominick's01.00196.7%93.2%91.2%26452120894.13.977.214.386.6%97.0%1.5645124 Dominick's10.97795.9%91.5%88.9%25812113494.13.977.214.486.5%96.3%1.5945124 Dominick's21.01397.7%94.4%92.6%26749125624.13.977.214.886.3%97.0%1.5945124 Dominick's31.02599.0%98.2%97.7%27090121884.13.977.214.985.6%98.5%1.6145124 Dominick's41.02498.8%97.9%97.2%27050121424.13.977.214.985.6%98.4%1.6145124 Dominick's51.02999.7%99.1%98.8%27189123564.13.977.215.285.0%98.5%1.5845124 Dominick's61.02999.7%99.1%98.8%27189123564.13.977.215.285.0%98.5%1.5845124 Dominick's71.02999.7%99.1%98.8%27189123564.13.977.215.285.0%98.5%1.5845124 Customer - Product Customer ProductRoundDemand per week (units)Demand per week (value)Sales priceGross margin per weekGross margin per pieceAttained shelf life (%)Service level (pieces)Service level (order lines)Additional sales as a result of promotions (%)OSACarbon footprintAdditional sales next round as a result of webshop service level Food & GroceriesFressie Orange 1 liter-242637178330.4278130.183285.0%94.2%92.6%3.3%87.7%1.070.0% Food & GroceriesFressie Orange 1 liter-142637173440.4174550.174885.3%93.8%91.9%3.3%87.1%1.040.0% Food & GroceriesFressie Orange 1 liter042637173440.4174550.174885.3%93.8%91.9%3.3%87.1%1.040.0% Food & GroceriesFressie Orange 1 liter142637157300.3759230.138985.8%93.7%92.5%3.3%87.6%1.020.0% Food & GroceriesFressie Orange 1 liter242637185230.4390420.212185.5%98.0%97.5%3.3%90.0%1.020.0% Food & GroceriesFressie Orange 1 liter342637196020.4692600.217285.5%99.1%99.0%3.3%90.0%1.080.0% Food & GroceriesFressie Orange 1 liter442637195760.4692450.216885.5%98.8%98.7%3.3%90.0%1.080.0% Food & GroceriesFressie Orange 1 liter542637196340.4694660.222085.5%98.9%98.5%3.3%90.0%1.060.0% Food & GroceriesFressie Orange 1 liter642637196340.4694660.222085.5%98.9%98.5%3.3%90.0%1.060.0% Food & GroceriesFressie Orange 1 liter742637196340.4694660.222085.5%98.9%98.5%3.3%90.0%1.060.0% Food & GroceriesFressie Orange/C-power 1 liter-2718236710.5117940.249887.4%85.2%80.9%3.7%83.0%1.220.0% Food & GroceriesFressie Orange/C-power 1 liter-1718235710.5017120.238487.7%83.9%78.7%3.7%80.8%1.200.0% Food & GroceriesFressie Orange/C-power 1 liter0718235710.5017120.238487.7%83.9%78.7%3.7%80.8%1.200.0% Food & GroceriesFressie Orange/C-power 1 liter1718232380.4513080.182288.7%75.4%69.9%3.7%71.7%1.500.0% Food & GroceriesFressie Orange/C-power 1 liter2718238130.5319690.274188.5%82.3%77.3%3.7%79.3%1.500.0% Food & GroceriesFressie Orange/C-power 1 liter3718240350.5620110.280087.6%96.1%94.8%3.7%97.3%1.300.0% Food & GroceriesFressie Orange/C-power 1 liter4718240300.5620070.279587.7%96