QSO Milestone 2

DATA CASE

destination	pallets	total case	cases ruby rd	cases murky white	case whole earth organic
Oakland CA		5376	2648	2648	80
Portland OR	48	5376	2438	2438	500
Riverside	48	5376	2673	2673	30
Seattle WA	48	5376	2638	2638	100

% OF WINES SOLD

	Row Labels	grand total	Sum of cases murky white	Sum of case whole earth organic
	Oakland CA	25.47%	2648	80
	Portland OR	23.45%	2438	500
	Riverside	25.71%	2673	30
	Seattle WA	25.37%	2638	100
	Grand Total	100.00%	10397	710

percentage of wine varieties sold

grand total

Oakland CA Portland OR Riverside Seattle WA 0.25468885255362123 0.23449071847648359 0.25709339232470907 0.25372703664518609 Sum of cases murky white Oakland CA Portland OR Riverside Seattle WA 2648 2438 2673 2638 Sum of case whole earth organic Oakland CA Portland OR Riverside Seattle WA 80 500 30 100

wines varieties sold

Row Labels	Sum of cases ruby rd	Sum of cases murky white	Sum of case whole earth organic
Oakland CA	2648	2648	80
Portland OR	2438	2438	500
Riverside	2673	2673	30
Seattle WA	2638	2638	100
Grand Total	10397	10397	710

Sum of cases ruby rd Oakland CA Portland OR Riverside Seattle WA 2648 2438 2673 2638 Sum of cases murky white Oakland CA Portland OR Riverside Seattle WA 2648 2438 2673 2638 Sum of case whole earth organic Oakland CA Portland OR Riverside Seattle WA 80 500 30 100

C.REVENUE FROM EACH CENTRE

	Column Labels
Row Labels	Oakland CA	Portland OR	price	Riverside	Seattle WA	Grand Total
5376
2438
2638
2648
2673
12
Grand Total
Row Labels	Sum of Sum of cases ruby rd	Sum of Sum of cases murky white	Sum of Sum of case whole earth organic
Grand Total	10397	10397	710
Oakland CA	2648	2648	80
Portland OR	2438	2438	500
Riverside	2673	2673	30
Seattle WA	2638	2638	100
Grand Total	20794	20794	1420
	prices	ruby red	murky wite	organic earth
		7.5	8	12
	revenue
	Oakland CA	19860	21184	960
	Parkland Or	18285	19504	6000
	Riverside CA	20047.5	21384	360
	Seattke WA	19785	21104	1200

D.central tendencies

		mean pallet	median pallet	mode pallet
	Oakland	23	15	48
	parkland	26.1428571429	18	48
	riverside	30	21	48
	seattle	34.8	24	48

shipment histogram

bin	frequency
1	15
3	19
6	0
12	21
18	0
24	26
48	12
72	3

summary of the sales analysis

The vinho wines sales ha several inneficiencies related to its distribtuin centres, brewing and pricing strategy.The histogram ship shows that the most shipped wine has little profit margin

It is important to note that the shipment pallets 72,48 and 24 have the best cost cutting strategies but are shipped least.

the histogram provides an important information to the management on dstributionmatrix that will maximise sales and revenue.