We now consider a few problems to show how the problem solving process can be used
to develop worksheets.
Example 5.1Salary Calculation with Overtime
You are given the task of setting up a worksheet to calculate the weekly pay of the
employees of a company. The information given to you to set up the worksheet consists
of the names and identification numbers of the employees, their respective hourly pay
rates, and the number of hours worked. You are told the rule for determining salary,
which is as follows. If the number of hours worked is less than or equal to 40, the salary
is simply the ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.