Bis Final

In: Business and Management

Submitted By jdweekley
Words 2271
Pages 10
1. (TCO 1) You work for a local construction firm, "DeVry Engineering Group" and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll for “15” employees with the following assumptions:

Note: This is a one part question.

• Each employee could have a standard hourly rate between $10.00 and $30.00 per hour.
• Each employee qualifies to earn overtime at a rate of 1.5 of his or her hourly rate for every hour greater than 40 hours.
• Each employee will have a standard 7.65% deduction for social security
• Each employee will have a standard 14.00% deduction for Federal Taxes
• Each employee will have a standard 5.33% deduction for State Taxes Explain how you will structure and format your worksheet, including titles, column headings, and formulas to calculate payroll variables for each employee to determine "Net Pay" including and not limited to Total Hours, Gross Pay, Social Security Tax, Federal Withholding Tax, and Sate Withholding Tax. In addition, determine how you would extract overtime hours from a calculated value of "Total Hours" using a conditional formula.

In addition, your supervisor will need this weekly payroll report on a weekly basis and instructed you to keep the payroll history of all weeks within "1" workbook but has allowed you to decide if you would rather keep the payroll running on one worksheet or by assigning a new worksheet for each week. Using your knowledge learned in this class, descriptively explain whether you would keep all weekly payrolls in one worksheet or assigned to new worksheets by week. Defend your reasoning's on the approach your take based on what you have learned in this course.(Points : 40)The creation of the Weekly Payroll WorkbookSince this is a weekly payroll for construction workers, the computation for Excel…...

Similar Documents

Bis 155 Final Exam

...BIS 155 Final Exam Purchase here http://chosecourses.com/BIS%20155/bis-155-final-exam Product Description 1. (TCO 1) You work for a local construction firm, "DeVry Engineering Group" and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll for “15” employees with the following assumptions: • Each employee could have a standard hourly rate between $10.00 and $30.00 per hour. • Each employee qualifies to earn overtime at a rate of 1.5 of his or her hourly rate for every hour greater than 40 hours. • Each employee will have a standard 7.65% deduction for social security • Each employee will have a standard 14.00% deduction for Federal Taxes • Each employee will have a standard 5.33% deduction for State Taxes Explain how you will structure and format your worksheet, including titles, column headings, and formulas to calculate payroll variables for each employee to determine "Net Pay" including and not limited to Total Hours, Gross Pay, Social Security Tax, Federal Withholding Tax, and Sate Withholding Tax. In addition, determine how you would extract overtime hours from a calculated value of "Total Hours" using a conditional formula. In addition, your supervisor will need this weekly payroll report on a weekly basis and instructed you to keep the payroll history of all weeks within "1" workbook but has allowed you to decide if you would rather......

Words: 938 - Pages: 4

Bis 155 Final Exam

...BIS 155 Final Exam Purchase here http://devrycourse.com/bis-155-final-exam Product Description 1. (TCO 1) You work for a local construction firm, "DeVry Engineering Group" and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll for “15” employees with the following assumptions: • Each employee could have a standard hourly rate between $10.00 and $30.00 per hour. • Each employee qualifies to earn overtime at a rate of 1.5 of his or her hourly rate for every hour greater than 40 hours. • Each employee will have a standard 7.65% deduction for social security • Each employee will have a standard 14.00% deduction for Federal Taxes • Each employee will have a standard 5.33% deduction for State Taxes Explain how you will structure and format your worksheet, including titles, column headings, and formulas to calculate payroll variables for each employee to determine "Net Pay" including and not limited to Total Hours, Gross Pay, Social Security Tax, Federal Withholding Tax, and Sate Withholding Tax. In addition, determine how you would extract overtime hours from a calculated value of "Total Hours" using a conditional formula. In addition, your supervisor will need this weekly payroll report on a weekly basis and instructed you to keep the payroll history of all weeks within "1" workbook but has allowed you to decide if you would rather keep the payroll......

Words: 936 - Pages: 4

Bis 155 Final Exam

