game over

Dear students,

this session is now closed. Thank you to those who worked seriously and were really involved in this module. For the other one, don't be surprise by the final mark.

you have the key points of the module in this file:
https://www.dropbox.com/s/8bhaltg39fv4099/debriefs%20for%20challenges%20-%20english.pptx?dl=0

and the final ranks on this one, with a lot of comments for each team:
https://www.dropbox.com/s/sxovb7ek068zu8m/%21online%20business%20game%202020%20-%20assessment%20-%20students.xlsx?dl=0
regards,

Anne Queffelec

shareholders letter : 08 april

dear students,

some explanations concerning the shareholeders letter (based on figures of year 6, and evolution between year 5 and year 5, not before).

A shareholder letter is a document written by a firm's top executives to its shareholders to provide a broad overview of the firm's operations throughout the year
The exercise generally covers:

• the firm's basic financial results
• its current position in the market
•  and some of its plans / forecasts

It can also mention specific events that have happened throughout the year, changes in the company's stock price, or reiterate aspects of its vision

good luck, last challenge :-)

best regards,

anne queffelec

results decision 5

The results for decision 5, the penultimate year because I would like to propose you one more decision, to allow team 3 & team 4 to make profit before the end of the game 😊

Good performance for team 2 & team 6, at the beginning the same one, and now they compete 😊

Team 4, If you look at the right numbers and look at the question properly, I think you will admit that you didn't take the right decisions.

Some indicators which are essentials:

• Prices (and evolution year after year)
• Ad budget (and evolution year after year)

Calculate average prices for each channels, average ad budget, and compare to yours.

You are in marketing management, you are suppose to identify trends, and sometimes trends into trends ! and compare your situation, your decisions to the other one. Try to understand the business models of the leaders of the game (team 6 and team 2) ; why they performed ? with which levels ?

Try to ask yourself the right questions 😊

So, decision 6 (the last one !) for the 31/03, and shareholders letter for the 08/04 ; are you OK with this schedule ?

you can update your results for year 5.

good luck !

anne queffelec

reporting : infographics & leaflets

the ranks are available in the dropbox file.

Infographic : exept team 6, I think you didn't take the time to read the instructions for the target of this infographic : it was shareholders.

the instructions : "For the infographic, the objective is to describe by a picture (=a graphic) the situation of your resort. It's financial communication to your shareholders, based on figures of period 3"

For most of the teams, not even 1 figure !! You were suppose to communicate financial informations, not the number of rooms or the color of the walls...

• net result
• turnover
• RevPar
• occupancy rate
• market share
• cash flow
• dividend policy
• etc....

leaflet : the target, the retailers, not the final customer.
"You rent a stand on the Tourism Exhibition Show in Athena, in order to meet new BtoB customers (Tour Operators and OTA). "

some arguments :

• Allotments 
• Prices
• Terms of payment
• Communication budget
• Customers’s satisfaction (example comments on tripadvisor)
• Employees’s skills (example multilinguals animators)
• Training for employees 
• Infrastructures (ex spa)
• Projects 
• Arguments concerning the destination
• Partnership with avec receptives (quality charter for activities as diving)
• Interface of information system
• Special contact person

and key words : Partnership, Trust, Sales , Values , Customer’s satisfaction

do you understand why most of youy missed the exercise ?

try to read the instructions, especially for next challenges.

Regards,

anne queffelec

delay for exceptionnal cirumstances

Dear students,

During the very special period, I propose you a new delay for the individual work. You can send it to me for the 03/24 (instead of 03/22).

please don't forget to rename your file :-)

good luck everyone

Anne Queffelec

next mission

Dear students,

I ask you for 3 tasks:

1/ individual work: in 1 page maximum, explain me and justify (based on results from year 1 to year 4):

• 2 good decisions you've made (year 1 to year 4)
• 2 mistakes you made (idem)
• The 2 axes to focus on for this 5th and final decision (in your opinion, not obviously the opinion of the whole team)

