mardi 18 février 2020

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

Publié par à

8 commentaires:

  1. Unknown19 février 2020 à 22:14

    Dear Mrs Queffelec,

    I have a question about the decision 2, we need to complete the column F but of our first excel document or we take your correction and we need to complete the column F until F215 ?

    I don't really understand the correction why our CA and Net profit and loss are different than yours?

    Thanks in advance,

    Ambre Etchelecou

    RépondreSupprimer
    Réponses
    1. Anne Queffelec23 février 2020 à 01:19

      Dear Ambre,

      sorry for the delay, I haven't seen you question.

      1/ For decision 2, you fill in the column F of the decision sheet (and not the results sheet), meeasn, from line 5 to line 32.

      2/ I understand that the real turn over and net result are differents than you forecasts.... now, you shoudl adjust your forecast, thanks to the analysis of the results

      regards,

      anne queffelec

      Supprimer
  2. Alice Bayart22 février 2020 à 04:59

    Good Afternoon,

    I have a question about " Marketing expenses and surveys ", it's for "Other Marketing Budget" or "Marketing Budget" in the decision sheet?

    Regards,

    Alice BAYART

    RépondreSupprimer
    Réponses
    1. Anne Queffelec23 février 2020 à 01:30

      Dear Alice,

      " Marketing expenses and surveys " includes : online marketing budget + other marketing budget + the studies

      regards,

      anne queffelec

      Supprimer
  3. Alice Bayart22 février 2020 à 05:44

    Hi,

    For turnover, we must put the number of rooms sold from the results sheet that you sent?

    Thanks,

    Alice Bayart

    RépondreSupprimer
  4. Anne Queffelec23 février 2020 à 01:32

    Dear Alice,

    I'm not sure to understand your question.

    You forecast the number of rooms sold, based on you previous results and your objectives, and then , I put all the decisons in my algorithm, which determinate the allocation of the demand.

    Best regards,

    anne

    RépondreSupprimer
  5. Andréa Gomez23 février 2020 à 05:48

    Hello, We have questions

    To do the marketing dashboard, should we take our table where we only have the results of the first year or the one that you sent us as example?
    Also, should it be posible to know more about HR?

    Regards,

    RépondreSupprimer
  6. Anne Queffelec29 février 2020 à 02:39

    dear Andrea,

    for the dashboards, you take in account the figures from the file "team 1 results" that I send by email. The page "dashboards " is useful for you to understand the methodology. On my post last sunday, I explained how to update with your own results. The figures of the sheet "results" of the file "daschboards example" are not the figure for this module, that's why you have to update with your own results (of year 1, and soon with year 2).

    regards,

    anne

    RépondreSupprimer

Inscription à : Publier les commentaires (Atom)