...BIS 155 Final Exam Purchase here http://chosecourses.com/BIS%20155/bis-155-final-exam Product Description 1. (TCO 1) You work for a local construction firm, "DeVry Engineering Group" and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll for “15” employees with the following assumptions: • Each employee could have a standard hourly rate between $10.00 and $30.00 per hour. • Each employee qualifies to earn overtime at a rate of 1.5 of his or her hourly rate for every hour greater than 40 hours. • Each employee will have a standard 7.65% deduction for social security • Each employee will have a standard 14.00% deduction for Federal Taxes • Each employee will have a standard 5.33% deduction for State Taxes Explain how you will structure and format your worksheet, including titles, column headings, and formulas to calculate payroll variables for each employee to determine "Net Pay" including and not limited to Total Hours, Gross Pay, Social Security Tax, Federal Withholding Tax, and Sate Withholding Tax. In addition, determine how you would extract overtime hours from a calculated value of "Total Hours" using a conditional formula. In addition, your supervisor will need this weekly payroll report on a weekly basis and instructed you to keep the payroll history of all weeks within "1" workbook but has allowed you to decide if you would rather keep......

Words: 938 - Pages: 4

Bis 220 Final Exam

...BIS 220 Final Exam To Purchase this Tutorial Copy And Paste Below Link In Your Browser http://www.homework-bank.com/downloads/bis-220-final-exam/ For Any Information or Any Class Which you Did not find on Our Website , Just Hit US Email On below address Email Address: hworkbank@gmail.com Visit Our Website : http://www.homework-bank.com/ BIS 220 Final Exam 1) Two information systems that support the entire organization are 2) _______ is the direct use of information systems by employees in their work. 3) ______ attempt to duplicate the work of human experts by applying reasoning capabilities. 4) ______ issues involve who may obtain information and how much they should pay for this information. 5) _____ issues involve collecting, storing, and disseminating information about individuals. 6) Your company’s computers have been taken over by an attacker and used to attack another organization’s information systems. Your problem is which of the following? 7) You are the only person in your office to upgrade to Microsoft® Word 2010. Before you share documents with coworkers, you should do which of the following? 8) Which of the following is detected by the contextual spelling checker? 9) If your cursor is near the bottom of a page and you want to display the next paragraph you type at the top of a new page, you should use which of the following? 10) Your ______ is the collection of traceable data that is captured when you use various information technologies such as...

Words: 564 - Pages: 3

Bis 155 Final Exam

...A++PAPER;http://www.homeworkproviders.com/shop/bis-155-final-exam/ BIS 155 FINAL EXAM BIS 155 FINAL EXAM,1. (TCO 1) You work for a local construction firm, "DeVry Engineering Group" and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll for “15” employees with the following assumptions: • Each employee could have a standard hourly rate between $10.00 and $30.00 per hour. • Each employee qualifies to earn overtime at a rate of 1.5 of his or her hourly rate for every hour greater than 40 hours. • Each employee will have a standard 7.65% deduction for social security • Each employee will have a standard 14.00% deduction for Federal Taxes • Each employee will have a standard 5.33% deduction for State Taxes Explain how you will structure and format your worksheet, including titles, column headings, and formulas to calculate payroll variables for each employee to determine "Net Pay" including and not limited to Total Hours, Gross Pay, Social Security Tax, Federal Withholding Tax, and Sate Withholding Tax. In addition, determine how you would extract overtime hours from a calculated value of "Total Hours" using a conditional formula. In addition, your supervisor will need this weekly payroll report on a weekly basis and instructed you to keep the payroll history of all weeks within "1" workbook but has allowed you to decide if you would rather keep the...

Words: 940 - Pages: 4

Bis 220 Final Exam

