Priya works as a sales representative and earns a base wage plus commission. A spreadsheet is used to calculate her weekly earnings.
Total weekly earnings = Base wage + Total sales \(\times\) Commission rate
A spreadsheet showing Priya's weekly earnings is shown.
- Write down the formula used in cell B9, using appropriate grid references. (1 mark)
--- 1 WORK AREA LINES (style=lined) ---
- In the following week, Priya earned total weekly earnings of $1437.50. Her base wage and commission rate remained unchanged. Calculate Priya's total sales for that week. (2 marks)
--- 5 WORK AREA LINES (style=lined) ---
- Priya's employer increases her commission rate to 4.2% but keeps her base wage the same. If Priya makes $22 000 in sales, calculate her new total weekly earnings. (2 marks)
--- 5 WORK AREA LINES (style=lined) ---