. Imaging your manager give you these raw data. He/she wants you to complete the following tasks: Please find the deposit amount and amount due. Format the data into appreciate table style at your choice, which in a professional manner. Prepare the findings that answers the following questions in separate sheets. If figures or diagrams if applies . . 1) Who brought the most pop corn in volume (in lbs)? 2) Who brought the most pop corn in value (dollar values)? 3) Which account type has the most owning? 4) Which flavor is the most profitable? (Define your profitable yourself first). 5) Which account type is most like to order $1.50 pop corn? 6) Does flavor impact on the volume? 7) Does corporate account tend to order big volume (50+) since they normally have party? Hint: Pivotable and data slider is very useful. Apply any functions if needed. 14 Betty 15 Kenj! 2 Date 2018-04-19 3 Deposit 5% 4 5 6 First Name Last Name Account type 7 Helen Sanchez Local 8 Liang Jeong Corporate 9 Yoshio Guo Local 10 Elmira Rangan Non Profit 11 Pola Han Non Profit 12 Dhruv Li Corporate 13 Ichiro Torres Small Business Jayaraman Small Business Kapoor Non Profit 16 Yong Lopez Local 17 Whan Han Corporate 18 Medina Ito Corporate 19 Betty Gao Small Business 20 Kazuo Abdul Corporate 21 David Suzuki Small Business 22 Priyanka Gomez Non Profit 23 Toshio Hamieh Small Business 24 Dalia Azizi 25 Kyung Rodrigues Local 26. Makoto Non Profit 2 CHI Mitchell Small Business 28 Ryung Abdul Small Business 29 Una Hernandez Corporate 30 Alejandro Jhadav Non Profit 31 Cala Hernandez Corporate Hariri Non Profit 33 Chan Jeong Small Business 34 Jasmine Bettar Local 35 Akira Zhang Non Profit 36 Rahul Rodriguez Non Profit Flavor Regular Regular Cheese Cheese Chocolate Crunch Carmel Chocolate Carmel Regular Low Salt Chocolate Cheese Cheese Chocolate Crunch Crunch Regular Carmel Cheese Low Salt Carmel Carmel Regular Low Salt Low Salt Cheese Cheese Carmel Regular Volume in lbs Price per lb Deposit Amount Due 58 $2.25 $ 0.11 S 130.50 69 $2.25 s 0.11 S 155.25 88 $2.00 $ 0.10 S 176.00 17 $2.00 $ 0.10 S 34.00 11 $2.00 S 0.10 S 22.00 43 $2.25 $ 0.11 $ 96.75 10 $1.50 S 0.08 $ 15.00 72 $2.00 $ 0.10 S 144.00 92 $1.50 $ 0.08 $ 138.00 91 $2.25 $ 0.11 S 204.75 57 $2.25 S 0.11 $ 128.25 28 $2,00 $ 0.10 S 56.00 55 $2.00 S 0.10 $ 110.00 30 $2.00 $ 0.10 S 50.00 21 $2.00 $ 0.10 $ 42.00 52 $2.25 $ 0.11 S 117.00 37 $2.25 S 0.11 S 83.25 33 $2.25 $ 0.11 S 74.25 99 $1.50 $ 0.08 $ 148.50 38 $2.00 $ 0.10 S 76,00 99 $2.25 S 0.11 S 222.75 48 $1.50 $ 0.08 S 72.00 63 $1.50 $ 0.08 S 94.50 27 $2.25 $ 0.11 $ 60.75 31 $2.25 S 0.11 S 69.75 57 $2.25 $ 0.11 128.25 13 $2.00 S 0.10 26.00 67 $2.00 $ 0.10 $ 134,00 66 $1.50 S 0.08 $ 99.00 16 $2.25 $ 0.11 36.00 Local 32 Kyu UV E 39 72 51 97 73 64 51 87 65 18 62 A B C Masao Hwang Small Business Carol Ito Non Profit Cui Hu Corporate Anthony Zhao Non Profit Dario Gutierrez Small Business Yukio He Local Apoorva Ramirez Small Business Casilda Ramirez Non Profit 5 Akira Hernandez Non Profit 5 Rajesh Allen Small Business 7. Dai Zhu Local 8 Minoru Morales Small Business 9 Jie Khan Small Business O Nam Sato Local 51 Majida Chatterjee Non Profit 52 Farrah Lin Non Profit 53 Ryung Inoue Local 54 Elizabeth Sasaki Small Bustess 55 Raul Martinez Local 56 Yoshio Flores Local 57 Eric Rodriguez Non Profit 58 Kazuo Banerjee Corporate 59 Chan Rodriguez Corporate 60 Elmira Zhang Non Profit 61 Diego Sun Local 62 Loelia Yoshida Non Profit 63 Deborah Rodriguez Corporate 64 Messina Hyat Small Business 65 Reina Flores Non Profit 66 Helen Hassan Non Profit 67 Helen Cho Local 68 Yoshio Seo Local 69 Kang Mehta Small Business Allen Local 71 Eric Huang Non Profit 72. Whan Mukopadhyay Non Profit D Regular Low Salt Cheese Low Salt Cheese Low Salt Carmel Cheese Carmel Chocolate Chocolate Regular Carmel Cheese Cheese Low Salt Chocolate Crunch Crunch Low Salt Low Salt Chocolate Carmel Carmel Low Salt Regular Crunch Chocolate Regular Chocolate Cheese Chocolate Regular Carmel Low Salt Low Salt 28 95 66 25 10 17 72 31 27 41 58 88 52 16 78 85 81 65 59 48 32 77 53 54 97 F $2.25 $ $2.25 S $2.00 $ $2.25 S $2.00 $ $2.25 $ $1.50 $ $2.00 $ $1.50 $ $2.00 $ $2.00 $ $2.25 $ $1.50 $ $2.00 S $2.00 $ $2.25 S $2.00 S $2.25 $ $2.25 $ $2.25 S $2.25 S $2.00 $ $1.50 $ $1.50 S $2.25 $ $2.25 $ $2.25 S $2.00 S $2.25 $ $2.00 $ $2.00 $ $2.00 S $2.25 S $1.50 S $2.25 S $2.25 $ G H 0.11 S 87.75 0.11 S 162.00 0.10 S 102.00 0.11 S 218.25 0.10 S 146.00 0.11 $ 144.00 0.08 $ 76.50 0.10 $ 174.00 0.08$ 97.50 0.10 $ 36.00 0.10 $ 124.00 0.11 $ 63.00 0.08 $ 142.50 0.10 $ 132.00 0.10 S 50.00 0.11 $ 22.50 0.10 S 34.00 0.11 S 162.00 0.11 $ 69.75 0.11 S 60.75 0.11 $ 92.25 0.10 S 116.00 0.08 S 132.00 0.08 $ 78.00 0.11 S 36.00 0.11 $ 175.50 0.11 S 191.25 0.10 $ 162.00 0.11 $ 146.25 0.10 S 118.00 0.10 $ 96.00 0.10 S 64.00 0.11 $ 173.25 0.08 $ 79.50 0.11 $ 121.50 0.11 S 218.25 70 Sang E F 41 100 16 88 87 37 33 19 33 74 96 47 88 19 B 73 Raj Hong Local 74 Javier Hyat Local 75 Brian Hernandez Local 76 Takeo Abaid Small Business 77 Dorothy Gao Small Business 79 Nam Nakamura Small Business 79 Nam Ma Non Profit 80 Ana Rivera Small Business 81 Javier Lee Small Business 82 Alvaro Kobayashi Local 83 Hiroshi Thomas Corporate 84 Jiao Bhatnagar Small Business 85 Keni Jayaraman Local 86 Nam Hyat Small Business 87 Yoshio Nayar Local 88 Cala Pawar Local 89 Lian Zhao Local 90 Daniel Park Non Profit 91 Candy Yamamoto Non Profit 92 Chi Hong Local 93 Gang Hu Small Business 94 Donna Reyes Local Thomas Small Business 96 Raul Flores Corporate 97 Carol Anderson Local 98 Dorothy Mitchell Local 99 Adolfo Carter Corporate 100 Yasuo Allen Local 101 Koichi Robinson Small Business 102 Edward Wilson Local Daher Non Profit 104 Ju Bettar Corporate 105 Jennifer Lim Small Business 106 Yoshio Anderson Small Business D Cheese Cheese Low Salt Low Salt Chocolate Cheese Cheese Carmel Low Salt Crunch Chocolate Carmel Chocolate Crunch Low Salt Crunch Crunch Chocolate Regular Carmel Cheese Regular Crunch Carmel Regular Carmel Low Salt Chocolate Crunch Crunch Low Salt Chocolate Crunch Cheese 96 52 38 97 13 26 95 50 56 $2.00 $ $2.00 $ $2.25 $2.25 $ $2.00 $ $2.00 $ $2.00 $ $1.50 $ $2.25 $ $2.25 $ $2.00 S $1.50 S $2.00 S $2.25 $ $2.25 $ $2.25 $ $2.25 $ $2.00 $ $2.25 $ $1.50 $ $2.00 $ $2.25 $ $2.25 S $1.50 S $2.25 S $1.50 $ $2.25 S $2.00 $ $2.25 S $2.25 S $2.25 $ $2.00 $ $2.25 S $2.00 S G H 0.10 $ 82.00 0.10 S 200.00 0.11 S 36.00 0.11 $ 198.00 0.10 S 174.00 0.10 S 74.00 0.10 S 66.00 0.08 $ 28.50 0.11 S 74.25 0.11 $ 166.50 0.10 $ 192.00 0.08. $ 70.50 0.10 $ 176.00 0.11 S 42.75 0.11 $ 216.00 0.11 $ 117.00 0.11 $ 85.50 0.10 $ 194.00 0.11 $ 29.25 0.08 $ 39.00 0.10 S 190.00 0.11 S 112.50 0.11 $ 126.00 0.08 $ 21.00 0.11 $ 144.00 0.08 $ 138.00 0.11 $ 87.75 0.10 S 88.00 0.11 $ 207.00 0.11 $ 216.00 0.11 S 186.75 0.10 $ 40.00 0.11 $ 202.50 0.10 S 134.00 95 Kang 14 64 92 39 44 92 96 83 20 90 67 103 Jung . Imaging your manager give you these raw data. He/she wants you to complete the following tasks: Please find the deposit amount and amount due. Format the data into appreciate table style at your choice, which in a professional manner. Prepare the findings that answers the following questions in separate sheets. If figures or diagrams if applies . . 1) Who brought the most pop corn in volume (in lbs)? 2) Who brought the most pop corn in value (dollar values)? 3) Which account type has the most owning? 4) Which flavor is the most profitable? (Define your profitable yourself first). 5) Which account type is most like to order $1.50 pop corn? 6) Does flavor impact on the volume? 7) Does corporate account tend to order big volume (50+) since they normally have party? Hint: Pivotable and data slider is very useful. Apply any functions if needed. 14 Betty 15 Kenj! 2 Date 2018-04-19 3 Deposit 5% 4 5 6 First Name Last Name Account type 7 Helen Sanchez Local 8 Liang Jeong Corporate 9 Yoshio Guo Local 10 Elmira Rangan Non Profit 11 Pola Han Non Profit 12 Dhruv Li Corporate 13 Ichiro Torres Small Business Jayaraman Small Business Kapoor Non Profit 16 Yong Lopez Local 17 Whan Han Corporate 18 Medina Ito Corporate 19 Betty Gao Small Business 20 Kazuo Abdul Corporate 21 David Suzuki Small Business 22 Priyanka Gomez Non Profit 23 Toshio Hamieh Small Business 24 Dalia Azizi 25 Kyung Rodrigues Local 26. Makoto Non Profit 2 CHI Mitchell Small Business 28 Ryung Abdul Small Business 29 Una Hernandez Corporate 30 Alejandro Jhadav Non Profit 31 Cala Hernandez Corporate Hariri Non Profit 33 Chan Jeong Small Business 34 Jasmine Bettar Local 35 Akira Zhang Non Profit 36 Rahul Rodriguez Non Profit Flavor Regular Regular Cheese Cheese Chocolate Crunch Carmel Chocolate Carmel Regular Low Salt Chocolate Cheese Cheese Chocolate Crunch Crunch Regular Carmel Cheese Low Salt Carmel Carmel Regular Low Salt Low Salt Cheese Cheese Carmel Regular Volume in lbs Price per lb Deposit Amount Due 58 $2.25 $ 0.11 S 130.50 69 $2.25 s 0.11 S 155.25 88 $2.00 $ 0.10 S 176.00 17 $2.00 $ 0.10 S 34.00 11 $2.00 S 0.10 S 22.00 43 $2.25 $ 0.11 $ 96.75 10 $1.50 S 0.08 $ 15.00 72 $2.00 $ 0.10 S 144.00 92 $1.50 $ 0.08 $ 138.00 91 $2.25 $ 0.11 S 204.75 57 $2.25 S 0.11 $ 128.25 28 $2,00 $ 0.10 S 56.00 55 $2.00 S 0.10 $ 110.00 30 $2.00 $ 0.10 S 50.00 21 $2.00 $ 0.10 $ 42.00 52 $2.25 $ 0.11 S 117.00 37 $2.25 S 0.11 S 83.25 33 $2.25 $ 0.11 S 74.25 99 $1.50 $ 0.08 $ 148.50 38 $2.00 $ 0.10 S 76,00 99 $2.25 S 0.11 S 222.75 48 $1.50 $ 0.08 S 72.00 63 $1.50 $ 0.08 S 94.50 27 $2.25 $ 0.11 $ 60.75 31 $2.25 S 0.11 S 69.75 57 $2.25 $ 0.11 128.25 13 $2.00 S 0.10 26.00 67 $2.00 $ 0.10 $ 134,00 66 $1.50 S 0.08 $ 99.00 16 $2.25 $ 0.11 36.00 Local 32 Kyu UV E 39 72 51 97 73 64 51 87 65 18 62 A B C Masao Hwang Small Business Carol Ito Non Profit Cui Hu Corporate Anthony Zhao Non Profit Dario Gutierrez Small Business Yukio He Local Apoorva Ramirez Small Business Casilda Ramirez Non Profit 5 Akira Hernandez Non Profit 5 Rajesh Allen Small Business 7. Dai Zhu Local 8 Minoru Morales Small Business 9 Jie Khan Small Business O Nam Sato Local 51 Majida Chatterjee Non Profit 52 Farrah Lin Non Profit 53 Ryung Inoue Local 54 Elizabeth Sasaki Small Bustess 55 Raul Martinez Local 56 Yoshio Flores Local 57 Eric Rodriguez Non Profit 58 Kazuo Banerjee Corporate 59 Chan Rodriguez Corporate 60 Elmira Zhang Non Profit 61 Diego Sun Local 62 Loelia Yoshida Non Profit 63 Deborah Rodriguez Corporate 64 Messina Hyat Small Business 65 Reina Flores Non Profit 66 Helen Hassan Non Profit 67 Helen Cho Local 68 Yoshio Seo Local 69 Kang Mehta Small Business Allen Local 71 Eric Huang Non Profit 72. Whan Mukopadhyay Non Profit D Regular Low Salt Cheese Low Salt Cheese Low Salt Carmel Cheese Carmel Chocolate Chocolate Regular Carmel Cheese Cheese Low Salt Chocolate Crunch Crunch Low Salt Low Salt Chocolate Carmel Carmel Low Salt Regular Crunch Chocolate Regular Chocolate Cheese Chocolate Regular Carmel Low Salt Low Salt 28 95 66 25 10 17 72 31 27 41 58 88 52 16 78 85 81 65 59 48 32 77 53 54 97 F $2.25 $ $2.25 S $2.00 $ $2.25 S $2.00 $ $2.25 $ $1.50 $ $2.00 $ $1.50 $ $2.00 $ $2.00 $ $2.25 $ $1.50 $ $2.00 S $2.00 $ $2.25 S $2.00 S $2.25 $ $2.25 $ $2.25 S $2.25 S $2.00 $ $1.50 $ $1.50 S $2.25 $ $2.25 $ $2.25 S $2.00 S $2.25 $ $2.00 $ $2.00 $ $2.00 S $2.25 S $1.50 S $2.25 S $2.25 $ G H 0.11 S 87.75 0.11 S 162.00 0.10 S 102.00 0.11 S 218.25 0.10 S 146.00 0.11 $ 144.00 0.08 $ 76.50 0.10 $ 174.00 0.08$ 97.50 0.10 $ 36.00 0.10 $ 124.00 0.11 $ 63.00 0.08 $ 142.50 0.10 $ 132.00 0.10 S 50.00 0.11 $ 22.50 0.10 S 34.00 0.11 S 162.00 0.11 $ 69.75 0.11 S 60.75 0.11 $ 92.25 0.10 S 116.00 0.08 S 132.00 0.08 $ 78.00 0.11 S 36.00 0.11 $ 175.50 0.11 S 191.25 0.10 $ 162.00 0.11 $ 146.25 0.10 S 118.00 0.10 $ 96.00 0.10 S 64.00 0.11 $ 173.25 0.08 $ 79.50 0.11 $ 121.50 0.11 S 218.25 70 Sang E F 41 100 16 88 87 37 33 19 33 74 96 47 88 19 B 73 Raj Hong Local 74 Javier Hyat Local 75 Brian Hernandez Local 76 Takeo Abaid Small Business 77 Dorothy Gao Small Business 79 Nam Nakamura Small Business 79 Nam Ma Non Profit 80 Ana Rivera Small Business 81 Javier Lee Small Business 82 Alvaro Kobayashi Local 83 Hiroshi Thomas Corporate 84 Jiao Bhatnagar Small Business 85 Keni Jayaraman Local 86 Nam Hyat Small Business 87 Yoshio Nayar Local 88 Cala Pawar Local 89 Lian Zhao Local 90 Daniel Park Non Profit 91 Candy Yamamoto Non Profit 92 Chi Hong Local 93 Gang Hu Small Business 94 Donna Reyes Local Thomas Small Business 96 Raul Flores Corporate 97 Carol Anderson Local 98 Dorothy Mitchell Local 99 Adolfo Carter Corporate 100 Yasuo Allen Local 101 Koichi Robinson Small Business 102 Edward Wilson Local Daher Non Profit 104 Ju Bettar Corporate 105 Jennifer Lim Small Business 106 Yoshio Anderson Small Business D Cheese Cheese Low Salt Low Salt Chocolate Cheese Cheese Carmel Low Salt Crunch Chocolate Carmel Chocolate Crunch Low Salt Crunch Crunch Chocolate Regular Carmel Cheese Regular Crunch Carmel Regular Carmel Low Salt Chocolate Crunch Crunch Low Salt Chocolate Crunch Cheese 96 52 38 97 13 26 95 50 56 $2.00 $ $2.00 $ $2.25 $2.25 $ $2.00 $ $2.00 $ $2.00 $ $1.50 $ $2.25 $ $2.25 $ $2.00 S $1.50 S $2.00 S $2.25 $ $2.25 $ $2.25 $ $2.25 $ $2.00 $ $2.25 $ $1.50 $ $2.00 $ $2.25 $ $2.25 S $1.50 S $2.25 S $1.50 $ $2.25 S $2.00 $ $2.25 S $2.25 S $2.25 $ $2.00 $ $2.25 S $2.00 S G H 0.10 $ 82.00 0.10 S 200.00 0.11 S 36.00 0.11 $ 198.00 0.10 S 174.00 0.10 S 74.00 0.10 S 66.00 0.08 $ 28.50 0.11 S 74.25 0.11 $ 166.50 0.10 $ 192.00 0.08. $ 70.50 0.10 $ 176.00 0.11 S 42.75 0.11 $ 216.00 0.11 $ 117.00 0.11 $ 85.50 0.10 $ 194.00 0.11 $ 29.25 0.08 $ 39.00 0.10 S 190.00 0.11 S 112.50 0.11 $ 126.00 0.08 $ 21.00 0.11 $ 144.00 0.08 $ 138.00 0.11 $ 87.75 0.10 S 88.00 0.11 $ 207.00 0.11 $ 216.00 0.11 S 186.75 0.10 $ 40.00 0.11 $ 202.50 0.10 S 134.00 95 Kang 14 64 92 39 44 92 96 83 20 90 67 103 Jung