...A++PAPER;http://www.homeworkproviders.com/shop/bis-220-final-exam/ BIS 220 FINAL EXAM BIS 220 FINAL EXAM, 1) Two information systems that support the entire organization are BIS 220 final exam question 2) _______ is the direct use of information systems by employees in their work 3) ______ attempt to duplicate the work of human experts by applying reasoning capabilities 4) ______ issues involve who may obtain information and how much they should pay for this information Bis 220 final exam 5) _____ issues involve collecting, storing, and disseminating information about individuals. 6) Your company’s computers have been taken over by an attacker and used to attack another organization’s information systems. Your problem is which of the following? 7) You are the only person in your office to upgrade to Microsoft® Word 2010. Before you share documents with coworkers, you should do which of the following? BIS 220 Final Exam 8) Which of the following is detected by the contextual spelling checker? bis 220 final exam 9) If your cursor is near the bottom of a page and you want to display the next paragraph you type at the top of a new page, you should use which of the following? 10) Your ______ is the collection of traceable data that is captured when you use various information technologies such as credit cards or the Internet 11) No alphabetic characters in a social security number field is an example of 12) In a database, the primary key...

Words: 537 - Pages: 3

Bis 155 Final Exam

...BIS 155 Final Exam Purchase here http://devrycourse.com/bis-155-final-exam Product Description 1. (TCO 1) You work for a local construction firm, "DeVry Engineering Group" and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll for “15” employees with the following assumptions: • Each employee could have a standard hourly rate between $10.00 and $30.00 per hour. • Each employee qualifies to earn overtime at a rate of 1.5 of his or her hourly rate for every hour greater than 40 hours. • Each employee will have a standard 7.65% deduction for social security • Each employee will have a standard 14.00% deduction for Federal Taxes • Each employee will have a standard 5.33% deduction for State Taxes Explain how you will structure and format your worksheet, including titles, column headings, and formulas to calculate payroll variables for each employee to determine "Net Pay" including and not limited to Total Hours, Gross Pay, Social Security Tax, Federal Withholding Tax, and Sate Withholding Tax. In addition, determine how you would extract overtime hours from a calculated value of "Total Hours" using a conditional formula. In addition, your supervisor will need this weekly payroll report on a weekly basis and instructed you to keep the payroll history of all weeks within "1" workbook but has allowed you to decide if you would rather keep the payroll......

Words: 936 - Pages: 4

Bis 155 Final Exam

...BIS 155 Final Exam Purchase here http://devrycourse.com/bis-155-final-exam Product Description 1. (TCO 1) You work for a local construction firm, "DeVry Engineering Group" and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll for “15” employees with the following assumptions: • Each employee could have a standard hourly rate between $10.00 and $30.00 per hour. • Each employee qualifies to earn overtime at a rate of 1.5 of his or her hourly rate for every hour greater than 40 hours. • Each employee will have a standard 7.65% deduction for social security • Each employee will have a standard 14.00% deduction for Federal Taxes • Each employee will have a standard 5.33% deduction for State Taxes Explain how you will structure and format your worksheet, including titles, column headings, and formulas to calculate payroll variables for each employee to determine "Net Pay" including and not limited to Total Hours, Gross Pay, Social Security Tax, Federal Withholding Tax, and Sate Withholding Tax. In addition, determine how you would extract overtime hours from a calculated value of "Total Hours" using a conditional formula. In addition, your supervisor will need this weekly payroll report on a weekly basis and instructed you to keep the payroll history of all weeks within "1" workbook but has allowed you to decide if you would rather keep the payroll......

Words: 936 - Pages: 4

Bis 155 Final Exam

...BIS 155 Final Exam Purchase here http://devrycourse.com/bis-155-final-exam Product Description 1. (TCO 1) You work for a local construction firm, "DeVry Engineering Group" and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll for “15” employees with the following assumptions: • Each employee could have a standard hourly rate between $10.00 and $30.00 per hour. • Each employee qualifies to earn overtime at a rate of 1.5 of his or her hourly rate for every hour greater than 40 hours. • Each employee will have a standard 7.65% deduction for social security • Each employee will have a standard 14.00% deduction for Federal Taxes • Each employee will have a standard 5.33% deduction for State Taxes Explain how you will structure and format your worksheet, including titles, column headings, and formulas to calculate payroll variables for each employee to determine "Net Pay" including and not limited to Total Hours, Gross Pay, Social Security Tax, Federal Withholding Tax, and Sate Withholding Tax. In addition, determine how you would extract overtime hours from a calculated value of "Total Hours" using a conditional formula. In addition, your supervisor will need this weekly payroll report on a weekly basis and instructed you to keep the payroll history of all weeks within "1" workbook but has allowed you to decide if you would rather keep the payroll......

