Excel Payroll Spreadsheet
Not what you're looking for?
You will enter in the correct Formulas or Functions needed to find out the monthly gross income for a Computer Repair Business. To view these instructions while working in Excel, print these instructions or move back and forth between your browser and Excel.
1.The Orange colored cells on the worksheet indicate places where you will
put in the formulas and functions.
2.Calculate the total Gross Pay for each employee. Keep in mind that employees are paid time and a half for all over-time hours. Here is an example formula that demonstrates how you would make such a calculation: =b4*d4+b4*c4*1.5 These must be formulas and will be entered into the range E11:E14.
3.In #5, #6, and #7 below you must include an absolute reference cell in each formula!!! Imagine while you are completing these steps that there were 150 employees at the company.
4.Calculate the total amount each employee must pay in Federal Taxes in the range F11:F14. These calculations must be completed using formulas. These formulas MUST contain an absolute reference to the cell holding the percentage amount. The percentage is above Federal in cell F9.
5.Calculate the total amount each employee must pay in State Taxes in the range G11:G14. These calculations must be completed using formulas. These formulas MUST contain an absolute reference to the cell holding the percentage amount. The percentage is above State in cell G9.
6.Calculate the total amount each employee must pay in Social Security Taxes in the range H11:H14. These calculations must be completed using formulas. These formulas MUST contain an absolute reference to the cell holding the percentage amount. The percentage is above Social in cell H9.
7.Calculate the total Net Pay for each employee in the range: I11:I14. These calculations must be completed using a formula.
8.Calculate the totals for all of the employee hours and pay categories in the range: B16:I16. These calculations must be completed using SUM functions.
9.Format all of the cells that represent a dollar amount as Currency with 2 decimal places.
Purchase this Solution
Solution Summary
The solution is contained in an Excel spreadsheet, complete with formulas and intermediary numbers required to complete the calculations.
Purchase this Solution
Free BrainMass Quizzes
Inserting and deleting in a linked list
This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.
Basic Networking Questions
This quiz consists of some basic networking questions.
Basic Computer Terms
We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.
Word 2010: Table of Contents
Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.
Java loops
This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.