Calculations using Excel for Mathematics General and Standard.
Calculate the commission on sales.
where A2 is the rate of commission (entered as a percentage)
B2 is the amount of sales
Calculate the holiday pay.
0.175 for 17.5% holiday loading
where B3 is 4 weeks normal pay
Calculate net pay following deductions from gross pay.
where B1 is gross pay and B2 is the deductions