Words: 936 - Pages: 4

Bis 155 Final Exam

...BIS 155 Final Exam Purchase here http://homeworkonestop.com/BIS%20155/bis-155-final-exam Product Description 1. (TCO 1) You work for a local construction firm, "DeVry Engineering Group" and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll for “15” employees with the following assumptions: • Each employee could have a standard hourly rate between $10.00 and $30.00 per hour. • Each employee qualifies to earn overtime at a rate of 1.5 of his or her hourly rate for every hour greater than 40 hours. • Each employee will have a standard 7.65% deduction for social security • Each employee will have a standard 14.00% deduction for Federal Taxes • Each employee will have a standard 5.33% deduction for State Taxes Explain how you will structure and format your worksheet, including titles, column headings, and formulas to calculate payroll variables for each employee to determine "Net Pay" including and not limited to Total Hours, Gross Pay, Social Security Tax, Federal Withholding Tax, and Sate Withholding Tax. In addition, determine how you would extract overtime hours from a calculated value of "Total Hours" using a conditional formula. In addition, your supervisor will need this weekly payroll report on a weekly basis and instructed you to keep the payroll history of all weeks within "1" workbook but has allowed you to decide if you would rather...

Words: 938 - Pages: 4

Bis 220 Final Exam

...BIS 220 FINAL EXAM A+ Graded Tutorial Available At: http://hwsoloutions.com/?product=final-exam-7 Visit Our website: http://hwsoloutions.com/ Product Description BIS 220 FINAL EXAM, 1) Two information systems that support the entire organization are BIS 220 final exam question 2) _______ is the direct use of information systems by employees in their work 3) ______ attempt to duplicate the work of human experts by applying reasoning capabilities 4) ______ issues involve who may obtain information and how much they should pay for this information Bis 220 final exam 5) _____ issues involve collecting, storing, and disseminating information about individuals. 6) Your company’s computers have been taken over by an attacker and used to attack another organization’s information systems. Your problem is which of the following? 7) You are the only person in your office to upgrade to Microsoft® Word 2010. Before you share documents with coworkers, you should do which of the following? BIS 220 Final Exam 8) Which of the following is detected by the contextual spelling checker? bis 220 final exam 9) If your cursor is near the bottom of a page and you want to display the next paragraph you type at the top of a new page, you should use which of the following? 10) Your ______ is the collection of traceable data that is captured when you use various information technologies such as credit cards or the Internet 11) No alphabetic characters in a social security number......

Words: 547 - Pages: 3

Bis 155 Final Exam

...BIS 155 Final Exam Purchase here http://homeworkonestop.com/BIS%20155/bis-155-final-exam Product Description 1. (TCO 1) You work for a local construction firm, "DeVry Engineering Group" and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll for “15” employees with the following assumptions: • Each employee could have a standard hourly rate between $10.00 and $30.00 per hour. • Each employee qualifies to earn overtime at a rate of 1.5 of his or her hourly rate for every hour greater than 40 hours. • Each employee will have a standard 7.65% deduction for social security • Each employee will have a standard 14.00% deduction for Federal Taxes • Each employee will have a standard 5.33% deduction for State Taxes Explain how you will structure and format your worksheet, including titles, column headings, and formulas to calculate payroll variables for each employee to determine "Net Pay" including and not limited to Total Hours, Gross Pay, Social Security Tax, Federal Withholding Tax, and Sate Withholding Tax. In addition, determine how you would extract overtime hours from a calculated value of "Total Hours" using a conditional formula. In addition, your supervisor will need this weekly payroll report on a weekly basis and instructed you to keep the payroll history of all weeks within "1" workbook but has allowed you to decide if you would rather...

