Production Management

Suppose Procter & Gamble sells 20 million bars of soap per week, but the demand is not constant and production management would like to get a better handle on how sales are distributed over the year. Let the following sales figures given in units of million bars represent the sales of bars per week over 1-year (in no particular order).

1. a) Construct a histogram chart or present the data using the appropriate tool from the data analysis tool pack. Make sure to specify your own bin ranges otherwise Excel will automatically pick them for you and you will have very strange bin ranges with confusing decimal points. Make a list of numbers in multiples of 5, starting from 10 up to 40; then, show where the bin numbers are in the histogram dialog box.
2. b) Creating a chart is not useful in and of itself unless it is properly interpreted. Write a brief analysis of the graph. What do you see in the graph that might be helpful to the production and sales people?

17.1	14.3	17	25.2
14.4	12.2	11.9	26.3
15.4	10.9	12.8	13.5
17.4	21.5	39.8	30.6
15	20.4	20.7	25.2
13.8	20.3	21.3	26.2
20.6	13.8	22.5	26.9
18.4	23.6	21.4	32.8
20	19.1	23.4	26.3
20.9	20.4	23.1	26.6
11.1	15.4	14.8	24.3
12.5	20.3	21.4	26.2
14.7	24.4	24	23.8

2 of 3

GB513: Business Analytics

Directions for submitting your Assignment

Submit your Word document to the Dropbox.

Unit 1 Assignment
Criteria	Points Possible	Points Earned
Question 1: Correct pie chart.	6
Question 1: Correct bar chart.	6
Question 2a: Correct descriptive output.	6
Question 2b: Explanation of each metric in the summary statistics for Question 2.	6
Question 2c: Appropriate analysis of the resulting figures in the report based on the data set for Question 2.	8
Question 3a: Correct histogram.	8	32
Question 3b: Analysis of the graph that would be helpful to the production and sales people.	6
Proper report formatting submitted as a Word file.	4
Total	50