Please send me an email for the 03/22 (next sunday - each of you, not only the manager !) with your individual work and specify your name in the document (title of the file : name-synthesis.doc) and in the subject of the email (excelia - individual work)

2/ decision 5, the last one ! everything could change in this decision, because team 2, team 5 and team 6, you're very closed. Don't forget that I take in account (for the rank on financial performance) only the 3 last decisions (so year 3, 4 and 5).

3/ The blog: What is a blog ? It' s "an online journal or informational website displaying information in the reverse chronological order, with latest posts appearing first. It is a platform where a writer or even a group of writers share their views on an individual subject".

a kind of guide with the mains questions before creating a blog (example for food, a very popular subject) : https://firstsiteguide.com/food-blog/

Please, send me the URL link, with the decision 5. You need to write at least 4 posts on your blog, with various subjects.

https://firstsiteguide.com/food-blog/?fbclid=IwAR1GubVz9Q6O9YTwm9FnzXZvNgoLmew_3t7YNFkfvdbY-mVDaA28KgK7EI0 

We change the schedule :

•  individual work for the 03/22
• decision 5 + blog for the 03/25 (instead of 03/20)
• shareholders letters for the 03/31 (instead of 03/27 ; more informations for this later at the end of the week

Good luck !

Anne Queffelec

D4, results :-)

Dear students,

the results for decision 4 :

congratulation team 6, you're the leader for this year :-)

godd job for teams 5 and 2. For the other, I put some comments on the file "$$online business game 2020 - assessment"

Anne Queffelec

Next mission : infographic

:Dear students,

For the infographic, the objective is to describe by a picture (=a graphic) the situation of your resort. It's financial communication to your shareholders, based on figures of period 3. You can creat nice infographics on the website www.easel.ly . An  example :

I'm waiting for the infographic for next thursday and for decision 4 on saturday (12.00 am please)

good luck :-).

results D3

dear students,

the results for decision 3 :

congrats Team 2, you are the leader (for the moment... ) :-)

I sent the file to each manager, because I have a problem with DropBox, so it's not possible to download the results with the link.

decision 4 + infograhic for the 14/03. Good luck !

anne queffelec

Results decision 3

dear students,

results for decision 3 will arrived on tomorrrow evening (7.00 pm) ; too busy during the day :-)

regards

anne queffelec

for next thursday 05/03

Dear students,

for next Thurs day (05/03), I'm waiting for :

1. decision 3
2. financial dashboards (12 indicators at minimum)

infography will be required for the 14/03 (instead of 05/03). I will give you more informatiosn and the target for the infography on Thurday.

Comments and ranks for challenges (poster & marketing dashboards) are available on the document "online business game - assessment_2019"

best regards,

anne queffelec

dear students,

Each team can upload the results from the link in the previous results sheet.

I created a file with comments & ranks for challenges and comments for decisions. You can download it on :
https://www.dropbox.com/s/y1ilmwecf6xwnxx/%24%24online%20business%20game%202020%20-%20assessment.xlsx?dl=0

This file contains  comments to help each team to understand what's happened during this decision 2. You have to ask you questions about :

·                 the price policy of your competitors

·                     the communication policy of your competitors : did their budgets increase ? or decresease ? how much ?

·                     the human resources policy of your competitors : did they increase the staff ? what about the wages ?

·                     the market : did it increase ? in total and by segment (direct channel, OTA) ? in number of rooms sold AND in value

·                     keep an eye on the satisfaction of your customers. The % is the reflect of the comments on websites as Tripadvisors for example.

In order to understand what's hapenned, you must build some dashboards. Please look carefully to the videos I posted.

I sent to each manager a file with the structure of dashboards. You must be able to build each indicators.

I'm waiting for decision 3 for the 05/03. For this third decision you can invest (jacuzzi, furniture or sauna). But, before, you have to check your treasury, to be sure that you have the cash !

Your investment is avalaible for the period, you needn't to wait a period. You will get royalties, so you needn't hire employees for this investment or provid any training budget. 

Good luck,

Anne Queffelec

decision 2 - results

Dear students,

the results for decision 2 are available.

congratulation teams 2 & 6 :-)

