Problem
|
- Develop a
Visual Basic function to compute the total amount an employee would be
paid for a single week based on ...
- Number of
hours worked,
- Hourly rate,
- The fact
that hours over 35 are counted as overtime, or "time-and-a-half",
- Three
different Federal incone tax brackets (see below); No state income tax,
- Unions
dues, and
- Health
insurance
- Use this in
an Excel worksheet to compute the salaries for three employees as
follows
- Employee A:
- 25 hours
- $12/hour
- $20 union
dues
- $30
health insurance
- Employee B:
- 35 hours
- $15/hour
- No union
dues
- $50
health insurance
- Employee C:
- 60 hours
- $25/hour
- No union
dues
- $75
health insurance
|
Task
|
- Using the
Know/Need/Do approach, develop a set of equations.
- Create a hand
drawn version of your worksheet layout.
- Convert your
equations into formulas, using your layout.
- Enter
values, formulas and labels into your worksheet and print out the final
result with (a) formulas turned on (see note below) and (b) formulas
turned off.
- Submit:
- a brief
description of your Know/Need/Do process
- your list
of equations
- a copy of
your layout drawing
- your list
of formulas
- printouts
of your completed worksheet as described above
|
Notes
|
- Federal
income tax brackets:
- Feel free to
do more than what is asked above, but note that if you do, you will
neither lose nor gain points for the extra work.
- To "turn on
formulas"
- From the
Tools menu choose Options ...
- Click on
the View tab
- Under
Window Options check Formulas
- Click on OK
|