Hi . This Assignment requires dashboard and infograaohics.I beong from SALES department. Please help me out with the outcome . Regards AND please let me know if you require anyting ELSE REGARDS.

1 answer below »
Hi . This Assignment requires dashboard and infograaohics.I beong from SALES department. Please help me out with the outcome . Regards AND please let me know if you require anyting ELSE REGARDS.










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 X | @ My Inchainge FE EE SN] a] game.thefreshconnection.eu [LS £3 Import favorites (5) New tab My Company Purchasing Operations Supply Chain eo 0 dashboard = customer product customer product product customer analysis decision log LL of 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 30 150 2 100 92.0% 90.3% v AA 0 oy 2324 88 © Type here to search Ei gi Qe n a a B i 110°C Partly cloudy ~~ & 7Z 9) ENG on 8 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 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.387.0%92.7%1.1451715 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 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 eng="" pi="" 2="" component="" component="" round="" delivery="" reliability="" (%)="" rejection="" (%)="" order="" lines="" previous="" round="" purchase="" value="" previous="" round="" transport="" costs="" previous="" round="" demand="" per="" week="" (piece="" or="" liter)="" purchase="" price="" order="" size="" stock="" (pieces="" or="" liters)="" stock="" (weeks)="" stock="" value="" economic="" inventory="" (weeks)="" obsoletes="" (%)="" component="" availability="" (%)="" bias="" amount="" purchased="" previous="" round="" (piece="" or="" liters)="" pack="" 1="" liter="" 0="" 92.3%="" 3.6%="" 5.7="" 110692="" 4552="" 132257="" 0.0310="" 619636="" 564440="" 4.3="" 17553="" 9="" 0.0%="" 99.5%="" 0.1%="" 3559348="" pack="" 1="" liter="" 1="" 92.5%="" 3.6%="" 5.9="" 109803="" 4516="" 130823="" 0.0310="" 602490="" 548335="" 4.2="" 17053="" 9="" 0.0%="" 99.7%="" 0.1%="" 3530773="" pack="" 1="" liter="" 2="" 92.5%="" 3.7%="" 5.8="" 110318="" 4537="" 131407="" 0.0310="" 608325="" 551677="" 4.2="" 17157="" 9="" 0.0%="" 99.5%="" 0.1%="" 3547317="" pack="" 1="" liter="" 3="" 92.5%="" 3.7%="" 5.8="" 113592="" 4671="" 135536="" 0.0310="" 626379="" 563225="" 4.2="" 17516="" 9="" 0.0%="" 99.8%="" 0.1%="" 3652593="" pack="" 1="" liter="" 4="" 92.7%="" 3.6%="" 5.9="" 113373="" 4662="" 135398="" 0.0310="" 622080="" 563675="" 4.2="" 17530="" 9="" 0.0%="" 99.8%="" 0.1%="" 3645575="" pack="" 1="" liter="" 5="" 92.4%="" 3.7%="" 5.8="" 113030="" 4648="" 135281="" 0.0310="" 623284="" 652478="" 4.8="" 20291="" 10="" 0.0%="" 99.9%="" 0.1%="" 3634546="" pack="" 1="" liter="" 6="" 92.4%="" 3.7%="" 5.8="" 113030="" 4648="" 135281="" 0.0310="" 623284="" 652478="" 4.8="" 20291="" 10="" 0.0%="" 99.9%="" 0.1%="" 3634546="" pack="" 1="" liter="" 7="" 92.4%="" 3.7%="" 5.8="" 113030="" 4648="" 135281="" 0.0310="" 623284="" 652478="" 4.8="" 20291="" 10="" 0.0%="" 99.9%="" 0.1%="" 3634546="" pet="" 0="" 84.1%="" 5.9%="" 5.9="" 307931="" 145393="" 204297="" 0.0546="" 951612="" 851667="" 4.2="" 46566="" 8="" 0.0%="" 99.5%="" -0.0%="" 5631948="" pet="" 1="" 83.3%="" 5.7%="" 5.9="" 309154="" 145475="" 204378="" 0.0549="" 951369="" 822699="" 4.0="" 45172="" 8="" 0.0%="" 99.3%="" -0.0%="" 5630507="" pet="" 2="" 84.0%="" 5.8%="" 6.0="" 310787="" 146246="" 205586="" 0.0549="" 947093="" 845714="" 4.1="" 46436="" 8="" 0.0%="" 99.3%="" -0.0%="" 5660153="" pet="" 3="" 93.9%="" 3.9%="" 5.9="" 313423="" 146574="" 210426="" 0.0552="" 963241="" 897196="" 4.3="" 49570="" 8="" 0.0%="" 100.0%="" -0.0%="" 5672824="" pet="" 4="" 93.9%="" 3.9%="" 5.9="" 313596="" 146644="" 210378="" 0.0552="" 968604="" 895394="" 4.2="" 49467="" 8="" 0.0%="" 100.0%="" -0.0%="" 5676308="" pet="" 5="" 94.1%="" 4.1%="" 7.7="" 313146="" 146671="" 208786="" 0.0553="" 739013="" 572888="" 2.7="" 31695="" 7="" 0.0%="" 99.6%="" -0.0%="" 5660103="" pet="" 6="" 94.1%="" 4.1%="" 7.7="" 313146="" 146671="" 208786="" 0.0553="" 739013="" 572888="" 2.7="" 31695="" 7="" 0.0%="" 99.6%="" -0.0%="" 5660103="" pet="" 7="" 94.1%="" 4.1%="" 7.7="" 313146="" 146671="" 208786="" 0.0553="" 739013="" 572888="" 2.7="" 31695="" 7="" 0.0%="" 99.6%="" -0.0%="" 5660103="" orange="" 0="" 97.8%="" 1.0%="" 5.4="" 409042="" 35046="" 35360="" 0.4392="" 172581="" 160757="" 4.5="" 70610="" 11="" 0.0%="" 99.3%="" 0.0%="" 931265="" orange="" 1="" 98.0%="" 1.0%="" 5.4="" 404768="" 34529="" 35090="" 0.4412="" 170919="" 158495="" 4.5="" 69934="" 11="" 0.0%="" 99.0%="" 0.0%="" 917340="" orange="" 2="" 97.7%="" 1.0%="" 5.4="" 408225="" 34826="" 35261="" 0.4412="" 170535="" 159168="" 4.5="" 70232="" 11="" 0.0%="" 99.5%="" 0.0%="" 925173="" orange="" 3="" 97.8%="" 1.2%="" 5.4="" 420484="" 35843="" 36283="" 0.4412="" 177568="" 162138="" 4.5="" 71537="" 11="" 0.0%="" 99.0%="" 0.0%="" 953024="" orange="" 4="" 98.0%="" 1.1%="" 5.3="" 420480="" 35839="" 36253="" 0.4412="" 178533="" 161436="" 4.4="" 71227="" 11="" 0.0%="" 99.0%="" 0.0%="" 953024="" orange="" 5="" 97.3%="" 0.8%="" 7.0="" 418796="" 35912="" 36152="" 0.4414="" 135124="" 139987="" 3.9="" 61798="" 10="" 0.0%="" 98.9%="" 0.0%="" 948672="" orange="" 6="" 97.3%="" 0.8%="" 7.0="" 418796="" 35912="" 36152="" 0.4414="" 135124="" 139987="" 3.9="" 61798="" 10="" 0.0%="" 98.9%="" 0.0%="" 948672="" orange="" 7="" 97.3%="" 0.8%="" 7.0="" 418796="" 35912="" 36152="" 0.4414="" 135124="" 139987="" 3.9="" 61798="" 10="" 0.0%="" 98.9%="" 0.0%="" 948672="" mango="" 0="" 93.7%="" 0.5%="" 5.3="" 81658="" 3314="" 3165="" 0.9924="" 15497="" 14089="" 4.4="" 13983="" 8="" 0.0%="" 100.0%="" 0.0%="" 82276="" mango="" 1="" 93.8%="" 0.6%="" 5.4="" 81956="" 3336="" 3155="" 0.9926="" 15219="" 14280="" 4.5="" 14174="" 8="" 0.0%="" 100.0%="" 0.0%="" 82566="" mango="" 2="" 93.6%="" 0.5%="" 5.3="" 82090="" 3332="" 3173="" 0.9924="" 15495="" 14285="" 4.5="" 14177="" 8="" 0.0%="" 100.0%="" 0.0%="" 82711="" mango="" 3="" 93.7%="" 0.5%="" 5.5="" 84218="" 3416="" 3259="" 0.9924="" 15559="" 14752="" 4.5="" 14641="" 8="" 0.0%="" 100.0%="" 0.0%="" 84858="" mango="" 4="" 93.5%="" 0.5%="" 5.4="" 84208="" 3406="" 3259="" 0.9923="" 15811="" 14787="" 4.5="" 14674="" 8="" 0.0%="" 100.0%="" 0.0%="" 84858="" mango="" 5="" 93.6%="" 1.4%="" 5.4="" 84329="" 3416="" 3236="" 0.9924="" 15663="" 14406="" 4.5="" 14296="" 9="" 0.0%="" 99.9%="" 0.0%="" 84974="" mango="" 6="" 93.6%="" 1.4%="" 5.4="" 84329="" 3416="" 3236="" 0.9924="" 15663="" 14406="" 4.5="" 14296="" 9="" 0.0%="" 99.9%="" 0.0%="" 84974="" mango="" 7="" 93.6%="" 1.4%="" 5.4="" 84329="" 3416="" 3236="" 0.9924="" 15663="" 14406="" 4.5="" 14296="" 9="" 0.0%="" 99.9%="" 0.0%="" 84974="" vitamin="" c="" 0="" 81.5%="" 1.2%="" 4.7="" 2295="" 1592="" 184="" 0.4728="" 1032="" 769="" 4.2="" 364="" 18="" 0.0%="" 84.3%="" 0.2%="" 4852="" vitamin="" c="" 1="" 88.9%="" 0.0%="" 0.5="" 3044="" 779="" 182="" 0.1942="" 30000="" 17703="" 97.5="" 3440="" 138="" 226.4%="" 72.1%="" 0.2%="" 15666="" vitamin="" c="" 2="" 88.9%="" 0.0%="" 0.5="" 3044="" 779="" 183="" 0.1942="" 30000="" 17728="" 97.1="" 3444="" 138="" 224.4%="" 73.2%="" 0.2%="" 15666="" vitamin="" c="" 3="" 98.2%="" 0.0%="" 4.9="" 2375="" 1632="" 191="" 0.4801="" 1015="" 753="" 3.9="" 362="" 17="" 0.0%="" 98.5%="" 0.2%="" 4946="" vitamin="" c="" 4="" 98.2%="" 0.0%="" 4.8="" 2364="" 1624="" 191="" 0.4799="" 1016="" 749="" 3.9="" 360="" 17="" 0.0%="" 98.4%="" 0.2%="" 4925="" vitamin="" c="" 5="" 98.3%="" 2.9%="" 4.8="" 2471="" 1688="" 195="" 0.4739="" 1076="" 746="" 3.8="" 354="" 18="" 0.0%="" 93.8%="" 0.2%="" 5215="" vitamin="" c="" 6="" 98.3%="" 2.9%="" 4.8="" 2471="" 1688="" 195="" 0.4739="" 1076="" 746="" 3.8="" 354="" 18="" 0.0%="" 93.8%="" 0.2%="" 5215="" vitamin="" c="" 7="" 98.3%="" 2.9%="" 4.8="" 2471="" 1688="" 195="" 0.4739="" 1076="" 746="" 3.8="" 354="" 18="" 0.0%="" 93.8%="" 0.2%="" 5215="" supplier="" supplier="" round="" delivery="" reliability="" (%)="" rejection="" (%)="" deliveries="" previous="" round="" order="" lines="" previous="" round="" purchase="" value="" previous="" round="" transport="" costs="" previous="" round="" mono="" packaging="" materials="" 0="" 92.3%="" 3.6%="" 5.7="" 5.7="" 110692="" 4552="" mono="" packaging="" materials="" 1="" 92.5%="" 3.6%="" 5.9="" 5.9="" 109803="" 4516="" mono="" packaging="" materials="" 2="" 92.5%="" 3.7%="" 5.8="" 5.8="" 110318="" 4537="" mono="" packaging="" materials="" 3="" 92.5%="" 3.7%="" 5.8="" 5.8="" 113592="" 4671="" mono="" packaging="" materials="" 4="" 92.7%="" 3.6%="" 5.9="" 5.9="" 113373="" 4662="" mono="" packaging="" materials="" 5="" 92.4%="" 3.7%="" 5.8="" 5.8="" 113030="" 4648="" mono="" packaging="" materials="" 6="" 92.4%="" 3.7%="" 5.8="" 5.8="" 113030="" 4648="" mono="" packaging="" materials="" 7="" 92.4%="" 3.7%="" 5.8="" 5.8="" 113030="" 4648="" trio="" pet="" plc="" 0="" 84.1%="" 5.9%="" 5.9="" 5.9="" 307931="" 145393="" trio="" pet="" plc="" 1="" 83.3%="" 5.7%="" 5.9="" 5.9="" 309154="" 145475="" trio="" pet="" plc="" 2="" 84.0%="" 5.8%="" 6.0="" 6.0="" 310787="" 146246="" trio="" pet="" plc="" 3="" 93.9%="" 3.9%="" 5.9="" 5.9="" 313423="" 146574="" trio="" pet="" plc="" 4="" 93.9%="" 3.9%="" 5.9="" 5.9="" 313596="" 146644="" trio="" pet="" plc="" 5="" 94.1%="" 4.1%="" 7.7="" 7.7="" 313146="" 146671="" trio="" pet="" plc="" 6="" 94.1%="" 4.1%="" 7.7="" 7.7="" 313146="" 146671="" trio="" pet="" plc="" 7="" 94.1%="" 4.1%="" 7.7="" 7.7="" 313146="" 146671="" seitan="" vitamins="" 0="" 81.5%="" 1.2%="" 4.7="" 4.7="" 2295="" 1592="" seitan="" vitamins="" 1="" 88.9%="" 0.0%="" 0.5="" 0.5="" 3044="" 779="" seitan="" vitamins="" 2="" 88.9%="" 0.0%="" 0.5="" 0.5="" 3044="" 779="" seitan="" vitamins="" 3="" 98.2%="" 0.0%="" 4.9="" 4.9="" 2375="" 1632="" seitan="" vitamins="" 4="" 98.2%="" 0.0%="" 4.8="" 4.8="" 2364="" 1624="" seitan="" vitamins="" 5="" 98.3%="" 2.9%="" 4.8="" 4.8="" 2471="" 1688="" seitan="" vitamins="" 6="" 98.3%="" 2.9%="" 4.8="" 4.8="" 2471="" 1688="" seitan="" vitamins="" 7="" 98.3%="" 2.9%="" 4.8="" 4.8="" 2471="" 1688="" no8do="" mango="" 0="" 93.7%="" 0.5%="" 5.3="" 5.3="" 81658="" 3314="" no8do="" mango="" 1="" 93.8%="" 0.6%="" 5.4="" 5.4="" 81956="" 3336="" no8do="" mango="" 2="" 93.6%="" 0.5%="" 5.3="" 5.3="" 82090="" 3332="" no8do="" mango="" 3="" 93.7%="" 0.5%="" 5.5="" 5.5="" 84218="" 3416="" no8do="" mango="" 4="" 93.5%="" 0.5%="" 5.4="" 5.4="" 84208="" 3406="" no8do="" mango="" 5="" 93.6%="" 1.4%="" 5.4="" 5.4="" 84329="" 3416="" no8do="" mango="" 6="" 93.6%="" 1.4%="" 5.4="" 5.4="" 84329="" 3416="" no8do="" mango="" 7="" 93.6%="" 1.4%="" 5.4="" 5.4="" 84329="" 3416="" miami="" oranges="" 0="" 97.8%="" 1.0%="" 5.4="" 5.4="" 409042="" 35046="" miami="" oranges="" 1="" 98.0%="" 1.0%="" 5.4="" 5.4="" 404768="" 34529="" miami="" oranges="" 2="" 97.7%="" 1.0%="" 5.4="" 5.4="" 408225="" 34826="" miami="" oranges="" 3="" 97.8%="" 1.2%="" 5.4="" 5.4="" 420484="" 35843="" miami="" oranges="" 4="" 98.0%="" 1.1%="" 5.3="" 5.3="" 420480="" 35839="" miami="" oranges="" 5="" 97.3%="" 0.8%="" 7.0="" 7.0="" 418796="" 35912="" miami="" oranges="" 6="" 97.3%="" 0.8%="" 7.0="" 7.0="" 418796="" 35912="" miami="" oranges="" 7="" 97.3%="" 0.8%="" 7.0="" 7.0="" 418796="" 35912="" supplier="" -="" component="" supplier="" component="" round="" rejection="" (%)="" order="" lines="" previous="" round="" purchase="" value="" previous="" round="" transport="" costs="" previous="" round="" demand="" per="" week="" (piece="" or="" liter)="" amount="" purchased="" previous="" round="" (piece="" or="" liters)="" purchase="" price="" order="" size="" mono="" packaging="" materials="" pack="" 1="" liter="" 0="" 3.6%="" 5.7="" 110692="" 4552="" 132257="" 3559348="" 0.0310="" 619636="" mono="" packaging="" materials="" pack="" 1="" liter="" 1="" 3.6%="" 5.9="" 109803="" 4516="" 130823="" 3530773="" 0.0310="" 602490="" mono="" packaging="" materials="" pack="" 1="" liter="" 2="" 3.7%="" 5.8="" 110318="" 4537="" 131407="" 3547317="" 0.0310="" 608325="" mono="" packaging="" materials="" pack="" 1="" liter="" 3="" 3.7%="" 5.8="" 113592="" 4671="" 135536="" 3652593="" 0.0310="" 626379="" mono="" packaging="" materials="" pack="" 1="" liter="" 4="" 3.6%="" 5.9="" 113373="" 4662="" 135398="" 3645575="" 0.0310="" 622080="" mono="" packaging="" materials="" pack="" 1="" liter="" 5="" 3.7%="" 5.8="" 113030="" 4648="" 135281="" 3634546="" 0.0310="" 623284="" mono="" packaging="" materials="" pack="" 1="" liter="" 6="" 3.7%="" 5.8="" 113030="" 4648="" 135281="" 3634546="" 0.0310="" 623284="" mono="" packaging="" materials="" pack="" 1="" liter="" 7="" 3.7%="" 5.8="" 113030="" 4648="" 135281="" 3634546="" 0.0310="" 623284="" trio="" pet="" plc="" pet="" 0="" 5.9%="" 5.9="" 307931="" 145393="" 204297="" 5631948="" 0.0546="" 951612="" trio="" pet="" plc="" pet="" 1="" 5.7%="" 5.9="" 309154="" 145475="" 204378="" 5630507="" 0.0549="" 951369="" trio="" pet="" plc="" pet="" 2="" 5.8%="" 6.0="" 310787="" 146246="" 205586="" 5660153="" 0.0549="" 947093="" trio="" pet="" plc="" pet="" 3="" 3.9%="" 5.9="" 313423="" 146574="" 210426="" 5672824="" 0.0552="" 963241="" trio="" pet="" plc="" pet="" 4="" 3.9%="" 5.9="" 313596="" 146644="" 210378="" 5676308="" 0.0552="" 968604="" trio="" pet="" plc="" pet="" 5="" 4.1%="" 7.7="" 313146="" 146671="" 208786="" 5660103="" 0.0553="" 739013="" trio="" pet="" plc="" pet="" 6="" 4.1%="" 7.7="" 313146="" 146671="" 208786="" 5660103="" 0.0553="" 739013="" trio="" pet="" plc="" pet="" 7="" 4.1%="" 7.7="" 313146="" 146671="" 208786="" 5660103="" 0.0553="" 739013="" seitan="" vitamins="" vitamin="" c="" 0="" 1.2%="" 4.7="" 2295="" 1592="" 184="" 4852="" 0.4728="" 1032="" seitan="" vitamins="" vitamin="" c="" 1="" 0.0%="" 0.5="" 3044="" 779="" 182="" 15666="" 0.1942="" 30000="" seitan="" vitamins="" vitamin="" c="" 2="" 0.0%="" 0.5="" 3044="" 779="" 183="" 15666="" 0.1942="" 30000="" seitan="" vitamins="" vitamin="" c="" 3="" 0.0%="" 4.9="" 2375="" 1632="" 191="" 4946="" 0.4801="" 1015="" seitan="" vitamins="" vitamin="" c="" 4="" 0.0%="" 4.8="" 2364="" 1624="" 191="" 4925="" 0.4799="" 1016="" seitan="" vitamins="" vitamin="" c="" 5="" 2.9%="" 4.8="" 2471="" 1688="" 195="" 5215="" 0.4739="" 1076="" seitan="" vitamins="" vitamin="" c="" 6="" 2.9%="" 4.8="" 2471="" 1688="" 195="" 5215="" 0.4739="" 1076="" seitan="" vitamins="" vitamin="" c="" 7="" 2.9%="" 4.8="" 2471="" 1688="" 195="" 5215="" 0.4739="" 1076="" no8do="" mango="" mango="" 0="" 0.5%="" 5.3="" 81658="" 3314="" 3165="" 82276="" 0.9924="" 15497="" no8do="" mango="" mango="" 1="" 0.6%="" 5.4="" 81956="" 3336="" 3155="" 82566="" 0.9926="" 15219="" no8do="" mango="" mango="" 2="" 0.5%="" 5.3="" 82090="" 3332="" 3173="" 82711="" 0.9924="" 15495="" no8do="" mango="" mango="" 3="" 0.5%="" 5.5="" 84218="" 3416="" 3259="" 84858="" 0.9924="" 15559="" no8do="" mango="" mango="" 4="" 0.5%="" 5.4="" 84208="" 3406="" 3259="" 84858="" 0.9923="" 15811="" no8do="" mango="" mango="" 5="" 1.4%="" 5.4="" 84329="" 3416="" 3236="" 84974="" 0.9924="" 15663="" no8do="" mango="" mango="" 6="" 1.4%="" 5.4="" 84329="" 3416="" 3236="" 84974="" 0.9924="" 15663="" no8do="" mango="" mango="" 7="" 1.4%="" 5.4="" 84329="" 3416="" 3236="" 84974="" 0.9924="" 15663="" miami="" oranges="" orange="" 0="" 1.0%="" 5.4="" 409042="" 35046="" 35360="" 931265="" 0.4392="" 172581="" miami="" oranges="" orange="" 1="" 1.0%="" 5.4="" 404768="" 34529="" 35090="" 917340="" 0.4412="" 170919="" miami="" oranges="" orange="" 2="" 1.0%="" 5.4="" 408225="" 34826="" 35261="" 925173="" 0.4412="" 170535="" miami="" oranges="" orange="" 3="" 1.2%="" 5.4="" 420484="" 35843="" 36283="" 953024="" 0.4412="" 177568="" miami="" oranges="" orange="" 4="" 1.1%="" 5.3="" 420480="" 35839="" 36253="" 953024="" 0.4412="" 178533="" miami="" oranges="" orange="" 5="" 0.8%="" 7.0="" 418796="" 35912="" 36152="" 948672="" 0.4414="" 135124="" miami="" oranges="" orange="" 6="" 0.8%="" 7.0="" 418796="" 35912="" 36152="" 948672="" 0.4414="" 135124="" miami="" oranges="" orange="" 7="" 0.8%="" 7.0="" 418796="" 35912="" 36152="" 948672="" 0.4414="" 135124="" bottling="" line="" bottling="" line="" round="" run="" 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="" 0="" 62.6="" 12.1="" 11="" 3.9="" 9.4="" 78.2%="" 15.1%="" 13.6%="" 4.9%="" 11.7%="" 8435="" 78.7%="" 0.0="" 0.0%="" swiss="" fill="" 2="" 1="" 62.0="" 13.6="" 11="" 3.4="" 9.7="" 77.6%="" 17.0%="" 13.5%="" 4.2%="" 12.2%="" 10083="" 73.9%="" 0.0="" 0.0%="" swiss="" fill="" 2="" 2="" 56.6="" 10.5="" 10="" 6.7="" 3.6="" 70.8%="" 13.2%="" 12.3%="" 8.4%="" 4.5%="" 10804="" 80.1%="" 0.0="" 0.0%="" swiss="" fill="" 2="" 3="" 58.3="" 10.7="" 3="" 48.3="" 0.0="" 48.5%="" 8.9%="" 2.4%="" 40.3%="" 0.0%="" 11687="" 92.5%="" 0.0="" 0.0%="" swiss="" fill="" 2="" 4="" 58.2="" 10.7="" 3="" 48.3="" 0.0="" 48.5%="" 8.9%="" 2.4%="" 40.3%="" 0.0%="" 11694="" 91.7%="" 0.0="" 0.0%="" swiss="" fill="" 2="" 5="" 58.1="" 9.8="" 4="" 47.9="" 0.0="" 48.4%="" 8.2%="" 3.6%="" 39.9%="" 0.0%="" 10225="" 92.4%="" 0.0="" 0.0%="" swiss="" fill="" 2="" 6="" 58.1="" 9.8="" 4="" 47.9="" 0.0="" 48.4%="" 8.2%="" 3.6%="" 39.9%="" 0.0%="" 10225="" 92.4%="" 0.0="" 0.0%="" swiss="" fill="" 2="" 7="" 58.1="" 9.8="" 4="" 47.9="" 0.0="" 48.4%="" 8.2%="" 3.6%="" 39.9%="" 0.0%="" 10225="" 92.4%="" 0.0="" 0.0%="" mixers="" mixer="" round="" cleaning="" time="" (%)="" average="" lot="" size="" megachurn="" 20="" 5="" 29.5%="" 17436="" megachurn="" 20="" 6="" 29.5%="" 17436="" megachurn="" 20="" 7="" 29.5%="" 17436="" fruitmix="" mq="" 0="" 14.5%="" 11022="" fruitmix="" mq="" 1="" 16.6%="" 10893="" fruitmix="" mq="" 2="" 16.6%="" 10893="" fruitmix="" mq="" 3="" 16.4%="" 10916="" fruitmix="" mq="" 4="" 16.4%="" 10915="" customer="" customer="" round="" attained="" contract="" index="" service="" level="" (pieces)="" service="" level="" (order="" lines)="" service="" level="" (orders)="" revenue="" per="" week="" gross="" margin="" per="" week="" shipments="" per="" week="" order="" lines="" per="" week="" pallets="" per="" week="" days="" in="" warehouse="" attained="" shelf="" life="" (%)="" osa="" carbon="" footprint="" distribution="" costs="" food="" &="" groceries="" 0="" 0.904="" 94.8%="" 91.2%="" 85.5%="" 44745="" 18510="" 7.7="" 7.0="" 168.7="" 14.7="" 85.9%="" 91.2%="" 1.16="" 94368="" food="" &="" groceries="" 1="" 0.820="" 94.2%="" 89.5%="" 82.6%="" 40581="" 14315="" 7.7="" 7.0="" 168.7="" 14.5="" 86.3%="" 90.6%="" 1.17="" 94368="" food="" &="" groceries="" 2="" 0.965="" 96.5%="" 92.9%="" 88.1%="" 47785="" 22265="" 7.7="" 7.0="" 168.7="" 14.9="" 85.8%="" 92.1%="" 1.17="" 94368="" food="" &="" groceries="" 3="" 1.022="" 98.2%="" 97.4%="" 95.6%="" 50570="" 23071="" 7.7="" 7.0="" 168.7="" 15.0="" 85.3%="" 93.6%="" 1.21="" 94368="" food="" &="" groceries="" 4="" 1.020="" 98.1%="" 97.2%="" 95.3%="" 50503="" 23012="" 7.7="" 7.0="" 168.7="" 15.0="" 85.4%="" 93.6%="" 1.20="" 94368="" food="" &="" groceries="" 5="" 1.023="" 98.5%="" 97.6%="" 95.9%="" 50652="" 23477="" 7.7="" 7.0="" 168.7="" 15.1="" 85.0%="" 93.6%="" 1.19="" 94368="" food="" &="" groceries="" 6="" 1.023="" 98.5%="" 97.6%="" 95.9%="" 50652="" 23477="" 7.7="" 7.0="" 168.7="" 15.1="" 85.0%="" 93.6%="" 1.19="" 94368="" food="" &="" groceries="" 7="" 1.023="" 98.5%="" 97.6%="" 95.9%="" 50652="" 23477="" 7.7="" 7.0="" 168.7="" 15.1="" 85.0%="" 93.6%="" 1.19="" 94368="" land="" market="" 0="" 0.926="" 94.4%="" 92.1%="" 86.9%="" 23452="" 10084="" 5.2="" 6.9="" 88.6="" 15.1="" 85.3%="" 90.7%="" 1.11="" 52623="" land="" market="" 1="" 0.894="" 93.9%="" 90.5%="" 84.4%="" 22624="" 9250="" 5.2="" 6.9="" 88.6="" 14.9="" 85.6%="" 90.1%="" 1.13="" 52623="" land="" market="" 2="" 0.953="" 96.8%="" 93.9%="" 89.8%="" 24113="" 11136="" 5.2="" 6.9="" 88.6="" 15.3="" 85.3%="" 91.6%="" 1.13="" 52623="" land="" market="" 3="" 1.005="" 98.5%="" 97.8%="" 96.2%="" 25441="" 11410="" 5.1="" 6.8="" 87.0="" 13.1="" 86.9%="" 92.6%="" 1.16="" 51715="" land="" market="" 4="" 1.004="" 98.3%="" 97.6%="" 96.0%="" 25418="" 11392="" 5.1="" 6.8="" 87.0="" 13.2="" 86.9%="" 92.6%="" 1.16="" 51715="" land="" market="" 5="" 1.004="" 98.4%="" 97.6%="" 95.9%="" 25406="" 11554="" 5.1="" 6.8="" 87.0="" 13.3="" 87.0%="" 92.7%="" 1.14="" 51715="" land="" market="" 6="" 1.004="" 98.4%="" 97.6%="" 95.9%="" 25406="" 11554="" 5.1="" 6.8="" 87.0="" 13.3="" 87.0%="" 92.7%="" 1.14="" 51715="" land="" market="" 7="" 1.004="" 98.4%="" 97.6%="" 95.9%="" 25406="" 11554="" 5.1="" 6.8="" 87.0="" 13.3="" 87.0%="" 92.7%="" 1.14="" 51715="" dominick's="" 0="" 1.001="" 96.7%="" 93.2%="" 91.2%="" 26452="" 12089="" 4.1="" 3.9="" 77.2="" 14.3="" 86.6%="" 97.0%="" 1.56="" 45124="" dominick's="" 1="" 0.977="" 95.9%="" 91.5%="" 88.9%="" 25812="" 11349="" 4.1="" 3.9="" 77.2="" 14.4="" 86.5%="" 96.3%="" 1.59="" 45124="" dominick's="" 2="" 1.013="" 97.7%="" 94.4%="" 92.6%="" 26749="" 12562="" 4.1="" 3.9="" 77.2="" 14.8="" 86.3%="" 97.0%="" 1.59="" 45124="" dominick's="" 3="" 1.025="" 99.0%="" 98.2%="" 97.7%="" 27090="" 12188="" 4.1="" 3.9="" 77.2="" 14.9="" 85.6%="" 98.5%="" 1.61="" 45124="" dominick's="" 4="" 1.024="" 98.8%="" 97.9%="" 97.2%="" 27050="" 12142="" 4.1="" 3.9="" 77.2="" 14.9="" 85.6%="" 98.4%="" 1.61="" 45124="" dominick's="" 5="" 1.029="" 99.7%="" 99.1%="" 98.8%="" 27189="" 12356="" 4.1="" 3.9="" 77.2="" 15.2="" 85.0%="" 98.5%="" 1.58="" 45124="" dominick's="" 6="" 1.029="" 99.7%="" 99.1%="" 98.8%="" 27189="" 12356="" 4.1="" 3.9="" 77.2="" 15.2="" 85.0%="" 98.5%="" 1.58="" 45124="" dominick's="" 7="" 1.029="" 99.7%="" 99.1%="" 98.8%="" 27189="" 12356="" 4.1="" 3.9="" 77.2="" 15.2="" 85.0%="" 98.5%="" 1.58="" 45124="" customer="" -="" product="" customer="" product="" round="" demand="" per="" week="" (units)="" demand="" per="" week="" (value)="" sales="" price="" gross="" margin="" per="" week="" gross="" margin="" per="" piece="" attained="" shelf="" life="" (%)="" service="" level="" (pieces)="" service="" level="" (order="" lines)="" additional="" sales="" as="" a="" result="" of="" promotions="" (%)="" osa="" carbon="" footprint="" additional="" sales="" next="" round="" as="" a="" result="" of="" webshop="" service="" level="" food="" &="" groceries="" fressie="" orange="" 1="" liter="" 0="" 42637="" 17344="" 0.41="" 7455="" 0.1748="" 85.3%="" 93.8%="" 91.9%="" 3.3%="" 87.1%="" 1.04="" 0.0%="" food="" &="" groceries="" fressie="" orange="" 1="" liter="" 1="" 42637="" 15730="" 0.37="" 5923="" 0.1389="" 85.8%="" 93.7%="" 92.5%="" 3.3%="" 87.6%="" 1.02="" 0.0%="" food="" &="" groceries="" fressie="" orange="" 1="" liter="" 2="" 42637="" 18523="" 0.43="" 9042="" 0.2121="" 85.5%="" 98.0%="" 97.5%="" 3.3%="" 90.0%="" 1.02="" 0.0%="" food="" &="" groceries="" fressie="" orange="" 1="" liter="" 3="" 42637="" 19602="" 0.46="" 9260="" 0.2172="" 85.5%="" 99.1%="" 99.0%="" 3.3%="" 90.0%="" 1.08="" 0.0%="" food="" &="" groceries="" fressie="" orange="" 1="" liter="" 4="" 42637="" 19576="" 0.46="" 9245="" 0.2168="" 85.5%="" 98.8%="" 98.7%="" 3.3%="">
Answered Same DayMay 11, 2023

