# Bis 155 Final Exam - Devry Essay

944 Words 4 Pages
BIS 155 Final Exam - 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
Your company is growing and is considering expansion. The company currently has three locations (North, South, and Central) in one state. Each parts supply store carries inventory in four categories. You have been presented with the sales figures for the last three years for each location and inventory category by store. Based on this information, you're tasked with analyzing current sales for each store by category and overall total sales by store and category.

1.) Explain your approach to setting up your worksheets and organizing the data.

2.) Explain how you will visually represent the data for the total sales of the individual inventory categories for each location for the time periods shown.

3.) Explain how you will visually represent the consolidated data for the sales of all stores and all inventory categories for all time periods in one chart or graph.

4.) Once you have finished the above tasks, you plan to send the Excel workbook to your manager for evaluation. Your manger is presenting your findings to the Board of Directors for justification for additional capital expenditures. The visually representations need to be concise and clear by able to support the requested expenditures. Explain how you would use the integration features of MS Office to incorporate the Excel information into other presentation media. (Points : 40)

3. (TCO 4) You are given a spreadsheet with daily sales numbers ordered by date from January 1st to December

## Related Documents

• ###### Bis 155 Final Exam – Devry Essay

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:…

Words: 957 - Pages: 4
• ###### Bis 155 Final Exam - Devry Essay

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…

Words: 971 - Pages: 4
• ###### Devry Bis 155 Final Exam-2015 Spring Essay

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…

Words: 909 - Pages: 4
• ###### Essay on Devry Bis 155 Final Exam - Latest 2014

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

Words: 1014 - Pages: 5
• ###### Essay about Bis 219 Complete Class

BIS 219 COMPLETE CLASS To purchase this Click here: http://www.activitymode.com/product/bis-219-complete-class/ Contact us at: SUPPORT@ACTIVITYMODE.COM BIS 219 COMPLETE CLASS BIS 219 Final Exam BIS 219 Week 1 Assignment BIS 219 Week 1 DQ One BIS 219 Week 1 DQ Two BIS 219 Week 1 DQ Three BIS 219 Week 1 DQ Four BIS 219 Week 2 Club IT Part 1 BIS 219 Week 2 DQ One BIS 219 Week 2 DQ Two BIS 219 Week 2 DQ Three BIS 219 Week 2 DQ Four BIS 219 Week 3 Amazon Paper BIS 219 Week 3…

Words: 984 - Pages: 4
• ###### Bshs 332 Entire Course Essay

(Financial Accounting), ACCT 344 (Entire Course) - Devry, ACCT 344 Final Exam Latest 2014 - Devry, ACCT 346 (Managerial Accounting), ACCT 346 Midterm Exam Updated DeVry, ACCT 504, ACCT 504 Week 8, ACCT 553, ART 101 Week 8, Ashford BUS 401, ASHFORD BUS 640, Ashford HIS 204, ASHFORD MAT 222 Week 3, BA 215 (Business Statistics), BA 215 All Assignments Week 1 -8 - Grantham, BA 225, BA 260, BA 265 (Business Law II), BA 265 (Business Law II) FINAL EXAM, BA 340 All Course Assignments, BA 340 Human Resource…

Words: 1356 - Pages: 6
• ###### Essay on Bsa 310 Entire Course V7

Team C Final paper v7 BSA 310 Week 5 Team C Final ppt v7 Activity mode aims to provide quality study notes and tutorials to the students of BSA 310 ENTIRE COURSE v7 in order to ace their studies. Activity mode , BSA 310 ENTIRE COURSE v7, Home Work Tutorials, Home Work Solutions, Home Work Essay, Home Work Questions.ACC 565 Wk 7 Assignment 3, ACC403 week 2 assignment, ACC565 Week 10, ACCT 212 (Financial Accounting), ACCT 344 (Entire Course) - Devry, ACCT 344 Final Exam Latest 2014 - Devry, ACCT…

Words: 1809 - Pages: 8
• ###### Essay about Hrm 531 Week 6 Learning Team Weekly Reflection

(Financial Accounting), ACCT 344 (Entire Course) - Devry, ACCT 344 Final Exam Latest 2014 - Devry, ACCT 346 (Managerial Accounting), ACCT 346 Midterm Exam Updated DeVry, ACCT 504, ACCT 504 Week 8, ACCT 553, ART 101 Week 8, Ashford BUS 401, ASHFORD BUS 640, Ashford HIS 204, ASHFORD MAT 222 Week 3, BA 215 (Business Statistics), BA 215 All Assignments Week 1 -8 - Grantham, BA 225, BA 260, BA 265 (Business Law II), BA 265 (Business Law II) FINAL EXAM, BA 340 All Course Assignments, BA 340 Human Resource…

Words: 1263 - Pages: 6
• ###### Psy 100 Week 8 Assignment 2 – Adjustment Case Study – New Updated Work

(Financial Accounting), ACCT 344 (Entire Course) - Devry, ACCT 344 Final Exam Latest 2014 - Devry, ACCT 346 (Managerial Accounting), ACCT 346 Midterm Exam Updated DeVry, ACCT 504, ACCT 504 Week 8, ACCT 553, ART 101 Week 8, Ashford BUS 401, ASHFORD BUS 640, Ashford HIS 204, ASHFORD MAT 222 Week 3, BA 215 (Business Statistics), BA 215 All Assignments Week 1 -8 - Grantham, BA 225, BA 260, BA 265 (Business Law II), BA 265 (Business Law II) FINAL EXAM, BA 340 All Course Assignments, BA 340 Human Resource…

Words: 1206 - Pages: 5
• ###### Hrm 531 Week 4 Individual Assignment Essay

(Financial Accounting), ACCT 344 (Entire Course) - Devry, ACCT 344 Final Exam Latest 2014 - Devry, ACCT 346 (Managerial Accounting), ACCT 346 Midterm Exam Updated DeVry, ACCT 504, ACCT 504 Week 8, ACCT 553, ART 101 Week 8, Ashford BUS 401, ASHFORD BUS 640, Ashford HIS 204, ASHFORD MAT 222 Week 3, BA 215 (Business Statistics), BA 215 All Assignments Week 1 -8 - Grantham, BA 225, BA 260, BA 265 (Business Law II), BA 265 (Business Law II) FINAL EXAM, BA 340 All Course Assignments, BA 340 Human Resource…

Words: 1056 - Pages: 5