Ethics and Professional skills module unit 7

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.

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.

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.

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

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”

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

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

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.

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

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?

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?

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.

No the questions are independent of each other.