You are to build a spreadsheet to handle the payroll for a restaurant.
Background
The restaurant has up to 10 employees who are paid weekly.
Each employee has an employee number.
The hospitality award is fairly messy with different jobs being given a different grading.
There are 4 possible grading in this particular business.
The payrate per hour also differs depending on which day the work is performed.
For work performed on Week days
Work on Saturdays is paid at time and a half.
Work on Sundays is paid at time and three quarters.
Work on Public Holidays is paid at double time.
In addition any week night,where work occurs after 7pm, a penalty of $1.04 per day is paid.
Tax deducted from the employees is calculated as 1/3 of the gross pay.
The spreadsheet should record
The spreadsheet should be capable of displaying the Gross, Tax and Nett pays for all the employees for each pay.
Restaurant are required by government to keep records of their payroll therefore as each pay is calculated your spreadsheet should keep a record of each pay for every employee.
It should be possible to easily ascertain from the spreadsheet
How much has been paid to an employee
How much tax has been deducted from all employees
How much is the cheque for nett pay for a particular week.
You should make the spreadsheet as user friendly as possible by creating your own menus or dialogs and buttons.
You should create a pair an auto_open() and auto_close() macro to simplify the user interface by removing
and replacing them when your spreadsheet closes.
Help and instructions should be available from within the program.
If you have been patient enough to read all the way to here you can now reap your reward.
There is a sample solution to this assignment on the cdrom in the file payroll.xls.
There is also a Windows Help file in the same directory called payroll.hlp which explains parts of the program.
If you are offsite email me and I will send you the files.
You are required to use Excel 97, 2000 or XP
Submit the assignment on a disc or via email to your tutor.
The assignment must be completed before the final week of the course.