MECC Meal Plan

Here is a comprehensive walkthrough guide list for the MECC Meal Plan provided by Excel MVP Giles Male, one of our faculty fellows, Diarmuid Early, as well as one of the MECC students Julian Poeltl, the case is available in your ExPrep account. Try it yourself, and if you get stuck, look for the solution in the videos.

TASK – MEAL PLAN REVIEW

You were searching through the University of Arizona archives and stumbled across meal plan information for some of the University’s most famous alums. Instead of selling this information to the tabloids, you decided to sort, review, and analyze what you found. (Good choice!) The information you found has been summarized onto two tabs, “Food Prices” and “Food Data.” The “Food Prices” tab contains the cost for 50 food items for each of the University’s four districts (Historic, Global, Highland, North). The “Food Data” tab contains 1,000 food orders. Each order contains the student who ordered, the food they ordered, the district where the order occurred, and the quantity they ordered. Get to work on your analyses and hopefully you don’t regret your choice to not sell this information to the tabloids!

WALKTHROUGH VIDEO PROVIDED BY GILES MALE

Step-by-step walkthrough to solve the case, as well as a showcase of using Excel Robot

WALKTHROUGH VIDEO PROVIDED BY DIARMUID EARLY

Video is divided in parts so you can easily skip to the part that you are stuck on to find out best solution.

WALKTHROUGH VIDEO PROVIDED BY JULIAN POELTL

In this video, he does a run through of the Meal Plan Review case (mainly lookup). Video is divided in parts so you can easily skip to the part that you are stuck on to find out best solution.

MECC Meal Plan

Keep In Touch