Chen earns an annual salary of $72 800. He is entitled to four weeks annual leave with 17.5% leave loading. A spreadsheet is used to calculate his total holiday pay.
Total holiday pay = 4 × weekly wage + 4 × weekly wage × 17.5%
A spreadsheet showing Chen's holiday pay calculation is shown.
- What value from the question should be entered in cell B5? (1 mark)
--- 1 WORK AREA LINES (style=lined) ---
- Write down the formula used in cell B9 to calculate the weekly wage, using appropriate grid references. (2 marks)
--- 2 WORK AREA LINES (style=lined) ---
- Verify the amount of Chen's total holiday pay using calculations. (2 marks)
--- 5 WORK AREA LINES (style=lined) ---