Answer To: Hi . This Assignment requires dashboard and infograaohics.I beong from SALES department. Please help...

Atul answered on May 12 2023
26 Votes
Dashboard
    KPI Dashboard
Total    
Mango    Orange    Pack 1 liter    PET    Vitamin C    25718.005499999996    286704.09869999997    1071264.6403999999    1661423.7286999999    1516.2465999999999    
Bottling line utilisation rate
0    
Swiss Fill 2    0.7823    1    
Swiss Fill 2    0.77549999999999997    2    
Swiss Fill 2    0.70779999999999998    3    
Swiss Fill 2    0.4854    4    
Swiss Fill 2    0.48509999999999998    5    
Swiss Fill 2    0.48370000000000002    6    
Swiss Fill 2    0.48370000000000002    7    
Swiss Fill 2    0.48370000000000002    
Average of Delivery reliability (%)    
Miami Oranges    Mono Packaging Materials    NO8DO Mango    Seitan Vitamins    Trio PET PLC    0.97658749999999994    0.92463750000000011    0.93637499999999996    0.93835000000000002    0.90179999999999993    Average of Rejection (%)    
Miami Oranges    Mono Packaging Materials    NO8DO Mango    Seitan Vitamins    Trio PET PLC    9.7750000000000007E-3    3.6612500000000006E-2    8.6499999999999997E-3    1.2487499999999999E-2    4.6587500000000004E-2    
Total Capacity    
Finished goods warehouse    Raw materials warehouse    Tank yard    9920    7080    160    Total Usage    
Finished goods warehouse    Raw materials warehouse    Tank yard    8892.9706999999999    6010.0400000000009    46.160599999999988    
Average % of obsolete Products
Total    
Fressie Orange 1 liter    Fressie Orange PET    Fressie Orange/C-power 1 liter    Fressie Orange/C-power PET    Fressie Orange/Mango 1 liter    Fressie Orange/Mango PET    9.202500000000001E-2    9.6587499999999993E-2    8.4912500000000002E-2    0.11716249999999999    0.11115000000000003    8.8050000000000003E-2    
Gross Margin per Product
Total    0    1    2    3    4    5    6    7    0    1    2    3    4    5    6    7    0    1    2    3    4    5    6    7    Dominick's    Food     &     Groceries    LAND Market    12088.532999999999    11348.868700000001    12561.866599999999    12188.295899999999    12141.8639    12355.6528    12355.6528    12355.6528    18510.197199999999    14315.148800000001    22264.565699999999    23071.492699999999    23012.273399999998    23476.661599999999    23476.661599999999    23476.661599999999    10083.6278    9250.1016999999993    11135.7516    11409.679    11392.2655    1155
3.6612    11553.6612    11553.6612    
Sheet3
    Row Labels    Sum of Demand per week (piece or liter)
    Mango    25718.0055
    Orange    286704.0987
    Pack 1 liter    1071264.6404
    PET    1661423.7287
    Vitamin C    1516.2466
    Grand Total    3046626.7199
