Devry Bis 155 Final Exam-2015 August

In: Other Topics

Submitted By petersun
Words 924
Pages 4
Devry BIS 155 Final Exam-2015 AUGUST
IF You Want To Purchase A+ Work then Click The Link Below For Instant Down Load http://www.hwspeed.com/Devry-BIS-155-Final-Exam-2015-AUGUST-6785641024.htm?categoryId=-1 IF You Face Any Problem Then E Mail Us At JOHNMATE1122@GMAIL.COM
Question
Question 1.1.(TCO 1) You are the Payroll Manager for your employer. Your payroll clerk has submitted the worksheet displayed here. All employees earn their regular pay rate times the hours worked plus an overtime bonus of 50% of the hours worked in excess of 40 hours.

Part 1: Write a formula as if it were in Cell E2 that will calculate gross pay. Write the formula so that it may be copied to the other employees without modification.

Part 2: You must also calculate the Income Tax which is assessed at an accelerated rate as shown in the Tax Rate Table. Write a formula as if it were in Cell F2 that calculates the income tax for the first employee. Write the formula so that it may be copied to the other employees without modification.

Part 3: Hourly employees must pay union dues of $0.25 per hour on hours worked in excess of 25 hours up to and including 40 hours plus $0.35 per hour on all hours worked in excess of 40 hours. Write a formula as if it were in Cell G2 that calculates the union dues (if any) for the first employee. Write the formula so that it may be copied to the other employees without modification.

Part 4: Salaried and Exempt employees (Pay Codes E and S) are covered by the company’s health insurance. The deduction is $10.00 per week. Write a formula as if it were in Cell H2 that calculates the Insurance deduction (if any) for the first employee. Write the formula so that it may be copied to the other employees without modification. (Points : 40)

Question 2.2.(TCO 3) Your supervisor has e-mailed you a workbook that contains a lot of very…...

Similar Documents

Bis 155 Final Exam - Devry Latest

...BIS 155 Final Exam - DeVry Latest IF You Want To Purchase A+ Work Then Click The Link Below , Instant Download http://acehomework.com/BIS-155-Final-Exam-DeVry-12009932.htm?categoryId=-1 If You Face Any Problem E- Mail Us At JOHNMATE1122@Gmail.Com 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......

Words: 969 - Pages: 4

Bis 155 Final Exam - Devry Latest

...BIS 155 Final Exam - DeVry Latest IF You Want To Purchase A+ Work Then Click The Link Below , Instant Download http://acehomework.com/BIS-155-Final-Exam-DeVry-12009932.htm?categoryId=-1 If You Face Any Problem E- Mail Us At JOHNMATE1122@Gmail.Com 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......

Words: 969 - Pages: 4

Bis 155 Final Exam - Devry Latest

...BIS 155 Final Exam - DeVry Latest IF You Want To Purchase A+ Work Then Click The Link Below , Instant Download http://acehomework.com/BIS-155-Final-Exam-DeVry-12009932.htm?categoryId=-1 If You Face Any Problem E- Mail Us At JOHNMATE1122@Gmail.Com 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......

Words: 969 - Pages: 4

Bis 155 Final Exam - Devry

...BIS 155 Final Exam - DeVry IF You Want To Purchase A+ Work Then Click The Link Below , Instant Download http://www.hwnerd.com/BIS-155-Final-Exam-DeVry-2071.htm?categoryId=-1 If You Face Any Problem E- Mail Us At Contact.Hwnerd@Gmail.Com 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...

Words: 970 - Pages: 4

Bis 155 Final Exam - Devry

...BIS 155 Final Exam - DeVry IF You Want To Purchase A+ Work Then Click The Link Below , Instant Download http://www.hwnerd.com/BIS-155-Final-Exam-DeVry-2071.htm?categoryId=-1 If You Face Any Problem E- Mail Us At Contact.Hwnerd@Gmail.Com 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...

Words: 970 - Pages: 4

Bis 155 Final Exam - Devry

...BIS 155 Final Exam - DeVry BIS 155 Final Exam Answers Paste the Below Link into Your Browser To Purchase http://www.homeworkarena.com/bis-155-wk-8-final-exam-answers-devry 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......

Words: 952 - Pages: 4

Bis 155 Final Exam – Devry