Words: 938 - Pages: 4

Bis 155 Final Exam

...BIS 155 Final Exam Purchase here http://homeworkonestop.com/BIS%20155/bis-155-final-exam Product Description 1. (TCO 1) You work for a local construction firm, "DeVry Engineering Group" and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll for “15” employees with the following assumptions: • Each employee could have a standard hourly rate between $10.00 and $30.00 per hour. • Each employee qualifies to earn overtime at a rate of 1.5 of his or her hourly rate for every hour greater than 40 hours. • Each employee will have a standard 7.65% deduction for social security • Each employee will have a standard 14.00% deduction for Federal Taxes • Each employee will have a standard 5.33% deduction for State Taxes Explain how you will structure and format your worksheet, including titles, column headings, and formulas to calculate payroll variables for each employee to determine "Net Pay" including and not limited to Total Hours, Gross Pay, Social Security Tax, Federal Withholding Tax, and Sate Withholding Tax. In addition, determine how you would extract overtime hours from a calculated value of "Total Hours" using a conditional formula. In addition, your supervisor will need this weekly payroll report on a weekly basis and instructed you to keep the payroll history of all weeks within "1" workbook but has allowed you to decide if you would rather...

Words: 938 - Pages: 4

Bis 155 Final Exam

...BIS 155 Final Exam Purchase here http://homeworkonestop.com/BIS%20155/bis-155-final-exam Product Description 1. (TCO 1) You work for a local construction firm, "DeVry Engineering Group" and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll for “15” employees with the following assumptions: • Each employee could have a standard hourly rate between $10.00 and $30.00 per hour. • Each employee qualifies to earn overtime at a rate of 1.5 of his or her hourly rate for every hour greater than 40 hours. • Each employee will have a standard 7.65% deduction for social security • Each employee will have a standard 14.00% deduction for Federal Taxes • Each employee will have a standard 5.33% deduction for State Taxes Explain how you will structure and format your worksheet, including titles, column headings, and formulas to calculate payroll variables for each employee to determine "Net Pay" including and not limited to Total Hours, Gross Pay, Social Security Tax, Federal Withholding Tax, and Sate Withholding Tax. In addition, determine how you would extract overtime hours from a calculated value of "Total Hours" using a conditional formula. In addition, your supervisor will need this weekly payroll report on a weekly basis and instructed you to keep the payroll history of all weeks within "1" workbook but has allowed you to decide if you would rather...

Words: 4686 - Pages: 19

Bis 155 Final Exam

...BIS 155 FINAL EXAM To purchase this tutorial visit here: http://mindsblow.us/question_des/BIS155FINALEXAM/74 contact us at: help@mindblows.us BIS 155 FINAL EXAM BIS 155 Final Exam 1. (TCO 1) You work for a local construction firm, “DeVry Engineering Group” and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll for “15” employees with the following assumptions: • Each employee could have a standard hourly rate between $10.00 and $30.00 per hour. • Each employee qualifies to earn overtime at a rate of 1.5 of his or her hourly rate for every hour greater than 40 hours. • Each employee will have a standard 7.65% deduction for social security • Each employee will have a standard 14.00% deduction for Federal Taxes • Each employee will have a standard 5.33% deduction for State Taxes Explain how you will structure and format your worksheet, including titles, column headings, and formulas to calculate payroll variables for each employee to determine “Net Pay” including and not limited to Total Hours, Gross Pay, Social Security Tax, Federal Withholding Tax, and Sate Withholding Tax. In addition, determine how you would extract overtime hours from a calculated value of “Total Hours” using a conditional formula. In addition, your supervisor will need this weekly payroll report on a weekly basis and instructed you to keep the payroll history of all weeks within “1”......

Words: 1901 - Pages: 8

Bête noire "Condamné plaider" | Haikyu!! | Passenger | Let Her Go (Official Video).mp3