Component
    Component    Round    Delivery reliability (%)    Rejection (%)    Order lines previous round    Purchase value previous round    Transport costs previous round    Demand per week (piece or liter)    Purchase price    Order size    Stock (pieces or liters)    Stock (weeks)    Stock value    Economic inventory (weeks)    Obsoletes (%)    Component availability (%)    Bias    Amount purchased previous round (piece or liters)
    Pack 1 liter    0    92.3%    3.6%    5.7    110692    4552    132257    0.0310    619636    564440    4.3    17553    9    0.0%    99.5%    0.1%    3559348
    Pack 1 liter    1    92.5%    3.6%    5.9    109803    4516    130823    0.0310    602490    548335    4.2    17053    9    0.0%    99.7%    0.1%    3530773
    Pack 1 liter    2    92.5%    3.7%    5.8    110318    4537    131407    0.0310    608325    551677    4.2    17157    9    0.0%    99.5%    0.1%    3547317
    Pack 1 liter    3    92.5%    3.7%    5.8    113592    4671    135536    0.0310    626379    563225    4.2    17516    9    0.0%    99.8%    0.1%    3652593
    Pack 1 liter    4    92.7%    3.6%    5.9    113373    4662    135398    0.0310    622080    563675    4.2    17530    9    0.0%    99.8%    0.1%    3645575
    Pack 1 liter    5    92.4%    3.7%    5.8    113030    4648    135281    0.0310    623284    652478    4.8    20291    10    0.0%    99.9%    0.1%    3634546
    Pack 1 liter    6    92.4%    3.7%    5.8    113030    4648    135281    0.0310    623284    652478    4.8    20291    10    0.0%    99.9%    0.1%    3634546
    Pack 1 liter    7    92.4%    3.7%    5.8    113030    4648    135281    0.0310    623284    652478    4.8    20291    10    0.0%    99.9%    0.1%    3634546
    PET    0    84.1%    5.9%    5.9    307931    145393    204297    0.0546    951612    851667    4.2    46566    8    0.0%    99.5%    -0.0%    5631948
    PET    1    83.3%    5.7%    5.9    309154    145475    204378    0.0549    951369    822699    4.0    45172    8    0.0%    99.3%    -0.0%    5630507
    PET    2    84.0%    5.8%    6.0    310787    146246    205586    0.0549    947093    845714    4.1    46436    8    0.0%    99.3%    -0.0%    5660153
    PET    3    93.9%    3.9%    5.9    313423    146574    210426    0.0552    963241    897196    4.3    49570    8    0.0%    100.0%    -0.0%    5672824
    PET    4    93.9%    3.9%    5.9    313596    146644    210378    0.0552    968604    895394    4.2    49467    8    0.0%    100.0%    -0.0%    5676308
    PET    5    94.1%    4.1%    7.7    313146    146671    208786    0.0553    739013    572888    2.7    31695    7    0.0%    99.6%    -0.0%    5660103
    PET    6    94.1%    4.1%    7.7    313146    146671    208786    0.0553    739013    572888    2.7    31695    7    0.0%    99.6%    -0.0%    5660103
    PET    7    94.1%    4.1%    7.7    313146    146671    208786    0.0553    739013    572888    2.7    31695    7    0.0%    99.6%    -0.0%    5660103
    Orange    0    97.8%    1.0%    5.4    409042    35046    35360    0.4392    172581    160757    4.5    70610    11    0.0%    99.3%    0.0%    931265
    Orange    1    98.0%    1.0%    5.4    404768    34529    35090    0.4412    170919    158495    4.5    69934    11    0.0%    99.0%    0.0%    917340
    Orange    2    97.7%    1.0%    5.4    408225    34826    35261    0.4412    170535    159168    4.5    70232    11    0.0%    99.5%    0.0%    925173
    Orange    3    97.8%    1.2%    5.4    420484    35843    36283    0.4412    177568    162138    4.5    71537    11    0.0%    99.0%    0.0%    953024
    Orange    4    98.0%    1.1%    5.3    420480    35839    36253    0.4412    178533    161436    4.4    71227    11    0.0%    99.0%    0.0%    953024
    Orange    5    97.3%    0.8%    7.0    418796    35912    36152    0.4414    135124    139987    3.9    61798    10    0.0%    98.9%    0.0%    948672
    Orange    6    97.3%    0.8%    7.0    418796    35912    36152    0.4414    135124    139987    3.9    61798    10    0.0%    98.9%    0.0%    948672
    Orange    7    97.3%    0.8%    7.0    418796    35912    36152    0.4414    135124    139987    3.9    61798    10    0.0%    98.9%    0.0%    948672
    Mango    0    93.7%    0.5%    5.3    81658    3314    3165    0.9924    15497    14089    4.4    13983    8    0.0%    100.0%    0.0%    82276
    Mango    1    93.8%    0.6%    5.4    81956    3336    3155    0.9926    15219    14280    4.5    14174    8    0.0%    100.0%    0.0%    82566
    Mango    2    93.6%    0.5%    5.3    82090    3332    3173    0.9924    15495    14285    4.5    14177    8    0.0%    100.0%    0.0%    82711
    Mango    3    93.7%    0.5%    5.5    84218    3416    3259    0.9924    15559    14752    4.5    14641    8    0.0%    100.0%    0.0%    84858
    Mango    4    93.5%    0.5%    5.4    84208    3406    3259    0.9923    15811    14787    4.5    14674    8    0.0%    100.0%    0.0%    84858
    Mango    5    93.6%    1.4%    5.4    84329    3416    3236    0.9924    15663    14406    4.5    14296    9    0.0%    99.9%    0.0%    84974
    Mango    6    93.6%    1.4%    5.4    84329    3416    3236    0.9924    15663    14406    4.5    14296    9    0.0%    99.9%    0.0%    84974
    Mango    7    93.6%    1.4%    5.4    84329    3416    3236    0.9924    15663    14406    4.5    14296    9    0.0%    99.9%    0.0%    84974
    Vitamin C    0    81.5%    1.2%    4.7    2295    1592    184    0.4728    1032    769    4.2    364    18    0.0%    84.3%    0.2%    4852
    Vitamin C    1    88.9%    0.0%    0.5    3044    779    182    0.1942    30000    17703    97.5    3440    138    226.4%    72.1%    0.2%    15666
    Vitamin C    2    88.9%    0.0%    0.5    3044    779    183    0.1942    30000    17728    97.1    3444    138    224.4%    73.2%    0.2%    15666
    Vitamin C    3    98.2%    0.0%    4.9    2375    1632    191    0.4801    1015    753    3.9    362    17    0.0%    98.5%    0.2%    4946
    Vitamin C    4    98.2%    0.0%    4.8    2364    1624    191    0.4799    1016    749    3.9    360    17    0.0%    98.4%    0.2%    4925
    Vitamin C    5    98.3%    2.9%    4.8    2471    1688    195    0.4739    1076    746    3.8    354    18    0.0%    93.8%    0.2%    5215
    Vitamin C    6    98.3%    2.9%    4.8    2471    1688    195    0.4739    1076    746    3.8    354    18    0.0%    93.8%    0.2%    5215
    Vitamin C    7    98.3%    2.9%    4.8    2471    1688    195    0.4739    1076    746    3.8    354    18    0.0%    93.8%    0.2%    5215
