logo Hurry, Grab up to 30% discount on the entire course
Order Now logo

Ask This Question To Be Solved By Our ExpertsGet A+ Grade Solution Guaranteed

expert
Bill BaileyLaw
(5/5)

903 Answers

Hire Me
expert
Hardik DixitSociology
(5/5)

937 Answers

Hire Me
expert
Rory BremnerComputer science
(5/5)

909 Answers

Hire Me
expert
Milan JoshiSocial sciences
(5/5)

815 Answers

Hire Me
Python Programming

Write a program that processes employee data (name, hours worked, pay rate) from an Excel spreadsheet and add that processed pay for the employees to the spreadsheet.

INSTRUCTIONS TO CANDIDATES
ANSWER ALL QUESTIONS

Lab Instructions:

Description:

Payroll is an important activity within a firm.  Everyone wants to be paid for their work!  In this firm, employees are paid on a weekly basis and everyone is an hourly employee.  Write a program that processes employee data (name, hours worked, pay rate) from an Excel spreadsheet and add that processed payments for the employees to the spreadsheet.  In addition, your program should be able to process any number of employees and their pay (while we are providing you with a test file, the file that is used by the grader to evaluate your code may have more or less records in it).  Your program should be able to read data from the spreadsheet and allow for a processed pay amount to be created/added to that spreadsheet for the employee based on the results of processing the payroll.

Some general ideas about the program:

  • Your program must process the data to be found in an Excel spreadsheet that will be on the TA’s computer and stored in the following spreadsheet file: C:\MGMT28800\payroll.xlsx (pay special attention to the path and the spelling so that your program will run correctly).

  • You do not know how many employees will be in the spreadsheet, so your code will need to be able to figure that out to process the spreadsheet successfully.

  • You must use a function (with arguments and a return) to calculate the pay for the period and you must pass it the rate and hours worked and receive the employee’s pay for the period.

  • Employees can be paid overtime pay. The overtime rate is 150% of their rate for each hour they work in excess of 40 hours.  No employee can work more than 80 hours.  As such, your code must look for this issue and print a message that Indicates the employee’s name and that they have an hour violation (e.g., “Bob Smith has more than 80 hours worked”).  You may use any way of accomplishing this that you have learned this semester, provided that it is efficient/effective.  In addition to the error message being written to the console (screen), you should add the word “Error” to the field where you would have stored the calculated pay in the spreadsheet.  Otherwise, if payment can be calculated correctly, then you should write the calculated payment amount to the spreadsheet (hint: this will be in a new field on the same row as the other employee data).  

  • The final output for the assignment will be the updated C:\MGMT28800\payroll.xlsx file that contains the original data PLUS the calculated pay for each employee based on the hours and rate found in the rates and hours fields (the calculated pay will be a new field added to the Excel spreadsheet on the row corresponding to the employee) as well as the displayed/printed console of error messages for employees with more than 80 hours.

  • this instruction will result in the loss of 10% on the assignment.

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme