In this Lab, you will focus on: Master the data (M) Perform test plan (P) Case: Boutique Winery is a small but fast growing winery in Ontario. It has received many awards from its 4 classic wine products (Red, White, Ros and Sparkling). The rapid growth has put a lot of strain on its staff and management is concern about the increase in labour cost. You, a consultant, has been engaged to help with the analysis to review the labour cost in wine production. The Finance team has provided excerpts of their data dictionary to help your analysis: Product code details: 1001 = Red, 1002 = White, 1003 = Ros, 1004 = Sparkling Activity codes are defined as follow: HAR = Harvesting SOR = Sorting PRE = Pressing BOT = Bottling VAC = Vacation SICK = Sick Requirements 1. Review and validate the consolidated timesheet data received from HR. For any data issues identified, please move them to a separate tab. 2. Cross reference the product code against the product type. 3. Convert the activity codes to process descriptions. 4. Create a pivot table to summarize the actual labour hours by product and by activities. 5. Calculate the efficiency variance for each product by each process 6. Calculate the labour rate variance for each product by each process For requirements 586, please assume that actual units produced equal to expected units produced. B C D E 1 Product 2 Red Process Descriptions Budgeted Hours Budgeted Hourly Rates Expected Units 20,000 4 5 6 7 White Harvesting Sorting Pressing Bottling 2,600 $ 2,700 $ 1,200 $ 5,800 $ 16.00 16.50 17.50 17.50 16,000 Harvesting Sorting Pressing Bottling 3,400 $ 2,000 $ 2,300 $ 1,500 $ 16.00 16.00 16.50 16.50 9 10 11 12 Ros 13 14 15 16 17 Sparkling 18 19 20 21 22 NORRONOWN 15,000 Harvesting Sorting Pressing Bottling 2,700 $ 1,400 $ 2,500 $ 2,000 $ 16.00 16.50 17.00 17.00 17,000 Harvesting Sorting Pressing Bottling 3,700 $ 2,000 $ 2,000 $ 2,200 $ 16.00 16.50 17.00 17.00 Hours pont Hourly Rate 120 15 120 15 124 15 132 15 132 15 132 15 56 15 N/A N/A 60 N/A IN/A 132 15 124 15 128 15 128 15 128 20 120 20 128 20 132 20 132 20 0 124 20 124 20 132 20 128 20 112 20 52 20 IN/A AN/A 128 18 124 18 124 18 112 18 132 18 132 18 Imployee ID Month Product Code Activity Code 1 Jan 20 1001 BOT 1 Feb-20 1001 BOT 1 Mar-20 1001 BOT 1 Apr 20 1001 BOT 1 May 20 1001 BOT 1 Jun-20 1001 BOT 1 Jul 20 1001 BOT 1 Jul-20 N/A VAC 1 Aug-20 1001 BOT 1 Aug 20 N/A VAC 1 Sep-20 1001 BOT 1 Oct-20 1001 01 1 Nov 20 1001 BOT 1 Dec 20 1001 BOT 2 Jan-20 1001 BOT 2 Feb-20 1001 BOT 2 Mar 20 1001 BOT 2 Apr-20 1001 B01 2 May 20 1001 BOT 2 Jun 20 2 Jul-20 1001 BOT 2 Aug 20 1001 BOT 2 Sep-20 1001 BOT 2 O20 1001 BOT 2 Nov-20 3001 BOT 2 Dec 20 1001 BOT 2 Dec 20 AN/A VAC 3 Jan-20 1001 SOR 3 Feb-20 1001 SOR 3 Mar 20 1001 SOR 3 ApN20 300: SOR 3 May 20 1001 SOR 3 Jun-20 1001 SOR 3 Jul-20 3 Aur 20 1001 SOR 3 Sep 20 1001 SOR 3 Oct20 300: SOR 3 Nov 20 1001 SOR 3 Dec 20 1001 SOR 3 Dec-20 N/A VAC 4 an-20 1004 BOT 4 Feb-20 1004 807 4 Mar-20 1004 BOT Apr-20 1004 SOT 4 May 20 1004 BOT 4 Jun 20 1004 SOT 4 Jul-20 1004 801 4 Aur 20 IN/A VAC 4 Sep 20 1004 BOT 4 Oct 20 1000 BOT 4 Nov 20 1004 BOT 4 Dec 20 1004 BOT $ Jan 20 ERROR ERROR 5 Feb-20 1001 BOT 5 Mar 20 1001 BOT 5 Mar-20 N/A VAC 5 Apr 20 1001 BOT 5 May 20 1001 BOT 5 May 20 N/A VAC 5 Jun-20 1001 BOT 5 Jul 20 1001 BOT 5 Auto 1001 BOT 5 Sep-20 1001 BOT 5 Oct 20 1001 BOT S Nov 20 1001 BOT 5 Der 20 1001 BOT 6 Jan-20 1004 SOR 6 Feb-20 1004 SOR 6 Mar-20 3004 SOR 6 Apr 20 1004 SOR 6 May-20 1004 SOR 6 Jun-20 1004 SOR 6 Jul 20 N/A VAC 124 18 124 18 18 124 18 18 N/A N/A 132 20 128 20 132 20 128 20 128 20 128 20 20 N/A N/A 132 20 132 20 128 20 132 20 WALLE ERROR 124 15 54 15 N/A MN/A 124 15 60 15 N/A AN/A 124 15 120 15 120 15 132 15 128 15 15 120 15 120 18 132 18 125 18 120 18 124 18 18 N/A N/A G H Sep 20 Employee 10 6 6 6 6 6 7 7 7 7 7 7 7 7 7 7 7 7 8 8 8 R B 8 8 8 8 8 8 8 8 8 9 9 9 9 9 9 9 9 9 9 9 9 10 10 10 10 10 10 10 10 10 10 10 10 10 11 11 11 11 11 11 11 11 11 11 11 11 11 12 12 D Month Product Code Activity Code Aug 20 1004 SOR Sep-20 1004 SOR Oct 20 1004 SOR Nov-20 1004 SOR Dec 20 1004 SOR Jan-20 1002 HAR Feb 20 1002 HAR Mar-20 1002 HAR Apr 20 May-20 Jun 20 1002 HAR Jul-20 AN/A VAC Aug 20 1002 HAR 1002 HAR Oct-20 1002 MAR Nov 20 1002 HAR Dec-20 1002 HAR Jan 20 1002 SOR Jan-20 MN/A SICK Feb-20 1002 SOR Mar-20 1002 SOR Apr 20 1002 May-20 1002 SOR Jun-20 1002 SOR Jul-20 1002 SOR Aug 20 1002 SOR Sep-20 1002 SOR Oct-20 1002 SOR Oct 20 AN/A VAC Nov 20 1002 SOR Der 20 1002 SOR Jan-20 1003 PRE Feb-20 1003 PRE Mar 20 100% PRE Apr 20 1003 PRE May-20 1003 PRE Jun 20 1003 PRE Jul-20 1003 PRE Aug 20 1003 PRE Sep-20 1003 PRE Oct-20 1003 PRE Nov-20 1003 PRE Dec-20 1003 PRE Jan-20 1004 PRE Feb-20 1004 PRE Mar 20 1004 PRE Apr-20 1004 PRE May 20 1004 PRE Jun-20 MN/A VAC Jul 20 1004 PRE Aug 20 1004 PRE Sep 20 1004 PRE Sep-20 AN/A SICK Oct 20 1004 PRE Nov-20 1004 PRE Dec-20 1004 PRE Jan-20 1002 PRE Feb-20 1002 PRE Feb-20 AN/A VAC Mar-20 1002 PRE Apr 20 1002 PRE May-20 1002 PRE Jun 20 1002 PRE Jul-20 1002 PRE Aur 20 1002 PRE Sep-20 1002 PRE Oct 20 1002 PRE Nov 20 1002 PRE De 20 1002 PRE Jan-20 1001 HAR Jan-20 1003 HAR Hours spent Hourly Rate 128 18 124 18 124 18 120 18 132 18 124 17 124 17 120 17 0 0 128 17 IN/A IN/A 132 17 120 17 128 17 120 17 124 17 60 18 IN/A N/A 132 18 128 18 132 18 128 18 124 18 132 18 132 18 124 18 60 18 IN/A N/A 124 18 128 18 132 15 132 15 120 15 128 15 132 15 124 15 128 15 128 15 128 15 128 15 124 15 128 15 124 15 120 15 124 15 120 15 132 15 IN/A N/A 124 15 120 15 48 15 IN/A N/A 124 15 124 15 128 15 124 15 60 15 IN/A IN/A 120 15 128 15 132 15 124 15 128 15 124 15 128 15 120 15 124 15 124 15 68 17 60 17 9383333 3338338338 Jun-20 Dec-20 Employee ID Month Product Code Activity Code 12 Feb 20 1001 HAR 12 Feb-20 IN/A VAC 12 Mar-20 1001 MAR 12 Mar 20 1003 HAR 12 Apr20 1001 HAR 12 Apr-20 1003 HAR 12 May 20 1001 HAR 12 May-20 1003 HAR 12 Jun-20 1001 MAR 12 Jun-20 N/A SICK 12 Jun-20 1003 HAR 12 Jul 20 1001 MAR 12 Jul 20 1003 HAR 12 Aug 20 1001 HAR 12 Aug 20 1003 HAR 12 Sep 20 1001 HR 12 Sep-20 1003 HAR 12 On-20 1001 HAR 12 Oct 20 1003 HAR 12 Nov-20 1001 HR 12 Nov-20 12 Dec 20 IN/A VAC 12 Dec-20 1003 HAR 13 lan-20 1003 HAR 13 Feb 20 1003 HAR 13 Mar-20 1003 HAR 13 Apr 20 1003 HAR 13 May 20 1003 HAR 13 1003 HAR 13 Jul-20 1003 HAR 13 Aug 20 IN/A VAC 13 Sep 20 1003 HAR 13 Oct 20 1003 HAR 13 Nov 20 1003 HR 13 1003 HAR 14 Jan 20 1002 HAR 14 Jan 20 1004 BOT 14 Feb-20 1002 HAR 14 Feb-20 1004 BOT 14 Mar 20 1002 HAR 14 Mar-20 1004 BOT 14 Apr-20 1002 HAR 14 Apr 20 IN/A VAC 14 May 20 1002 HAR 14 May 20 1004 BOT 14 Jun 20 1002 HAR 14 Jun-20 1004 BOT 14 Jul-20 1002 MAR 14 Jul 20 1004 BOT 14 Aue 20 1002 HAR 14 Aug 20 1004 BOT 14 Sep 20 1002 HAR 14 Sep-20 1004 SOT 14 Oct-20 1002 MAR 14 Oct 20 1004 BOT 14 Nov-20 1002 HAR 14 Nov 20 1004 801 14 Dec 20 1002 HAR 14 De 20 1004 BOT 15 Jan-20 1002 PRE 15 Jan 20 N/A VAC 15 Feb-20 100) PRE 15 Feb-20 1003 MAR 15 Mar 20 1002 PRE 15 Mar-20 ERROR ERROR 15 Apr-20 1002 PRE 15 Apr 20 1003 HAR 15 May 20 1002 PRE May 20 1003 HAR 15 Jun 20 1002 PRE 15 Jun-20 1003 HAR 15 Jul-20 1002 PRE 15 M20 1003 HAR Style 60 17 N/A N/A 17 60 17 50 17 17 68 17 68 17 17 /A N/A 54 17 17 68 17 60 17 17 17 50 17 17 64 17 60 17 0 N/A N/A 54 17 320 15 132 15 120 15 324 15 128 15 132 15 124 15 N/A N/A 124 15 324 35 120 15 120 15 60 17 54 20 64 17 CH 20 60 17 68 20 44 17 N/A IN/A 68 17 20 60 17 54 20 17 60 20 60 12 20 17 54 20 17 60 20 64 17 20 60 17 54 20 15 N/A N/A 15 15 15 VALUE ERROR 15 50 15 15 15 64 15 33333333333333333 1898989898989898 333 389333 15 15 58 G M Employee ID Month Product Code Activity Code 15 Aug-20 1002 PRE 15 Aug 20 1003 HAR 15 Sep 20 1002 PRE 15 Sep-20 1003 HR 15 Oct 20 1002 PRE 15 Oct 20 1003 HAR 15 Nov 20 1002 PRE 15 Nov 20 1003 HAR 15 Des 20 2002 PRE 15 Dec-20 3003 MAR 16 Jan 20 1002 BOT 16 Feb-20 N/A VAC 16 Mar-20 1002 BOT 16 Apr 20 1002 BOT 16 May 20 2002 BOT 16 Jun-20 1002 BOT 16 Jul-20 1002 BOT 16 Aug-20 1002 BOT 16 Sep-20 2002 BOT 16 Oct 20 1002 BOT 16 Nov 20 1002 BOT 16 Dec-20 1002 BOT 17 Jan 20 1001 PRE 17 Feb-20 1001 PRE 12 Mar-20 1001 PRE 17 Apr 20 1001 PRE 17 Apr 20 N/A SICK 17 May 20 1001 PRE 17 Jun-20 1001 PRE 17 Jul-20 1001 PRE 17 A70 300: PRE 17 Sep 20 1001 PRE 17 Oct 20 1001 PRE 17 Nov 20 N/A VAC 17 Dec 20 1001 PRE 18 Jan-20 1003 HAR 18 Jan-20 1003 BOT 18 Feb 20 1003 HAR 18 Feb-20 2003 BOT 18 Mar-20 18 Mar-20 1001 BOT 18 Apr 20 1003 HAR 18 Apr-20 3003 BOT 18 May 20 1003 HAR 18 May 20 1003 BOT 18 lan-20 1003 HAR 18 Jun-20 1003 BOT 18 Jul 20 1003 HAR 18 20 IN/A VAC 18 Aug 20 1003 HAR 18 Au 20 1003 BOT 18 1003 HAR 18 Sep-20 1003 BOT 18 Oct20 1003 HAR 18 Oct 20 3003 BOT 18 Nov-20 1003 HAR 18 Now 20 1003 BOT 18 Dec-20 1003 HAR 18 Dec 20 1003 BOT 19 Jan 20 1002 HAR 19 Feb-20 1002 HAR 19 Mar-20 1002 M 19 Apr 20 1002 HAR 19 May-20 1002 HAR 19 Jun-20 1002 HAR 19 Jul 20 1002 HAR 19 A 20 N/A VAC 19 Sep-20 1002 MAR 19 Oct 20 1002 HAR 19 Now 20 19 Dec-20 1002 HAR 20 Jan-20 2003 SOR Heurs Scent HoutRate 60 15 68 15 54 15 60 15 68 15 64 15 65 15 54 15 68 15 64 15 128 20 N/A IN/A 120 20 124 20 124 20 124 20 132 20 128 20 120 20 120 20 124 20 124 20 124 15 124 15 132 15 54 15 IN/A N/A 124 15 128 15 132 15 124 15 228 15 124 15 N/A IN/A 124 15 64 17 60 20 68 17 68 20 o 66 20 68 17 64 20 17 54 20 60 17 66 20 54 17 N/A GO 17 68 20 64 17 66 20 50 17 68 20 CH 17 50 20 64 17 GO 20 128 17 120 17 120 17 120 17 120 17 120 17 128 17 N/A N/A 124 12 124 17 0 124 17 120 18 N/A Sep-20 G . Apr 20 Hours Spent Hourly Rate 128 18 124 18 120 18 120 18 120 120 18 112 18 132 18 132 18 N/A N/A IN/A AN/A 124 18 15 15 14 15 15 15 15 15 15 15 15 N/A N/A 15 60 15 15 15 15 881&IS C D Employee ID Month Product Code Activity Code 20 Feb-20 1003 SOR 20 Mar-20 1003 SOR 20 1003 SOR 20 May-20 1003 SOR 20 Jun-20 1003 SOR 20 Jul 20 1003 SOR 20 Aur 20 1003 SOR 20 Sep-20 1003 SOR 20 Oct-20 1003 SOR 20 Nov-20 N/A VAC 20 Nov 20 AN/A SICK 20 Dec-20 1003 SOR 21 Jan-20 1001 SOR 21 Jan-20 1002 BOT 21 Feb-20 1001 SOR 21 Feb-20 1002 BOT 21 Mar-20 1001 SOR 21 Mar-20 1002 BOT 21 Apr 20 1001 SOR 21 Apr-20 1002 DOT 21 May 20 1001 SOR 21 May-20 1002 BOT 21 Jun-20 N/A VAC 21 Jun-20 1002 BOT 23 Jul-20 1001 SOR 21 Jul-20 1002 BOT 21 Aug 20 1001 SOR 21 Aug 20 1002 BOT 21 Sep 20 21 Sep-20 1002 BOT 21 Oct-20 1001 SOR 21 Oct 20 1002 BOT 21 Nov-20 1001 SOR 21 Nov 20 1002 BOT 21 Dec-20 1001 SOR 21 Dec-20 1002 BOT 22 Jan 20 1001 BOT 22 Jan-20 N/A VAC 22 Feb-20 1001 BOT 22 Feb-20 1003 SOR 22 Mar-20 1001 BOT 22 Mar-20 1003 SOR 22 Apr 20 1001 BOT 22 Apr-20 1003 SOR 22 May 20 1001 BOT 22 May-20 1003 SOR 22 Jun 20 1001 BOT 22 Jun-20 1003 SOR 22 Jul-20 1001 BOT 22 Jul 20 1003 SOR 22 Aug-20 1001 BOT 22 Aug 20 1003 SOR 22 Sep 20 AN/A VAC 22 Sep-20 1003 SOR 22 Oct 20 1001 BOT 22 Oct-20 ERROR ERROR 22 Nov-20 1001 DOT 22 Nov 20 1003 SOR 22 Dec-20 1001 BOT 22 Dec-20 1003 SOR 23 Jan-20 1004 PRE 23 Feb-20 1004 PRE 23 Mar-20 1004 PRE 23 Apr-20 1004 PRE 23 May 20 1004 PRE 23 Jun 20 1004 PRE 23 Jul 20 1004 PRE 23 AN/A VAC 23 Sep-20 1004 PRE 23 Oct 20 1004 PRE 23 Nov 20 1004 PRE 23 Dec-20 1004 PRE 15 15 15 15 15 15 15 20 N/A N/A 20 18 20 18 20 18 60 20 60 18 68 20 18 60 20 60 18 68 20 64 18 AN/A #N/A 18 68 20 INALLE ERROR 60 20 64 18 68 20 68 18 128 20 124 20 132 20 124 20 132 20 124 20 128 20 N/A IN/A 128 20 124 20 128 20 128 20 $$ $$88888888888888888III. &&&88 Aug 20 G H Hours Spent Hourly Rae 64 17 20 20 17 20 N/A IN/A 20 20 20 17 64 123 IN/A 124 124 120 20 17 20 17 N/A 17 3333333333333333333333333333333 Employee ID Month Product Code Activity Code 24 Jan-20 1001 HR 24 Jan-20 1003 PRE 24 Feb-20 1001 HR 24 Feb 20 1003 PRE 24 Mar 20 1001 HR 24 Mar 30 1003 PRE 24 Apr-20 1001 HR 24 Apr 20 1003 PRE 24 May 20 1001 HAR 24 May 20 1003 PRE 24 Jun 20 N/A VAC 24 Jun-20 1003 PRE 24 20 1001 HAR 24 Jul 20 100) PRE 24 A20 1001 HAR 24 A 20 1003 PRI 24 Sep-20 1001 HR 24 Sep 20 1003 PRE 24 Oct 20 1001 HAR 24 Oct 20 1003 PRE 24 Now 20 1001 HR 24 Nov-20 1003 PRE 24 Dec 20 1001 HR 24 Dec-20 1003 PRE 25 an-20 1004 HAR 25 Feb-20 N/A VAC 25 Mar 20 1004 HAR 25 Apr 20 1004 HAR 25 May 20 1004 HAR 25 Jun-20 1004 25 Jul 20 1004 M 25 A 20 1004 HAR 25 Sep 20 1004 HAR 25 Oct 20 1004 HAR 25 Nov 20 1004 PUR 25 Dec 20 1004 HAR 26 Jan-20 1002 HAR 26 lan-20 1002 SOR 26 Feb-20 1002 HUR 26 Feb-20 1002 SOR 26 Mar 20 N/A VAC 26 Mar 20 1002 SOR 26 Apr-20 1002 HAR 26 Apr-20 1002 SOR 25 May 20 1002 HR 26 May 20 26 Jun-20 ERROR ERROR 26 Jun-20 1002 SOR 26 Jul 20 1002 HUR 26 Jul 20 1002 SOR 26 Aug 0 1002 HAR 26 Aug-20 1002 SOR 26 S-20 1002 HUR 26 Sep 20 1002 SOR 26 Oct 20 1002 HAR 26 Oct 20 1002 SOR 26 Now 1002 HAR 26 Nov 20 1002 SOR 26 Dec 20 1002 HAR 26 Dec 20 1002 SOR 27 Jan-20 1003 BOT 27 Jan-20 1004 MR 27 Feb-20 1003 BOT 27 Feb 20 1004 H 27 Mar 20 AN/A VAC 27 Mar-20 1004 MAR 27 Apr 20 1003 BOT 27 Apr 20 1004 HAR 27 May 20 1003 BOT 27 May 20 1004 MAR 27 Jun-20 1003 BOT 27 Jun-20 1004 MUR 27 20 1003 BOT SAASAASAAAAAAAAAAAAAAAAAAAAAAAAABAAN 120 17 17 17 17 124 128 120 124 124 120 64 17 18 60 IN/A 18 N/A 60 60 68 17 18 17 0 VALLEI ERROR 64 60 18 17 18 17 GIR88888888888 64 60 60 60 60 64 60 17 18 17 18 17 18 17 18 15 15 15 15 60 68 60 64 66 68 N/A 60 60 58 68 64 64 IN/A 99393999 15 15 15 15 15 15 60 15 #88888 Employee Month Product Code Activity Code 27 Jul 20 1004 HUR 27 Aug 20 1003 BOT 27 Aug 20 1004 HAR 27 Sep 20 1003 BOT 27 Sep 20 1004 HAR 27 Oct 20 1003 BOT 27 Oct 20 1004 MAR 27 Nov-20 1003 BOT 27 Nov 20 1004 HAR 27 Dec-20 1003 BOT 27 Dec-20 1004 HAR 28 Ian 20 1001 HAR 28 Feb-20 N/A VAC 28 Mar-20 1001 MAR 28 Apr-20 1001 HAR 28 May 20 1001 HAR 28 Jun-20 1001 HAR 28 Nul-20 1001 HAR 28 Aug 20 1001 HAR 28 Sep 20 1001 HAR 28 Oct 20 1001 HAR 28 Nov-20 1001 MAR 28 Dec-20 1001 HAR 29 Jan 20 1001 SOR 29 Jan 20 1001 BOT 29 Feb-20 1001 SOR 29 Feb-20 1001 BOT 29 Mar 20 1001 SOR 29 Mar 20 1001 BOT 29 Apr-20 1001 SOR 29 Apr-20 1001 BOT 29 May 20 1001 SOR 29 May 20 1001 BOT 29 jun 20 1001 SOR 29 Jun 20 1001 BOT 29 Jul-20 1001 SOR 29 Al-20 N/A VAC 29 Aug-20 1001 SOR 29 Aug 20 1001 BOT 29 Sep 20 1001 SOR 29 Sep-20 1001 BOT 29 Oct 20 1001 SOR 29 Oct 20 1001 BOT 29 Nov 20 1001 SOR 29 Nov-20 1001 BOT 29 Dec-20 1001 SOR 29 Dec. 20 1001 BOT 30 Jan-20 1001 BOT 30 20 1004 MAR 30 Feb-20 1001 BOT 30 Feb-20 1004 HAR 30 Mar-20 N/A VAC 30 Mar-20 1004 HR 30 Apr-20 1001 BOT 30 Apr 20 1004 HAR 30 May 20 1001 BOT 30 May-20 1004 HAR 30 jun-20 1001 BOT 30 Jun 20 N/A VAC 30 M20 1001 BOT 30 l-20 1004 HUR 30 Aur 20 1001 BOT 30 Aug 20 1004 HAR 30 Sep-20 1001 BOT 30 Sep-20 1004 HAR 30 Oct 20 1001 BOT 30 Oct 20 1004 HAR 30 Nov 20 1001 BOT 30 Nov-20 1004 HAR 30 Dec 20 1001 BOT 30 Dec 20 1004 HAR Hous spent Hourly Rate 60 15 54 15 68 15 68 15 60 15 60 15 60 15 68 15 68 15 60 15 68 15 128 17 AN/A IN/A 124 17 128 17 128 17 124 17 120 17 120 17 124 17 120 17 132 17 128 17 64 18 60 20 68 18 64 20 60 18 64 20 68 18 64 20 64 18 64 20 60 18 64 20 60 18 IN/A IN/A 68 60 20 64 18 68 20 68 18 68 20 68 18 60 20 64 18 68 20 64 15 68 15 64 15 60 15 IN/A N/A 64 15 68 15 64 15 60 15 60 15 60 15 AN/A N/A 64 15 64 15 60 15 68 15 60 15 68 15 68 15 60 15 64 15 60 15 60 15 60 15 9999 In this Lab, you will focus on: Master the data (M) Perform test plan (P) Case: Boutique Winery is a small but fast growing winery in Ontario. It has received many awards from its 4 classic wine products (Red, White, Ros and Sparkling). The rapid growth has put a lot of strain on its staff and management is concern about the increase in labour cost. You, a consultant, has been engaged to help with the analysis to review the labour cost in wine production. The Finance team has provided excerpts of their data dictionary to help your analysis: Product code details: 1001 = Red, 1002 = White, 1003 = Ros, 1004 = Sparkling Activity codes are defined as follow: HAR = Harvesting SOR = Sorting PRE = Pressing BOT = Bottling VAC = Vacation SICK = Sick Requirements 1. Review and validate the consolidated timesheet data received from HR. For any data issues identified, please move them to a separate tab. 2. Cross reference the product code against the product type. 3. Convert the activity codes to process descriptions. 4. Create a pivot table to summarize the actual labour hours by product and by activities. 5. Calculate the efficiency variance for each product by each process 6. Calculate the labour rate variance for each product by each process For requirements 586, please assume that actual units produced equal to expected units produced. B C D E 1 Product 2 Red Process Descriptions Budgeted Hours Budgeted Hourly Rates Expected Units 20,000 4 5 6 7 White Harvesting Sorting Pressing Bottling 2,600 $ 2,700 $ 1,200 $ 5,800 $ 16.00 16.50 17.50 17.50 16,000 Harvesting Sorting Pressing Bottling 3,400 $ 2,000 $ 2,300 $ 1,500 $ 16.00 16.00 16.50 16.50 9 10 11 12 Ros 13 14 15 16 17 Sparkling 18 19 20 21 22 NORRONOWN 15,000 Harvesting Sorting Pressing Bottling 2,700 $ 1,400 $ 2,500 $ 2,000 $ 16.00 16.50 17.00 17.00 17,000 Harvesting Sorting Pressing Bottling 3,700 $ 2,000 $ 2,000 $ 2,200 $ 16.00 16.50 17.00 17.00 Hours pont Hourly Rate 120 15 120 15 124 15 132 15 132 15 132 15 56 15 N/A N/A 60 N/A IN/A 132 15 124 15 128 15 128 15 128 20 120 20 128 20 132 20 132 20 0 124 20 124 20 132 20 128 20 112 20 52 20 IN/A AN/A 128 18 124 18 124 18 112 18 132 18 132 18 Imployee ID Month Product Code Activity Code 1 Jan 20 1001 BOT 1 Feb-20 1001 BOT 1 Mar-20 1001 BOT 1 Apr 20 1001 BOT 1 May 20 1001 BOT 1 Jun-20 1001 BOT 1 Jul 20 1001 BOT 1 Jul-20 N/A VAC 1 Aug-20 1001 BOT 1 Aug 20 N/A VAC 1 Sep-20 1001 BOT 1 Oct-20 1001 01 1 Nov 20 1001 BOT 1 Dec 20 1001 BOT 2 Jan-20 1001 BOT 2 Feb-20 1001 BOT 2 Mar 20 1001 BOT 2 Apr-20 1001 B01 2 May 20 1001 BOT 2 Jun 20 2 Jul-20 1001 BOT 2 Aug 20 1001 BOT 2 Sep-20 1001 BOT 2 O20 1001 BOT 2 Nov-20 3001 BOT 2 Dec 20 1001 BOT 2 Dec 20 AN/A VAC 3 Jan-20 1001 SOR 3 Feb-20 1001 SOR 3 Mar 20 1001 SOR 3 ApN20 300: SOR 3 May 20 1001 SOR 3 Jun-20 1001 SOR 3 Jul-20 3 Aur 20 1001 SOR 3 Sep 20 1001 SOR 3 Oct20 300: SOR 3 Nov 20 1001 SOR 3 Dec 20 1001 SOR 3 Dec-20 N/A VAC 4 an-20 1004 BOT 4 Feb-20 1004 807 4 Mar-20 1004 BOT Apr-20 1004 SOT 4 May 20 1004 BOT 4 Jun 20 1004 SOT 4 Jul-20 1004 801 4 Aur 20 IN/A VAC 4 Sep 20 1004 BOT 4 Oct 20 1000 BOT 4 Nov 20 1004 BOT 4 Dec 20 1004 BOT $ Jan 20 ERROR ERROR 5 Feb-20 1001 BOT 5 Mar 20 1001 BOT 5 Mar-20 N/A VAC 5 Apr 20 1001 BOT 5 May 20 1001 BOT 5 May 20 N/A VAC 5 Jun-20 1001 BOT 5 Jul 20 1001 BOT 5 Auto 1001 BOT 5 Sep-20 1001 BOT 5 Oct 20 1001 BOT S Nov 20 1001 BOT 5 Der 20 1001 BOT 6 Jan-20 1004 SOR 6 Feb-20 1004 SOR 6 Mar-20 3004 SOR 6 Apr 20 1004 SOR 6 May-20 1004 SOR 6 Jun-20 1004 SOR 6 Jul 20 N/A VAC 124 18 124 18 18 124 18 18 N/A N/A 132 20 128 20 132 20 128 20 128 20 128 20 20 N/A N/A 132 20 132 20 128 20 132 20 WALLE ERROR 124 15 54 15 N/A MN/A 124 15 60 15 N/A AN/A 124 15 120 15 120 15 132 15 128 15 15 120 15 120 18 132 18 125 18 120 18 124 18 18 N/A N/A G H Sep 20 Employee 10 6 6 6 6 6 7 7 7 7 7 7 7 7 7 7 7 7 8 8 8 R B 8 8 8 8 8 8 8 8 8 9 9 9 9 9 9 9 9 9 9 9 9 10 10 10 10 10 10 10 10 10 10 10 10 10 11 11 11 11 11 11 11 11 11 11 11 11 11 12 12 D Month Product Code Activity Code Aug 20 1004 SOR Sep-20 1004 SOR Oct 20 1004 SOR Nov-20 1004 SOR Dec 20 1004 SOR Jan-20 1002 HAR Feb 20 1002 HAR Mar-20 1002 HAR Apr 20 May-20 Jun 20 1002 HAR Jul-20 AN/A VAC Aug 20 1002 HAR 1002 HAR Oct-20 1002 MAR Nov 20 1002 HAR Dec-20 1002 HAR Jan 20 1002 SOR Jan-20 MN/A SICK Feb-20 1002 SOR Mar-20 1002 SOR Apr 20 1002 May-20 1002 SOR Jun-20 1002 SOR Jul-20 1002 SOR Aug 20 1002 SOR Sep-20 1002 SOR Oct-20 1002 SOR Oct 20 AN/A VAC Nov 20 1002 SOR Der 20 1002 SOR Jan-20 1003 PRE Feb-20 1003 PRE Mar 20 100% PRE Apr 20 1003 PRE May-20 1003 PRE Jun 20 1003 PRE Jul-20 1003 PRE Aug 20 1003 PRE Sep-20 1003 PRE Oct-20 1003 PRE Nov-20 1003 PRE Dec-20 1003 PRE Jan-20 1004 PRE Feb-20 1004 PRE Mar 20 1004 PRE Apr-20 1004 PRE May 20 1004 PRE Jun-20 MN/A VAC Jul 20 1004 PRE Aug 20 1004 PRE Sep 20 1004 PRE Sep-20 AN/A SICK Oct 20 1004 PRE Nov-20 1004 PRE Dec-20 1004 PRE Jan-20 1002 PRE Feb-20 1002 PRE Feb-20 AN/A VAC Mar-20 1002 PRE Apr 20 1002 PRE May-20 1002 PRE Jun 20 1002 PRE Jul-20 1002 PRE Aur 20 1002 PRE Sep-20 1002 PRE Oct 20 1002 PRE Nov 20 1002 PRE De 20 1002 PRE Jan-20 1001 HAR Jan-20 1003 HAR Hours spent Hourly Rate 128 18 124 18 124 18 120 18 132 18 124 17 124 17 120 17 0 0 128 17 IN/A IN/A 132 17 120 17 128 17 120 17 124 17 60 18 IN/A N/A 132 18 128 18 132 18 128 18 124 18 132 18 132 18 124 18 60 18 IN/A N/A 124 18 128 18 132 15 132 15 120 15 128 15 132 15 124 15 128 15 128 15 128 15 128 15 124 15 128 15 124 15 120 15 124 15 120 15 132 15 IN/A N/A 124 15 120 15 48 15 IN/A N/A 124 15 124 15 128 15 124 15 60 15 IN/A IN/A 120 15 128 15 132 15 124 15 128 15 124 15 128 15 120 15 124 15 124 15 68 17 60 17 9383333 3338338338 Jun-20 Dec-20 Employee ID Month Product Code Activity Code 12 Feb 20 1001 HAR 12 Feb-20 IN/A VAC 12 Mar-20 1001 MAR 12 Mar 20 1003 HAR 12 Apr20 1001 HAR 12 Apr-20 1003 HAR 12 May 20 1001 HAR 12 May-20 1003 HAR 12 Jun-20 1001 MAR 12 Jun-20 N/A SICK 12 Jun-20 1003 HAR 12 Jul 20 1001 MAR 12 Jul 20 1003 HAR 12 Aug 20 1001 HAR 12 Aug 20 1003 HAR 12 Sep 20 1001 HR 12 Sep-20 1003 HAR 12 On-20 1001 HAR 12 Oct 20 1003 HAR 12 Nov-20 1001 HR 12 Nov-20 12 Dec 20 IN/A VAC 12 Dec-20 1003 HAR 13 lan-20 1003 HAR 13 Feb 20 1003 HAR 13 Mar-20 1003 HAR 13 Apr 20 1003 HAR 13 May 20 1003 HAR 13 1003 HAR 13 Jul-20 1003 HAR 13 Aug 20 IN/A VAC 13 Sep 20 1003 HAR 13 Oct 20 1003 HAR 13 Nov 20 1003 HR 13 1003 HAR 14 Jan 20 1002 HAR 14 Jan 20 1004 BOT 14 Feb-20 1002 HAR 14 Feb-20 1004 BOT 14 Mar 20 1002 HAR 14 Mar-20 1004 BOT 14 Apr-20 1002 HAR 14 Apr 20 IN/A VAC 14 May 20 1002 HAR 14 May 20 1004 BOT 14 Jun 20 1002 HAR 14 Jun-20 1004 BOT 14 Jul-20 1002 MAR 14 Jul 20 1004 BOT 14 Aue 20 1002 HAR 14 Aug 20 1004 BOT 14 Sep 20 1002 HAR 14 Sep-20 1004 SOT 14 Oct-20 1002 MAR 14 Oct 20 1004 BOT 14 Nov-20 1002 HAR 14 Nov 20 1004 801 14 Dec 20 1002 HAR 14 De 20 1004 BOT 15 Jan-20 1002 PRE 15 Jan 20 N/A VAC 15 Feb-20 100) PRE 15 Feb-20 1003 MAR 15 Mar 20 1002 PRE 15 Mar-20 ERROR ERROR 15 Apr-20 1002 PRE 15 Apr 20 1003 HAR 15 May 20 1002 PRE May 20 1003 HAR 15 Jun 20 1002 PRE 15 Jun-20 1003 HAR 15 Jul-20 1002 PRE 15 M20 1003 HAR Style 60 17 N/A N/A 17 60 17 50 17 17 68 17 68 17 17 /A N/A 54 17 17 68 17 60 17 17 17 50 17 17 64 17 60 17 0 N/A N/A 54 17 320 15 132 15 120 15 324 15 128 15 132 15 124 15 N/A N/A 124 15 324 35 120 15 120 15 60 17 54 20 64 17 CH 20 60 17 68 20 44 17 N/A IN/A 68 17 20 60 17 54 20 17 60 20 60 12 20 17 54 20 17 60 20 64 17 20 60 17 54 20 15 N/A N/A 15 15 15 VALUE ERROR 15 50 15 15 15 64 15 33333333333333333 1898989898989898 333 389333 15 15 58 G M Employee ID Month Product Code Activity Code 15 Aug-20 1002 PRE 15 Aug 20 1003 HAR 15 Sep 20 1002 PRE 15 Sep-20 1003 HR 15 Oct 20 1002 PRE 15 Oct 20 1003 HAR 15 Nov 20 1002 PRE 15 Nov 20 1003 HAR 15 Des 20 2002 PRE 15 Dec-20 3003 MAR 16 Jan 20 1002 BOT 16 Feb-20 N/A VAC 16 Mar-20 1002 BOT 16 Apr 20 1002 BOT 16 May 20 2002 BOT 16 Jun-20 1002 BOT 16 Jul-20 1002 BOT 16 Aug-20 1002 BOT 16 Sep-20 2002 BOT 16 Oct 20 1002 BOT 16 Nov 20 1002 BOT 16 Dec-20 1002 BOT 17 Jan 20 1001 PRE 17 Feb-20 1001 PRE 12 Mar-20 1001 PRE 17 Apr 20 1001 PRE 17 Apr 20 N/A SICK 17 May 20 1001 PRE 17 Jun-20 1001 PRE 17 Jul-20 1001 PRE 17 A70 300: PRE 17 Sep 20 1001 PRE 17 Oct 20 1001 PRE 17 Nov 20 N/A VAC 17 Dec 20 1001 PRE 18 Jan-20 1003 HAR 18 Jan-20 1003 BOT 18 Feb 20 1003 HAR 18 Feb-20 2003 BOT 18 Mar-20 18 Mar-20 1001 BOT 18 Apr 20 1003 HAR 18 Apr-20 3003 BOT 18 May 20 1003 HAR 18 May 20 1003 BOT 18 lan-20 1003 HAR 18 Jun-20 1003 BOT 18 Jul 20 1003 HAR 18 20 IN/A VAC 18 Aug 20 1003 HAR 18 Au 20 1003 BOT 18 1003 HAR 18 Sep-20 1003 BOT 18 Oct20 1003 HAR 18 Oct 20 3003 BOT 18 Nov-20 1003 HAR 18 Now 20 1003 BOT 18 Dec-20 1003 HAR 18 Dec 20 1003 BOT 19 Jan 20 1002 HAR 19 Feb-20 1002 HAR 19 Mar-20 1002 M 19 Apr 20 1002 HAR 19 May-20 1002 HAR 19 Jun-20 1002 HAR 19 Jul 20 1002 HAR 19 A 20 N/A VAC 19 Sep-20 1002 MAR 19 Oct 20 1002 HAR 19 Now 20 19 Dec-20 1002 HAR 20 Jan-20 2003 SOR Heurs Scent HoutRate 60 15 68 15 54 15 60 15 68 15 64 15 65 15 54 15 68 15 64 15 128 20 N/A IN/A 120 20 124 20 124 20 124 20 132 20 128 20 120 20 120 20 124 20 124 20 124 15 124 15 132 15 54 15 IN/A N/A 124 15 128 15 132 15 124 15 228 15 124 15 N/A IN/A 124 15 64 17 60 20 68 17 68 20 o 66 20 68 17 64 20 17 54 20 60 17 66 20 54 17 N/A GO 17 68 20 64 17 66 20 50 17 68 20 CH 17 50 20 64 17 GO 20 128 17 120 17 120 17 120 17 120 17 120 17 128 17 N/A N/A 124 12 124 17 0 124 17 120 18 N/A Sep-20 G . Apr 20 Hours Spent Hourly Rate 128 18 124 18 120 18 120 18 120 120 18 112 18 132 18 132 18 N/A N/A IN/A AN/A 124 18 15 15 14 15 15 15 15 15 15 15 15 N/A N/A 15 60 15 15 15 15 881&IS C D Employee ID Month Product Code Activity Code 20 Feb-20 1003 SOR 20 Mar-20 1003 SOR 20 1003 SOR 20 May-20 1003 SOR 20 Jun-20 1003 SOR 20 Jul 20 1003 SOR 20 Aur 20 1003 SOR 20 Sep-20 1003 SOR 20 Oct-20 1003 SOR 20 Nov-20 N/A VAC 20 Nov 20 AN/A SICK 20 Dec-20 1003 SOR 21 Jan-20 1001 SOR 21 Jan-20 1002 BOT 21 Feb-20 1001 SOR 21 Feb-20 1002 BOT 21 Mar-20 1001 SOR 21 Mar-20 1002 BOT 21 Apr 20 1001 SOR 21 Apr-20 1002 DOT 21 May 20 1001 SOR 21 May-20 1002 BOT 21 Jun-20 N/A VAC 21 Jun-20 1002 BOT 23 Jul-20 1001 SOR 21 Jul-20 1002 BOT 21 Aug 20 1001 SOR 21 Aug 20 1002 BOT 21 Sep 20 21 Sep-20 1002 BOT 21 Oct-20 1001 SOR 21 Oct 20 1002 BOT 21 Nov-20 1001 SOR 21 Nov 20 1002 BOT 21 Dec-20 1001 SOR 21 Dec-20 1002 BOT 22 Jan 20 1001 BOT 22 Jan-20 N/A VAC 22 Feb-20 1001 BOT 22 Feb-20 1003 SOR 22 Mar-20 1001 BOT 22 Mar-20 1003 SOR 22 Apr 20 1001 BOT 22 Apr-20 1003 SOR 22 May 20 1001 BOT 22 May-20 1003 SOR 22 Jun 20 1001 BOT 22 Jun-20 1003 SOR 22 Jul-20 1001 BOT 22 Jul 20 1003 SOR 22 Aug-20 1001 BOT 22 Aug 20 1003 SOR 22 Sep 20 AN/A VAC 22 Sep-20 1003 SOR 22 Oct 20 1001 BOT 22 Oct-20 ERROR ERROR 22 Nov-20 1001 DOT 22 Nov 20 1003 SOR 22 Dec-20 1001 BOT 22 Dec-20 1003 SOR 23 Jan-20 1004 PRE 23 Feb-20 1004 PRE 23 Mar-20 1004 PRE 23 Apr-20 1004 PRE 23 May 20 1004 PRE 23 Jun 20 1004 PRE 23 Jul 20 1004 PRE 23 AN/A VAC 23 Sep-20 1004 PRE 23 Oct 20 1004 PRE 23 Nov 20 1004 PRE 23 Dec-20 1004 PRE 15 15 15 15 15 15 15 20 N/A N/A 20 18 20 18 20 18 60 20 60 18 68 20 18 60 20 60 18 68 20 64 18 AN/A #N/A 18 68 20 INALLE ERROR 60 20 64 18 68 20 68 18 128 20 124 20 132 20 124 20 132 20 124 20 128 20 N/A IN/A 128 20 124 20 128 20 128 20 $$ $$88888888888888888III. &&&88 Aug 20 G H Hours Spent Hourly Rae 64 17 20 20 17 20 N/A IN/A 20 20 20 17 64 123 IN/A 124 124 120 20 17 20 17 N/A 17 3333333333333333333333333333333 Employee ID Month Product Code Activity Code 24 Jan-20 1001 HR 24 Jan-20 1003 PRE 24 Feb-20 1001 HR 24 Feb 20 1003 PRE 24 Mar 20 1001 HR 24 Mar 30 1003 PRE 24 Apr-20 1001 HR 24 Apr 20 1003 PRE 24 May 20 1001 HAR 24 May 20 1003 PRE 24 Jun 20 N/A VAC 24 Jun-20 1003 PRE 24 20 1001 HAR 24 Jul 20 100) PRE 24 A20 1001 HAR 24 A 20 1003 PRI 24 Sep-20 1001 HR 24 Sep 20 1003 PRE 24 Oct 20 1001 HAR 24 Oct 20 1003 PRE 24 Now 20 1001 HR 24 Nov-20 1003 PRE 24 Dec 20 1001 HR 24 Dec-20 1003 PRE 25 an-20 1004 HAR 25 Feb-20 N/A VAC 25 Mar 20 1004 HAR 25 Apr 20 1004 HAR 25 May 20 1004 HAR 25 Jun-20 1004 25 Jul 20 1004 M 25 A 20 1004 HAR 25 Sep 20 1004 HAR 25 Oct 20 1004 HAR 25 Nov 20 1004 PUR 25 Dec 20 1004 HAR 26 Jan-20 1002 HAR 26 lan-20 1002 SOR 26 Feb-20 1002 HUR 26 Feb-20 1002 SOR 26 Mar 20 N/A VAC 26 Mar 20 1002 SOR 26 Apr-20 1002 HAR 26 Apr-20 1002 SOR 25 May 20 1002 HR 26 May 20 26 Jun-20 ERROR ERROR 26 Jun-20 1002 SOR 26 Jul 20 1002 HUR 26 Jul 20 1002 SOR 26 Aug 0 1002 HAR 26 Aug-20 1002 SOR 26 S-20 1002 HUR 26 Sep 20 1002 SOR 26 Oct 20 1002 HAR 26 Oct 20 1002 SOR 26 Now 1002 HAR 26 Nov 20 1002 SOR 26 Dec 20 1002 HAR 26 Dec 20 1002 SOR 27 Jan-20 1003 BOT 27 Jan-20 1004 MR 27 Feb-20 1003 BOT 27 Feb 20 1004 H 27 Mar 20 AN/A VAC 27 Mar-20 1004 MAR 27 Apr 20 1003 BOT 27 Apr 20 1004 HAR 27 May 20 1003 BOT 27 May 20 1004 MAR 27 Jun-20 1003 BOT 27 Jun-20 1004 MUR 27 20 1003 BOT SAASAASAAAAAAAAAAAAAAAAAAAAAAAAABAAN 120 17 17 17 17 124 128 120 124 124 120 64 17 18 60 IN/A 18 N/A 60 60 68 17 18 17 0 VALLEI ERROR 64 60 18 17 18 17 GIR88888888888 64 60 60 60 60 64 60 17 18 17 18 17 18 17 18 15 15 15 15 60 68 60 64 66 68 N/A 60 60 58 68 64 64 IN/A 99393999 15 15 15 15 15 15 60 15 #88888 Employee Month Product Code Activity Code 27 Jul 20 1004 HUR 27 Aug 20 1003 BOT 27 Aug 20 1004 HAR 27 Sep 20 1003 BOT 27 Sep 20 1004 HAR 27 Oct 20 1003 BOT 27 Oct 20 1004 MAR 27 Nov-20 1003 BOT 27 Nov 20 1004 HAR 27 Dec-20 1003 BOT 27 Dec-20 1004 HAR 28 Ian 20 1001 HAR 28 Feb-20 N/A VAC 28 Mar-20 1001 MAR 28 Apr-20 1001 HAR 28 May 20 1001 HAR 28 Jun-20 1001 HAR 28 Nul-20 1001 HAR 28 Aug 20 1001 HAR 28 Sep 20 1001 HAR 28 Oct 20 1001 HAR 28 Nov-20 1001 MAR 28 Dec-20 1001 HAR 29 Jan 20 1001 SOR 29 Jan 20 1001 BOT 29 Feb-20 1001 SOR 29 Feb-20 1001 BOT 29 Mar 20 1001 SOR 29 Mar 20 1001 BOT 29 Apr-20 1001 SOR 29 Apr-20 1001 BOT 29 May 20 1001 SOR 29 May 20 1001 BOT 29 jun 20 1001 SOR 29 Jun 20 1001 BOT 29 Jul-20 1001 SOR 29 Al-20 N/A VAC 29 Aug-20 1001 SOR 29 Aug 20 1001 BOT 29 Sep 20 1001 SOR 29 Sep-20 1001 BOT 29 Oct 20 1001 SOR 29 Oct 20 1001 BOT 29 Nov 20 1001 SOR 29 Nov-20 1001 BOT 29 Dec-20 1001 SOR 29 Dec. 20 1001 BOT 30 Jan-20 1001 BOT 30 20 1004 MAR 30 Feb-20 1001 BOT 30 Feb-20 1004 HAR 30 Mar-20 N/A VAC 30 Mar-20 1004 HR 30 Apr-20 1001 BOT 30 Apr 20 1004 HAR 30 May 20 1001 BOT 30 May-20 1004 HAR 30 jun-20 1001 BOT 30 Jun 20 N/A VAC 30 M20 1001 BOT 30 l-20 1004 HUR 30 Aur 20 1001 BOT 30 Aug 20 1004 HAR 30 Sep-20 1001 BOT 30 Sep-20 1004 HAR 30 Oct 20 1001 BOT 30 Oct 20 1004 HAR 30 Nov 20 1001 BOT 30 Nov-20 1004 HAR 30 Dec 20 1001 BOT 30 Dec 20 1004 HAR Hous spent Hourly Rate 60 15 54 15 68 15 68 15 60 15 60 15 60 15 68 15 68 15 60 15 68 15 128 17 AN/A IN/A 124 17 128 17 128 17 124 17 120 17 120 17 124 17 120 17 132 17 128 17 64 18 60 20 68 18 64 20 60 18 64 20 68 18 64 20 64 18 64 20 60 18 64 20 60 18 IN/A IN/A 68 60 20 64 18 68 20 68 18 68 20 68 18 60 20 64 18 68 20 64 15 68 15 64 15 60 15 IN/A N/A 64 15 68 15 64 15 60 15 60 15 60 15 AN/A N/A 64 15 64 15 60 15 68 15 60 15 68 15 68 15 60 15 64 15 60 15 60 15 60 15 9999