Sheet5
    Row Labels    Average of Delivery reliability (%)    Average of Rejection (%)
    Miami Oranges    0.9765875    0.009775
    Mono Packaging Materials    0.9246375    0.0366125
    NO8DO Mango    0.936375    0.00865
    Seitan Vitamins    0.93835    0.0124875
    Trio PET PLC    0.9018    0.0465875
    Grand Total    0.93555    0.0228225
Supplier
    Supplier    Round    Delivery reliability (%)    Rejection (%)    Deliveries previous round    Order lines previous round    Purchase value previous round    Transport costs previous round
    Mono Packaging Materials    0    92.3%    3.6%    5.7    5.7    110692    4552
    Mono Packaging Materials    1    92.5%    3.6%    5.9    5.9    109803    4516
    Mono Packaging Materials    2    92.5%    3.7%    5.8    5.8    110318    4537
    Mono Packaging Materials    3    92.5%    3.7%    5.8    5.8    113592    4671
    Mono Packaging Materials    4    92.7%    3.6%    5.9    5.9    113373    4662
    Mono Packaging Materials    5    92.4%    3.7%    5.8    5.8    113030    4648
    Mono Packaging Materials    6    92.4%    3.7%    5.8    5.8    113030    4648
    Mono Packaging Materials    7    92.4%    3.7%    5.8    5.8    113030    4648
    Trio PET PLC    0    84.1%    5.9%    5.9    5.9    307931    145393
    Trio PET PLC    1    83.3%    5.7%    5.9    5.9    309154    145475
    Trio PET PLC    2    84.0%    5.8%    6.0    6.0    310787    146246
    Trio PET PLC    3    93.9%    3.9%    5.9    5.9    313423    146574
    Trio PET PLC    4    93.9%    3.9%    5.9    5.9    313596    146644
    Trio PET PLC    5    94.1%    4.1%    7.7    7.7    313146    146671
    Trio PET PLC    6    94.1%    4.1%    7.7    7.7    313146    146671
    Trio PET PLC    7    94.1%    4.1%    7.7    7.7    313146    146671
    Seitan Vitamins    0    81.5%    1.2%    4.7    4.7    2295    1592
    Seitan Vitamins    1    88.9%    0.0%    0.5    0.5    3044    779
    Seitan Vitamins    2    88.9%    0.0%    0.5    0.5    3044    779
    Seitan Vitamins    3    98.2%    0.0%    4.9    4.9    2375    1632
    Seitan Vitamins    4    98.2%    0.0%    4.8    4.8    2364    1624
    Seitan Vitamins    5    98.3%    2.9%    4.8    4.8    2471    1688
    Seitan Vitamins    6    98.3%    2.9%    4.8    4.8    2471    1688
    Seitan Vitamins    7    98.3%    2.9%    4.8    4.8    2471    1688
    NO8DO Mango    0    93.7%    0.5%    5.3    5.3    81658    3314
    NO8DO Mango    1    93.8%    0.6%    5.4    5.4    81956    3336
    NO8DO Mango    2    93.6%    0.5%    5.3    5.3    82090    3332
    NO8DO Mango    3    93.7%    0.5%    5.5    5.5    84218    3416
    NO8DO Mango    4    93.5%    0.5%    5.4    5.4    84208    3406
    NO8DO Mango    5    93.6%    1.4%    5.4    5.4    84329    3416
    NO8DO Mango    6    93.6%    1.4%    5.4    5.4    84329    3416
    NO8DO Mango    7    93.6%    1.4%    5.4    5.4    84329    3416
    Miami Oranges    0    97.8%    1.0%    5.4    5.4    409042    35046
    Miami Oranges    1    98.0%    1.0%    5.4    5.4    404768    34529
    Miami Oranges    2    97.7%    1.0%    5.4    5.4    408225    34826
    Miami Oranges    3    97.8%    1.2%    5.4    5.4    420484    35843
    Miami Oranges    4    98.0%    1.1%    5.3    5.3    420480    35839
    Miami Oranges    5    97.3%    0.8%    7.0    7.0    418796    35912
    Miami Oranges    6    97.3%    0.8%    7.0    7.0    418796    35912
    Miami Oranges    7    97.3%    0.8%    7.0    7.0    418796    35912
