• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
OpenTuition | ACCA | CIMA

OpenTuition | ACCA | CIMA

Free ACCA and CIMA on line courses | Free ACCA, CIMA, FIA Notes, Lectures, Tests and Forums

  • ACCA
  • CIMA
  • FIA
  • OBU
  • Forums
  • Search
  • Register
  • Login
  • Latest
  • ACCA
  • Ask ACCA Tutor
  • OBU
  • CIMA
  • Ask CIMA Tutor
  • FIA
  • Buy/Sell
  • Qualified
  • Forum Rules

Ethics and Professional skills module unit 7

Forums › Ask ACCA Tutor Forums › ACCA Ethics and Professional Skills Module › Ethics and Professional skills module unit 7

  • This topic has 86 replies, 30 voices, and was last updated 3 weeks ago by arjun585.
Viewing 27 posts - 61 through 87 (of 87 total)
← 1 2 3
  • Author
    Posts
  • May 17, 2020 at 9:14 am #571095
    JP1982
    • Topics: 0
    • Replies: 2
    • ☆

    Hi

    Please you can you explain the link between the following:

    Coefficients
    Intercept -63964..57622
    X1 234.9566375
    X2 0.406247082

    and so on
    many thanks

    May 17, 2020 at 9:52 am #571103
    Kim Smith
    Keymaster
    • Topics: 39
    • Replies: 3633
    • ☆☆☆☆☆

    The BBQ Illustration is in the predictive analytics section of the module – you’re expected to work through the module before attempting the assessment at the end of it. If you do so you should understand the types of variables you might have to deal with and that the multiple regression formula is simply the sum of the coefficients multiplied by the variables.

    In principle it is no different to linear regression – which is assumed knowledge of MA – see Chapter 19 of the MA notes https://opentuition.com/acca/ma/ – only multiple regression has more than two variables.

    May 17, 2020 at 7:40 pm #571131
    Daryn
    • Topics: 0
    • Replies: 2
    • ☆

    I took these X1,X2 and … variables from the ANOVA summary that is given in the task. There is a table with the intercept and variables coefficient. I did it in the same was as in the example from unit.

    in the xls file there is no data about variables.

    What other variables should I try? not clear.

    May 18, 2020 at 8:02 am #571171
    Kim Smith
    Keymaster
    • Topics: 39
    • Replies: 3633
    • ☆☆☆☆☆

    I suggest it makes sense for them to be presented in the order indicated on the first slide (before the download spreadsheet slide) which describes the spreadsheet.

    June 10, 2020 at 3:57 am #573328
    bw196502
    • Topics: 0
    • Replies: 1
    • ☆

    Hi

    SO sorry to disturb you that I used –
    Would you please guide me what to do next as really stuck here?

    I have passed all acca exams except this unit now. Wish someone can help.

    Thanks a million.

    June 10, 2020 at 7:29 am #573341
    Kim Smith
    Keymaster
    • Topics: 39
    • Replies: 3633
    • ☆☆☆☆☆

    There are 4 variables – not 3. If you put the values of the variables you are given into a blank column of the spreadsheet (say column J) – matched up against the corresponding rows (16-19) – then multiply out and take account of the intercept you should get the correct answer. Your approach is correct you just have careless errors in it.

    July 20, 2020 at 12:50 pm #577452
    kumbie2019
    • Topics: 0
    • Replies: 1
    • ☆

    Please help me on tkumbirai@gmail.com or whatsapp number +26771404392. I am not getting it

    July 20, 2020 at 1:43 pm #577471
    Kim Smith
    Keymaster
    • Topics: 39
    • Replies: 3633
    • ☆☆☆☆☆

    To solve the abacus problem you just need to read VERY carefully the explanation of values top and bottom (rather than make any assumptions).

    August 17, 2020 at 8:43 am #580854
    calen
    • Topics: 0
    • Replies: 1
    • ☆

    I can confirm that this helped me pass the module, thanks for this!

    August 18, 2020 at 2:07 pm #581047
    Vu
    • Topics: 45
    • Replies: 86
    • ☆☆

    Here is the hint for the question of predicted sales:

    “To get the predicted sale you need to load the Data Analysis Tab if not loaded already and follow the procedure to use the linear regression prediction following the instruction given on the module. You need to understand how to identify the constant and the coefficient and you will get the predicted sale easily. If you are not able please get back”

    September 19, 2020 at 2:16 pm #586175
    Tom85
    • Topics: 4
    • Replies: 20
    • ☆

    I went through this with a professional data scientist and got the first two questions wrong.

    The reason was because I entered the data to two decimal places. There was nothing to suggest we’d be penalised for this. ACCA are usually very clear when they want it rounded to the nearest dollar so this is disappointing. It is meant to be simulating real life after all.

    If you are getting these wrong try answering without decimals.

    September 20, 2020 at 6:24 pm #586263
    kavanaghc
    • Topics: 1
    • Replies: 1
    • ☆

    Hi all,

    I am loosing the will to live. I am doing Unit 7 – “Types of data visualisation – Composition” In 2017 how much was the total sales in $m (excluding bakery sales)?. Maybe I am just looking at this wrong. I don’t want someone to tell me the answer as that won’t help me, but to see am I actually going mad or just tired. This was my thinking on it.

    The departments are stacked – exclude bakery. I was working the basics

    Deli 25000000
    Homeware 20000000
    Grocery 15000000

    Min Total 60000000

    Then I added the little parts above the break line and was getting these figures

    Homeware 2500000
    Grocery 500000

    So I put in my answer, including all the zeros, then I thought maybe I have the little extra number wrong so tried a few of them. Then I thought maybe I am just tired so I had a colleague look at it and she got the same numbers I did.

    Any help on this would be great as I am cracking up.

    Rgds

    Caroline

    October 2, 2020 at 12:16 am #587177
    dladyx
    • Topics: 0
    • Replies: 5
    • ☆

    Try answering without the zeros. For instance 25 instead of 25000000

    October 2, 2020 at 8:18 am #587184
    Kim Smith
    Keymaster
    • Topics: 39
    • Replies: 3633
    • ☆☆☆☆☆

    In $m means the # of millions – i.e. the number before the 000000.

    October 7, 2020 at 2:47 pm #587611
    thjxxacca
    • Topics: 0
    • Replies: 1
    • ☆

    Hi.. I really need help. Im stucked at level 7 of the end of unit assessment, where i had to answer questions relating to the data analysis of the ticket sales and all that. But im totally lost, had no idea where to refer to for the analysing of the data from the spreadsheet. Can anyone guide me along please 🙁

    October 7, 2020 at 4:23 pm #587631
    Kim Smith
    Keymaster
    • Topics: 39
    • Replies: 3633
    • ☆☆☆☆☆

    thjxxacca – I suggest you start at the beginning of this thread reading my posts – I tell you exactly what you are supposed to have done before you tackle the assessment.

    October 18, 2020 at 7:16 am #589649
    kjayale
    • Topics: 0
    • Replies: 3
    • ☆

    Can someone help me to advise on Module 7 Q2? I am so desperate to complete the Professional Ethics. Whole week wasted 🙁

    October 18, 2020 at 7:20 am #589650
    kjayale
    • Topics: 0
    • Replies: 3
    • ☆

    I managed to solve the abacus question within 10 minutes but the predicted sales (Q2) and other final questions are disaster..

    October 18, 2020 at 8:55 am #589665
    Kim Smith
    Keymaster
    • Topics: 39
    • Replies: 3633
    • ☆☆☆☆☆

    @kjayale – please spend 5 minutes reading through my posts on this thread – I tell you everything you need to pay attention to, to pass this module.

    October 18, 2020 at 11:39 am #589690
    Spiro
    • Topics: 0
    • Replies: 17
    • ☆

    Regarding the 250k investment question. Probably we should first calculate the expected revenues by updating the barrier cost variable value in the equation?
    But, what about the next step? Should we deduct from the calculated sales the 250k investment cost to find the profit and to elaborate further, or simply to compare the sales based on 250k and 30k investments variables?

    October 18, 2020 at 5:16 pm #589736
    Kim Smith
    Keymaster
    • Topics: 39
    • Replies: 3633
    • ☆☆☆☆☆

    Please read through my posts on this thread – you need to look to the illustration in the module, that I have clearly signposted, to understand what you are trying to achieve in the task.

    October 19, 2020 at 9:37 am #590327
    Spiro
    • Topics: 0
    • Replies: 17
    • ☆

    I read several times your posts. What we are looking for is the impact on profits if $250,000 were spent on automated ticket barrier investment.
    First calculate the expected sales with change of X Variable 3 to 250K, and then take into account the increase in cost of investment with 220K.
    Probably I do not understand properly the question?

    October 19, 2020 at 9:48 am #590338
    Spiro
    • Topics: 0
    • Replies: 17
    • ☆

    Just to correct the above comment, that the 220K investment cost increase I deduct from the increase of expected sales.

    October 19, 2020 at 5:58 pm #590566
    Kim Smith
    Keymaster
    • Topics: 39
    • Replies: 3633
    • ☆☆☆☆☆

    But have you gone back to the illustration in the module? You don’t seem to understand the point of the formula. As I explain in previous posts increase in revenue is increase in profit because there is no variable/direct cost of sales. It cannot be correct to deduct cost of investment – i.e. CAPITAL cost (which would be asset in SoFP) from revenue in the derivation of profit.

    October 20, 2020 at 4:47 am #590673
    Spiro
    • Topics: 0
    • Replies: 17
    • ☆

    Well, I change one of the variables (the investment spend) and predict the new sales using the rest variables values from Q2. Then compare with sales initially calculated with 30k spend. The delta is not accepted as a correct answer. Spent plenty of hours by making various trials but without any result. Even, I’m asking myself, are unit 7 assessment Q2 and Q3 related?

    October 21, 2020 at 8:47 am #590945
    Kim Smith
    Keymaster
    • Topics: 39
    • Replies: 3633
    • ☆☆☆☆☆

    No the questions are independent of each other.

    December 26, 2020 at 1:45 pm #600908
    arjun585
    • Topics: 4
    • Replies: 4
    • ☆

    Hi,
    I used the formula Y = deleted
    I got the following :

    DELETED

    This is the correct answer!!!

  • Author
    Posts
