• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Free ACCA & CIMA online courses from OpenTuition

Free ACCA & CIMA online courses from OpenTuition

Free Notes, Lectures, Tests and Forums for ACCA and CIMA exams

  • ACCA
  • CIMA
  • FIA
  • OBU
  • Books
  • Forums
  • Ask AI
  • Search
  • Register
  • Login
  • ACCA Forums
  • Ask ACCA Tutor
  • CIMA Forums
  • Ask CIMA Tutor
  • FIA
  • OBU
  • Buy/Sell Books
  • All Forums
  • Latest Topics

20% off ACCA & CIMA Books

OpenTuition recommends the new interactive BPP books for September 2025 exams.
Get your discount code >>

Regret Table Help

Forums › Ask CIMA Tutor Forums › Ask CIMA P1 Tutor Forums › Regret Table Help

  • This topic has 6 replies, 3 voices, and was last updated 5 years ago by Cath.
Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • March 18, 2017 at 4:04 pm #378630
    joshgoncalves
    Member
    • Topics: 1
    • Replies: 1
    • ☆

    I’m stuck on the following question, I just can’t seem to work out how the regret table was formulated.
    someone please help, I understand the minimax regret philosophy but formulating the regret table without knowing the exact contribution puzzles me.

    The committee of a new golf club is setting the annual membership fee. The number of members depends on the membership fee charged and economic conditions. The forecast annual cash inflows from membership fees are shown below.

    Membership level

    Membership fee Low Average High
    $000 $000 $000
    $600 360 480 540
    $800 400 440 480
    $900 360 405 495
    $1,000 320 380 420

    If the minimax regret criterion is applied the fee set by the committee would be:
    $600
    $800
    $900
    $1,000

    Answer:
    A regret matrix is shown below:

    Membership level
    Membership fee Low $000 Average $000 High $000
    $600 40 0 0
    $800 0 40 60
    $900 40 75 45
    $1,000 80 100 120

    Maximum regret if set fee of $600 is $40k

    Maximum regret if set fee of $800 is $60k

    Maximum regret if set fee of $900 is $75k

    Maximum regret if set fee of $1,000 is $120k

    March 18, 2017 at 5:12 pm #378634
    Cath
    Participant
    • Topics: 0
    • Replies: 447
    • ☆☆☆

    Hi,
    Thanks for your question.
    It’s a hard one to explain in written form – hoping you have watched our CIMA P1 videos.

    To create the risk matrix itself doesnt need contribution it is calculated from the payoff table – which is given in the question.

    A minimax regret person is concerned how bad they will feel if they select the wrong decision for the outcome that occurs.

    Eg – how bad will they feel ( what regret will they have) if membership does turn out to be low and they have chosen a $600 price policy.
    They will compare the pay off for this $600 / low membership which is $360 and compare to what they could’ve received if they had chosen the best option in those circumstances.
    The best option in those circumstances (e.g. low membership) would have been to chose an $800 price point. This would’ve yielded a pay off of $400 – so the amount of regret that you feel from selecting 600price rather than 800price will be 40 ( 400 -360) Every square in the regret table is comparing the payoff received to the best payoff in those circumstances ( best in the column)

    There are no negative figures in a regret table – the bigger the regret figure – the worse it feels for the decision maker. Where it shows 0 as the regret – this means this was the best decision in those circumstances so you have no regrets in that case.

    I assume you are happy with how to make the final decision with this minimax regret method and it was just building the table of regrets that is causing the problem?
    The answer to “minimise the maximum regret” is to charge $600 – let me know if you need this explaining further.
    Kind Regards
    Cath

    March 18, 2017 at 5:16 pm #378635
    joshgoncalves
    Member
    • Topics: 1
    • Replies: 1
    • ☆

    Thanks Cath,

    Appreciate the swift response, i literally figured it out about 5minutes after posting this.

    Your explanation of the process helps to realise i was on the right lines myself.

    Thank you very much.

    Josh

    March 23, 2017 at 1:08 am #379014
    Cath
    Participant
    • Topics: 0
    • Replies: 447
    • ☆☆☆

    You’re welcome – thank you

    August 30, 2019 at 1:10 pm #543834
    kah868
    Member
    • Topics: 0
    • Replies: 2
    • ☆

    Please can someone help me? I’m struggling on this question, I don’t understand how the correct answer is £45 (max regret -£10000) when the smallest of the largest regrets would be £20000 at a selling price of £50?

    Selling Price
    40 45 50 55
    Boom £10000 £0 £20000 £30000
    Growth £20000 £10000 £0 £20000
    Recession £0 £10000 £20000 £30000

    August 30, 2019 at 1:13 pm #543835
    kah868
    Member
    • Topics: 0
    • Replies: 2
    • ☆

    Just read the question again, these figures are the actual outcomes so I understand now. Sorry.

    August 30, 2019 at 4:19 pm #543868
    Cath
    Participant
    • Topics: 0
    • Replies: 447
    • ☆☆☆

    No problem!! Thanks for your question.

  • Author
    Posts
Viewing 7 posts - 1 through 7 (of 7 total)
  • You must be logged in to reply to this topic.
Log In

Primary Sidebar

Donate
If you have benefited from our materials, please donate

ACCA News:

ACCA My Exam Performance for non-variant

Applied Skills exams is available NOW

ACCA Options:  “Read the Mind of the Marker” articles

Subscribe to ACCA’s Student Accountant Direct

ACCA CBE 2025 Exams

How was your exam, and what was the exam result?

BT CBE exam was.. | MA CBE exam was..
FA CBE exam was.. | LW CBE exam was..

Donate

If you have benefited from OpenTuition please donate.

PQ Magazine

Latest Comments

  • John Moffat on Investment Appraisal Under Uncertainty: Expected Values (example 2) – ACCA Financial Management (FM)
  • Dinomain on Investment Appraisal Under Uncertainty: Expected Values (example 2) – ACCA Financial Management (FM)
  • hoangacca on Cost Classification and Behaviour part 2 – ACCA Management Accounting (MA)
  • Elikplim on Time Series Analysis – ACCA Management Accounting (MA)
  • Elikplim on Time Series Analysis – ACCA Management Accounting (MA)

Copyright © 2025 · Support · Contact · Advertising · OpenLicense · About · Sitemap · Comments · Log in