...BIS 155 FINAL EXAM – DEVRY To buy this click here http://www.coursehomework.com/product/bis-155-final-exam-devry/ Contact us:+1 315-750-4434 help@coursehomework.com BIS 155 FINAL EXAM - DEVRY 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......

Words: 959 - Pages: 4

Bis 155 Final Exam - Devry

...BIS 155 Final Exam - DeVry BIS 155 Final Exam Answers Paste the Below Link into Your Browser To Purchase http://www.homeworkarena.com/bis-155-wk-8-final-exam-answers-devry 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......

Words: 952 - Pages: 4

Bis 155 Final Exam - Devry Latest

...BIS 155 Final Exam - DeVry Latest IF You Want To Purchase A+ Work Then Click The Link Below , Instant Download http://acehomework.com/BIS-155-Final-Exam-DeVry-12009932.htm?categoryId=-1 If You Face Any Problem E- Mail Us At JOHNMATE1122@Gmail.Com 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......

Words: 969 - Pages: 4

Devry Bis 155 Final Exam-2015 Spring

...Devry BIS 155 Final Exam-2015 Spring IF You Want To Purchase A+ Work then Click The Link Below For Instant Down Load http://www.hwspeed.com/Devry-BIS-155-Final-Exam-2015-Spring-5811235986.htm?categoryId=-1 IF You Face Any Problem Then E Mail Us At JOHNMATE1122@GMAIL.COM Question Question 1.1.(TCO 1) You are the Payroll Manager for your employer. Your payroll clerk has submitted the worksheet displayed here. All employees earn their regular pay rate times the hours worked plus an overtime bonus of 50% of the hours worked in excess of 40 hours. Part 1: Write a formula as if it were in Cell E2 that will calculate gross pay. Write the formula so that it may be copied to the other employees without modification. Part 2: You must also calculate the Income Tax which is assessed at an accelerated rate as shown in the Tax Rate Table. Write a formula as if it were in Cell F2 that calculates the income tax for the first employee. Write the formula so that it may be copied to the other employees without modification. Part 3: Hourly employees must pay union dues of $0.25 per hour on hours worked in excess of 25 hours up to and including 40 hours plus $0.35 per hour on all hours worked in excess of 40 hours. Write a formula as if it were in Cell G2 that calculates the union dues (if any) for the first employee. Write the formula so that it may be copied to the other employees without modification. Part 4: Salaried and Exempt employees (Pay Codes E and S) are......

Words: 922 - Pages: 4

Devry Bis 155 Final Exam-2015 August

...Devry BIS 155 Final Exam-2015 AUGUST IF You Want To Purchase A+ Work then Click The Link Below For Instant Down Load http://www.hwspeed.com/Devry-BIS-155-Final-Exam-2015-AUGUST-6785641024.htm?categoryId=-1 IF You Face Any Problem Then E Mail Us At JOHNMATE1122@GMAIL.COM Question Question 1.1.(TCO 1) You are the Payroll Manager for your employer. Your payroll clerk has submitted the worksheet displayed here. All employees earn their regular pay rate times the hours worked plus an overtime bonus of 50% of the hours worked in excess of 40 hours. Part 1: Write a formula as if it were in Cell E2 that will calculate gross pay. Write the formula so that it may be copied to the other employees without modification. Part 2: You must also calculate the Income Tax which is assessed at an accelerated rate as shown in the Tax Rate Table. Write a formula as if it were in Cell F2 that calculates the income tax for the first employee. Write the formula so that it may be copied to the other employees without modification. Part 3: Hourly employees must pay union dues of $0.25 per hour on hours worked in excess of 25 hours up to and including 40 hours plus $0.35 per hour on all hours worked in excess of 40 hours. Write a formula as if it were in Cell G2 that calculates the union dues (if any) for the first employee. Write the formula so that it may be copied to the other employees without modification. Part 4: Salaried and Exempt employees (Pay Codes E and S) are......

Words: 924 - Pages: 4

Devry Bis 155 Final Exam-2015 Spring

