(10 points) Define business processes. Describe the information needs by the different management levels in a business firm. Explain why collaboration and social business have become so important in business today.
(10 points) Read case study “Piloting Procter and Gamble from Decision Cockpits” on page 51. Then answer the following questions:
a) What are the business benefits of Business Sufficiency, Business Sphere, and Decision Cockpits?
b) What people, organization, and technology issues has to be addressed when implementing Business Sufficiency, Business Sphere, and Decision Cockpits?
c) How are these systems related to P&G’s business strategy?
(10 points) Watch the video cases in Chapter 2 folder Select one case and answer three questions from the list of Case Questions in that case.
(12 points) You are an assistant manager at Premiere Movie Source, an online company that enables customers to download movies for a fee. You need to track movie download sales by genre. You gathered the data for November 2016 and organized it in an Excel workbook. You are ready to create charts to help represent the data so that you can make a presentation to your manager later this week. You have created a clustered column chart. To the following steps to finalize your chart:
a) Open the attached Movies workbook.
b) Set chart filters to remove the Category Totals and the Weekly Totals.
c) Positon and size the chart to fill the range A18:K37.
d) Change the row and column orientation so that the weeks appear in the category axis and the genres appear in the legend.
e) Enter the text November 2016 Downloads by Genre as the chart title, and bold the title.
f) Add a value axis title: Number of Downloads.
g) Move the legend to the right side of the chart.
h) Select the Drama data series and add data labels in the Outside End position to emphasize this series.
i) Select the range A4:E14 and create a stacked bar chart that shows how the weekly totals contribute to the month totals by genre.
j) Move the chart to its own sheet named Bar Chart.
k) Add a chart title above the chart and enter November 2016 Weekly Downloads.
l) Display the value axis in units of Thousands, set the Major Units to 500, and apply the Number format with 1 decimal place.
m) Create a footer on each worksheet with your name.
n) Change the scaling so that the worksheet fits on only one page.
o) Save the workbook.