gg-2 - and gross pay (the sum of regular and all overtime...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Goodpay Payroll System Problem Narrative ( r 3/22/10 dd) Goodpay wants you to develop a program it can use to calculate pay for Goodpay’s employees. Sometimes employees work over 40 hours a week. Management wants to reward employees when they work long hours so they have implemented the following overtime policy: Process Logic When a worker works 40 hours or less, gross pay is calculated by multiplying the hourly rate by the hours worked. When a worker works more than 40 and up to 80 hours a week, they get time and half of their normal hourly rate for the hours over 40. If employees work over 80 hours a week, they get double time for hours over 80 hours. The program algorithm will calculate gross pay from payroll data (employee name, week-ended date, pay rate, and the number of hours worked during the week). The program should print the employee name, week-ended date, pay rate, hours worked, regular pay for hour not exceeding 40 hours, overtime pay for hours over 40 and up to 80, and double overtime pay for hours over 80,
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: and gross pay (the sum of regular and all overtime pay). Your finished program should look like the spreadsheet view shown at the right. An example of this spreadsheet without the VBA and the button is provided with this problem. Note: for convenience sake, we have included abbreviated variable names that correspond with those on the flowchart. Required 1. Prepare a flowchart to express the logic of this process. 2. Implement this problem in Excel using VBA PL1 - Goodpay Payroll Start Input N, D, R, H H > 40? OP1 = 1.5 * R * (H - 40) OP2 = 0 GP = RP + OP1 + OP2 Print (N, D, R, H), RP, OP1, OP2, GP End True False H > 80 True OP1 = 1.5 * R * 40 OP2 = 2 * R * (H - 80) False VARIABLE LEGEND INPUT VARIABLES N = Employee Name D = Week-Ended Date R = Pay Rate (hourly) H = Hours Worked NON-INPUT VARIABLES RP = Regular Pay OP1 = 1.5 pay for hrs > 40 up to 80 OP2 = Double pay for hours >80 GP = Gross Pay RP = R * H OP1 = 0 OP2 = 0 Rev: 3-17-10 dld RP = R * 40 GoodPay Code That Corresponds to the Flowchart...
View Full Document

This note was uploaded on 04/07/2011 for the course ISYS 200 taught by Professor Dean during the Winter '11 term at BYU.

Page1 / 3

gg-2 - and gross pay (the sum of regular and all overtime...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online