Business Analytics

profileKhush Oberoi
updated.xlsx
Home>Business & Finance homework help>Business Analytics

Sheet1

Student number First name Surname [i.] [ii.] [iii.] [iv.] [v.] [vi.] [vii.] [viii.] [ix.] [x.] [xi.] [xii.] [xiii.]
(thousand Euro) (thousand Euro) (thousand Euro) (thousand Euro) (thousand Euro) (thousand Euro) (thousand Euro)
s19006440 Mehmet Hiram Abas -11.30 8.87 124.85 87.20 40.20 61.59 0.76 0.23 23.70 0.19 0.35 0.46 weak demand
s20006880 Shakir Afridi -14.74 8.38 60.35 98.61 58.57 28.96 0.28 0.34 5.38 0.04 0.25 0.71 strong demand
s19006667 Yash Aggarwal -24.89 12.25 70.81 52.48 24.89 66.82 0.12 0.04 14.66 0.02 0.30 0.68 strong demand
s19004814 Ghaith Maher S Alnahdi -27.86 10.99 131.58 44.88 39.87 59.66 0.54 0.40 17.62 0.11 0.18 0.71 medium demand
s18006477 Mohamed Yusuf Al Sadiq -28.61 11.02 86.18 49.26 49.16 62.75 0.42 0.24 15.76 0.02 0.44 0.53 weak demand
s18003315 Arthur Andersson -28.54 7.10 76.87 86.15 59.28 41.24 0.81 0.06 15.85 0.16 0.36 0.48 medium demand
s20005179 Aaveg Bagdi -17.50 8.82 57.17 60.38 28.69 60.53 0.72 0.23 5.24 0.03 0.43 0.54 medium demand
s18003050 Lidia Barkhanoeva -16.36 13.99 126.77 47.29 20.28 30.32 0.23 0.49 15.18 0.09 0.25 0.66 strong demand
s19004550 Bibiane Frederika Whilemina Ma Beerens -15.88 13.73 87.45 70.57 52.94 67.45 0.12 0.03 21.21 0.04 0.35 0.61 strong demand
s18002952 Paoloenrico Bianchi -18.00 14.32 65.76 60.29 37.11 24.40 0.03 0.50 3.97 0.23 0.38 0.39 medium demand
s17005332 Karl Bork -26.87 13.90 58.74 75.12 22.36 31.61 0.56 0.05 13.42 0.06 0.20 0.74 medium demand
s19004217 Prateek Chotrani -11.78 12.76 111.58 90.87 49.36 29.04 0.44 0.46 23.01 0.12 0.18 0.71 medium demand
s19000854 Andrew Dadlani -17.37 13.10 130.56 73.29 22.43 26.58 0.20 0.02 24.88 0.05 0.36 0.59 strong demand
s19006295 Manuela Larissa Diago Garcia -13.74 13.32 56.01 51.35 22.51 49.50 0.28 0.06 7.99 0.13 0.23 0.63 strong demand
s18005601 Axel Ehrnrooth -15.19 10.99 115.56 79.36 47.80 64.00 0.43 0.24 12.54 0.02 0.12 0.86 weak demand
s19003830 Emaan Faisal -27.30 8.39 59.26 81.99 22.53 34.51 0.27 0.30 26.12 0.04 0.28 0.68 weak demand
s19004492 Vedant Anil Farande -23.13 9.16 119.97 69.21 29.66 38.29 0.15 0.25 23.01 0.03 0.38 0.59 weak demand
s18000143 Carl Fehrling -29.23 5.63 69.52 97.84 48.78 63.09 0.71 0.09 23.04 0.18 0.31 0.51 weak demand
s19003523 Ki Fung -21.98 13.78 135.73 65.91 24.64 66.86 0.62 0.22 23.29 0.02 0.19 0.78 weak demand
s17001507 Daria Jakubowska Claramunt -18.86 9.46 71.15 101.40 59.15 58.11 0.60 0.24 3.96 0.03 0.13 0.84 weak demand
s19003855 Bengt Jonsson -18.19 14.47 50.72 50.40 28.91 24.64 0.06 0.03 19.34 0.27 0.30 0.44 medium demand
s19002991 Jonathan Khazaal -18.25 12.04 128.13 57.19 49.92 24.18 0.04 0.02 12.86 0.01 0.49 0.50 strong demand
s17002026 Yuvraj Kukreja -12.30 7.03 77.18 81.26 43.70 22.98 0.02 0.02 7.52 0.11 0.22 0.67 weak demand
s18002708 Bence Kun -23.71 6.07 101.98 52.97 37.88 28.22 0.25 0.09 6.50 0.08 0.33 0.59 medium demand
s18000334 Adnane Lahlou Mimi -18.43 10.59 84.02 38.13 32.03 55.60 0.24 0.17 12.70 0.16 0.22 0.62 medium demand
s18000548 Adrian Lindqvist -16.44 8.58 57.97 55.48 22.17 56.18 0.10 0.03 12.91 0.03 0.24 0.73 strong demand
s19000617 Yuchen Liu -24.00 7.29 84.08 51.17 51.96 56.74 0.08 0.42 20.22 0.04 0.39 0.58 weak demand
s19003472 Amina Mammadzada -18.13 14.45 128.08 83.82 46.15 27.15 0.38 0.17 5.19 0.27 0.30 0.43 medium demand
s18006913 Maximilien Moeremans D'Emaus -14.13 14.33 104.24 35.31 28.19 24.32 0.12 0.04 16.90 0.09 0.35 0.56 weak demand
s19001484 Teresa Nava -18.92 13.47 118.76 44.00 43.74 24.90 0.44 0.14 26.04 0.15 0.20 0.65 strong demand
s19006625 Khush Oberoi -10.78 12.05 89.48 97.55 50.63 54.05 0.30 0.35 14.24 0.01 0.12 0.87 weak demand
s20001029 Sethanan Osatis -22.31 6.31 142.16 88.93 53.41 42.60 0.61 0.09 7.88 0.19 0.22 0.59 strong demand
s19004347 Amanvir Patel -26.36 10.87 120.21 94.80 54.85 55.60 0.03 0.17 5.85 0.09 0.22 0.69 strong demand
s18004908 Karsang Paturel -12.57 9.57 73.17 49.63 31.58 52.69 0.13 0.24 17.75 0.11 0.27 0.62 medium demand
s17004605 Nansi Petrova -22.25 14.95 132.84 60.59 59.59 55.03 0.06 0.04 6.15 0.21 0.35 0.44 weak demand
s20006025 Esha Pilinja -25.65 11.46 147.04 45.21 59.66 57.38 0.07 0.02 20.45 0.21 0.24 0.55 weak demand
s19002989 Juan Jose Salazar Puig -15.75 11.03 141.53 64.16 38.73 48.09 0.57 0.08 4.72 0.25 0.37 0.37 strong demand
s18006638 Nicola Scaramuzzo -25.35 8.72 111.22 94.44 39.54 35.68 0.30 0.02 18.46 0.03 0.04 0.93 medium demand
s00908268 Samuel Sinclair -19.96 14.22 54.83 90.73 33.89 23.49 0.22 0.07 26.77 0.04 0.40 0.57 weak demand
s19007079 Anurag Singhi -24.83 7.79 141.40 89.93 48.56 26.92 0.09 0.09 6.30 0.07 0.08 0.85 weak demand
s19000865 Marius Slinning -18.42 14.55 55.38 45.39 27.58 34.80 0.06 0.07 4.51 0.30 0.31 0.39 strong demand
s17001105 Tim Soliman -24.23 5.70 57.15 81.29 40.97 57.52 0.22 0.02 13.37 0.05 0.22 0.73 weak demand
s19005587 Nishanth Srinivas -17.88 11.04 69.80 97.14 59.85 28.25 0.84 0.08 4.00 0.07 0.46 0.47 medium demand
s18007190 Shubham Tantia -17.71 14.14 68.28 58.91 34.49 46.88 0.46 0.32 23.78 0.03 0.19 0.79 medium demand
s19001451 Gabriele Valente -29.29 10.37 63.97 35.32 55.50 56.24 0.31 0.36 22.28 0.06 0.19 0.75 strong demand

&"Helvetica Neue,Regular"&12&K000000&P

Khush Data

s19006625 Khush Oberoi thousand Euro Comment
1 -10.78 Demand for the finished product is low and Russo manufactures the parts.
2 12.05 Russo purchases the component part, hence no production cost and demand of the finished product is low.
3 89.48 when demand for the finished product is high and Russo opts to manufactures
4 97.55 Demand is high and Russo purchases the part
5 50.63 Demand for the finished product is at medium level and Russo manufactures the component part.
6 54.05 Russo purchases parts under medium level.
7 0.30 Probability of weak demand
8 0.35 Probability of strong demand
9 14.24 The cost of the research
10 0.01
11 0.12
12 0.87
13 weak demand

Minimax regreat Approach

MINIMAX REGREAT APPROACH
DEMAND
SUPPLY HIGH MEDIUM LOW
MANUFACTURE 89.477 50.633 -10.780
PURCHASE 97.547 54.052 12.05
PROBABILITY - - -
REGREAT TABLE
DEMAND
SUPPLY HIGH MEDIUM LOW
MANUFACTURE 8.070 3.418 22.834
PURCHASE 0.000 0.000 0.00
Maximum Regreat 8.070 3.418 22.834

Payoff Table

DEMAND
SUPPLY HIGH MEDIUM LOW
MANUFACTURE 89.477 50.633 -10.780
PURCHASE 97.547 54.052 12.05
PROBABILITY - - -

Sensitivity Anaysis

DEMAND
SUPPLY HIGH MEDIUM LOW
MANUFACTURE 89.477 50.633 -10.780
PURCHASE 97.547 54.052 12.05
PROBABILITY 0.1 0.1 0.1
0.1 0.1
0
Scenario-Manufacture High Medium Low
Weak demand 89.477 50.633 -10.780
0.1 89.4765471956 50.633313687 -10.7796139387
Scenario-Purchase High Medium Low
Weak demand 97.547 54.052 12.055
0.1 97.5468307129 54.0516921618 12.0545329082