supply store . 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 ….. ( 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 the months so they are listed in order from highest to lowest average sales . Give a step-by-step explanation of how you will rearrange the data so you can analyze the best and worst months ….. ( Points : 40 ) 4 . ( TCO 5 ) You ' ve just joined the staff of the XYZ Manufacturing Company ( XYZ , for short ). XYZ manufactures only one product , the gizmo . It comes in two sizes , the mini-gizmo and the magna-gizmo . Both are difficult to manufacture , and consequently , the company closely monitors rejected units . The company has three locations , each of which produces both the mini and the magna-gizmos . You are automating the weekly production reports so that you can easily calculate total production for the entire company each week . The mini-gizmo is priced at $ 3.25 per unit . The magna-gizmo is priced at $ 7.00 per unit . The unit cost for a reject mini-gizmo is $ 1.75 . The cost for a reject magna-gizmo is $ 3.50 . Respond fully to the following questions regarding this task :…… ( Points : 40 ) 5 . 5 . ( TCO 9 ) You have been tasked with analyzing an extremely large amount of data and to ultimately produce a report to share with the board of directors . The data is currently in a text file and has over two thousand records of data . Explain how you would use Excel to analyze this data and organize it to prepare a written report . Be very specific on the variety of tools you would use and the steps you would go through to analyze the data and to ultimately prepare a detailed report with recommendations ………( Points : 40 )
2 . ==============================================