Please perform each calculation in the same workbook, one question per worksheet.
You should rename the worksheets Exercise 1, Exercise 2, Exercise 3.
Exercise 1
A firm pays its salespersons by a commission system. Each unit costs €30 and each
salesperson is paid $5 per unit sold. As an added incentive, a bonus of 7% of the total
sales made should the salesperson’s sales exceed $1000 is awarded. Calculate the
wages earned by each of the salespersons.
Salesperson Units Sold
Jennifer Smith 34
Adrian Walshe 27
Norah Walker 38
Deirdre Connolly 29
Michael Durnin 44
Calculate the wages earned.
Now, calculate the wages earned in the following scenarios:
a) Each unit costs $25
b) The bonus threshold is $1300
Exercise 2
A shop is open Monday – Saturday and records the sales daily. Accounts are compiled
monthly. The VAT rate for all sales is paid at 21%. Calculate the total sales and VAT
paid for the month.
Day Week 1 Week 2 Week 3 Week 4
Monday $500 $470 $610 $440
Tuesday $600 $430 $480 $510
Wednesday $550 $420 $410 $560
Thursday $370 $560 $420 $620
Friday $750 $590 $540 $450
Saturday $800 $600 $610 $700
Caculate.
Calculate the sales and VAT in the following scenarios:
a) VAT is paid at 18%
b) Sales increase 10% across the board.
