Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

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 »
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 ta
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% XXXXXXXXXXOrange/Mango 1 liter, Fressie Orange
Mn ol XXXXXXXXXX000K PET and Fressie Orange/Mango PET
07757 have a high obsoletes percentage.
o 7 i Service level outbound orde
20 — 800k lines
o 8 Round: -2 “ XXXXXXXXXXRound: XXXXXXXXXX
LITE ET . a
A lower service level than agreed to is
eing provided to Food & Groceries.
= i Obsolete products (%) i Service level outbound order lines
Finance
30 150
XXXXXXXXXX% 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 ta
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% XXXXXXXXXXOrange/Mango 1 liter, Fressie Orange
Mn ol XXXXXXXXXX000K PET and Fressie Orange/Mango PET
07757 have a high obsoletes percentage.
o 7 i Service level outbound orde
20 — 800k lines
o 8 Round: -2 “ XXXXXXXXXXRound: XXXXXXXXXX
LITE ET . a
A lower service level than agreed to is
eing 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
    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
Supplie
    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
Custome
    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    Ca
on 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    Ca
on 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
assignment-brief-9-1arljoi4.docx screenshot-806-yg5o2gef.png screenshot-810-2r2dml3u.png screenshot-792-xcnts2qg.png tfcdata-jwkixr5o-5dzrwmi3.xlsx
Answered Same Day May 11, 2023

Solution

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    11553.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
Supplie
    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
Custome
    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    Ca
on 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    Ca
on 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
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Attach File