Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

AAT L3 MATS > EQUATIONS > Flashcards

EQUATIONS Flashcards

1
Q

Equation for Breakeven points in Units?

A

Fixed Costs/Unit Contribution

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Equation for Breakeven point in Revenue?

A

Breakeven point in units x Selling Price

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Equation to work out Target Units?

A

Fixed Costs + Target Profit/Unit Contribution

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

How do you work out the Target Revenue?

A

Target Units x Selling Price

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

How do you work out the Margin of Safety in units?

A

Budget or Actual Sales - breakeven in units (sales volume)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is the profit/volume or contribution/sales ratio?

A

unit contribution/unit price x 100

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is the equation to calculate the breakeven using c/s ratio?

A

Fixed costs + Target profit/Contribution to sales ratio

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

How do you work out the Variable cost per unit?

A

Difference in cost/Difference in activity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

How do you work out OAR?

A

Budgeted costs/budgeted activity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is Marginal costing?

A

Only uses variable costings

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Difference in profit for Marginal and absorption costing

A

Inventory movement x OAR

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What does SIAM mean?

A

Stock Increasing means Absorption will have More profit

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

How do you work out M.O.S in percent?

A

M.O.S in units/budgeted actual sales x 100

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

How to work out Trade receivables collection period?

A

Receivables / Sales x 365

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

How to work out Trade payables collection period?

A

Payables / Cost of Sales x 365

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q
A
17
Q

How do you work out inventory holding days.

A

Inventory/ cost of sales x 365

18
Q

How do you work out Variance for Flexed Budgets?

A

Actual - Flexed

19
Q

How do you work out Percentage of Variance?

A

Variance/Flexed

20
Q

How to work out VLOOKUP?
Lookup_Value -
Table_array -
Col_Index_num -

A

Lookup_Value - First in column to match (Product code)
Table_array - Table to match with ($ around the Letters)
Col_Index_num - Number of column from Table array

21
Q

When allocating what is insurance put as?

A

Carrying Value (Depreciation)

22
Q

When allocating what is Facilities as?

A

Floorspace

23
Q

How do you work out Total sales Revenue?

A

Fixed costs/C/S Ratio

24
Q

How do you work out profit mark up in percentage?

A

Using the percentage format do Profit/Total costs

25
Q

How to do Sumif?

A

Range,>350,Range again

26
Q

How do you work out working capital cycle?

A

Inventory days + receivable days - payable days

27
Q

When doing flexed budgets, what is the equation for Revenue?

A

Actual/Flexed

28
Q

When doing flexed budgets, what is the equation for Expenses?

A

Flexed/Actual

29
Q

How do you lock some cells on a protected sheet?

A

Format the cells

30
Q

How do you work out Variances for flexed budgets in percentage?

A

Variance/Flexed x 100

31
Q

How do you put Variances % in excel without a Variance column for Revenue?

A

(Actual-Flexed)/Flexed

32
Q

How do you put Variances % in excel without a Variance column for Expenses?

A

(Flexed/Actual)/Flexed

AAT L3 MATS (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions