ISPM 301 Assignment-5-Solution

ISPM 301 Assignment-5-Solution - box refers to the employee...

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

View Full Document Right Arrow Icon
Create an a Step 1: Step 2: Step 3:
Background image of page 1

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

View Full DocumentRight Arrow Icon
application that will calculate the regular and overtime pay of an employee and create a report We pay $12.50 / hour for up to 40 hours and pay time and a half on any hours worked over 40. Print Preview (do not print) the report for the user to see Add a graphic of your choice to the sheet and attach the macro to it Create a nicely formatted sheet in Excel to hold the employees Name, Hours Worked, Regular Pay, Overtime Pay and Total Pay. Write a macro that will ask the user for the employee's name and hours worked. Note that the second input
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: box refers to the employee by name. These two quantities should be stored in variables of the appropriate type. Assume that the user will enter appropriate data error free. Place the information the user provides in appropriate cells and calculate the regular pay, overtime pay and total pay. These calculations must be done in vba and not Excel. Place the calculated values in the approriate cells. Butler's Brickyard Pay Stub Name Sarah Rice Hours 62 Regular Pay $500.00 Overtime Pay $412.50 Total Pay $912.50...
View Full Document

Page1 / 3

ISPM 301 Assignment-5-Solution - box refers to the employee...

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