...Devry BIS 155 Final Exam-2015 Spring IF You Want To Purchase A+ Work then Click The Link Below For Instant Down Load http://www.hwspeed.com/Devry-BIS-155-Final-Exam-2015-Spring-5811235986.htm?categoryId=-1 IF You Face Any Problem Then E Mail Us At JOHNMATE1122@GMAIL.COM Question Question 1.1.(TCO 1) You are the Payroll Manager for your employer. Your payroll clerk has submitted the worksheet displayed here. All employees earn their regular pay rate times the hours worked plus an overtime bonus of 50% of the hours worked in excess of 40 hours. Part 1: Write a formula as if it were in Cell E2 that will calculate gross pay. Write the formula so that it may be copied to the other employees without modification. Part 2: You must also calculate the Income Tax which is assessed at an accelerated rate as shown in the Tax Rate Table. Write a formula as if it were in Cell F2 that calculates the income tax for the first employee. Write the formula so that it may be copied to the other employees without modification. Part 3: Hourly employees must pay union dues of $0.25 per hour on hours worked in excess of 25 hours up to and including 40 hours plus $0.35 per hour on all hours worked in excess of 40 hours. Write a formula as if it were in Cell G2 that calculates the union dues (if any) for the first employee. Write the formula so that it may be copied to the other employees without modification. Part 4: Salaried and Exempt employees (Pay Codes E and S) are......

Words: 922 - Pages: 4

Devry Busn 319 Final Exam-2015 August

...Devry BUSN 319 Final Exam-2015 August IF You Want To Purchase A+ Work then Click The Link Below For Instant Down Load http://www.hwspeed.com/Devry-BUSN-319-Final-Exam-2015-August-04040444235.htm?categoryId=-1 IF You Face Any Problem Then E Mail Us At JOHNMATE1122@GMAIL.COM Question Question 1.1. (TCO 4) Three commonly used methods of evaluating marketing programs are marketing metrics, marketing dashboards, and (Points : 5) marginal analysis. marketing audits. marketing ROI. marginal analysis. marketing control boards. Question 2.2. (TCO 1) Ideally in effective marketing planning, goals should be _____ in terms of what is to be accomplished and when. (Points : 5) loose and vague as general as possible flexible or elastic quantified and measurable None of the above Question 3.3. (TCO 3) Which marketing strategy focuses on a single market segment but adds additional product lines? (Points : 5) Full coverage Market specialization Product specialization Selective specialization Market-product concentration Question 4.4. (TCO 1) Based on relative competitive scope (broad target to narrow target) and source of competitive advantage (lower cost to differentiation), Porter's four generic business strategies are differentiation, cost focus, differentiation focus, and (Points : 5) exclusivity. electronic-focus. quality focus. cost leadership. service leadership. Question 5.5. (TCO 1) Step 3 in the planning phase of the strategic marketing process......

Words: 2325 - Pages: 10

Devry Busn 319 Final Exam-2015 August

...Devry BUSN 319 Final Exam-2015 August IF You Want To Purchase A+ Work then Click The Link Below For Instant Down Load http://www.hwspeed.com/Devry-BUSN-319-Final-Exam-2015-August-04040444235.htm?categoryId=-1 IF You Face Any Problem Then E Mail Us At JOHNMATE1122@GMAIL.COM Question Question 1.1. (TCO 4) Three commonly used methods of evaluating marketing programs are marketing metrics, marketing dashboards, and (Points : 5) marginal analysis. marketing audits. marketing ROI. marginal analysis. marketing control boards. Question 2.2. (TCO 1) Ideally in effective marketing planning, goals should be _____ in terms of what is to be accomplished and when. (Points : 5) loose and vague as general as possible flexible or elastic quantified and measurable None of the above Question 3.3. (TCO 3) Which marketing strategy focuses on a single market segment but adds additional product lines? (Points : 5) Full coverage Market specialization Product specialization Selective specialization Market-product concentration Question 4.4. (TCO 1) Based on relative competitive scope (broad target to narrow target) and source of competitive advantage (lower cost to differentiation), Porter's four generic business strategies are differentiation, cost focus, differentiation focus, and (Points : 5) exclusivity. electronic-focus. quality focus. cost leadership. service leadership. Question 5.5. (TCO 1) Step 3 in the planning phase of the strategic marketing process......

Words: 2325 - Pages: 10

Bis 155 Final Exam – Devry

...BIS 155 FINAL EXAM – DEVRY To purchase this, Click here http://www.activitymode.com/product/bis-155-final-exam-devry/ Contact us at: SUPPORT@ACTIVITYMODE.COM BIS 155 FINAL EXAM – DEVRY 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...

Words: 1911 - Pages: 8