Description Case Assignment Manipulate the data in this sample order spreadsheet to answer the following questions

  

Description Case Assignment Manipulate the data in this sample order spreadsheet to answer the following questions: Sort your spreadsheet and then calculate each region’s order totals using Excel sort and “sum” functions. Which region’s order generated the highest dollar amount? What percent of total sales does this region represent? Sort your spreadsheet and then calculate each region’s order totals using Excel sort and “sum” functions. Which rep generated the highest sales? Create a bar chart or a pie graph to illustrate both of these trends. Save each sort and submit it as a worksheet in your Excel workbook. Label each worksheet. Use attached document labeled info for mod 3 case Copy of SampleData.xls Assignment Expectations Save and submit your work on the sample spreadsheet as an Excel Workbook to show your sorting and totaling results as individual worksheets. For example, Worksheet 1 should be titled “Region;” Worksheet 2 should be titled “Rep;” and Worksheet 3, “Graphs.” In the summary, upload the following into the Case 3 drop box by the module due date: 1 Excel workbook with 3 worksheets NOTE: You do not need to submit a cover or reference page for this assignment, but please name file BUS 101 MOD 3 CASE CLAYTON ___________________________________________________________________________________________________________ The initial phase of Creative Problem Solving is often referred to as Problem Scoping. This process establishes clear requirements for creating a viable final solution. It often is initiated by the identification of a need or issue. This part of the problem solving process focuses on the issue/need by gathering and analyzing information. In other words, you will clearly define what needs to be done prior to creating an effective solution. This SLP will help you practice your problem scoping skills by completing a clear, focused Problem Scoping Document. This will provide a clear problem definition and target for solution development. The best way to approach this assignment is to present the required information in the order given in the Step 2 section of the Problem Scoping Assignment Instructions. For example; begin by stating the problem that you found from the choices in Step 1.