Description of this paper





Question;Programming;Assignment 8 Instructions;General Background Information;CMS Systems, Inc. is a company that provides information;systems consulting services to companies in the telecom industry in the United;States and the United Kingdom. Due to;its success, CMS is hoping to expand its operations into other parts of;Europe. Despite its large size, CMS;currently uses a manual/spreadsheet-based process for maintaining employee and;client data. Management has now decided;to implement a company-wide application that will keep track of all of its;employees? hours, calculate employee payroll, and produce invoices for clients;based on hours worked by employees.;CMS currently employs 1,500 individuals (900 in the US and;600 in the UK) who serve as systems analysts, developers, managers, testers;maintenance engineers, accountants, lawyers, and sales representatives.;The company also has more than 200 clients in the US and UKx. Clients can have one or more contracts with;CMS to provide a variety of consulting services. For example, a single client might have one;contract for maintenance of an existing system and also have another contract;(sometimes called a work order by the sales force) for the development of a new;system.;Some clients are billed based upon negotiated contracts;which stipulate a pre-determined amount for charges --regardless of the number;of hours that employees actually work on the contracts. Such contracts are called ?fixed price?;contracts. Other clients are billed;based on the total number of hours provided by CMS employees multiplied by a;rate per employee type per employee hour.;These arrangements are called ?T&M ? Time and Materials?;contracts. T&M contracts specify a;maximum of forty hours per week for which the client is willing to pay. Any amounts over 40 hours per week are not;billable, but are considered discounted hours.;For T&M contracts, the rate per hour for each consultant;is determined by the employee?s level of expertise. For example, a client pays $100/hour for an;employee who is at the level of Systems Analyst I. That same client pay $250/hour for an;employee designated as a Manager II.;T&M and Fixed Price contracts are the only two types of;contracts currently used by CMS.;All CMS employees must keep a record of the time they spend;working for each client on a weekly basis.;Because employees can work for more than one client and perform;different functions for each client, CMS utilizes ?project management? to keep;track of employee assignments to client contracts. Employees can be assigned to work on more;than one project at a given time. In;fact, it is not unusual for an employee to spend time on two or more different;projects within the same day.;Just as a client can have more than one contract with CMS, a;contract can consist of more than one project.;For example, a contract for the development of a new system could be;fulfilled in multiple phases. Phase I;could include implementation at one client site using a group of consultants in;close proximity to that site. Phase II;could include implementation at a different site with a potentially different;set of consultants. Both of these phases;are considered separate projects, even though they are governed by the same;contract.;The number of hours worked for each employee on each project;must be recorded on a weekly basis.;Employees currently log their time using an Excel worksheet. An example of this worksheet is presented;below. Notice that the employee?s;supervisor is listed on the worksheet. A;supervisor is currently required to approve his employees? timesheets by;placing his initials beside his name.;Deliverable;For this assignment, you are required to create the GUI for;a timekeeping/payroll system for CMS.;The system should first allow an employee to enter his name;and record the time he worked on each project for a given week. Using the spreadsheet above as a guideline;the system must allow the user to enter his name and the name of his;supervisor. Next, the user must enter;the number of the week for which he is entering time. Assume a maximum of 52 weeks in a year. Make sure the employee enters only a valid;week number.;To record an employee?s hours, the user must enter the name;of a client, a client?s contract and a project.;For each of the seven days in a week, the user must enter hours worked;or check a box that indicates the day is a weekend, a holiday, or a vacation;day. If the employee fails to enter any;hours for a day and fails to check the weekend/holiday/vacation box for that;day, the system should warn the user that the given day is missing;information. The system should also ensure;that if any work hours are entered for a day, the checkbox for that day should;NOT be checked. Finally, the system;should ensure that a user cannot enter more than 24 hours in a single day. Once the hours are entered, the user should;be able to ?Submit? his hours by clicking a button that will calculate his;payroll information for the week and display it on the same screen.;Payroll information;is calculated as follows;All employees are paid for hours worked at a rate of $15 US;dollars per hour. If the number of hours;worked in the week exceeds 40, the employee is paid time and a half for his overtime;hours. For example, assume an employee;works 50 hours during a week, he will receive (40 X $15) + (10 overtime hours X;(1.5 X $15)) = $825.00. If an employee;works less than 40 hours in a week, the system should make note of this fact in;a label beside the supervisor?s name. An;example payroll calculation is shown below;Payroll information for John Doe for the week ending Week 1;Total Hours Worked;42.00;Regular Hours Worked;40.00;Rate per regular work hour;$ 15.00;Regular Hourly Pay;$ 600.00;OverTime Hours Worked;2.00;Rate per overtime work hour;$ 22.50;Overtime Hourly Pay;$ 45.00;Gross Pay;$ 645.00;Number of Weekend/Holiday/Vacation days claimed;2


Paper#36813 | Written in 18-Jul-2015

Price : $29