Neco 2024 Computer Studies Question 1

An accountant uses a spreadsheet to compute weekly pay. Regular hours are paid at the rate in column B, overtime (hours beyond\(40\)) at 1.5\times that rate. Tax is applied progressively: 10\% on the first \(\text{₦}20\,000\), 15\% on the next \(\text{₦}30\,000\) and 20\% on any remaining amount. For employee John, the spreadsheet shows \(48\) hours worked and a rate of \(\text{₦}500\) per hour. (a) Calculate John's net pay after tax. (b) A summary report lists the net pay of 150 employees, one per line. Each line can contain at most 70 characters and a page can hold 40 lines. Assuming every line uses the maximum possible characters, how many pages are required for the report?