Forums › Ask ACCA Tutor Forums › ACCA Ethics and Professional Skills Module › Ethics and Professional skills module unit 7
 This topic has 109 replies, 41 voices, and was last updated 2 months ago by Kim Smith.

AuthorPosts

March 23, 2020 at 9:29 pm #565595oblatty
 Topics: 2
 Replies: 2
 ☆
please share the answer or how to do it am really straggling also this side
March 24, 2020 at 7:56 am #565617Kim SmithKeymaster Topics: 93
 Replies: 6413
 ☆☆☆☆☆
If you read through my responses on this post and also on this one https://opentuition.com/topic/accaethicsandprofessionalskillsmoduleunit7unit82/ you will see that I am giving as much assistance as ethics permits – and other students are managing to work out the answers on this basis. This is a difficult unit and there are no shortcuts to working through it carefully.
April 2, 2020 at 11:43 am #566369sehrikhan Topics: 0
 Replies: 2
 ☆
Hi @Shariqfaraz are you able to help me with unit 7 please? i am struggling with it
April 2, 2020 at 11:45 am #566370sehrikhan Topics: 0
 Replies: 2
 ☆
Hi Sir,
appreciate your help on this. I am stuggling wiht unit 7 alot.i have read through your comments and also the instruction but still unable to resolve it. can you please guide meApril 2, 2020 at 1:12 pm #566374Kim SmithKeymaster Topics: 93
 Replies: 6413
 ☆☆☆☆☆
I cannot offer any more guidance short of giving the answers which would clearly be inappropriate. I can only repeat – work carefully through the illustration in the unit before you attempt the endofunit assessment. Pay attention to “units” when keying in a numberfill answer. I have virtually spelt out the calculation you need to do for the first Q (which seems to be the hardest) and if you do the calculation in the spreadsheet which you can download there should be no scope for calculation error.
April 9, 2020 at 3:14 pm #566981avrondavids25 Topics: 0
 Replies: 1
 ☆
Dear Shauna,
I trust you are well.
Kindly advice the steps you followed for Q2 and Q3
I have downloaded the spredhsheet, did everything but cannot find the X values 🙁
I thank you in advance.
April 9, 2020 at 3:22 pm #566985Kim SmithKeymaster Topics: 93
 Replies: 6413
 ☆☆☆☆☆
Please see the 2nd post on the 1st page of posts on this thread. If you work through the illustration BBQ sales as directed you should understand what the X values are.
April 9, 2020 at 10:24 pm #567045irehs Topics: 1
 Replies: 7
 ☆
Thank you, thank you, thank you, Thank you!
Have spend a whole evening trying to work this out. First off didn’t have data analytics on my excel, took ages to figure out I needed an add in (thanks google). Then I’m met with a data table that made no sense (not going to lie I skimmed this chapter it hurt my brain). Then came here great explanation by Kim and the other posters. Boom! Moving on to chapter 8. Thank you again
April 14, 2020 at 5:30 pm #568271Anonymous Topics: 0
 Replies: 4
 ☆
the answer is DELETED $
Predictive salesApril 18, 2020 at 9:47 am #568644pillgrim117 Topics: 0
 Replies: 3
 ☆
HI All, I am really struggling with this assessment. I am specifically trying to calculate the answer to Question 1 of the end of section assessment “What would the predicted ticket sales be with the following data”
As I understand it the formula “Y = 588 – 30X1 – 20X2 +10X3”
based on the data in the question the formula should be as follows:63964.57622 + (150*234.9566375) and so on for each of the 4 variables in the question * by the relevant X variable number as per the table provided.
However when I do this the answer $41,234, what am I doing wrong?
I appreciate anyones help, I have done all my exams and PER all that is holding me up from being fully qualified now is this stupid question!
April 19, 2020 at 2:57 am #568718gordy15557 Topics: 1
 Replies: 3
 ☆
I was wondering if you can help with the following unit please?
DELETED
April 19, 2020 at 9:18 am #568728Kim SmithKeymaster Topics: 93
 Replies: 6413
 ☆☆☆☆☆
If you read CAREFULLY through my posts on this thread and also on this one https://opentuition.com/topic/accaethicsandprofessionalskillsmoduleunit7unit82/ you will see that students are managing to successfully complete this module. As advised on earlier posts it may be that you need to revisit the illustration in the module – it isn’t something to be glossed over.
I will gladly look to see where you went wrong according to your earlier post after the weekend.
April 19, 2020 at 9:32 am #568730pillgrim117 Topics: 0
 Replies: 3
 ☆
Hi Kim,
Thanks for the reply. I have fully read all previous comments and fully reviewed the previous slides on the topic, and am now confident I understand the application of the formula required to answer the question.
I suspect that my errors with the answer are due to rounding as I am exactly applying the formula previously provided in the illustration of “Y = 588 – 30X1 – 20X2 + 10X3” in the question provided 588 is replaced by 63,964.57622 and all the x variable number I have taken as per the Anova table 234.9566375 etc. I understand these numbers need to be X by the coefficients in the question (150, 15000 etc).
However I noticed the illustration earlier in the chapter rounds the X numbers and the intercept down to whole numbers, which I have done exactly replicating how it was calculated in the illustration, but am still coming out with the wrong answer?
Thanks again for your help.
April 19, 2020 at 9:41 am #568731pillgrim117 Topics: 0
 Replies: 3
 ☆
