Summary
Summary YOUR COMPLETE GUIDE FOR MAC 3761. Only for intelligent students.
- Course
- Institution
YOUR COMPLETE GUIDE FOR MAC 3761. Only For Intelligent Students Looking For Another Distinction
[Show more]
2 reviews
By: anishachunder0410 • 7 months ago
By: jeanettevdwatt • 10 months ago
Seller
Follow
unisadistinc
Reviews received
Content preview
Cost classification and behaviour videoDear Students
Below please find a link to an additional resource on Cost Classification and Behaviour.
Before you watch the video, it is important that you take note of the following:
Any references to specific tutorial letters, persons, or exam administration should be ignored. Dur
intention in making the video available is that students use it as an additional resource to help with
understanding some MAC3761 content only. and as part of the activities of learning unit 1.
The video briefly addresses some of the concepts of learning unit 1. However, it also touches on a few of
the concepts of learning unit 2 (Relevant Costing). These concepts lay an important foundation for later
learning units.
Please use your mylife details to accessthe video.
Thank you,
MAC3761 lecturers
Dcost classification and behaviour video.mp4
,The results are as follows:
Total talk
minutes
Total cost per
1 (R's) month
2 January 260.00 762.30
3 February 428.54 1338.00
4 March 338.58 956.40
5 April 310.00 900.00
6 May 260.76 485.30 Multiple R 0.954069
7 June 387.09 1255.00 Rsquare 0.910248
8 July 354.83 1110.10 Observations 12
9 August 208.93 555.80 Intercept 90.01236
10 SeptembE 400.44 1269.60 Slope 0.242979
11 October 201.32 612.00
12 Novembe 297.71 861.00
13 Decembea 329.62 997.00
14
Source of data set:
Roos, S, Cairney, C, Chivaka, R, Fourie, H, Joubert, D, Mohammadali, H, Pienaar, A, Stack, L, Streng, J,
Swartz, G & Williams, J. 2019. Principles of management accounting: a South African perspective. 3rd
edition. Cape Town: Oxford University Press Southern Africa.
, S. Calculate they-intercept using the "INTERCEPT"function:
-....ltcui
i!QCopy
.,
Ho-
Clipboard r.
B I U
fonl
A
,
C2 X ✓ /. -=intet~t(82:B1l,Cl:Ol)
A
• C
Tolal talk
0
• G H
minutes
rotalcost per
2 -Jan1,1-1ry
IR'sl
-()C)
month
762-30
.
3 , Fe.bruary 4>:B.S4 1338.00
Ma«:h 333.SS -40
's April 310.()C) 901).()C)
• May
1 June
?60.76
387.09 1255.00
485.30 M-ultJple R
R square
0.954069
0,910248
8 July 354-8} lll0.10 ObstrvatlonJ 12
9 !August 208.93 >SS.IIO 1ntetce9t ~!(82:813,Q:Cll~
10 ·se.ptemb 40C>A4 1269,60
11 October :!OU: 612.00
t2•NovembE 297,71, 861.00
,,
1l Decembe 32'.62 997.00
,.
IS
17
6. Calculate the slope ("m" in the equation) using the "SLOPE"function:
Home:
J(,c.,
~Copy
B I \I
' A
r. Font Ali9nmtnt
C2 X ✓ /, :slope(B2:B13,C2:C13)
A 8 C D E F H J
Totaltalk
minutes
Total cost per
1 IR's1 month
2 January 260.00 762.30
3 February 428.54 1338.00
4 March 338.58 956.40
5 Aprll 310.00 900,00
6 May 260.76 48$.30 Multlple A 0.954069
7 June 387.09 USS.DO Rsquare 0.910248
8 July 354.83 1110.10 Observations 12
9 August 208.93 555.80 Intercept 90,01236
400.44 1269.60 Slope !:slope(82,813,C2:CJ3)I
,oiseptemb
11 October 20L32 612.00
12 Novemb◄ 297.71 861.00
,.
13 oe«mbe. 329.62 997.00
, 4. For the number of observations, one option would be to do a "COUNT" of the number of values
for x (the number of values in the Total talk minutes per month column):
Home Insert Page layout Formulas Data Rev,~ V1ev1 Help Q Tell mewl
... ~Cut
A A G,
f@I Copy •
r ., B 1 U • A !et
r. Font Alignment
C2 • X ✓ f,, :count(C2:C13)
A 8 C 0 e F G H
Total talk
minutes
Total cost per
{R's) month
2 January 260.00 762.30 •
3 February 428.54 1338.00
4 March 338.58 956.40
5 April 310.00 900.00
6 May 260.76 485.30 Multiple R 0.954069
7 June 387.09 1255.00 R square 0.910248
8 July 354.83 1110.10 Observations!=count{C2_:C13JI
9 August 208.93 555.80
10 Septemb, 400.44 1269.60
11 October 201.32 612.00
12 Novembe 297.71 861.00
13 Oecembet 329.62 997.00
14
Make sure you only highlight the values in one of the columns, otherwise you will double count.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller unisadistinc. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.64. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
67474 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now