A$.$ Use the Excel workbook "Superstore$\_$MIS$688".$ You will develop a professional report based on the following:

a$.$ Add columns to include the region manager $("$People$"$ Worksheet$))$ and Retums $("$Returns$"$ Worksheet$)$ for each record in the "Orders" Worksheet. You will use "vlookup" function to add these two columns.

b$.$ What Information can be generated by processing the data you see in the workbook. You will have to study the data and understand what the data represent.

c$.$ List at least five different conclusions which can be drawn based on the data you see in the workbook. Explain the basis of each of your conclusions. $($e$.$g$.$ which region made the most profit, which product needs to be discontinued and why, and so on$.).$ Be very creative and critical in your selection and the rationale for each conclusion you draw. I will grade this based on how critically your group has thought over these conclusions.

d$.$ Based on the response in b and $c$ what types of decisions the management can make regarding the sale of their products in future. Yes, this is subjective, however, I will accept your responses based on the reasoning that you use in suggesting the future decisions.

e$.$ Finally, each group will present their report $-$ use PowerPoint and excel workbook to demo the Pivot table you used.