Use a spreadsheet to display examples of the above computations when multiple or repeated computations are required, e.g. preparing a wage sheet displaying the weekly earnings of workers in an organisation, preparing a budget, investigating the potential cost of owning and operating a car over a year.

A local courier company uses a spreadsheet to calculate weekly delivery costs for its drivers. The spreadsheet records driver name, number of deliveries completed, and calculates total weekly cost using a flat fee of $45 per week plus $2.50 per delivery. Which spreadsheet formula correctly calculates the total weekly cost for a driver in row 3, where cell B3 contains the number of deliveries?

A small catering business prepares a weekly pay sheet for its five staff members. The hourly rates and hours worked are shown below. (a) Calculate the gross weekly wage for each employee (hourly rate × hours worked). [1] (b) The business deducts tax at 20% of gross wage and superannuation at 9.5% of gross wage. Calculate the net weekly wage for each employee (gross wage − tax − superannuation), correct to the nearest cent. [1] (c) Determine the total weekly payroll cost (sum of all net wages). [1] Employee data: - Alice: \$18.50/hour, 38 hours - Bryn: \$16.75/hour, 35 hours - Celia: \$19.25/hour, 40 hours - Darren: \$17.00/hour, 36 hours - Elena: \$18.00/hour, 39 hours