FreshBite is a pre-packaged sandwich manufacturer which produces a range of products that are sold in cafés and refreshment stands in tourist attractions such as theme parks.
Freshbite's sales are highly variable - the business regularly suffers from high levels of wastage as a result of having large quantities of unsold stock. On several occasions it has also been unable to fulfill orders from customers as it has not produced enough units.
The business has recently employed a new operations manager who has suggested that calculating the standard deviation of sales would aid planning. He has requested the last month's sales data to allow him to calculate this.
Product
|
Last month's sales ($)
|
A |
110,000 |
B |
27,000 |
C |
12,000 |
D |
54,000 |
E |
7,000 |
Calculate the standard deviation of last months' sales for Freshbite.
[4 marks]
Step 1: Calculate the mean
110,000 + 27,000 + 12,000 + 54,000 + 6,000 = 210,000
210,000 ÷ 5 = 42,000
[1 mark]
Step 2: For each product, subtract the mean and square the result
Product
|
Last month's sales ($000s)
|
Minus mean =
|
Squared = (000's)
|
A |
110 |
68 |
4,624 |
B |
27 |
-15 |
225 |
C |
12 |
-30 |
900 |
D |
54 |
12 |
144 |
E |
7 |
-35 |
1,225 |
[1 mark]
Step 3: Add up the squared differences and express in an expanded form
4,624 + 225 + 900 + 144 + 1,225 = 7,118
= 7,118,000
[1 mark]
Step 4: Find the square root to identify the standard deviation
[1 mark]
Note - in this instance, a significant standard deviation from the mean informs Freshbite's managers that they need to carefully plan for significant variations in sales. This may include detailed market research as well as capital investment to reduce wastage (for example, further freezers)