Sublime Delight Case Analysis . Background 'Sublime Delight' is a small, but rapidly growing, coffee roaster, coffee supplier, and outlet operator. It began 5 years ago when David Geoffs decided to turn his passion for high quality coffee into a business. He started small with what would best be called a 'micro' roasting setup. He sourced organically grown coffee beans from ethically operated sources which he would then ship to his site in Australia where they were carefully stored under rigorously controlled conditions. He experimented with various mixes of beans, moisture levels, and roasting patterns, selling each batch to local coffee shops. Gradually he developed three main products - Espresso Delight, Mocha Delight, and Sublime Delight. The products are consistent in flavour, easy to grind, and have a good shelf life, which offers the coffee shops both an identifiable and repeatable coffee product, and a more manageable and cost effective production process. The business has grown rapidly over the past few years and the roasting equipment is now state-of-the-art, and of mid-range capacity. Eighteen months ago Geoffs decided to branch out into takeaway/coffee cart operations plus operating three mobile units. The business now has seven takeaway sites plus the three mobiles. The mobiles concentrate on supplying building sites, commercial areas and office sites on a regular basis and two of the mobiles are available for event catering. Geoffs is now finding that the success of his business is pulling him away from his passion for coffee roasting and he is increasingly spending more time on general business management. Six months ago he recruited a general manager who spent many months in the office pulling various printouts and papers together and muttering comments about "If you can't measure it, you can't manage it!" and "let's get the evidence before we decide on that!", with a real favourite being "I don't like the shape of the data!". Last month the general manager announced that he had been offered a much better job in another state and immediately hopped on a plane to Western Australia leaving behind a big mess. 1 STAT201AHEP: NSW5028/CRICOS Provider Code NSW00246M _T2_2016_Case_Analysis_Assessment.Docx Laureate International Universities 2014 You have worked in the dispatch and delivery section of the business on a parttime basis for the past year and you have asked Geoffs to allow you to do your Think internship activity with the company. He has now handed you some of the material collected by the ex-general manager and has asked you to make sense of it and write a report about it for consideration by the board of directors. Overview You are provided with a number of datasets and some information about them. You are to use the BADIR methodology to investigate the datasets and use appropriate descriptive, and where possible inferential, techniques to discuss and present your findings to the board. Your submission should be in the form of a business report that should include an Executive Summary, Introduction, Background and Context, Methodology, Sections discussing each area, and a Summary. The report should be referenced appropriately. DATASET 1 The DATASET 1 includes a month-by-month sales report showing the amount of beans sold in Kgs. Data for 17 external customers, the internally owned cart outlets, and mobile set-ups has been collated from the company accounting systems. In addition the following information is also available: 800 COST 500Kgs/Mth 501 - 650 651 - 800 Average Cost Beans/Kg $8 $7.5 $7 $6.5 Cost of processing/Kg $14 $12 $10 $9 Total Cost $22 $19.5 $17 $15.5 2 STAT201AHEP: NSW5028/CRICOS Provider Code NSW00246M _T2_2016_Case_Analysis_Assessment.Docx Laureate International Universities 2014 Customer Volume 40Kg/Mth 41 - 60 61 - 80 Sale Price/Kg $45 $42 $40 80 $38 TASK 1 In general, the board would be interested in how sales are distributed across outlets, how profits are distributed, and where the major growth areas are? However, you are encouraged to address other questions where appropriate. DATASET 2 The DATASET 2 provides raw data from a customer satisfaction survey undertaken by all the internal cart outlets on a particular day. All customers were asked to complete a user survey card for the day. The customers were asked to rate the service (1 Poor 2 Fair 3 Good 4 Very Good 5 Excellent) and quality of coffee (1 Poor 2 Fair 3 Good 4 Very Good 5 Excellent). The customers were also asked about the frequency with which they purchased from the outlet (A Less than once per week, B Once or more per week, C Daily, D more than once per day). The data was collected by each outlet asking its customers to complete a survey card on a particular day. TASK 2 The board would be interested in whether there is any significant difference between the outlets in terms of service quality and coffee quality. DATASET 3 3 STAT201AHEP: NSW5028/CRICOS Provider Code NSW00246M _T2_2016_Case_Analysis_Assessment.Docx Laureate International Universities 2014 Total Marks 100 The data in DATASET 3 covers the type of bean mix supplied to external outlets in January and December of 2015. A market analysis done in mid 2014 suggested that the mix would be 30% Espresso, 10% Mocha and 60% Sublime. TASK 3 You need to address following questions: a) Does the prediction regarding the mix proportions hold for January? b) Does the prediction hold for December? c) Has the taste mix changed overall between January and December? d) What would be the new expected market mix based on the December data? 4 STAT201AHEP: NSW5028/CRICOS Provider Code NSW00246M _T2_2016_Case_Analysis_Assessment.Docx Laureate International Universities 2014 Orders in K 2015 External Customers 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 Total Jan Feb Mar Apr May 30 32 35 36 39 32 34 37 39 41 35 37 40 42 45 54 58 62 66 69 27 29 31 33 35 34 36 39 41 44 67 72 70 74 78 29 31 34 35 37 36 39 42 44 46 37 40 43 45 48 32 34 32 34 36 34 36 39 41 44 36 39 42 44 49 47 50 54 57 60 29 31 34 35 37 25 27 33 35 37 25 27 29 30 32 609 652 695 730 777 Internal Carts Jan Feb Mar Apr May 1 2 3 4 5 6 7 Total 100 102 105 104 106 103 105 108 110 113 85 87 89 91 93 97 99 102 104 106 78 80 82 84 85 109 112 114 117 121 86 88 90 92 94 658 673 689 701 719 Mobiles Jan Feb Mar Apr May 1 2 3 Total 60 64 63 70 69 70 75 77 81 82 53 56 56 58 59 183 195 196 209 210 Orders in Kgs Jun Jul Aug Sep Oct Nov Dec 39 38 38 39 40 44 47 42 41 40 41 43 47 50 45 45 44 45 47 51 55 70 69 68 69 54 50 54 35 34 34 35 36 39 42 44 43 43 44 46 50 53 79 77 76 78 81 88 95 38 37 37 37 39 42 45 47 46 45 46 48 53 56 48 47 47 48 50 54 58 36 35 35 36 35 38 41 44 43 43 44 46 50 53 49 49 48 49 51 56 60 61 60 59 60 63 69 74 38 37 37 37 33 36 38 37 36 36 37 38 42 45 32 32 31 32 34 36 39 785 771 761 776 786 844 905 Jun Jul Aug Sep Oct Nov Dec 109 111 114 117 119 122 125 115 118 117 120 122 125 128 95 97 100 102 104 107 109 109 111 112 115 117 120 123 87 87 87 89 91 93 95 110 113 132 135 140 143 147 90 92 94 96 99 101 103 716 730 756 773 793 811 830 Jun Jul Aug Sep Oct Nov Dec 64 65 70 77 73 75 77 80 82 84 86 88 90 92 56 58 60 65 61 64 67 200 206 213 228 222 228 235 Reven External Customers 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 Total Jan Feb Mar Apr May 1350 1440 1575 2268 1215 1530 2680 1305 1620 1665 1440 1530 1620 1974 1305 1125 1125 26767 1445 1541 1685 2427 1300 1637 2868 1396 1733 1782 1541 1637 1733 2112 1396 1204 1204 28641 1560 1664 1820 2496 1404 1768 2800 1508 1747 1796 1440 1768 1747 2281 1508 1485 1300 30093 1638 1747 1784 2621 1474 1733 2940 1583 1835 1886 1512 1733 1835 2395 1583 1559 1365 31223 1736 1729 1891 2778 1563 1837 3116 1678 1945 1999 1603 1837 2058 2539 1678 1653 1447 33086 Internal Carts Jan Feb Mar Apr May 1 2 3 4 5 6 7 Total 3800 3914 3230 3686 3120 4142 3268 25160 3887 4004 3304 3771 3192 4237 3343 25739 3977 4096 3380 3858 3102 4335 3420 26167 3952 4190 3458 3946 3173 4434 3499 26653 4043 4287 3538 4037 3246 4598 3579 27328 Mobiles 1 2 3 Total Jan 2520 2800 2226 7546 Feb 2578 3000 2352 7930 Mar 2520 3080 2352 7952 Apr 2800 3078 2428 8306 May 2760 3102 2484 8346 Cos External Customers 1 2 3 4 5 6 7 8 9 Jan Feb Mar Apr May 660 704 770 1188 594 748 1474 638 792 706 753 824 1271 636 800 1577 683 847 763 814 890 1373 686 864 1540 737 915 801 854 934 1441 721 908 1617 774 961 849 905 990 1528 764 962 1714 821 1019 10 11 12 13 14 15 16 17 Total 814 704 748 792 1034 638 550 550 13398 871 753 800 847 1106 683 589 589 14336 941 704 864 915 1195 737 726 636 15300 988 739 908 961 1255 774 762 667 16065 1047 784 962 1078 1330 821 808 707 17089 Internal Carts 1 2 3 4 5 6 7 Total Jan Feb Mar Apr May 2200 2266 1870 2134 1716 2398 1892 14476 2251 2318 1913 2183 1755 2453 1936 14809 2302 2371 1957 2233 1796 2510 1980 15150 2288 2426 2002 2285 1837 2567 2026 15431 2341 2482 2048 2337 1879 2662 2072 15821 Mobiles 1 2 3 Total Jan 1320 1540 1166 4026 Feb 1418 1650 1232 4300 Mar 1386 1694 1232 4312 Apr 1540 1782 1272 4594 May 1518 1796 1301 4615 Profi External Customers 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 Total Internal Carts 1 2 3 Jan Feb Mar Apr May 690 736 805 1080 621 782 1206 667 828 851 736 782 828 940 667 575 575 13369 738 788 861 1156 664 837 1290 714 886 911 788 837 886 1006 714 615 615 14305 797 851 930 1123 718 904 1260 771 832 855 736 904 832 1086 771 759 664 14793 837 893 849 1179 754 825 1323 809 874 898 773 825 874 1141 809 797 698 15158 887 823 900 1250 799 875 1402 858 926 952 819 875 980 1209 858 845 740 15998 Jan Feb Mar Apr May 1600 1648 1360 1637 1686 1391 1674 1725 1423 1664 1764 1456 1702 1805 1490 4 5 6 7 Total 1552 1404 1744 1376 10684 1588 1436 1784 1408 10930 1624 1306 1825 1440 11018 1662 1336 1867 1473 11222 1700 1367 1936 1507 11506 Mobiles 1 2 3 Total Jan 1200 1260 1060 3520 Feb 1160 1350 1120 3630 Mar 1134 1386 1120 3640 Apr 1260 1296 1156 3712 May 1242 1306 1183 3731 Revenue G External Customers 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 Jan Internal Carts 1 2 3 4 5 6 7 Jan Mobiles 1 2 3 Jan Feb Mar Apr May 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 8.00% 8.00% 8.00% 2.86% 8.00% 8.00% -2.36% 8.00% 0.80% 0.80% -6.54% 8.00% 0.80% 8.00% 8.00% 23.36% 8.00% 5.00% 5.00% -2.00% 5.00% 5.00% -2.00% 5.00% 5.00% 5.00% 5.00% 5.00% -2.00% 5.00% 5.00% 5.00% 5.00% 5.00% 6.00% -1.07% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 12.18% 6.00% 6.00% 6.00% 6.00% Feb Mar Apr May 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% -2.82% 2.30% 2.30% -0.62% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 3.69% 2.30% Feb 2.30% 7.14% 5.66% Mar -2.25% 2.67% 0.00% Apr 11.11% -0.06% 3.24% May -1.43% 0.78% 2.30% Profit Gr External Customers 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 Jan Internal Carts 1 2 3 4 5 6 7 Jan Mobiles 1 2 3 Jan Feb Mar Apr May 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 8.00% 8.00% 8.00% -2.80% 8.00% 8.00% -2.36% 8.00% -6.09% -6.09% -6.54% 8.00% -6.09% 8.00% 8.00% 23.36% 8.00% 5.00% 5.00% -8.70% 5.00% 5.00% -8.70% 5.00% 5.00% 5.00% 5.00% 5.00% -8.70% 5.00% 5.00% 5.00% 5.00% 5.00% 6.00% -7.83% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 12.18% 6.00% 6.00% 6.00% 6.00% Feb Mar Apr May 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% -9.07% 2.30% 2.30% -0.62% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 3.69% 2.30% Feb -3.33% 7.14% 5.66% Mar -2.25% 2.67% 0.00% Apr 11.11% -6.49% 3.24% May -1.43% 0.78% 2.30% Revenue Calculation Jun Jul Aug Sep Oct Nov Dec 1754 1746 1910 2806 1578 1855 3148 1695 1964 2019 1619 1855 2079 2442 1695 1669 1461 33295 1724 1716 1877 2758 1552 1824 3094 1666 1931 1984 1591 1824 2043 2521 1666 1641 1437 32849 1701 1814 1852 2721 1531 1799 3053 1644 1905 1958 1570 1799 2016 2487 1644 1619 1417 32530 1735 1727 1889 2776 1561 1835 3114 1677 1943 1997 1601 1835 2056 2537 1677 1651 1446 33057 1816 1808 1978 2268 1635 1921 3097 1756 2034 2091 1575 1921 2153 2529 1485 1729 1514 33310 1839 1962 2146 2100 1774 2085 3360 1778 2207 2269 1709 2085 2336 2744 1611 1751 1642 35398 1974 2100 2310 2268 1764 2226 3610 1890 2352 2436 1722 2226 2520 2960 1710 1890 1755 37713 Jun Jul Aug Sep Oct Nov Dec 4136 4385 3619 4130 3321 4180 3420 27191 4231 4486 3702 4225 3306 4276 3499 27725 4328 4446 3787 4256 3306 5016 3579 28719 4428 4548 3874 4354 3382 5131 3661 29379 4530 4653 3964 4454 3460 5320 3746 30126 4634 4760 4055 4556 3539 5442 3832 30819 4740 4869 4148 4661 3621 5568 3920 31527 Jun 2560 3200 2352 8112 Jul 2619 3110 2449 8178 Aug 2800 3181 2505 8487 Sep 3080 3255 2600 8935 Oct 2930 3329 2440 8700 Nov 2998 3406 2555 8958 Dec 3067 3484 2680 9231 Cost Calculation Jun Jul Aug Sep Oct Nov Dec 857 915 1000 1543 772 972 1731 829 1029 843 899 983 1517 759 955 1702 815 1011 832 887 970 1497 748 942 1679 804 998 848 905 989 1527 763 961 1713 820 1018 888 947 1036 1188 799 1006 1793 858 1066 963 1028 1124 1100 867 1092 1945 931 1156 1034 1100 1210 1188 924 1166 2090 990 1232 1057 791 972 1089 1343 829 816 714 17259 1039 778 955 1070 1320 815 802 702 16966 1026 768 942 1056 1303 804 791 693 16739 1046 783 961 1077 1329 820 807 707 17073 1095 770 1006 1128 1391 726 845 740 17283 1188 835 1092 1224 1509 788 917 803 18564 1276 902 1166 1320 1628 836 990 858 19910 Jun Jul Aug Sep Oct Nov Dec 2394 2539 2095 2391 1923 2420 1980 15742 2450 2597 2143 2446 1914 2476 2026 16051 2506 2574 2193 2464 1914 2904 2072 16627 2564 2633 2243 2521 1958 2971 2120 17009 2622 2694 2295 2579 2003 3080 2169 17441 2683 2756 2347 2638 2049 3151 2218 17842 2744 2819 2401 2699 2096 3223 2269 18253 Jun 1408 1760 1232 4400 Jul 1440 1800 1283 4524 Aug 1540 1842 1312 4694 Sep 1694 1884 1430 5008 Oct 1612 1928 1342 4881 Nov 1649 1972 1405 5026 Dec 1687 2017 1474 5178 Profit Calculation Jun Jul Aug Sep Oct Nov Dec 896 831 909 1263 807 883 1416 866 935 961 827 883 990 1099 866 853 747 16035 881 817 894 1241 793 868 1392 852 919 945 813 868 973 1200 852 839 734 15883 869 927 882 1225 782 857 1374 840 907 932 802 857 960 1184 840 827 724 15791 887 822 900 1249 798 874 1401 857 925 951 818 874 979 1208 857 844 739 15983 928 861 942 1080 836 915 1304 897 969 996 805 915 1025 1138 759 884 774 16027 876 934 1022 1000 907 993 1415 847 1051 1080 873 993 1112 1235 824 834 839 16834 940 1000 1100 1080 840 1060 1520 900 1120 1160 820 1060 1200 1332 874 900 897 17803 Jun Jul Aug Sep Oct Nov Dec 1741 1846 1524 1781 1889 1559 1822 1872 1595 1864 1915 1631 1907 1959 1669 1951 2004 1707 1996 2050 1747 1739 1398 1760 1440 11449 1779 1392 1800 1473 11674 1792 1392 2112 1507 12092 1833 1424 2161 1542 12370 1875 1457 2240 1577 12684 1919 1490 2292 1613 12976 1963 1525 2344 1651 13275 Jun 1152 1440 1120 3712 Jul 1178 1309 1166 3654 Aug 1260 1340 1193 3793 Sep 1386 1370 1170 3926 Oct 1319 1402 1098 3819 Nov 1349 1434 1150 3933 Dec 1380 1467 1206 4053 Revenue Growth Calculation Jun Jul Aug Sep Oct Nov Dec 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% -3.81% 1.00% 1.00% 1.00% -1.70% -1.70% -1.70% -1.70% -1.70% -1.70% -1.70% -1.70% -1.70% -1.70% -1.70% -1.70% -1.70% 3.22% -1.70% -1.70% -1.70% -1.34% 5.71% -1.34% -1.34% -1.34% -1.34% -1.34% -1.34% -1.34% -1.34% -1.34% -1.34% -1.34% -1.34% -1.34% -1.34% -1.34% 2.00% -4.80% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 4.70% 4.70% 4.70% -18.29% 4.70% 4.70% -0.53% 4.70% 4.70% 4.70% -1.64% 4.70% 4.70% -0.29% -11.45% 4.70% 4.70% 1.27% 8.50% 8.50% -7.41% 8.50% 8.50% 8.50% 1.27% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 1.27% 8.50% 7.32% 7.03% 7.65% 8.00% -0.54% 6.78% 7.43% 6.30% 6.56% 7.38% 0.77% 6.78% 7.89% 7.85% 6.13% 7.95% 6.86% Jun Jul Aug Sep Oct Nov Dec 2.30% 2.30% 2.30% 2.30% 2.30% -9.09% -4.45% 2.30% 2.30% 2.30% 2.30% -0.45% 2.30% 2.30% 2.30% -0.90% 2.30% 0.74% 0.00% 17.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 3.68% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% Jun -7.25% 3.16% -5.31% Jul 2.30% -2.82% 4.13% Aug 6.92% 2.30% 2.30% Sep 10.00% 2.30% 3.78% Oct -4.86% 2.30% -6.15% Nov 2.30% 2.30% 4.69% Dec 2.30% 2.30% 4.91% Profit Growth Calculation Jun Jul Aug Sep Oct Nov Dec 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% 1.00% -9.10% 1.00% 1.00% 1.00% -1.70% -1.70% -1.70% -1.70% -1.70% -1.70% -1.70% -1.70% -1.70% -1.70% -1.70% -1.70% -1.70% 9.22% -1.70% -1.70% -1.70% -1.34% 13.46% -1.34% -1.34% -1.34% -1.34% -1.34% -1.34% -1.34% -1.34% -1.34% -1.34% -1.34% -1.34% -1.34% -1.34% -1.34% 2.00% -11.30% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 4.70% 4.70% 4.70% -13.54% 4.70% 4.70% -6.93% 4.70% 4.70% 4.70% -1.64% 4.70% 4.70% -5.77% -11.45% 4.70% 4.70% -5.65% 8.50% 8.50% -7.41% 8.50% 8.50% 8.50% -5.65% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% -5.65% 8.50% 7.32% 7.03% 7.65% 8.00% -7.34% 6.78% 7.43% 6.30% 6.56% 7.38% -6.12% 6.78% 7.89% 7.85% 6.13% 7.95% 6.86% Jun Jul Aug Sep Oct Nov Dec 2.30% 2.30% 2.30% 2.30% 2.30% -9.09% -4.45% 2.30% 2.30% 2.30% 2.30% -0.45% 2.30% 2.30% 2.30% -0.90% 2.30% 0.74% 0.00% 17.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 3.68% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% Jun -7.25% 10.25% -5.31% Jul 2.30% -9.07% 4.13% Aug 6.92% 2.30% 2.30% Sep 10.00% 2.30% -1.93% Oct -4.86% 2.30% -6.15% Nov 2.30% 2.30% 4.69% Dec 2.30% 2.30% 4.91% Mean Median 1689 1750 1893 2524 1529 1837 3073 1631 1935 1990 1577 1837 2016 2460 1580 1581 1426 32330 1729 1737 1883 2558 1556 1829 3096 1672 1937 1991 1583 1829 2050 2504 1628 1646 1441 32953 Standard Deviation 164 164 185 241 158 176 236 156 193 201 84 176 246 249 124 210 164 2776 Mean Median Standard Deviation 4224 4387 3672 4161 3314 4723 3564 28044 4183 4416 3661 4177 3306 4516 3539 27526 296 287 288 299 156 513 189 1976 Mean Median Standard Deviation 2769 3169 2452 8390 2780 3146 2445 8326 203 178 119 473 Mean Median 837 893 977 1363 753 948 1715 808 1004 845 902 986 1407 761 958 1707 817 1015 Standard Deviation 97 103 114 159 86 109 163 92 115 1032 776 948 1046 1312 772 784 697 16665 1043 774 958 1074 1325 796 805 705 17020 120 52 109 143 154 61 117 80 1674 Mean Median 2445 2540 2126 2409 1903 2735 2063 16221 2422 2556 2119 2418 1914 2615 2049 15936 Standard Deviation 171 166 167 173 110 297 109 1164 Mean Median 1518 1805 1307 4630 1529 1798 1292 4604 Mean Median 852 857 916 1160 776 889 1359 823 931 958 801 889 970 1148 808 798 729 15665 878 841 900 1168 796 874 1383 849 922 948 809 874 976 1162 832 836 737 15933 Mean Median 1778 1847 1546 1761 1859 1541 Standard Deviation 119 131 88 330 Standard Deviation 72 69 75 84 75 71 81 69 81 85 37 71 105 101 64 97 84 1104 Standard Deviation 125 121 121 1752 1411 1989 1501 11823 1759 1401 1902 1490 11590 126 59 216 79 812 Mean Median 1252 1363 1145 3760 1251 1360 1153 3722 Standard Deviation 86 62 41 145 Mean Median 3.57% 3.58% 3.62% 0.28% 3.51% 3.54% 2.82% 3.47% 3.50% 3.58% 1.73% 3.54% 4.18% 3.83% 2.65% 5.02% 4.18% 4.70% 5.00% 4.70% 2.00% 4.70% 4.70% 2.00% 4.70% 4.70% 4.70% 1.00% 4.70% 4.70% 5.00% 5.00% 4.70% 5.00% Mean Median 2.03% 2.01% 2.30% 2.16% 1.38% 2.88% 1.69% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% Mean Median 1.95% 2.03% 1.78% 2.30% 2.30% 3.24% Standard Deviation 3.32% 4.28% 3.95% 7.26% 3.60% 3.87% 3.88% 3.22% 3.34% 3.42% 4.32% 3.87% 4.23% 4.01% 5.62% 6.57% 3.47% Standard Deviation 0.84% 0.92% 0.00% 0.45% 1.64% 5.68% 1.94% Standard Deviation 5.51% 2.29% 3.84% Mean Median 2.94% 3.08% 3.01% 0.20% 2.89% 2.93% 2.24% 2.85% 2.88% 2.95% 1.11% 2.93% 3.56% 3.40% 2.65% 4.39% 4.18% 4.70% 5.00% 4.70% 1.00% 4.70% 4.70% 2.00% 4.70% 4.70% 4.70% 1.00% 4.70% 4.70% 6.00% 5.00% 4.70% 5.00% Mean Median 2.03% 2.01% 2.30% 2.16% 0.81% 2.88% 1.69% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% 2.30% Mean Median 1.44% 1.53% 1.26% 2.30% 2.30% 2.30% Standard Deviation 4.22% 7.08% 5.11% 6.25% 4.67% 5.05% 4.73% 4.14% 4.30% 4.37% 4.87% 5.05% 5.10% 5.94% 5.62% 7.20% 3.47% Standard Deviation 0.84% 0.92% 0.00% 0.45% 3.27% 5.68% 1.94% Standard Deviation 5.71% 5.13% 3.92% Outlet Service Coffee Difference 1 1 2 3 4 1 5 1 2 3 4 5 6 7 8 1 2 3 3 3 4 4 5 5 7 7 7 7 6 6 6 2 2 3 3 5 6 5 4 7 3 2 1 3 3 4 3 4 5 4 5 4 5 4 5 4 5 4 3 4 5 4 5 4 5 5 5 5 3 3 4 4 5 5 4 4 4 3 5 5 2 4 5 5 5 4 4 4 3 5 5 4 4 4 4 4 4 5 5 5 5 5 5 5 5 5 5 5 3 3 4 4 4 4 4 3 3 3 3 5 5 5 5 5 5 5 5 5 5 5 4 4 4 4 4 4 4 4 -1 0 1 0 1 -1 0 -1 0 -1 0 -1 -2 -1 0 -1 2 1 1 1 1 1 -1 0 1 1 2 0 -1 -1 -1 -2 0 0 -3 -1 0 0 1 0 0 0 -1 1 1 0 5 6 7 4 2 4 5 5 3 2 4 4 3 4 5 0 1 2 -1 -3 Outlet Service Coffee Difference 1 3 4 -1 HO: d = 0 (The difference 1 2 3 4 1 5 1 4 5 4 5 4 5 4 4 4 4 4 5 5 5 0 1 0 1 -1 0 -1 HA: d 0 (The difference 2 3 4 5 6 7 8 1 2 3 3 3 4 4 5 5 7 7 7 6 6 6 2 2 3 3 5 6 5 4 7 3 2 1 3 5 4 5 4 3 4 5 4 5 4 5 5 5 5 3 3 4 5 5 4 4 4 3 5 5 2 4 5 5 5 4 4 4 3 5 5 5 5 5 5 5 5 5 3 3 4 4 4 4 4 3 3 3 5 5 5 5 5 5 5 5 5 5 5 4 4 4 4 4 4 0 -1 0 -1 -2 -1 0 -1 2 1 1 1 1 1 -1 0 1 2 0 -1 -1 -1 -2 0 0 -3 -1 0 0 1 0 0 0 -1 1 Step 1: Formulation of Step 2: Selection of lev For this test, the significa Step 3: Selection of the Here, the appropriate tes = n-1 as standard deviati small (n=10). Now, = -0.098/(1.136/50) = Step 4: Identification of the decision rule At 5% level of significanc value of t statistics is 2.0 more than the table or cr Step 5: Compare the ca null hypothesis As the calculated t value of reject the null hypothesis. Step 6: Make the relate As we have failed to reject difference between the out 3 4 5 6 7 4 2 Mean Standard Deviation 5 4 4 5 5 3 2 4 4 4 4 3 4 5 1 0 0 1 2 -1 -3 -0.098 1.136 Step 1: Formulation of Null and Alternative Hypothesis HO: d = 0 (The difference in between service quality rating and coffee quality rating is zero) HA: d 0 (The difference in between service quality rating and coffee quality rating is not zero) Step 2: Selection of level of significance For this test, the significance level will be specified as 0.05. Step 3: Selection of the test statistics and calculate its value Here, the appropriate test statistic is t test statistics & the t distribution will be used with df = n-1 as standard deviation of population mean difference is unknown and sample size is small (n=10). Now, = -0.098/(1.136/50) -0.610319 Step 4: Identification of the Critical value (table value) for test statistics and state the decision rule At 5% level of significance and degree of confidence level of 49 (df = n-1), the critical value of t statistics is 2.008. Null hypothesis will be rejected if the calculated value of t is more than the table or critical value of t. Step 5: Compare the calculated & critical value and reach a conclusion for null hypothesis As the calculated t value of -0.61032 is less than the critical value 0f 2.008 of t statistics, we fail to reject the null hypothesis. Step 6: Make the related business decision As we have failed to reject the null hypothesis, we can conclude that there is no significant difference between the outlets in terms of service quality and coffee quality. Orders 2015 2015 Jan Espresso Mocha Sublime 9 11 11 16 8 20 20 5 3 11 5 4 11 14 9 2 8 3 2 7 5 3 6 7 7 10 4 9 2 4 5 3 7 3 18 19 17 33 16 8 40 17 23 22 18 28 21 28 17 16 14 Total External Customer 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 Total 30 32 35 54 27 34 67 29 36 37 32 34 36 47 29 25 25 609 30 32 35 54 27 34 67 29 36 37 32 34 36 47 29 25 25 Dec Espresso Mocha Sublime Total 47 50 55 54 42 53 95 45 56 58 41 53 60 74 38 45 39 905 22 14 15 33 12 5 35 35 15 15 15 23 12 34 23 12 13 12 13 14 15 23 4 17 1 12 15 16 23 14 15 14 23 9 13 23 26 6 7 44 43 9 29 28 10 7 34 25 1 10 17 47 50 55 54 42 53 95 45 56 58 41 53 60 74 38 45 39 Hi, I have two works currently but I can't afford to pay you so much and you still get half of the money. I ask you to email me and do it through paypal. I have good volume of work. If you are interested, email me here Nick.nickky.nitesh@gmail.com If you are not interested, just comment by saying, \" No, thank you\" Hi, I have two works currently but I can't afford to pay you so much and you still get half of the money. I ask you to email me and do it through paypal. I have good volume of work. If you are interested, email me here Nick.nickky.nitesh@gmail.com If you are not interested, just comment by saying, \" No, thank you\