Hi Kim,
Sorry to keep bombarding you with messages. I worked it out! Realised when I initially done the full calculation I had got some of the numbers in the formula round the wrong way!
Thanks again for all your help, the previous comments you made with other students really helped!
April 19, 2020 at 11:12 am #568744Kim SmithKeymaster Topics: 93
 Replies: 6413
 ☆☆☆☆☆
@pillgrim117 – excellent news! That should encourage those who are still struggling. As you will have gathered from my posts, I strongly believe that, ethics and professionalism aside, students get much more out of the module (as ACCA intend that they should) if they get there in the end by their own work!
April 21, 2020 at 9:18 pm #568915theodoor Topics: 5
 Replies: 9
 ☆
Dear Tutor,
I got trough it with 50% but still got question 1 and 2 wrong.
I did;
150*X1(234.95)+15000*X2(0.406)+3000*X3(1.1336)+3*X4(11779.31) and got 110’683.79 but this was incorrect.What am I doing wrong?
April 22, 2020 at 7:38 am #568926Kim SmithKeymaster Topics: 93
 Replies: 6413
 ☆☆☆☆☆
You are forgetting about the intercept – you should WORK CAREFULLY through the example in the module (as referenced earlier in this thread) i.e. download it and put in the numbers yourself to confirm how the data in the spreadsheet should be used.
April 25, 2020 at 11:06 am #569193AdarshG Topics: 0
 Replies: 2
 ☆
Hi Kim,
I am unable to get the answer for Q2
i did the below
=
Please advise where i went wrong.Thank you.
April 25, 2020 at 5:18 pm #569225Kim SmithKeymaster Topics: 93
 Replies: 6413
 ☆☆☆☆☆
The calculation you are trying to do is correct – all I can suggest – that you use the spreadsheet to make the calculation (there’s plenty of space to do it) so you are not making a calculator error and so you don’t introduce rounding errors.
April 27, 2020 at 10:08 am #569332nikit.mittal Topics: 0
 Replies: 3
 ☆
Hi,
Can you please help me to solve the abacus problem?
Thanks and Regards
Nikit MittalApril 27, 2020 at 10:19 am #569343Kim SmithKeymaster Topics: 93
 Replies: 6413
 ☆☆☆☆☆
Re Abacus – You just need to read VERY carefully the explanation of values top and bottom (rather than make any assumptions).
April 27, 2020 at 1:27 pm #569354AdarshG Topics: 0
 Replies: 2
 ☆
Hi Kim,
I followed the steps as described in your previous comments but i’m still unable to get the corrrect answer.
Can you please help me?
April 27, 2020 at 4:25 pm #569365Kim SmithKeymaster Topics: 93
 Replies: 6413
 ☆☆☆☆☆
I can only reiterate that if you do the calculation in the spreadsheet in such a way that you avoid calculator errors you should get the correct answer. Perhaps try reworking the equivalent numbers in the illustration earlier in the module – just to make sure you’re not making a careless mistake (mismatching the variables and their coefficients or ignoring the negative intercept).
April 28, 2020 at 6:31 am #569390nikit.mittal Topics: 0
 Replies: 3
 ☆
Hi,
I have gone through all the comments but not able to figure out how to solve question 3
How much additional profit would be generated if $250,000 were spent on automated ticket barrier investment?
Kindly suggest me the way to solve it.
Any help would be really appreciated.
Thanks!
April 28, 2020 at 7:37 am #569393Kim SmithKeymaster Topics: 93
 Replies: 6413
 ☆☆☆☆☆
You need to READ through the section “Predictive Analytics” in the unit – in particular the page which shows the summary output of the BBQ sales illustration and the following page which starts “This information can therefore be used to predict future sales …”
You should then apply what you learn to the endofunit assessment. Q3 asks you to predict additional profit (= revenue because there is no variable cost). The first page of the unit assessment, before you download the spreadsheet, tells you what the variables are.
May 7, 2020 at 7:21 pm #570273Anonymous Topics: 0
 Replies: 4
 ☆
You can find the results here DELETED
May 8, 2020 at 8:25 am #570297Kim SmithKeymaster Topics: 93
 Replies: 6413
 ☆☆☆☆☆
tanzeelrehman – please reflect on the ethics and professionalism of your action
May 15, 2020 at 7:21 pm #570968Daryn Topics: 0
 Replies: 2
 ☆
Hello,
I am like others in this chat have difficulties in solving the 1 question in the last assessment of unit 7 re the predicted sales.
I used the formula Y = 588 – 30X1 – 20X2 + 10X3 from the example of unit 7.
I got the following : 63965+150*235+15000*0+30000*1+11779*3 = 36622.
but this is wrong. WHY?????
I am really confused and do not understand what I am doing wrong.Please HELP!!!!
May 15, 2020 at 7:36 pm #570969Kim SmithKeymaster Topics: 93
 Replies: 6413
 ☆☆☆☆☆
I suggest you read through MY posts – I don’t have the xls to hand but I don’t think you have correctly identified the X1, X2, etc values in the xls. I’m pretty sure there should be a *1 or *0 in the calculation. If you download the xls and do the calculation in the xls there really is little scope to get this wrong. Just make sure you are multiplying out the correct values!
May 17, 2020 at 8:35 am #571091JP1982 Topics: 0
 Replies: 2
 ☆
Can someone provide a link to the BBQ sales example.
thanks 
AuthorPosts
 You must be logged in to reply to this topic.