# Bis 155 Final Exam Essay examples

938 Words Dec 7th, 2015 4 Pages
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
…show more content…
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 31st. You have been tasked with finding the average sales of each month, then to reorder

## Related Documents

• ###### Bis 155 Final Exam Essays

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…

Words: 941 - Pages: 4
• ###### Bis 155 Final Exams Essay

BIS 155 Final Exams To Buy This material Click below link http://www.uoptutors.com/bis-155/bis-155-final-exams BIS 155 Final Exam Data Analysis with Spreadsheets with Lab (TCO 3) A retail chain keeps daily data with summaries of the dollar amounts of sales for each of 151 different products sold at 23 retail stores. The daily data is tracked by product and by store. At the end of the day each store sends its data to the sales manager at the corporate office. The data is sent in an Excel spreadsheet…

Words: 1643 - Pages: 7
• ###### 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 Essay

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…

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

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…

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

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…

Words: 952 - Pages: 4
• ###### Essay on 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…

Words: 932 - 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
• ###### Bis 155 Entire Course All Labs-Quizzes and Final Exam Essay

BIS 155 Entire Course All Labs-Quizzes And Final Exam Follow Link Below To Get Tutorial https://homeworklance.com/downloads/bis-155-entire-course-labs-quizzes-final-exam/ Description: BIS 155 ( All Quizzes Included in File ) BIS 155 Lab 1 BIS 155 Lab 2 BIS 155 Lab 3 BIS 155 Lab 4 ( Word ) BIS 155 Lab 4 (Excel ) BIS 155 Lab 4 Clary labels BIS 155 Lab 5 BIS 155 Lab 6 BIS 155 Lab 6 Clary Course Project BIS 155 Lab 6 Clary Project Memo Template BIS 155 Lab 7 Clary ( BIS 155 Final…

Words: 9197 - Pages: 37
• ###### Bis 155 Final Exam Essay

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…

Words: 929 - Pages: 4