Board course 300 part 1 - 306 Mismatch of results for question 2

Daniel Estermann
Daniel Estermann Active Partner
First Comment
in Academy

Dear all
When I run the allocation of the indirect costs and check the results of store FR0001 I don't get the right numbers. I reviewed the various steps according to the manual several times.

Any tip how I can solve this issue? All temporary cubes are setup as "double" according to the instructions (as also discussed in another question)

Thank you

Daniel

image.png

Answers

  • Crystal Zhao
    Crystal Zhao Employee
    10 Comments September Badge of the Month Name Dropper August Badge of the Month

    Hi Daniel,

    When you entered the numbers per these instructions:

    image.png

    Did you put the > symbol and see the number duplicated across all of the columns to the right, or did you just enter in the actual numbers without the symbol?

    Crystal Zhao

  • Daniel Estermann
    Daniel Estermann Active Partner
    First Comment

    Hi Crystal
    Thanks for your message. Yes I did it according to the instructions (with the > symbol).

    image.png

    Best Daniel

  • Crystal Zhao
    Crystal Zhao Employee
    10 Comments September Badge of the Month Name Dropper August Badge of the Month

    Hi Daniel,

    Oh okay, that does look right. Can you share a screenshot of your Indirect Costs procedure?

  • Daniel Estermann
    Daniel Estermann Active Partner
    First Comment

    Thanks. Sure, see below…

    image.png

  • Crystal Zhao
    Crystal Zhao Employee
    10 Comments September Badge of the Month Name Dropper August Badge of the Month

    Hi Daniel,

    That looks right too. I'm wondering if there is a dimension missing in your temporary cubes that might be causing this. Can you click the word "Options" on that same screenshot so that I can see all of the dimensions in your temporary cubes?

  • Daniel Estermann
    Daniel Estermann Active Partner
    First Comment

    Yes sure. I think I reviewed it several times to make sure it is set up according the instructions…

    image.png

  • Crystal Zhao
    Crystal Zhao Employee
    10 Comments September Badge of the Month Name Dropper August Badge of the Month

    Hi Daniel,

    Okay that also looks like mine. Can you go back to your Expense Planning screen with France selected, highlight the Office Technology: Software cell, then click "Drill Anywhere" and choose Month?

    image.png

    I have a feeling that you have the opposite months showing since your numbers look to be about 1/4 the numbers that I am seeing in mine.

    Crystal Zhao

  • Daniel Estermann
    Daniel Estermann Active Partner
    First Comment

    It looks like that I'm getting approx 1/4 of your values. Strange. Just FYI, I run the "Population of Expense PLan" again and get slightly different figures which have been allocated. See also in background in screenshot)

    image.png

  • Daniel Estermann
    Daniel Estermann Active Partner
    First Comment

    Hi Crystal, could you maybe provide me the correct values of the functional test so that I can move forward? Many thanks
    Best Daniel

Categories