Excel Assignment: Making Business Decisions:

(dont screetshot the answer do a spreadsheet on here so i can edit if needed, thx)

1. Production Errors

Established in 2002, t-shirts.com has rapidly become the place to find, order, and save on T-shirts. One huge selling factor is that the company manufactures its own T-shirts. However, the quality manager for the production plant, Kasey Harnish, has noticed an unacceptable number of defective T-shirts being produced. You have been hired to assist Kasey in understanding where the problems are concentrated. He suggests using a PivotTable to perform an analysis and has provided you with a data file, the following is a brief definition of the information within the data file:

A. Batch: A unique number that identifies each batch or group of products produced.

B. Product: A unique number that identifies each product.

C. Machine: A unique number that identifies each machine on which products are produced.

D. Employee: A unique number that identifies each employee producing products.

E. Batch Size: The number of products produced in a given batch.

F. Num Defect: The number of defective products produced in a given batch.

ZOOM + 2310 Vanilla February South 2620 Vanilla March South Vanilla April South 2450 Vanilla May South 2430 Vanilla June South 2480 July South 2540 Vanilla August 2610 Vanilla South Vanilla September South 2340 South 2380 Vanilla October November South 2540 Vanilla December South 2310 Vanilla January North 2400 Irish Cream February North 2320 Irish Cream 290 Irish Cream March North April North 5290 Irish Cream 4350 Irish Cream May North Irish Cream June North 4350 Irish Cream July North 4350 August North 4350 Irish Cream September North 3610 Irish Cream October 3640 Irish Cream North 3610 Irish Cream November North Irish Cream December North 2210 2430 Irish Cream January South Irish Cream February South 2430 Irish Cream March South 2460 April South 2540 Irish Cream Irish Cream May South 2310 South Irish Cream June 2620 Irish Cream July South 2450 Irish Cream August South 2430 2480 Irish Cream September South Irish Cream Octobe South 2540 November South 2610 Irish Cream Irish Cream December South 4350 Hazelnut January North 3610 3640 Hazelnut February North Hazelnut March North 3610 Hazelnut April North 2210 May North 2430 Hazelnut Hazelnut June North 2430 Hazelnut July North 2460 August North 2540 Hazelnut September North 2310 Hazelnut October North 2620 Hazelnut 2450 Hazelnut November North 2430 Hazelnut December North 2480 Hazelnut January South Hazelnut February South 2540 2610 Hazelnut March South Hazelnut April South 2340 Hazelnut May South 2380 June South 2540 HazelnutZOOM + Key Jitters = North Bean Scene = South Product Month Store Revenue Regular January North 4320 February 4500 Regular North Regular March North 3528 Regular April North 3960 399 Regular May North June North 3960 Regular Regular July North 3960 Regular August North 4230 September North 4230 Regular Regular October North 4275 Regular November North 4365 Regular December North 4455 Regular January South 3960 February South 4230 Regular Regular March South 4230 April South 4275 Regular Regular May South 4365 June South 4455 Regular 4128 Regular July South Regular August South 4176 Regular September South 3936 Regular October South 4090 3936 Regular November South December South 4350 Regular January North 350 Decaf 4350 Decaf February North Decaf March North 4350 Decaf April North 3610 Decaf May North 3640 3610 Decaf June North 2210 Decaf July North Decaf August North 2430 Decaf September North 2430 October 2460 Decaf North November North 2540 Decaf Decaf December North 2310 Decaf January South 2620 Decaf February South 2450 March South 2430 Decaf April 2480 Decaf South Decaf May South 2540 Decaf June South 2610 Decaf July South 2340 August South 2380 Decaf Decaf September South 2540 Decaf October South 2310 Decaf November South 2400Decaf Decaf Deaf Deaf Decaf Deaf Deaf Decaf Decaf Deaf Deaf Decaf French Roast French Roast French Roast French Roast French Roast French Roast French Roast French Roast French Roast French Roast French Roast French Roast French Roast French Roast French Roast French Roast French Roast French Roast French Roast French Roast French Roast French Roast French Roast French Roast Vanilla Vanilla Vanilla Vanilla Vanilla Vanilla Vanilla Vanilla Vanilla Vanilla Vanilla Vanilla Vanilla Vanilla Vanilla Vanilla Vanilla South Smith South South South South South South South South South South North North North North North North North North North North North North South South South South South South South South South South South South North North North North North North North North North North North North South South South South Smith 2620 2450 2430 2490 2540 2610 2340 2330 2540 2310 2400 2320 2290 5290 4320 4500 3523 3960 39% 3960 3960 4230 4230 4275 4365 4455 3960 4230 4230 4275 4365 4455 4123 4176 3936 4090 3936 4350 4350 4350 4350 3610 3640 3610 2210 2430 2430 2460 2540 2310 2620 2450 2430 200 M + Title Hire Date Birth Date Gender Clearance ID First Name Last Name Department Salary 2956 Michael Engineer 51,000 4/1 1/97 3/7/63 Goldstein Engineering T'S 4123 Steve Ballmer Engineering Engineer 42,900 5/1/02 4/14/70 M Engineering Engineer 56,700 5/14/99 5/27/70 V 3117 Frederich Bednarczyk 9/5/95 3/4/64 2122 Yuan Chang Engineering Engineer 46,540 Detweiler Engineering Engineer 56,700 10/10/95 4/29/70 2451 Francine 2896 Samuel Gates Engineering Engineer 66,300 1/28/97 4/10/74 2768 Ph Leonard Engineering Engineer 59,800 12/13/96 7/2/70 1119 Sharad Manispour Engineering Manager 54,500 10/13/90 2/4/69 2344 Nemesha Mehta Engineering Engineer 65,000 10/1/95 2/12/65 3210 Carmen Ortega-Molina Engineering Engineer 46,000 9/16/99 3/28/52 2002 Edgar Rothrock Engineering Engineer 53,300 2/8/94 3/21/70 3015 Patti Stonesifer Engineering Engineer 64,300 7/6/98 3/10/66 Engineering Engineer 1/24/63 2678 Koshi Yamamoto 49,600 11/16/95 2733 John Zumkowski Engineering Staff 33,000 4/18/96 12/12/72 38,000 5/3/82 3314 Svetlana Kartashev Human Resources Staff 11/5/01 4006 Alice Rovik Human Resources Manager 43,000 12/1/01 1/26/55 2042 Cushner Management Staff 32,000 8/26/94 5/6/61 SSSSTTTTTestsTests 1851 Melinda English Management Manager 62,040 10/1/93 2/14/56 4/10/65 1355 Barbara Grabowski Management Manager 75,700 10/13/92 1173 Roberta Kurzweil Management Manager 63,000 6/16/92 12/22/58 1441 James Van Horn Management Manager 66,500 12/18/92 2/3/58 Andretti Marketing CSR 42,500 3/21/90 8/20/70 1042 Maria Flintsteel 3/21/90 8/22/58 1032 Marketing Staff 34,500 Grundies Marketing CSR 38,900 12/24/89 3/4/61 1009 Kevin Lambros Marketing CSR 41,000 5/16/93 7/13/70 1614 Artie 8/26/95 5/6/50 2105 Luca Pacioli Marketing Staff 42,300 1016 Oscar Gomez Marketing CSR 43,500 2/16/90 4/29/67ZOOM + 4350 Irish Cream May North June North 350 Irish Cream Irish Cream July North 4350 Irish Cream August North 4350 September North 3610 Irish Cream Irish Cream Octobe North 3640 Irish Cream November North 3610 December North 2210 Irish Cream South 2430 Irish Cream January Irish Cream February South 2430 2460 Irish Cream March South Irish Cream April South 2540 Irish Cream May South 2310 Irish Cream June South 2620 Irish Cream July South 2450 2430 Irish Cream August South September South 2480 Irish Cream Irish Cream October South 2540 Irish Cream November South 2610 Irish Cream December South 4350 January North 3610 Hazelnut Hazelnut February North 3640 March North 3610 Hazelnut Hazelnut April North 2210 Hazelnut May North 2430 June North 2430 Hazelnut July North 2460 Hazelnut North 2540 Hazelnut August September North 2310 Hazelnut 2620 Hazelnut October North Hazelnut November North 2450 December North 2430 Hazelnut Hazelnut January South 2480 Hazelnut February South 2540 March South 2610 Hazelnut April 2340 Hazelnut South Hazelnut May South 2380 Hazelnut June South 2540 July South 2310 Hazelnut 2400 Hazelnut August South Hazelnut September South 2320 2290 Hazelnut October South South 5290 Hazelnut November 4320 Hazelnut December SouthZOO M BALE! m was was: was: mm 1 10 5 5515 500 15 2 20 7 5555 10000 10 3 30 5 2m 5000 13 4 30 a 1444 1000 12 5 20 a 5555 1000 5 5 20 7 1111 5000 5 7 30 a 2m 10000 20 5 10 5 35:15 10000 1.1 0 10 a 1111 5000 17 10 00 7 5565 500 10 11 :0 5 am 500 a 12 :10 7 am 1000 7 15 10 5 H22 5000 5 1-1 00 0 am 10000 e 15 :10 7 1111 10000 :1 15 10 5 1111 5000 15 17 10 a 1111 500 a 10 10 a 4444 500 0 1s 10 7 am 500 0 20 20 a 222 1000 15 21 10 7 5555 10000 12 22 20 a 31:; 10000 10 23 30 7 4444 10000 e 21 50 a 222 5000 12 25 20 7 5555 1000 a 25 20 5 1111 1000 e 27 20 a 2m 5000 s 25 50 7 5515 10000 15 20 50 5 am 500 15 30 30 5 5555 5.10 a 31 10 5 1444 10000 I: a: 10 5 5555 500 5 55 20 7 5515 5000 1a 34 30 5 2m 1000 11 as 30 5 an 1000 a an 20 a 1111 5000 14 a7 10 7 5555 500 :1 00 00 0 222: 10000 0 as 10 5 an 5000 1 40 10 7 H22 1000 15 41 20 5 H22 1000 15 42 :0 0 2m 5000 0 43 00 0 222: 10000 0 u 20 a an: 500 12 45 :10 7 1111 500 a as 20 a 4444 10000 a 47 :0 7 2222 500 s 45 :10 5 5555 5000 1a 40 :10 5 am 1000 15 50 10 a 5555 1000 4 51 10 7 1111 5000 13 52 10 5 m2 500 5 51a 10 a am 10000 171 54 20 7 m4 500 11 55 10 7 5555 5000 25 55 20 5 mi 1000 1: 57 30 5 1111 1000 0 50 30 7 3m 5000 9 50 20 a 222 500 17 m 20 7 am 10000 15 01 20 a 3m 5000 d 02 30 a 5555 1000 7 05 a0 5 am 1000 5 04 a0 7 1111 5000 5 66 10 5 222: 10000 :1 05 10 5 1111 5.10 15 07 20 7 m2 500 a 05 :10 a 35:15 10000 a 00 :0 7 14-14 500 0 70 10 0 222: 10000 15 71 :10 a 5555 5000 12 72 :10 7 am 1000 10 73 :10 s 5555 500 a 7-1 20 7 am 500 12 75 10 a 1111 10000 a 75 10 7 5555 5000 a Submitted Employee ID Last Name First Name Organization Amount Donation Sent 1 1/29/2021 688 Abbs Don Habitat for Humanity 50 12/1/2021 12/5/2021 08T Adams David Red Cross 100 12/6/2021 12/9/2021 Y7CA Ascott Karen Red Cross 100 12/18/2021 12/5/2021 M5NA Bagby Sharon Rotary Club 25 12/6/2021 12/3/2021 39N Butler Barry Rotary Club 250 12/10/2021 12/3/2021 ONNA Clark Jolene Toastmasters 20 12/5/2021 12/2/2021 ONNA Clark Jolene Make a Wish Foundation 75 12/4/2021 12/6/2021 ONNA Clark Jolene Leukemia Society 60 12/19/2021 12/16/2021 CT8A Donovan Gary Make a Wish Foundation 130 12/21/2021 12/12/2021 1XBA Doster Glenn Amnisty International 200 12/21/2021 12/16/2021 L3H Dunn Elaine Make a Wish Foundation 225 12/29/2021 12/4/2021 56NA Foster Scott Rotary Club 125 12/10/2021 12/2/2021 56NA Foster Scott Meals on WHeels 125 12/26/2021 12/17/2021 1F9A Hughes Gary Red Cross 50 12/22/2021 12/27/2021 J5M Johnson Les Foster Children's Fund 25 12/30/2021 12/10/2021 44JA Kelleher George Romania Relief 180 12/14/2021 12/20/2021 57XA Lomstein Thomas Meals on WHeels 115 12/22/2021 12/12/2021 FA5A Peters Roger Toastmasters 35 12/15/2021 12/14/2021 FA5A Peters Roger Foster Children's Fund 80 12/19/2021 12/6/2021 R9M Simpson Joseph Red Cross 50 12/19/2021 12/13/2021 R9M Simpson Jospeh Habitat for Humanity 150 12/23/2021 12/6/2021 08A Thimsen Timothy Rotary Club 50 12/14/2021 12/3/2021 C3P Warren James Lion's Club 60 12/13/2021 12/27/2021 R45A Womak Anthony Habitat for Humanity 100 12/29/2021