This preview has intentionally blurred sections. Sign up to view the full version.View Full 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
- Winter '11
- pay rate, Goodpay Payroll