Supplier - Component
    Supplier     Component    Round    Rejection (%)    Order lines previous round    Purchase value previous round    Transport costs previous round    Demand per week (piece or liter)    Amount purchased previous round (piece or liters)    Purchase price    Order size
    Mono Packaging Materials    Pack 1 liter    0    3.6%    5.7    110692    4552    132257    3559348    0.0310    619636
    Mono Packaging Materials    Pack 1 liter    1    3.6%    5.9    109803    4516    130823    3530773    0.0310    602490
    Mono Packaging Materials    Pack 1 liter    2    3.7%    5.8    110318    4537    131407    3547317    0.0310    608325
    Mono Packaging Materials    Pack 1 liter    3    3.7%    5.8    113592    4671    135536    3652593    0.0310    626379
    Mono Packaging Materials    Pack 1 liter    4    3.6%    5.9    113373    4662    135398    3645575    0.0310    622080
    Mono Packaging Materials    Pack 1 liter    5    3.7%    5.8    113030    4648    135281    3634546    0.0310    623284
    Mono Packaging Materials    Pack 1 liter    6    3.7%    5.8    113030    4648    135281    3634546    0.0310    623284
    Mono Packaging Materials    Pack 1 liter    7    3.7%    5.8    113030    4648    135281    3634546    0.0310    623284
    Trio PET PLC    PET    0    5.9%    5.9    307931    145393    204297    5631948    0.0546    951612
    Trio PET PLC    PET    1    5.7%    5.9    309154    145475    204378    5630507    0.0549    951369
    Trio PET PLC    PET    2    5.8%    6.0    310787    146246    205586    5660153    0.0549    947093
    Trio PET PLC    PET    3    3.9%    5.9    313423    146574    210426    5672824    0.0552    963241
    Trio PET PLC    PET    4    3.9%    5.9    313596    146644    210378    5676308    0.0552    968604
    Trio PET PLC    PET    5    4.1%    7.7    313146    146671    208786    5660103    0.0553    739013
    Trio PET PLC    PET    6    4.1%    7.7    313146    146671    208786    5660103    0.0553    739013
    Trio PET PLC    PET    7    4.1%    7.7    313146    146671    208786    5660103    0.0553    739013
    Seitan Vitamins    Vitamin C    0    1.2%    4.7    2295    1592    184    4852    0.4728    1032
    Seitan Vitamins    Vitamin C    1    0.0%    0.5    3044    779    182    15666    0.1942    30000
    Seitan Vitamins    Vitamin C    2    0.0%    0.5    3044    779    183    15666    0.1942    30000
    Seitan Vitamins    Vitamin C    3    0.0%    4.9    2375    1632    191    4946    0.4801    1015
    Seitan Vitamins    Vitamin C    4    0.0%    4.8    2364    1624    191    4925    0.4799    1016
    Seitan Vitamins    Vitamin C    5    2.9%    4.8    2471    1688    195    5215    0.4739    1076
    Seitan Vitamins    Vitamin C    6    2.9%    4.8    2471    1688    195    5215    0.4739    1076
    Seitan Vitamins    Vitamin C    7    2.9%    4.8    2471    1688    195    5215    0.4739    1076
    NO8DO Mango    Mango    0    0.5%    5.3    81658    3314    3165    82276    0.9924    15497
    NO8DO Mango    Mango    1    0.6%    5.4    81956    3336    3155    82566    0.9926    15219
    NO8DO Mango    Mango    2    0.5%    5.3    82090    3332    3173    82711    0.9924    15495
    NO8DO Mango    Mango    3    0.5%    5.5    84218    3416    3259    84858    0.9924    15559
    NO8DO Mango    Mango    4    0.5%    5.4    84208    3406    3259    84858    0.9923    15811
    NO8DO Mango    Mango    5    1.4%    5.4    84329    3416    3236    84974    0.9924    15663
    NO8DO Mango    Mango    6    1.4%    5.4    84329    3416    3236    84974    0.9924    15663
    NO8DO Mango    Mango    7    1.4%    5.4    84329    3416    3236    84974    0.9924    15663
    Miami Oranges    Orange    0    1.0%    5.4    409042    35046    35360    931265    0.4392    172581
    Miami Oranges    Orange    1    1.0%    5.4    404768    34529    35090    917340    0.4412    170919
    Miami Oranges    Orange    2    1.0%    5.4    408225    34826    35261    925173    0.4412    170535
    Miami Oranges    Orange    3    1.2%    5.4    420484    35843    36283    953024    0.4412    177568
    Miami Oranges    Orange    4    1.1%    5.3    420480    35839    36253    953024    0.4412    178533
    Miami Oranges    Orange    5    0.8%    7.0    418796    35912    36152    948672    0.4414    135124
    Miami Oranges    Orange    6    0.8%    7.0    418796    35912    36152    948672    0.4414    135124
    Miami Oranges    Orange    7    0.8%    7.0    418796    35912    36152    948672    0.4414    135124
