Page 17 - SOLUTIONS TO PRACTICAL APPLICATION FNSACC313 V3 .doc

Perform Financial Calculations

On your computer, make a folder for the files for calculating petty cash for the four fortnights
from 4 November 20XX to 16 December 20XX. Move the four files for these calculations into
the folder in the correct order.

USING SIMPLE SPREADSHEETS TO PERFORM REPEATED CALCULATIONS

PRACTICAL APPLICATION 1
Open the file July 20XX to June 20X1 Quarterly Leave Balances and update fourth quarter
details using the following figures and save the file appropriately. The opening balance for
the fourth quarter is the current balance for the third quarter.

LEAVE BALANCES OF STAFF (IN HOURS) QUARTER THREE 20XX/20X1
EMPLOYEE OPENING BALANCE QUARTERLY LEAVE CURRENT BALANCE
ACCRUED
H Wilson 129.14 0 129.14
M Howard 125 10 135
B Canton 84 14 98
I M Reader SOLUTIONS 30 127
97
P Bradley 42 10 52

LEAVE BALANCES OF STAFF (IN HOURS) QUARTER FOUR 20XX/20X1
EMPLOYEE OPENING BALANCE QUARTERLY LEAVE CURRENT BALANCE
ACCRUED
H Wilson 129.14 10 139.14
M Howard 135 14 139
B Canton 98 4 102
I M Reader 127 22 149
P Bradley 52 8 60

PRACTICAL APPLICATION 2

Open the file Product Price List and calculate the GST and Total Price for the products.

PRODUCT GROSS PRICE (no GST) GST TOTAL PRICE
Plaster $100.00 $10.00 $110.00
Cornice $45.00 $4.30 $49.30
Back Mesh $44.00 $4.00 $48.00
Battens $31.90 $3.19 $35.09
Gyprock $230.95 $23.10 $254.05

Anne Bowden ©2020
17