McKinsey Problem Solving Game (PSG): Ecosystem Game & Redrock Study | COMPLETE “SOLVE” WALKTHROUGH

Hi, I want to know where can I find de excel template? Thanks a lot!

Hey Jörg, thanks so much for this video. It seems that I successfully passed the PSG since I am invited into the next round of interviews at McKinsey :)
Your video helped me a lot in preparing for the game. Funny (or maybe not so funny story for me): I had to take the test twice since they did not receive the results of my first test. Only god knows why ;)

Just finished the game!
I noticed a couple of inconsistencies:
1. In the tutorial, they only let you see the first producer.
2. There are only two feathers available, not four. It seems like there should be two lines for location characteristics, but there's only one line with two options: depth and temperature.

I only had two minutes left, so I focused on delivering the ecosystem. However, I checked back later and realized I placed one wrong animal, that made the whole ecosystem not sustainable. Do you think I can still get an interview?

I dived deep

Cant animal 2 eat from animals 1 AND 3? as both provide 3,300 calories

Passed the test , Thank you so much for the efforts !

Hi, where can I get the microsoft solver sheet for the ecosystem game? Or at least does anyone know how to make the sheet?

where can I get the free excel solver from?

i dived deep ;)

Hey guys I just took the psg yesterday. I think I did well. I came out with these tips; the ecosystem game as greatly explained in the video is quite simple, there's only 3 possible combinations of 3 producers. I started with the one that produced most calories. However I eliminated it because one of the algae wasn't eaten by Any fish. I went to the 2nd highest cal but I eliminated too because the fish only produced about 1/5 of what they needed. So lastly I was left with the producers that produced the least cal but whose animals produced 1/2 or more than what they needed. From then on it was much easier and I finished with 5 min to go.
For the analysis the math was super simple, I mean brush up on percentages and learn how to add/subtract percentages, besides you get a calculator. I took a little too long analyzing the red rock study and before I realized I had 7 min left for the whole thing, so I may have botched the graph. However since they give a calculator I easily cruised through the case questions even though they recommend 18 min for it, 7 min was enough, for anyone that passed middle school and given a calculator that was more than enough time. I'd review what the mean median and mode are and that's it. I had Gemini next to me just in case, I only used it because I wasn't sure what the mode was.

I dived deep!

This was really helpful. I managed to create a sustainable food chain but only had less than a minute left to get the location. I only picked the location based on the elevation and temperature range. Not sure whether the location was conducive for the rest of the parameters as I had to submit before the time elapsed. Do you think this could lead to failure in the ecosystem?

hi is the excel template available?

hey, can you share the eco system excel solver sheet? and can we open it on the same laptop as we are taking the assessment on?

I dived deep

I dived deep

hi i tried to suscribe to your newsletter but i couldn’t receive the email

I dived deep

I dived deep

I dived deeper

Please how can I get the excel solver

Thanks a Ton!! This video helps me in my prep. I dived Deep 🙂

Do you have the link to the Excel Solver file?

Does anyone know where can get the solver? @YOUinConsulting

How can i get my hand on the excel solver template for the ecosystem game?

Hey
Is this video still useful in August 2024 or has some changes been made?

I dived deep 😊

I dived deep

I gave test today and it consisted of mountain and redrock game. Literally your video helped a lot.
Thanks a lot

just took my own test and dam the time was too short i wasent able to create the ecosystem completely although i was able to filter the bundle that was my best chance. as for the red rock study, time flied like a breeze, i could not even finish the caculations in the study. That sums up my experience . Dont know whether i will pass but over all the video helps you to have an idea of what to expect, the realtify of doing it is a different thing entirely espically witht the timer seriously against you at every sec.

I dived deep

Is the test proctored?

Where do you get the excell solver?

Hi guys, just a consideration about the Ecosystem game. You basically have 3 ecosystems, each with:

-3 producers

-10 animals.

For each ecosystem you have to use all 3 producers and 5 out 10 animals in such a way that the all thing is balanced.

The hard thing is that one ecosystem could have 0 successfull combinations of producers and animals, so you can lose a lot of time trying to find a combination that doesn't exist.

I've developed a code that tries all the 252 combinations (756 if you count the three ecosystems) and gives you the one that is balanced. After that you just have to find the right spot to place it (temperature, height/depth etc.) and the job is done!

If you're interested contact me!

Good luck to all of you!

Very useful and helpful video. Thankyou for sharing

please is the excel solver provided

It was helpful and I completed my PSG yesterday... Even after crosschecking the ecosystem thrice on paper, I was able to finish the ecosystem game in flat 20 minutes.. Followed the set with highest calories producers and luckily had other animals in the set which were not that problematic. As for redrock, questions might not be that tough, but the pressure of time restricts you to think freely and you end up finishing in the last moments.. I would recommend brushing up on basic percentage and fractions along with basis statistics and you should be good to nail redrock...

I wonder if it is no problem to use only the Excel (on the same computer that I'm testing with) for calculation and not leave any logs in the on-screen calculator given.
Anyone with the same experience and passed without problem?

Thank you so much for the video. It really helped me! However, I did not have time to review it and dont know if I got it correctly. Are there cases of people who didnt finish or did not passed it and still moved for the next stage of the selection process?

One question please: but the 4 monitors to be selected changes randomly ? I see another prep video where instead of oxygen monitors there was the water current range....

Hey! This video is super helpful. I have a question regarding the excel solver though - is this something that McKinsey provides during the game or do we have to separately create our own excel sheet? If it is the latter, how do you create the solve button option?

Thank you so much for the helpful content!

your accent omg 😆

i dived deep!
thanks for the amazing vid

I watched this video, i did it manually and I passed

can someone help me with ms excel solver part?

How did you get the Excel template? Thanks for the great video.