Summary YOUR COMPLETE GUIDE FOR MAC 3761. Only for intelligent students.

Cost classification and behaviour video

Dear 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.