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 = WeekEnded Date R = Pay Rate (hourly) H = Hours Worked NONINPUT 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: 31710 dld RP = R * 40 GoodPay Code That Corresponds to the Flowchart...
View
Full Document
 Winter '11
 Dean
 pay rate, Goodpay Payroll

Click to edit the document details