You can follow this link to watch 2 videos :

1. 1 to download the results of year 2
2. 1 for building and/or update the dashboards

https://www.dropbox.com/sh/o5fxzgivjowltfm/AABe26AOhWCTnBrfiOARNfJUa?dl=0

I put some comments on the results and for the challenges (poster and leaflet) on tomorrow.

I'm waiting for decision 3 on next thurday. Please respect the deadlines. Team 4 & team 5, you send me your decision out of the delay, I didn't take it in account. Organize your team for the next one.

Best regards,

anne queffelec

Reminder : decision 2 for today, 1.00 pm

I remind you that you have to send me the decision 2 for today, 1.00 pm. If I haven't received it, i'll take the decision 1. No delay will be allowed :-)

Anne queffelec

importance of team work

Dear students,

I would like to reinforce the importance of working as a team in this module. It seems that, in some teams, some of you are not involved in the work.

So, I asked each team leader to specify in the email with the task (challenge or decision) those are really involved. 

I remind you that you will have an individual work in few days. If you have ever watched figures, decision sheet and/or results sheet, it will be impossible for you to understand the work to do.

Best regards,

anne queffelec

new deadline for decision 2

Dear student,

you can send me the decision 2 for the 28/02 (instead of 24/02) if you need a delay to build the dashboards and take the decision.

to make the dashboards, you can use the file "dashboards example", but you need to update with your own figures. For that :

• select column E of the file "team$$ results sheet" (I send it to you by email) from line 5 to line 432
• open the file "dashboards example"
• put your mouse on cell E5 and copy (only values, clic right with your mouse) on the column E of the file "dashboards example" 
• delete the figures on column F, G, H, etc...
• save this file as (name-dashboards.xls"

I will explain you later how to update it with figures of year 1, 2, 3, etc.

Then, to build your own dashboards, you used new sheet (1 for prices, 1 for communication, 1 for HR, etc.)


Concerning the leaflet (fort the 29/02):  You rent a stand on the Tourism Exhibition Show in Athena, in order to meet new BtoB customers (Tour Operators and OTA). To communicate with them, you have to create (ex on canva.com ) trade show brochures, for handing out.

3 key points :

1. Grab Your Reader’s Attention
2. Meet Your Reader’s Needs
3. Give Your Reader an Action to Take

Best regards,

anne queffelec

the link for comments

the link for some comments (finance & challenges) : https://www.dropbox.com/s/y1ilmwecf6xwnxx/%24%24online%20business%20game%202020%20-%20assessment.xlsx?dl=0

Results decision 1

Dear students,

the results for decision 1 :

Congratulations Team 1. Luck or strategy ;-) ?

I send to each manager the results sheet, with a .ppt file, with some ratios and KPI you should calculate. I join an Excel file with examples of dashboards. Read it carefully to understand the methodology

I created a file with comments & ranks for challenges and comments for decisions. You can download it on : https://www.dropbox.com/s/y1ilmwecf6xwnxx/%24%24online%20business%20game%202020%20-%20assessment.xlsx?dl=0

I'm waiting for decision 2 and marketing dashboards for the 24/02. For decision 2, keep the same decision sheet, complete column F and rename it "Team $$ - decision sheet- D2"

good luck

anne queffelec

results are coming soon...

I'm waiting for 1 figure from Team 3 until 12.00am, then you will have the results for this first year. Don't worry if you lost money, it's quite "normal" for the first year, with an average occupancy rate of 30%

I will send to the manager a file with the results (and a link to download the next results for next periods) and another link for some comments (on finance and on challenges).

I'm waiting for the marketing dashboard for 24/02, but maybe you can provide some dashboards on finance and human resources.

Regards

anne queffelec

very useful YouTube channel in finance : Investopedia

very useful videos on key concepts in finance and  for  definitions :
https://www.youtube.com/playlist?list=PLEAWiihj06OL80BfkpXVh2AQ-AYe04xiU

OK for D1 :-)

OK, perfect, all the teams were on time for D1 and the poster. Results and explanations in the evening