Viewing 27 posts - 61 through 87 (of 87 total)
← 1 2 3
  • You must be logged in to reply to this topic.
Log In

Primary Sidebar

ACCA Exam Results – Comments

ACCA PM December 2020 Exam Results ACCA TX December 2020 Exam Results ACCA AA December 2020 Exam Results ACCA FR December 2020 Exam Results ACCA FM December 2020 Exam Results ACCA SBL December 2020 Exam Results ACCA SBR December 2020 Exam Results ACCA AAA December 2020 Exam Results ACCA AFM December 2020 Exam Results ACCA APM December 2020 Exam Results ACCA ATX December 2020 Exam Results

Donate

If you have benefited from our materials please donate

Donate now

You can also "donate your time" and help out other students on the Students Forums

Specially for OpenTuition students

20% off ACCA Books

Get BPP Discount Code

Latest comments

  • StefanosG on ACCA FR Chapter 5 IAS16 Questions
  • FinKi on The Normal distribution – Management Accounting (MA)
  • John Moffat on Interest Rate Collars
  • John Moffat on Control Accounts (part c) – ACCA Financial Accounting (FA) lectures
  • John Moffat on Activity Based Costing part 1 – ACCA Performance Management (PM)

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


We use cookies to show you relevant advertising, find out more: Privacy Policy · Cookie Policy