Sheet4
    Sum of Run time (%)    Column Labels
    Row Labels    0    1    2    3    4    5    6    7    Grand Total
    Swiss Fill 2    0.7823    0.7755    0.7078    0.4854    0.4851    0.4837    0.4837    0.4837    4.6872
    Grand Total    0.7823    0.7755    0.7078    0.4854    0.4851    0.4837    0.4837    0.4837    4.6872
Bottling line
    Bottling line    Round    Run 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    0    62.6    12.1    11    3.9    9.4    78.2%    15.1%    13.6%    4.9%    11.7%    8435    78.7%    0.0    0.0%
    Swiss Fill 2    1    62.0    13.6    11    3.4    9.7    77.6%    17.0%    13.5%    4.2%    12.2%    10083    73.9%    0.0    0.0%
    Swiss Fill 2    2    56.6    10.5    10    6.7    3.6    70.8%    13.2%    12.3%    8.4%    4.5%    10804    80.1%    0.0    0.0%
    Swiss Fill 2    3    58.3    10.7    3    48.3    0.0    48.5%    8.9%    2.4%    40.3%    0.0%    11687    92.5%    0.0    0.0%
    Swiss Fill 2    4    58.2    10.7    3    48.3    0.0    48.5%    8.9%    2.4%    40.3%    0.0%    11694    91.7%    0.0    0.0%
    Swiss Fill 2    5    58.1    9.8    4    47.9    0.0    48.4%    8.2%    3.6%    39.9%    0.0%    10225    92.4%    0.0    0.0%
    Swiss Fill 2    6    58.1    9.8    4    47.9    0.0    48.4%    8.2%    3.6%    39.9%    0.0%    10225    92.4%    0.0    0.0%
    Swiss Fill 2    7    58.1    9.8    4    47.9    0.0    48.4%    8.2%    3.6%    39.9%    0.0%    10225    92.4%    0.0    0.0%
