The sales department at Tinka Toys has 10 staff. The human resources department is currently reviewing the way that these staff are paid. They have decided to use one of the options below:
1. Pay all employees commission only (5% of what they sell)
2. Pay all employees get a weekly wage of £100 and then 2.5% commission on all sales over £1000
3. Pay all employees get a weekly wage of £25 and then 5% commission on all sales over £1000
Create a spreadsheet to calculate the gross pay for each employee if they sell £1000, £2000, £3000 and £4000 worth of stock for each of the three options.