I send to the team leaders a file with the matrix of dashboards, in order to prepare decision 2 (for the 02/16). Managers, I suggest you to share this document with your partners, and share the tasks :

• 2 students on marketing dashboards
• 1 student on HR
• 2 students on finance

more informations in the evening

good luck, and don't forget :



anne queffelec

some informations

dear students,

some informations, to keep your projects on track :

• occupancy rate for the first year : between 20% and 30%
• part of the turn over in the marketing : between 5% and 10% --> it means that you have to forecast the turn over, maybe the net result
• check on booking.com the average price for a ** hotel in Gythio (less than 150 € !)
• training budget : check on Internet the acceptable values (between 0.5% and 5% of the total payroll)
• no investment for the moment (from year 3, not before) ; idem for dividends
• you're supoosed to fill in the forecasts

Teams 1, 2 and 4, you can change your decision sheet if you want to adjust.

Teams 3 & 5, I'm waiting for your work at 5.00 pm. If I haven't reveived it, you have a 0.

Best regards

anne queffelec

for tomorrow : decision 1 (column E) + poster for opening

Dear students,

I remind you that I'm waiting for the decision 1(=year 1=colum E of the decision sheet) for tomorrow, maximum 5.00 pm

Don't forget to specify :

1.  the number of the team in the name of decison sheet : : ex : Team 3-decision sheet-decision 1
2. ...  the number of the team + Excelia in the subject of the email

idem for the poster, name your file : team 3-poster.pdf

best regards,

anne queffelec

Evaluation finale du business game

Bonjour à tous,
voici les évaluations finale pour le module de business plan
https://www.dropbox.com/s/qr0kp78hr6urtxc/Evaluation%20BP%20ESC%202.xlsm?dl=0

J'ai mis les commentaires par équipe, certains groupes ont bien progressé.
Bon courage pour le business game.
Cordialement
MP

Team leaders, last call...

For the third time, I ask who are the team leaders ; I have no anwer from team 3 & team 5

Ok for teams 1, 2 and 4.

Anne Queffelec

Corrigé de A3

Bonjour,
voici le lien vers le corrigé de la dernière activité :
https://www.dropbox.com/s/wmqm4c6lkvsonej/Corrig%C3%A9%20A3%20V3.xlsm?dl=0

Je vous invite comme pour les corrigés précédents à retrouver les formules dans excel et à poser vos questions sur ce blog.

Je vous donne une évaluation de votre travail dans la semaine.
Ce business plan doit vous permettre de simuler les résultats de vos décisions pour le business game, il faut échanger entre vous sur les options stratégiques et les simuler sous excel.
Bon courage pour la suite.
Cordialement
MP

Evaluation de A2 en ligne

Bonjour,
j'ai mis en ligne les évaluation de A2,
https://www.dropbox.com/s/qr0kp78hr6urtxc/Evaluation%20BP%20ESC%202.xlsm?dl=0

Vous pouvez les charger.
Plusieurs erreurs récurrentes sur la masse salariales, j'ai donné le détail dans l'évaluation.
Attention au calcul des commissions des OTA.

L'objectif de cette partie était de calculer le résultat pour voir si le modèle économique était équilibré (ce que vous allez devoir faire pendant le jeu d'entreprise dès la semaine prochaine). Ce détail semble avoir échappé à toutes les équipes. Ne perdez pas de vue et les objectifs, cela vous aidera à vous y retrouver dans les calculs.

Bon courage pour la troisième activité.
Cordialement
MP

Team leaders ?

could you specify who is the team leader for each team ? for the moment, I have this information only for team 2.

some questions

Dear students,

some relevant questions from team 2 (please, next time, post on this blog, not by email) :

yes, you have to find a name, a logo and a slogan for your hotel.
the opening date is not important, choose it
best regards,

AQ

Online business game

Dear students,

Let's go for the online business game ! The shedule:

• 17-févr : Decision 1 + poster for opening
• 24-févr : D2+marketing dashboards
• 29-févr : leaflet TO 
• 5-mars : D3 + infography+ finance dashboards
• 14-mars : D4
• 20-mars : D5 + blog
• 27-mars : shareholders letter