Mixers
    Mixer    Round    Cleaning time (%)    Average lot size
    MegaChurn 20    5    29.5%    17436
    MegaChurn 20    6    29.5%    17436
    MegaChurn 20    7    29.5%    17436
    Fruitmix MQ    0    14.5%    11022
    Fruitmix MQ    1    16.6%    10893
    Fruitmix MQ    2    16.6%    10893
    Fruitmix MQ    3    16.4%    10916
    Fruitmix MQ    4    16.4%    10915
Sheet2
    Row Labels    Sum of Gross margin per week
    Dominick's    97396.3865
    0    12088.533
    1    11348.8687
    2    12561.8666
    3    12188.2959
    4    12141.8639
    5    12355.6528
    6    12355.6528
    7    12355.6528
    Food & Groceries    171603.6626
    0    18510.1972
    1    14315.1488
    2    22264.5657
    3    23071.4927
    4    23012.2734
    5    23476.6616
    6    23476.6616
    7    23476.6616
    LAND Market    87932.4092
    0    10083.6278
    1    9250.1017
    2    11135.7516
    3    11409.679
    4    11392.2655
    5    11553.6612
    6    11553.6612
    7    11553.6612
    Grand Total    356932.4583
Customer
    Customer    Round    Attained contract index    Service level (pieces)    Service level (order lines)    Service level (orders)    Revenue per week    Gross margin per week    Shipments per week    Order lines per week    Pallets per week    Days in warehouse    Attained shelf life (%)    OSA    Carbon footprint    Distribution costs
    Food & Groceries    0    0.904    94.8%    91.2%    85.5%    44745    18510    7.7    7.0    168.7    14.7    85.9%    91.2%    1.16    94368
    Food & Groceries    1    0.820    94.2%    89.5%    82.6%    40581    14315    7.7    7.0    168.7    14.5    86.3%    90.6%    1.17    94368
    Food & Groceries    2    0.965    96.5%    92.9%    88.1%    47785    22265    7.7    7.0    168.7    14.9    85.8%    92.1%    1.17    94368
    Food & Groceries    3    1.022    98.2%    97.4%    95.6%    50570    23071    7.7    7.0    168.7    15.0    85.3%    93.6%    1.21    94368
    Food & Groceries    4    1.020    98.1%    97.2%    95.3%    50503    23012    7.7    7.0    168.7    15.0    85.4%    93.6%    1.20    94368
    Food & Groceries    5    1.023    98.5%    97.6%    95.9%    50652    23477    7.7    7.0    168.7    15.1    85.0%    93.6%    1.19    94368
    Food & Groceries    6    1.023    98.5%    97.6%    95.9%    50652    23477    7.7    7.0    168.7    15.1    85.0%    93.6%    1.19    94368
    Food & Groceries    7    1.023    98.5%    97.6%    95.9%    50652    23477    7.7    7.0    168.7    15.1    85.0%    93.6%    1.19    94368
    LAND Market    0    0.926    94.4%    92.1%    86.9%    23452    10084    5.2    6.9    88.6    15.1    85.3%    90.7%    1.11    52623
    LAND Market    1    0.894    93.9%    90.5%    84.4%    22624    9250    5.2    6.9    88.6    14.9    85.6%    90.1%    1.13    52623
    LAND Market    2    0.953    96.8%    93.9%    89.8%    24113    11136    5.2    6.9    88.6    15.3    85.3%    91.6%    1.13    52623
    LAND Market    3    1.005    98.5%    97.8%    96.2%    25441    11410    5.1    6.8    87.0    13.1    86.9%    92.6%    1.16    51715
    LAND Market    4    1.004    98.3%    97.6%    96.0%    25418    11392    5.1    6.8    87.0    13.2    86.9%    92.6%    1.16    51715
    LAND Market    5    1.004    98.4%    97.6%    95.9%    25406    11554    5.1    6.8    87.0    13.3    87.0%    92.7%    1.14    51715
    LAND Market    6    1.004    98.4%    97.6%    95.9%    25406    11554    5.1    6.8    87.0    13.3    87.0%    92.7%    1.14    51715
    LAND Market    7    1.004    98.4%    97.6%    95.9%    25406    11554    5.1    6.8    87.0    13.3    87.0%    92.7%    1.14    51715
    Dominick's    0    1.001    96.7%    93.2%    91.2%    26452    12089    4.1    3.9    77.2    14.3    86.6%    97.0%    1.56    45124
    Dominick's    1    0.977    95.9%    91.5%    88.9%    25812    11349    4.1    3.9    77.2    14.4    86.5%    96.3%    1.59    45124
    Dominick's    2    1.013    97.7%    94.4%    92.6%    26749    12562    4.1    3.9    77.2    14.8    86.3%    97.0%    1.59    45124
    Dominick's    3    1.025    99.0%    98.2%    97.7%    27090    12188    4.1    3.9    77.2    14.9    85.6%    98.5%    1.61    45124
    Dominick's    4    1.024    98.8%    97.9%    97.2%    27050    12142    4.1    3.9    77.2    14.9    85.6%    98.4%    1.61    45124
    Dominick's    5    1.029    99.7%    99.1%    98.8%    27189    12356    4.1    3.9    77.2    15.2    85.0%    98.5%    1.58    45124
    Dominick's    6    1.029    99.7%    99.1%    98.8%    27189    12356    4.1    3.9    77.2    15.2    85.0%    98.5%    1.58    45124
    Dominick's    7    1.029    99.7%    99.1%    98.8%    27189    12356    4.1    3.9    77.2    15.2    85.0%    98.5%    1.58    45124
