DEVRY BIS 155 Final Exams
Check this A + tutorial guideline at
http :// www . assignmentcloud . com / bis- 155 / bis-155-final-exams
For more classes visit http :// www . assignmentcloud . com
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 . Describe a data consolidation strategy and at least two different types of visualization techniques the sales manager can use to analyze the data received from all stores . Be sure to include formulas that are to be used in the Excel spreadsheet . ( Points : 40 )
Data consolidation strategy is a new concept that a majority of mangers are trying to adopt in order to keep track of their …
( TCO 5 ) Mark Jacobs , owner of Jacob ’ s Mini-Mart currently operates two stores in Atlanta . His business has been very successful , and he is now opening two new stores . He will no longer be able to manage all stores himself , so he is hiring managers for three of the four stores . He will continue to operate one store , and act as general manager over the company . He is looking for an easy and efficient way to collect information from the stores , and he would like your help with the following : PART 1 Marc wants you to design a worksheet for his managers to complete showing the sales by product category by month at each store . He wants to