all the information for the challenges will be on this blog. Use it for all your questions & requests.

You can use the business plan module to prepare the first decision. Team 5, even if you didn't take this course, you can play with us. Mathieu Paquerot will send you the final matrix of the business plan.

Please don’t forget to specify me in the object of your email:

• Excelia
• the number of your team
• The work (decision xx, marketing dashboards, etc.)

Good luck,

anne queffelec

Corrigé de A2

Bonjour,
le corrigé de A2 est en ligne
https://www.dropbox.com/sh/ptu3hhzh71ylhb5/AADJcyuePCT_YARwIryXQKAua?dl=0

Je vous donne un retour sur vos activités dans les prochains jours.

Cordialement
MP

Corrigé de A1 en ligne

Bonjour,
j'ai mis le corrigé de A1 en ligne.
Vous trouverez le corrigé en copiant ce lien dans votre navigateur, il suffit ensuite de charge le fichier excel.
https://www.dropbox.com/s/10ma1qxblwuw01i/Corrig%C3%A9%20A1.xlsm?dl=0


3 équipes sur 4 seulement ont rendu l'activité.

• Elles ont toutes fait la même erreur, en oubliant de multiplier par 365 le CA obtenu pour un jour. Le CA de 1000 euros pour l'année aurait dû vous alerter sur la cohérence de vos calculs.

En business plan, vous devez avoir des attentes par rapport aux différents calculs que vous réalisez sinon vous passez à côté de choses importantes. 

Les 3 équipes qui ont rendu ont obtenu un D pour cette activité (elles sont notées de A (très bien) à E (mauvais)).
Vous trouverez le fichier d'évaluation en chargeant ce lien :
https://www.dropbox.com/s/qr0kp78hr6urtxc/Evaluation%20BP%20ESC%202.xlsm?dl=0


Modifiez vos fichiers pour l'activité 2 et vérifiez que les résultats vous semblent cohérents.
Bon courage.
Cordialement
MP

Equipe 3

Bonjour,
je n'ai pas reçu le travail de l'équipe 3. Si je n'ai rien à 17H, cette équipe aura 0 comme première note d'activité.
Le corrigé sera mis en ligne avant 19H.
Cordialement
MP

Coquille à corriger

Bonjour,


merci de recharger l'énoncé une correction a été apportée concernant l'évolution des prix et des taux de remplissage ligne 21 et 22.
Cordialement
MP

Bonjour,

voici le lien vers le fichier pour les 3 activités à remettre
https://www.dropbox.com/sh/ptu3hhzh71ylhb5/AADJcyuePCT_YARwIryXQKAua?dl=0

Je vous invite à télécharger le fichier excel présent dans le répertoire : LMBG Bachelor V3 ETUDIANT.xlsm
Les corrigés seront déposés dans ce même répertoire.

Il faut lire l'ensemble des consignes présentes dans le fichier.

Date de remise du travail	heure de remise	Annexe à remettre
vendredi 24 janvier 2020	à midi	Annexe 1
samedi 1 février 2020	à midi	Annexe 2
samedi 8 février 2020	à midi	Annexe 3

 Les travaux doivent être envoyés sur l'adresse : lmbgasia@gmail.com dans le format demandé (cf. fichier excel)
N'hésitez pas à poser vos questions sur le blog en faisant répondre à ce message.

Cordialement
MP

chaînage modules business plan et business game

Bonjour à tous,

je vous présente également tous mes vœux pour cette nouvelle année.

Je suivrai Mathieu Paquerot avec le module de business game, qui débutera mi-février. Ce business plan est essentiel pour bien amorcer le business game. Il doit vous permettre de modéliser revenus & charges pour amorcer au mieux le démarrage de votre activité (vous allez gérer un hôtel à Gythio) et ainsi éviter les grosses erreurs du départ.

c'est un cours qui peut s'avérer complexe, mais qu'il est essentiel de maîtriser pour votre future carrière.

bon courage,

Anne Queffelec