Customer - Product
    Customer     Product    Round    Demand per week (units)    Demand per week (value)    Sales price    Gross margin per week    Gross margin per piece    Attained shelf life (%)    Service level (pieces)    Service level (order lines)    Additional sales as a result of promotions (%)    OSA    Carbon footprint    Additional sales next round as a result of webshop service level
    Food & Groceries    Fressie Orange 1 liter    0    42637    17344    0.41    7455    0.1748    85.3%    93.8%    91.9%    3.3%    87.1%    1.04    0.0%
    Food & Groceries    Fressie Orange 1 liter    1    42637    15730    0.37    5923    0.1389    85.8%    93.7%    92.5%    3.3%    87.6%    1.02    0.0%
    Food & Groceries    Fressie Orange 1 liter    2    42637    18523    0.43    9042    0.2121    85.5%    98.0%    97.5%    3.3%    90.0%    1.02    0.0%
    Food & Groceries    Fressie Orange 1 liter    3    42637    19602    0.46    9260    0.2172    85.5%    99.1%    99.0%    3.3%    90.0%    1.08    0.0%
    Food & Groceries    Fressie Orange 1 liter    4    42637    19576    0.46    9245    0.2168    85.5%    98.8%    98.7%    3.3%    90.0%    1.08    0.0%
    Food & Groceries    Fressie Orange 1 liter    5    42637    19634    0.46    9466    0.2220    85.5%    98.9%    98.5%    3.3%    90.0%    1.06    0.0%
    Food & Groceries    Fressie Orange 1 liter    6    42637    19634    0.46    9466    0.2220    85.5%    98.9%    98.5%    3.3%    90.0%    1.06    0.0%
    Food & Groceries    Fressie Orange 1 liter    7    42637    19634    0.46    9466    0.2220    85.5%    98.9%    98.5%    3.3%    90.0%    1.06    0.0%
    Food & Groceries    Fressie Orange/C-power 1 liter    0    7182    3571    0.50    1712    0.2384    87.7%    83.9%    78.7%    3.7%    80.8%    1.20    0.0%
    Food & Groceries    Fressie Orange/C-power 1 liter    1    7182    3238    0.45    1308    0.1822    88.7%    75.4%    69.9%    3.7%    71.7%    1.50    0.0%
    Food & Groceries    Fressie Orange/C-power 1 liter    2    7182    3813    0.53    1969    0.2741    88.5%    82.3%    77.3%    3.7%    79.3%    1.50    0.0%
    Food & Groceries    Fressie Orange/C-power 1 liter    3    7182    4035    0.56    2011    0.2800    87.6%    96.1%    94.8%    3.7%    97.3%    1.30    0.0%
    Food & Groceries    Fressie Orange/C-power 1 liter    4    7182    4030    0.56    2007    0.2795    87.7%    96.2%    94.6%    3.7%    97.1%    1.29    0.0%
    Food & Groceries    Fressie Orange/C-power 1 liter    5    7182    4042    0.56    2056    0.2863    86.6%    96.5%    94.8%    3.7%    97.3%    1.26    0.0%
    Food & Groceries    Fressie Orange/C-power 1 liter    6    7182    4042    0.56    2056    0.2863    86.6%    96.5%    94.8%    3.7%    97.3%    1.26    0.0%
    Food & Groceries    Fressie Orange/C-power 1 liter    7    7182    4042    0.56    2056    0.2863    86.6%    96.5%    94.8%    3.7%    97.3%    1.26    0.0%
    Food &...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here