your

a

Executive Summary

Bama Burger Buggy is a local food truck company. They currently have multiple trucks serving meals in the local area. Bama Burger Buggy also has a central storage and kitchen facility that preps everything for the day. Inventory is held at the central storage facility and administrative duties are done there.

Bama Burger prides themselves on fresh, homemade products. Everything they sell is handmade in their central kitchen facility.

Bama Burger keeps centralized records of all sales and inventory and bases their reorder point on a preset inventory level. The current inventory policy for hamburger patties is to place an order for 750 patties to be made when the inventory levels get below 200 units.

Project description

Bama Burger has noticed a issue with their hamburgers. The prescribed cooking process is based on the gross weight of the hamburger patty. Because of this issue Bama Burger has been taking samples of each production order that is placed. They are randomly sampling 15 hamburgers from each order.

Management has established an average weight for each patty of 15.25 oz. They have also set upper and lower control limits of 15.75 oz and 14.50 oz.

They have also established an average range of 2.50 oz with upper and lower control limits of 4.00 oz and 1.00 oz

Deliverables

Bama Burger has provided daily sales, inventory and order sample data.

They have asked you to review the data, create an X-bar and R chart using their set control limits and provided data. (Hint: Use a scatter plot to graph your samples. To mark your Upper and Lower Control Limits and to show your center, "Insert" "Shapes" and draw the appropriate line.) Further assistance for making and moving charts can be found at the attached links:

Moving a chart

Making a chart

If their process is out of control (as they assume it is) they have also asked for an Ishikawa (or Cause & Effect) diagram with your assumptions of possible causes. They would like at least 2 possible causes for each of the 4 areas (Manpower, Material, Machinery and Methods)

Finally, they have asked for a short paragraph or two with your observation of the data (Is the process in or out of control? What do you see happening in the data? What is the story the data is telling?) and a brief recommendation to address possible corrections (either a paragraph or bullet points for recommendations).

Assignment

Download the "BBB - SPC Student file" from Blackboard to your computer. Rename the file "Your Last Name, First initial-BBB SPC" before you submit your completed assignment. Please keep it as an Excel file. Other spreadsheet file types will not be accepted.

Do not change the names on the tabs.

"Documentation" Sheet- Type your name in Cell B3 as the Author. Type the date in B4.

"Sales and Order Data" Sheet- You may manipulate the data as you see fit on this page. Each column holds information you may find helpful in your analysis. The following is a data dictionary for the listed information:

"Date" - Date of the transaction

"Day" - Day of the week (Monday - Sunday)

"Open" - Bama Burger Buggy is not open 7 days per week. 1 = "Yes, we are open.", 0 = "Closed"

"Burgers" & "Cheese Burgers" - Units sold that day

"Total Burgers On Hand" - A running inventory count of burger patties available in inventory. Units are subtracted from the On Hand count when sold and added to the On Hand count when a production Order is placed.

"Order Placed" - Number of units requested to replenish On Hand inventory

"Sample #" - Recorded sample of randomly chosen item. In this example it is the recorded weight of each item sampled.

"Output" Sheet -

Post your SPC Charts in the "Graphs" box posed from Row 1 - Row 36

Fill out 2 possible issues for each area (Manpower, Machinery, Material and Methods) in the text boxes on the Cause & Effect Diagram. Text boxes are located at P52-P62.

Give your Observation and Recommendation in the text box located on Row 39 - Row 44.

AutoSave OFF HA PYC... Sales and Order - Student Data Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) A A ab 11 General Conditional Formatting v Insert v Format as Table v x Delete v Paste B I U A % 9 00 Sort & Find & Analyze Sensitivity i Cell Styles v Format v Filter Select Data AF86 X V fx D E F G H M N 0 Q U W Z AA AB AC AD AE AF AG U.U1049 Saturday 0 998 2/25/18 Sunday 0 998 2/26/18 Monday 56 878 8 6 8 2/27/18 Tuesday 55 43 ooc 2/28/18 Wednesday 32 3/1/18 Thursday 3/2/18 Friday 74 60 3/3/18 aturday 3/4/18 Sunday 54 oo 3/5/18 Monday 3/6/18 Tuesday 39 o 3/7/18 Wednesday 34 750 15.35852 14.39527 15.64004 14.25669 15.6318 15.78477 16.86885 16.75641 14.87347 16.68668 15.47033 15.32618 14.47855 16.78536 14.808 3/8/18 Thursday 39 o 3/9/18 Friday 79 61 0 3/10/18 0 OC 3/11/18 Sunday of 3/12/18 Monday 55 3/13/18 uesday 43 o 3/14/18 Wednesday 33 3/15/18 Thursday 40 3/16/18 Friday 60 12.5008 15.95961 12.97117 11.04355 11.21494 17.70191 11.30514 11.39713 13.7828 13.78276 15.40854 16.03264 13.5211 13.897 17.60048 3/17/18 Saturday o 3/18/18 Sunday 0 3/19/18 Monday 49 $/20/18 Tuesday 3/21/18 Wednesday 35 o 3/22/18 Thursday 38 3/23/18 Friday 62 3/24/18 aturday poc 3/25/18 Sunday 3/26/18 0 Monday 51 o 3/27/18 Tuesday 37 16.86479 14.76225 14.0349 14.41587 14.73551 15.15584 15.72855 15.81366 15.57094 16.18556 14.81987 15.34654 14.06673 14.62643 14.73808 3/28/18 Wednesday 38 o 3/29/18 Thursday 43 3/30/18 Friday 56 3/31/18 Saturday 0 o 4/1/18 Sunday 0 o 4/2/18 Monday 44 o 4/3/18 Tuesday 38 4/4/18 Wednesday 4/5/18 Thursday 41 o 4/6/18 Friday 59 17.95866 17.75679 15.33504 15.37614 14.60495 14.95472 16.58342 16.80603 17.34224 17.49825 15.23726 16.6057 11.60847 14.47965 11.72924 4/7/18 Saturday o 4/8/18 Sunday 0 4/9/18 Monday 45 4/10/18 Tuesday 41 703 4/11/18 Wednesday 32 629 4/12/18 Thursday 39 538 o 4/13/18 Friday 73 60 405 4/14/18 0 405 4/15/18 Sunday 0 405 4/16/18 Monday 49 292 4/17/18 Tuesday 41 200 14.88595 15.50767 14.60821 15.71841 15.32454 14.49314 16.92083 16.00164 15.45808 16.88015 14.10196 14.08008 16.98953 15.24391 14.12582 4/18/18 Wednesday 34 39 877 o 4/19/18 Thursday 787 4/20/18 Friday 59 652 Documentation Sales and Order Data Output + Ready Accessibility: Investigate + 66%AutoSave OFF Sales and Order - Student Data Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) 11 A A ab General Conditional Formatting v Insert v Format as Table x Delete Paste B I U A % 9 Sort & Find & Analyze Sensitivity i Cell Styles v Format v Filter Select Data AF86 X V fx C D E F G H K M N O P Q R T U V W X Y AA AB AC AD AE AF AG 4/21/18 Saturday 0 652 4/22/18 Sunday 0 4/23/18 Monday 65 45 oo OO 4/24/18 Tuesday 51 44 4/25/18 Wednesday 48 33 4/26/18 Thursday 50 44 o 4/27/18 Friday 74 59 15.40474 15.3187 15.96701 13.79527 14.36734 15.84695 13.82559 12.83698 14.00681 16.85266 11.1891 12.72984 12.79392 13.05621 17.84339 4/28/18 saturday 4/29/18 Sunday 4/30/18 Monday 47 5/1/18 Tuesday ONHaygood 38 5/2/18 Wednesday 31 o 5/3/18 Thursday 40 5/4/18 Friday 61 5/5/18 Saturday 5/6/18 Sunday 5/7/18 Monday 46 5/8/18 Tuesday 37 33 16.43773 15.44168 15.9959 16.16361 16.0173 14.15935 15.40399 15.23961 16.00904 16.74631 15.94232 16.67529 14.27321 14.62604 14.40894 5/9/18 Wednesday 5/10/18 Thursday 42 0 5/11/18 Friday 60 5/12/18 Saturday 5/13/18 Sunday 5/14/18 Monday 48 o ooo 5/15/18 Tuesday 40 5/16/18 Wednesday 35 5/17/18 Thursday 38 5/18/18 Friday 59 750 14.59563 16.80411 12.12026 16.21305 14.29935 17.93405 13.53719 17.48205 12.81838 14.85957 13.49761 12.90867 15.983 14.60883 16.70232 5/19/18 aturday o 5/20/18 Sunday 0 5/21/18 Monday 45 o 5/22/18 Tuesday 39 5/23/18 Wednesday 32 5/24/18 Thursday 42 5/25/18 Friday 60 oo 5/26/18 saturday 5/27/18 Sunda 5/28/18 Monday 47 o o o o o o o o H o O O O O O O O O . o 5/29/18 Tuesday 41 16.57895 16.444 15.29956 16.54203 16.94399 14.30237 14.22963 14.06691 16.59207 16.93089 15.29522 15.4496 16.70531 15.22101 14.8568 5/30/18 Wednesday 30 5/31/18 Thursday 37 0 6/1/18 Friday 43 6/2/18 Saturday 0 0 6/3/18 Sunday 0 o 6/4/18 Monday 31 599 6/5/18 Tuesday 30 529 o 6/6/18 Wednesday 20 33 478 6/7/18 Thursday 24 421 o 6/8/18 Friday 36 334 oooooo 6/9/18 Saturday 334 6/10/18 Sunday 0 334 6/11/18 Monday 33 262 5/12/18 Tuesday 22 206 14.38429 15.8867 16.73247 14.80136 14.03018 14.96746 15.73252 16.56611 15.87791 15.47852 14.41504 16.7391 15.56418 15.67698 15.82047 6/13/18 Wednesday 20 910 o o . 6/14/18 Thursday 25 849 o 6/15/18 Friday 39 755 o Documentation Sales and Order Data Output + Ready Accessibility: Investigate + 66%AutoSave OFF HAPYC... Sales and Order - Student Data Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) 11 A A General Conditional Formatting v Insert v Format as Table v x Delete Paste B I U A % 9 100 Sort & Find & Analyze Sensitivity i Cell Styles v Format v Filter Select Data AF86 X V fx B D E F G H M N O P Q R T U V W X Y Z AA AB AC AD AE AF AG 1/1/18 Monday 51 1/2/18 74 875 uesday 46 767 1/3/18 Wednesday 53 39 1/4/18 Thursday 45 1/5/18 Friday 1/6/18 aturday 1/7/18 Sunday 1/8/18 Monday 70 53 o 8T/6/I Tuesday 44 14.11632 15.2103 14.93076 16.28249 16.52017 15.75874 14.87262 14.8882 15.75856 14.56965 15.4606 15.59878 15.28531 15.95381 15.67991 1/10/18 Wednesday 40 0 1/11/18 Thursday 46 0 1/12/18 Friday 70 ol 1/13/18 saturday 0 1/14/18 Sunday 1/15/18 Monday 53 1/16/18 Tuesday 49 1/17/18 Wednesday 39 1/18/18 Thursday 44 Friday 68 o 15.53696 15.5683 15.62064 14.97382 14.39333 16.47806 16.33145 14.46633 16.5592 15.32396 15.48321 14.71197 16.80086 14.53624 14.28047 1/19/18 1/20/18 Saturday 0 o 1/21/18 Sunday o 1/22/18 Monday 52 o 1/23/18 Tuesday 47 1/24/18 Wednesday 39 1/25/18 Thursday 41 o 1/26/18 Friday 68 17.55948 13.42561 16.78656 17.83318 12.12518 15.52671 15.262 13.63044 11.4885 11.3929 11.82649 14.47033 15.23045 14.43757 13.1599 1/27/18 Saturday o o o o O O O O O V O O O O O O o 1/28/18 Sunday 0 1/29/18 Monday 53 o 1/30/18 Tuesday 49 o 1/31/18 Wednesday 41 2/1/18 Thursday 40 o 2/2/18 Friday 59 2/3/18 aturday 2/4/18 Sunday 0 2/5/18 Monday 70 51 750 15.92422 16.13332 15.29762 14.40601 15.14755 14.90702 15.80525 15.8723 14.26049 15.11584 14.51376 16.4322 15.62402 15.2312 15.7084 2/6/18 Tuesday 42 o 2/7/18 Wednesday 36 2/8/18 Thursday 44 810 o 2/9/18 Friday 62 o 2/10/18 Saturday u o o o o o o o O O V o 2/11/18 Sunday o 2/12/18 Monday 53 2/13/18 Tuesday 43 2/14/18 Wednesday 32 2/15/18 Thursday 42 750 16.63189 15.3759 16.5846 15.68709 16.57561 14.58702 15.19356 14.86141 16.87059 15.14548 14.18612 15.42132 16.9529 15.69895 15.20727 2/16/18 Friday 62 793 0 2/17/18 saturday 793 2/18/18 Sunday 0 793 OC 2/19/18 Monday 70 56 667 o 2/20/18 Tuesday 57 43 567 2/21/18 Wednesday 36 486 2/22/18 Thursday 40 387 o 2/23/18 Friday 63 248 17.70194 16.41226 14.22522 13.74665 17.31496 17.00339 11.80911 16.51066 15.6515 11.9935 13.37553 15.48841 12.51175 16.81844 11.35697 2/24/18 Saturday 998 0 2/25/18 Sunday 998 o 2/26/18 Monday 878 Documentation Sales and Order Data Output + Ready Accessibility: Investigate + 66%AutoSave OFF HAPYC... Sales and Order - Student Data Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) 11 A A ab General Conditional Formatting Insert v Format as Table v x Delete Paste B I U A % 9 i Cell Styles v Sort & Find & Analyze Format v Sensitivity Filter Select Data AF86 X V fx C D E F G H M N 0 P Q T U V W X Y Z AA AB AC AD AE AF AG 6/15/18 Friday 55 39 755 6/16/18 Saturday 0 755 6/17/18 Sunday 0 0 755 6/18/18 Monday 36 27 692 6/19/18 Tuesday 37 27 o 6/20/18 Wednesday 28 22 6/21/18 Thursday 37 23 6/22/18 Friday 40 6/23/18 saturday 6/24/18 Sunday 6/25/18 Monday 27 6/26/18 Tuesday 29 6/27/18 Wednesday 20 6/28/18 Thursday 28 6/29/18 40 16.72189 14.64995 14.18813 16.3091 15.47444 14.69047 14.10128 15.31172 15.5046 15.48837 14.17898 14.02228 16.33545 14.83092 16.93611 Friday o 6/30/18 Saturday o 7/1/18 Sunday 7/2/18 Monday 21 7/3/18 Tuesday 19 7/4/18 Wednesday 19 o 7/5/18 Thursday 19 o 7/6/18 Friday 28 7/7/18 Saturday 0 7/8/18 Sunday 7/9/18 Monday 22 o 7/10/18 Tuesday 19 o 7/11/18 Wednesday 20 7/12/18 Thursday 16 o 7/13/18 Friday 28 7/14/18 Saturday 7/15/18 Sunday 0 7/16/18 Monday 20 7/17/18 Tuesday 20 7/18/18 Wednesday 18 15.10908 15.39202 15.33154 16.30097 14.02873 14.17715 14.78111 14.37481 16.94546 14.93401 15.92366 14.64301 15.56987 16.76097 16.88479 7/19/18 Thursday 18 7/20/18 Friday 28 7/21/18 Saturday 7/22/18 Sunday 0 7/23/18 Monday 20 7/24/18 Tuesday 20 o 7/25/18 Wednesday 19 o 7/26/18 Thursday 22 7/27/18 Friday 30 7/28/18 saturday 7/29/18 Sunday 0 7/30/18 Monday 25 21 7/31/18 Tuesday 19 500 453 of 8/1/18 Wednesday 21 36 398 o 8/2/18 Thursday 29 35 333 8/3/18 Friday 255 8/4/18 Saturday 0 255 8/5/18 Sunday 0 255 Monday 26 193 8/7/18 Tuesday 26 889 14.5111 15.03162 15.9455 15.28107 14.33662 14.27733 16.35994 15.8363 14.7086 15.05007 14.24088 15.24913 16.6575 16.97042 14.24286 o 8/8/18 Wednesday 22 8/9/18 Thursday 28 838 0 771 o Documentation Sales and Order Data Output + Ready Accessibility: Investigate + 66%AutoSave OFF HAPYC... Sales and Order - Student Data Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) 11 A A General Conditional Formatting v Insert v Format as Table v x Delete Paste B I U A % 9 Sort & Find & Analyze Sensitivity i Cell Styles v Format v Filter Select Data AF86 X V fx B C D E F G H I M N P Q U V W X Y Z AA AB AC AD AE AF AG 8/9/18 hursday 28 8/10/18 Friday 589 /11/18 Saturday 0 689 /12/18 Sunday 0 689 /13/18 onday 26 630 3/14/18 Tuesday 26 570 8/15/18 Wednesday 32 21 o o o o O O O O O /16/18 Thursday 29 24 /17/18 Friday 43 34 /18/18 Saturday 8/19/18 Sunday 0 387 8/20/18 Monday 39 30 /21/18 Tuesday 33 28 o 3/22/18 Wednesday 31 23 750 14.09969 16.31659 15.42221 15.9962 14.96242 16.59874 16.42876 15.72305 14.76608 15.98905 14.20988 14.73792 15.47842 14.14091 16.5246 /23/18 Thursday 36 25 0 /24/18 Friday 45 36 0 8/25/18 Saturday 0 0 /26/18 Sunday 0 0 /27/18 Monday 31 24 /28/18 Tuesday 24 /29/18 Wednesday 21 8/30/18 Thursday 25 /31/18 Friday 45 9/1/18 Saturday 9/2/18 unday 9/3/18 Monday 8 8 . 44 0 9/4/18 uesday 40 o 9/5/18 Wednesday 35 750 15.88813 16.69191 16.72943 14.91185 16.15617 16.84951 16.23372 16.27814 14.33442 16.99889 14.84663 16.99227 16.55725 15.41339 15.81732 9/6/18 Thursday 36 o 9/7/18 Friday 59 0 /8/18 Saturday 749 9/9/18 Sunday /10/18 Monday 41 637 0 /11/18 Tuesday 9/12/18 Wednesday 29 /13/18 Thursday 38 0 o 9/14/18 Friday 57 750 12.47335 11.24068 17.36201 14.50248 13.06559 12.12263 15.4988 16.83707 13.9526 17.32905 14.21503 14.3185 12.81179 12.28164 14.27899 /15/18 Saturday 0 /16/18 Sunday 980 /17/18 Monday 45 0 o 9/18/18 Tuesday 42 777 0 35 ooo 9/19/18 Wednesday Gagabe /20/18 Thursday 40 602 0 /21/18 Friday 77 60 465 /22/18 Saturday 0 465 0 ooo 9/23/18 Sunday 0 465 0 9/24/18 Monday 68 45 352 /25/18 Tuesday 53 41 258 0 o /26/18 Wednesday 43 33 182 15.68859 15.89604 16.42822 16.52435 16.98099 14.79287 15.33041 14.77206 15.33871 16.3238 14.04618 14.49877 15.09763 15.54441 15.21834 9/27/18 Thursday 48 41 843 o 9/28/18 Friday 74 62 707 0 9/29/18 Saturday OOH 0 707 9/30/18 Sunday 707 10/1/18 Monday 50 594 10/2/18 Jesday 37 504 10/3/18 Wednesday 36 422 10/4/18 329 Documentation Sales and Order Data Output + Ready Accessibility: Investigate + 66%AutoSave OFF HAPYC... Sales and Order - Student Data Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) 11 A A ab General Conditional Formatting v Insert v Format as Table v x Delete Paste B I U A $ % 9 -00 Sort & Find & Analyze Sensitivity i Cell Styles v Format v Filter Select Data AF86 X V fx A B C D E F G H L M N o U w Y Z AA AB AC AD AE AF AG 10/3/18 Wednesday 36 422 o 10/4/18 Thursday 10/5/18 Friday 61 750 12.48908 17.91974 11.33275 14.78269 11.91954 13.06447 16.73729 17.8874 16.93594 17.72937 13.98709 16.86649 14.39471 14.46944 17.90372 10/6/18 Saturday 0 o o o 10/7/18 Sunday 10/8/18 Monday 59 52 10/9/18 Tuesday 40 10/10/18 Wednesday 43 35 10/11/18 Thursday 56 42 10/12/18 Friday 73 60 10/13/18 Saturday 10/14/18 Sunday 10/15/18 Monday o 10/16/18 Tuesday 750 15.296 16.14122 15.13559 15.22317 15.27866 14.0896 16.01162 15.59336 16.91722 14.30119 14.5503 15.10111 15.05797 14.83312 16.31514 10/17/18 Wednesday 0 o 10/18/18 Thursday 0 10/19/18 Friday 10/20/18 Saturday 10/21/18 Sunday 10/22/18 Monday oo oo OO 10/23/18 Tuesday 10/24/18 Wednesday 10/25/18 Thursday 10/26/18 Friday 750 11.98019 15.47159 16.55723 17.90948 14.54633 15.12597 16.1935 12.47527 11.00604 17.96515 12.16251 11.13198 12.60174 12.30842 14.58901 10/27/18 Saturday 0 o 10/28/18 Sunday 10/29/18 Monday 10/30/18 Tuesday 10/31/18 Wednesday 42 11/1/18 Thursday 11/2/18 Friday 11/3/18 Saturday 11/4/18 Sunday o 11/5/18 Monday 77 750 15.92263 16.57659 15.92765 14.96642 14.67105 16.19624 14.91166 14.89589 14.51152 16.37462 16.74031 16.25687 16.88685 16.67958 16.27106 11/6/18 Tuesday 56 0 44 o 11/7/18 Wednesday 0 -1/8/18 Thursday 11/9/18 Friday oo OC 11/10/18 Saturday 11/11/18 Sunday 0 11/12/18 Monday 63 11/13/18 Tuesday 11/14/18 Wednesday 48 0 o 11/15/18 Thursday 55 45 750 16.565 15.41671 14.69112 14.38035 16.87338 14.74285 15.34342 14.0494 15.46075 16.10214 14.11802 16.67173 15.7575 14.56817 14.2632 11/16/18 Friday 81 62 o 11/17/18 Saturday 0 172 o 11/18/18 Sunday 172 0 11/19/18 Monday 65 11/20/18 Tuesday 60 549 11/21/18 Wednesday 46 166 11/22/18 Thursday 59 363 0 11/23/18 Friday 220 750 15.89259 12.33529 14.35809 16.88075 15.50281 12.31237 13.25947 15.82429 12.61851 12.60025 11.78676 14.99026 13.06935 15.0678 13.35555 11/24/18 Saturday 970 0 DOOR 11/25/18 Sunday 970 o O 11/26/18 Monday 852 51 oo 11/27/18 Tuesday 758 Documentation Sales and Order Data Output + Ready Accessibility: Investigate + 66%AutoSave OFF HAPYC... Sales and Order - Student Data Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) 11 A A ab General Conditional Formatting v Insert v Format as Table x Delete Paste B I U A % 9 Sort & Find & Analyze Sensitivity i Cell Styles v Format v Filter Select Data AF86 X V fx B D E F G H K L M N P Q S T U V W X Y AA AB AC AD AE AF AG 1/28/18 Wednesday 45 32 581 11/29/18 Thursday 56 40 585 1/30/18 Friday 74 65 446 2/1/18 Saturday 4 46 NOOOOOO 12/2/18 unday 0 446 12/3/18 londay 73 55 o 2/4/18 yesday 41 15.48018 16.08335 16.0964 16.24612 15.20931 14.76463 15.76327 14.30659 14.84192 14.96429 14.88603 16.35569 15.68925 15.22726 15.4179 12/5/18 Wednesday 49 36 o 2/6/18 Thursday 58 43 12/7/18 Friday 61 2/8/18 Saturday 0 2/9/18 Sunday 2/10/18 Monday 53 0 2/11/18 Tuesday 42 418 0 12/12/18 nesday 36 o 12/13/18 Thursday 42 750 2/14/18 Friday 59 15.56918 14.46933 14.78803 15.44108 14.86029 14.72377 14.45672 15.97874 16.26459 15.6932 16.71059 14.21755 15.36871 15.86643 15.30043 0 o 12/15/18 Saturday 0 0 2/16/18 Sunday 0 2/17/18 onday 52 12/18/18 wesday 43 616 0 12/19/18 Wednesday 50 41 12/20/18 Thursday 41 429 2/21/18 Friday 66 288 12/22/18 iturday 2/23/18 Sunday 0 288 0 o 12/24/18 Monday 68 54 750 16.34396 16.3111 15.68449 16.13039 15.86578 14.71099 15.30886 15.34635 16.14479 16.58371 16.48381 15.01605 16.61369 15.18202 16.22063 12/25/18 Tuesday 42 814 0 12/26/18 Wednesday 38 730 12/27/18 ursday 43 2/28/18 Friday 60 489 0 12/29/18 Saturday 12/30/18 Sunday 489 o 2/31/18 Monday 52 368 0 o 1/1/19 Jesday 69 750 14.68796 16.17716 14.36666 16.95476 16.54032 14.34426 14.12485 16.81311 14.26055 15.18826 15.77387 14.65085 16.46376 15.21382 16.62336 1/2/19 Wednesday 54 845 o 1/3/19 Thursday 68 691 1/4/19 Friday 96 475 0 1/5/19 Saturday 0 475 0 1/6/19 Sunday 0 0 1/7/19 Monday 77 300 o /8/19 Jesday 63 750 14.85577 16.54442 14.96633 15.47615 16.27197 14.60588 14.1344 15.09556 16.29695 14.0114 15.01401 15.71972 14.09885 14.21244 16.95146 1/9/19 Wednesday 68 53 784 0 o /10/19 Thursday 89 64 631 0 1/11/19 Friday 121 95 415 o /12/19 Saturday 415 o 13/19 Sunday 415 o /14/19 Monday 73 244 750 16.04852 14.10678 15.12083 16.1119 16.07359 15.13495 14.46662 16.14568 16.53706 16.42731 16.95706 14.28371 16.26359 16.752 15.42926 1/15/19 Tuesday 90 69 835 0 o 1/16/19 Wednesday 67 54 714 /17/19 Thursday 85 67 562 0 o 18/19 Friday 123 91 348 1/19/19 Saturday 348 /20/19 Sunday 348 0 o 1/21/19 Monday 74 181 750 14.12567 14.7164 14.02173 16.29543 14.23184 14.9172 16.92469 14.96344 15.07419 14.6492 14.76388 16.46675 14.51796 15.47053 16.17734 388 /22/19 Tuesday 69 775 Documentation Sales and Order Data Output + Ready Accessibility: Investigate + 66%AutoSave OFF HAPYC... Sales and Order - Student Data Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) 11 A A ab General Conditional Formatting v Insert v Format as Table x Delete Paste B I U A % 9 Sort & Find & Analyze Sensitivity i Cell Styles v Format v Filter Select Data AF86 X V fx C D E F G H K M N P Q T U v W X Y 2 AA AB AC AD AE AF AG 1/22/19 Tuesday 87 69 775 1/23/19 Wednesday 82 653 1/24/19 65 oo Thursday 1/25/19 Friday 119 94 293 1/26/19 Saturday 1/27/19 Sunday o u o o o H oo ooo 1/28/19 Monday 101 74 15.50724 14.92391 14.59034 14.80101 14.59554 16.74413 14.25216 16.83501 15.84406 15.19973 15.83727 15.45713 15.23138 16.05017 16.79857 1/29/19 Tuesday 84 68 o 1/30/19 Wednesday 70 54 /31/19 hursday 81 66 o 2/1/19 Friday 111 87 14.84408 13.20966 15.87377 16.33159 17.97772 15.34652 12.0054 15.53977 11.45763 17.86141 14.58773 16.02167 15.73634 13.26257 12.48105 2/2/19 aturday 0 0 Sunday 0 0 2/4/19 Monday 93 70 o 2/5/19 Tuesday 64 2/6/19 Wednesday 65 46 2/7/19 Thursday 79 62 o Friday 106 85 750 16.29626 16.90268 11.12291 14.85257 17.10718 15.07151 15.10737 13.42812 15.1201 14.0733 14.70091 15.63292 14.90614 15.58144 17.54529 2/9/19 Saturday o 2/10/19 Sunday 0 o 2/11/19 Monday 76 o u o o o o o o M o o o o o o H o o o O O o 2/12/19 Tuesday 77 60 o 2/13/19 Wednesday 50 2/14/19 Thursday 81 61 o 2/15/19 Friday 104 86 11.24408 17.3595 16.46692 13.21104 15.61179 14.17142 16.47924 15.49638 12.5187 14.49226 11.88738 16.90441 16.28703 14.96213 13.9536 2/16/19 aturday o 2/17/19 Sunday 2/18/19 Monday 73 of 2/19/19 Tuesday 60 o 2/20/19 Wednesday 59 47 2/21/19 Thursday 83 62 o 2/22/19 Friday 110 84 16.08066 15.20259 14.32379 15.92621 11.56258 13.88902 14.58477 13.59678 13.51618 14.8108 11.62962 17.7045 17.98398 11.37293 13.80918 /23/19 0 0 o 2/24/19 Sunday 0 /25/19 Monday 71 0 2/26/19 Tuesday 59 o 2/27/19 Wednesday 58 46 2/28/19 Thursday 61 3/1/19 Friday 107 88 o o i o o o o o o O O o 3/2/19 Saturday 3/3/19 Sunday o 3/47 19 Monday 68 3/5/19 Tuesday 62 15.19601 15.41434 16.56124 16.68274 16.89578 14.93931 16.63494 15.74915 16.19879 15.86439 16.41837 15.84407 14.89246 16.83951 16.08213 o 3/6/19 Wednesday 46 o 3/7/19 Thursday 60 o 3/8/19 Friday 85 o 3/9/19 aturday 292 3/10/19 Sunday 292 3/11/19 Monday 92 71 129 750 15.60784 16.57861 16.37138 16.53685 16.83219 14.86469 16.93149 16.34511 14.24036 16.71326 15.79906 14.76301 16.82137 15.51271 16.2668 /12/19 Tuesday 58 747 o 3/13/19 Wednesday 62 48 637 3/14/19 Thursday 73 58 506 3/15/19 Friday 108 87 311 noooOOO 3/16/19 Saturday 311 3/17/19 Sunday 311 o 3/18/19 Monday 151 16.03921 16.66475 14.07304 16.29341 15.09435 16.32781 15.18797 16.7373 16.86407 15.74497 14.87035 14.95076 14.65268 16.74725 15.34107 Documentation Sales and Order Data Output + Ready Accessibility: Investigate + 66%AutoSave OFF HAPYC... Sales and Order - Student Data Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) 11 A A ab General Conditional Formatting Insert v Format as Table x Delete Paste B I U A % 9 Sort & Find & Analyze Sensitivity i Cell Styles v Format v Filter Select Data AF86 X V fx C D E F G H K M N O P Q R T U V W X Y 2 AA AB AC AD AE AF AG 3/19/19 Tuesday 74 60 767 3/20/19 Wednesday 3/21/19 Thursday 75 58 3/22/19 Friday 102 87 3/23/19 Saturday o 3/24/19 Sunday 0 o 8/25/19 Monday 92 73 14.83994 14.03223 14.33212 15.94365 16.77119 16.25748 14.16026 14.79583 14.42472 16.00779 15.0834 14.27428 16.29573 16.93126 15.44905 3/26/19 Tuesday 76 63 o 3/27/19 Wednesday 60 44 0 3/28/19 Thursday 70 60 o 3/29/19 Friday 104 87 o 8/30/19 Saturday 3/31/19 Sunday 0 o 4/1/19 Monday 66 15.68224 15.80478 16.3313 14.38003 15.57151 15.14209 14.81675 14.77594 15.59305 15.68373 16.58684 15.46801 16.00416 15.60988 14.69687 4/2/19 Tuesday 57 o 4/3/19 Wednesday 43 4/4/19 Thursday 61 4/5/19 Friday 104 83 o 4/6/19 aturday o 4/7/19 Sunday 4/8/19 Monday 71 o 4/9/19 Tuesday 58 16.88617 14.99391 16.79372 15.90669 14.84672 15.48317 14.7165 14.84684 14.43021 16.1702 14.45229 16.6176 16.2729 15.17135 14.13785 4/10/19 Wednesday 43 o 4/11/19 Thursday 61 o 4/12/19 Friday 82 o 4/13/19 u o o o o o O Saturday o /14/19 Sunday 4/15/19 Monday 68 o 4/16/19 Tuesday 58 15.74589 14.83046 16.02111 14.49999 14.24008 14.77718 16.26714 16.05803 15.9137 15.76575 15.76797 14.62955 15.27924 14.06761 14.39725 4/17/19 Wednesday 43 o 4/18/19 Thursday 64 4/19/19 Friday 107 86 4/20/19 Saturday o 4/21/19 Sunday o 4/22/19 4/23/19 Monday 65 Tuesday 17 58 y o o o o o o H o o O OOO 1/24/19 Wednesday 44 15.40094 15.17182 15.26925 14.976 14.27854 14.67727 14.68416 14.66141 14.463 14.84836 15.30339 16.75573 16.86748 15.10579 16.4331 o 4/25/19 Thursday 77 57 4/26/19 Friday 106 83 o 4/27/19 aturday o 4/28/19 Sunday o 1/29/19 Monday 67 4/30/19 Tuesday 61 16.82754 15.74224 15.48489 16.92536 14.53208 15.90925 14.56296 16.52202 15.3339 14.89784 15.4532 14.52256 15.96527 16.54357 16.83295 5/1/19 Wednesday 41 o 5/2/19 Thursday 62 5/3/19 Friday 82 567 5/4/19 Saturday 567 o ooo ooo 5/5/19 Sunday 0 567 o 5/6/19 Monday 66 419 5/7/19 Tuesday 59 28 8 5/8/19 Wednesday 43 190 14.72693 14.11476 14.39685 14.37475 14.52709 14.755 16.02809 16.30357 15.25394 15.04652 16.04408 14.62489 15.71923 16.41061 16.90437 5/9/19 Thursday 60 807 o 5/10/19 Friday 84 624 0 5/11/19 ooooo aturday 624 o 5/12/19 Sunday 0 624 o 5/13/19 63 474 o Documentation Sales and Order Data Output Ready Accessibility: Investigate + 66%AutoSave OFF HA PYC... Sales and Order - Student Data Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) 11 A A ab General Conditional Formatting v Insert v Format as Table v Ex Delete Paste B I U A $ % 9 -00 Sort & Find & Analyze Sensitivity i Cell Styles v Format v Filter Select Data AF86 X V fx C D E F G H M N P Q U W X Y Z AA AB AC AD AE AF AG 5/13/19 Monday 5/14/19 87 63 Tuesday 75 62 o 5/15/19 Wednesday 57 750 Thursday 74 16.16869 15.22261 14.36637 15.12823 15.10114 15.63648 15.19916 16.83111 14.78945 15.99632 15.50449 16.4414 16.65362 16.27762 14.4228 5/16/19 61 o 5/17/19 Friday 104 84 0 5/18/19 aturday o o 5/19/19 Sunday 0 o of 5/20/19 Monday 85 67 o /21/19 Tuesday 59 5/22/19 Wednesday 58 40 o 5/23/19 Thursday 74 59 15.0546 15.10116 15.91245 14.53494 16.24258 16.03082 15.92196 16.82958 14.5797 15.44122 14.40844 15.05323 15.85761 16.1654 16.66309 5/24/19 Friday 82 o 5/25/19 Saturday 5/26/19 Sunday o 5/27/19 Monday 70 o 5/28/19 Tuesday 60 of 5/29/19 Wednesday 44 o 5/30/19 Thursday 62 750 5/31/19 85 15.72351 15.51415 14.6108 15.24557 16.96316 15.39531 16.19666 14.44684 16.43947 15.11007 15.28534 16.8104 16.16458 15.38985 14.17095 Friday 6/1/19 Saturday 0 6/2/19 Sunday o Monday 39 6/4/19 Tuesday 40 6/5/19 Wednesday 27 6/6/19 Thursday 42 6/7/19 Friday 54 Saturday 0 6/9/19 Sunday 0 o 5/10/19 Monday 40 14.50926 16.32329 14.6618 14.24044 16.99431 14.10408 16.29606 15.41458 15.09459 14.29924 16.49642 14.41263 15.53989 14.75954 15.33724 6/11/19 Tuesday 39 o 6/12/19 Wednesday 26 0 5/13/19 Thursday 39 6/14/19 Friday 56 6/15/19 aturday o 6/16/19 Sunday o o 6/17/19 Monday 39 6/18/19 Tuesday 42 6/19/19 Wednesday 27 o 6/20/19 Thursday 41 14.93133 14.90418 16.39995 16.92512 16.35433 16.67427 14.06731 16.45918 15.70436 15.21839 16.38973 16.60021 15.84856 15.89803 15.26649 6/21/19 Friday 50 o 6/22/19 aturday o 6/23/19 Sunday 6/24/19 Monday 38 6/25/19 Tuesday 39 6/26/19 Wednesday 26 o 6/27/19 Thursday 39 503 6/28/19 Friday 57 380 6/29/19 Saturday 0 380 6/30/19 Sunday 0 380 7/1/19 Monday 29 311 o 6T/2/ L Tuesday 28 247 750 14.00508 15.49607 14.66255 15.40605 16.16432 16.19941 15.15304 14.07878 15.428 14.6262 14.64993 15.1485 14.72213 15.31935 16.87535 7/3/19 Wednesday 945 o 7/4/19 Thursday 881 7/5/19 Friday 786 7/6/19 Saturday 786 7/7/19 Sunday 786 Documentation Sales and Order Data Output + Ready Accessibility: Investigate + 66%AutoSave OFF HAPYC... Sales and Order - Student Data Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) 11 A A General Conditional Formatting v Insert v Format as Table x Delete Paste B I U A % 9 100 Sort & Find & Analyze Sensitivity i Cell Styles v Format v Filter Select Data AF86 X V fx B C D E F G H K L M N Q R S U V W Z AA AB AC AD AE AF AG 7/8/19 Monday 50 28 7/9/ 19 Tuesday 7/10/19 Wednesday 28 20 7/11/19 Thursday 32 30 7/12/19 Friday 7/13/19 Saturday /14/19 Sunday 7/15/19 Monday 7/16/19 Tuesday 40 7/17/19 Wednesday 7/18/19 Thursday 16.23951 15.16324 14.49206 15.50823 16.03754 15.85348 16.88853 14.85493 15.48831 15.47624 14.34066 15.81921 16.42447 15.99832 14.27075 7/19/19 Friday o 7/20/19 aturday 7/21/19 Sunday 7/22/19 Monday 7/23/19 Tuesday o 7/24/19 Wednesday 7/25/19 Thursday 7/26/19 Friday 7/27/19 saturday 7/28/19 Sunday /29/19 Monday 7/30/19 Tuesday 7/31/19 Wednesday 8/1/19 Thursday 16.66233 15.8626 14.08627 15.79552 15.04331 15.34528 15.35659 15.39171 15.79481 15.80427 16.65768 16.36984 16.5424 14.65457 14.93286 8/2/19 0 8/3/19 aturday 8/4/19 Sunday 8/5719 Monday o 8/6/19 Tuesday o 8/7/19 Wednesday o 8/8/19 Thursday 8/9/19 Friday 8/10/19 Saturday 8/11/19 Sunday 8/12/19 Monday 52 8/13/19 Tuesday o 8/14/19 Wednesday o 8/15/19 Thursday NN LOON WWW WOON 14.50383 16.43491 14.5966 15.99714 16.20991 15.57613 16.0998 14.12435 14.52401 16.20686 14.60836 15.25847 15.03928 15.93431 14.1089 8/16/19 Friday 8/17/19 iaturday o 8/18/19 Sunday 8/19/19 Monday Tuesday o o 8/20/19 8/21/19 Wednesday 8/22/19 Thursday 44 32 8/23/19 Friday 42 8/24/19 aturday o 8/25/19 Sunday 410 o 8/26/19 Monday 318 8/27/19 Tuesday 33 236 16.08191 15.07677 14.59439 16.73988 16.25614 16.32486 15.40944 15.61483 16.32665 15.88538 16.30583 15.72847 14.96211 15.86375 14.16356 8/28/19 Wednesday 926 o 8/29/19 Thursday 850 8/30/19 Friday 754 o o 8/31/19 Saturday 754 9/1/19 Sunday 54 o Documentation Sales and Order Data Output + Ready Accessibility: Investigate + 66%AutoSave OFF HAPYC... Sales and Order - Student Data Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) 11 A A ab General Conditional Formatting v Insert v Format as Table x Delete Paste B I U A $ % 9 Sort & Find & Analyze Sensitivity i Cell Styles v Format v Filter Select Data AF86 X V fx B C D E F G H K M N 0 P Q U V W X Y Z AA AB AC AD AE AF AG 9/2/19 Monday 9/3/19 66 65 502 Tuesday 475 0 14/19 Wednesday 62 42 0 9/5/19 Thursday 79 61 16.64233 15.09968 15.34144 15.90662 14.23771 14.4484 15.15967 15.58267 16.26476 14.03303 16.924 16.69844 16.42415 14.25308 15.86019 9/6/19 Friday 103 85 o 9/7/19 aturday 0 0 9/8/19 Sunday 0 ui o o o o o o o yo o 0 9/9/19 Monday 70 9/10/19 Tuesday 79 61 9/11/19 Wednesday 59 41 o 9/12/19 Thursday 61 9/13/19 Friday 101 84 12.95764 14.3413 14.00755 15.37042 17.47954 11.85024 17.88345 16.71658 11.16464 14.96741 14.24646 16.96376 16.0363 14.22468 15.30464 /14/19 Saturday 9/15/19 Sunday 0 o 9/16/19 Monday 65 o 9/17/19 Tuesday 59 9/18/19 Wednesday 40 o 9/19/19 Thursday 58 9/20/19 Friday 85 16.26387 15.93724 13.71256 17.56659 17.31557 12.12957 12.43953 15.0968 14.21968 13.69125 13.9646 11.99628 15.76655 17.59209 12.80769 9/21/19 saturday o 9/22/19 Sunday 0 9/23/19 Monday 68 o 3/24/19 Tuesday 59 o 9/25/19 Wednesday 42 9/26/19 Thursday 78 62 o 9/27/19 Friday 102 84 16.65975 13.51151 12.49705 17.50763 17.22585 12.73809 11.06552 14.9967 13.46248 15.60726 17.4888 15.98454 16.04481 17.04068 17.6198 9/28/19 Saturday o 9/29/19 Sunday 0 9/30/19 Monday 79 64 10/1/19 Tuesday 60 0 10/2/19 Wednesday 43 o 10/3/19 Thursday 73 58 o 10/4/19 Friday 103 86 13.7389 12.34028 15.36518 11.25789 13.8819 16.70282 12.25657 12.36168 13.10273 16.85038 11.92031 14.09134 14.61153 16.13448 11.87983 10/5/19 aturday 0 o 10/6/19 Sunday 0 10/7/19 Monday 70 o 10/8/19 Tuesday 72 59 o 10/9/19 Wednesday 44 o 0/10/19 Thursday 74 57 o 0/11/19 Friday 106 84 750 11.07149 15.74893 11.56879 17.79152 15.53961 16.64738 14.03412 17.75005 13.03766 15.12083 16.98594 17.83245 15.1725 12.13035 17.56367 10/12/19 aturday o 10/13/19 Sunday 0 ooo 0/14/19 Monday 73 0 0/15/19 uesday 59 o 0/16/19 Wednesday 61 49 590 o 10/17/19 Thursday 73 63 454 10/18/19 Friday 105 83 266 0 0/19/19 Saturday 266 0/20/19 Sunday 0 266 o 0/21/19 Monday 87 73 106 750 15.80729 16.62127 15.42382 15.28045 14.75558 16.23948 16.60992 15.34914 14.90515 16.88182 16.33395 16.76861 16.61253 14.95611 15.21232 10/22/19 Tuesday 73 59 724 0/23/19 Wednesday 59 49 o 0/24/19 Thursday 72 616 61 483 0/25/19 Friday 105 90 288 o 0/26/19 Saturday 0 288 10/27/19 Sunday Roo 10/29/10 Mandan Documentation Sales and Order Data Output + Ready Accessibility: Investigate + 66%AutoSave OFF HAPYC... Sales and Order - Student Data Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) 11 A A ab General Conditional Formatting Insert v Format as Table v x Delete Paste B I UV A $ % 9 Sort & Find & Analyze Sensitivity i Cell Styles v Format v Filter Select Data AF86 X V fx 3 C D E F G H K M P Q U V w X Y Z AA AB AC AD AE AF AG 10/28/19 Monday 86 69 133 750 16.1928 14.27869 15.3615 16.96221 14.90293 15.27629 16.3613 15.63379 14.30536 16.58111 15.97462 14.58794 14.54474 14.71758 14.25714 10/29/19 Tuesday 59 0 0/30/19 Wednesday 64 49 636 0/31/19 Thursday 80 61 495 11/1/19 Friday 108 85 302 1/2/19 Saturday 0 302 0 1/3/19 Sunday 0 302 o 11/4/19 Monday 8 8 70 144 750 14.46499 14.59833 15.99294 15.20189 16.13977 15.51878 14.13918 14.15391 15.72851 15.02766 14.62411 15.90054 16.46071 15.95457 16.23783 1/5/19 Tuesday 79 60 755 11/6/19 Wednesday 57 46 652 1/7/19 Thursday 83 510 1/8/19 Frida 110 87 313 11/9/19 Saturday 0 o 1/10/19 Sunday 0 0 0 11/11/19 Monday 89 74 750 16.93685 15.74127 15.20223 16.05993 15.41179 14.34108 15.47771 14.88813 16.11378 15.67403 14.82184 15.21902 16.09924 16.85062 15.0971 1/12/19 Tuesday 86 62 0 1/13/19 Wednesday 63 46 11/14/19 ursday 81 64 1/15/19 Friday 114 87 11/16/19 Saturday 0 1/17/19 Sunday 0 o 1/18/19 onday 74 750 14.06643 14.94792 15.89971 15.65214 14.81995 14.39106 16.30898 15.64154 15.18324 14.4884 14.78666 16.32436 16.62283 16.41558 15.75498 11/19/19 Tuesday 59 742 o 1/20/19 Wednesday 42 0 11/21/19 Thursday 57 11/22/19 Friday 106 85 0 1/23/19 Saturday 0 1/24/19 junday 0 o 1/25/19 Monday 92 70 750 16.2946 16.86152 15.14627 15.95663 14.74319 16.53132 15.71789 16.92803 15.10569 16.8347 16.86108 14.60756 15.16118 15.10972 15.84819 11/26/19 Tuesday 79 60 0 o 11/27/19 Wednesday 57 50 0 1/28/19 Thursday 85 59 1/29/19 Friday 112 83 1/30/19 Saturday 0 12/1/19 Sunday 0 12/2/19 Monday 90 74 750 12/3/19 Tuesday 62 15.83381 16.33797 16.84035 15.30336 16.71383 16.5279 16.70033 14.7618 14.06111 15.82163 15.77705 16.3289 15.3171 14.48186 15.59368 o 2/4/19 Wednesday 62 49 2/5/19 Thursday 86 63 2/6/19 Friday 112 94 12/7/19 Saturday 0 0 o 2/8/19 Sunday o 2/9/19 Monday 74 131 750 15.98657 16.54867 14.06399 14.90426 16.26013 14.34841 15.44798 15.64681 14.96497 15.72142 15.85312 15.92444 15.53481 15.57611 14.80342 2/10/19 Tuesday 67 730 o 12/11/19 Wednesday 63 52 615 0 12/12/19 Thursday 81 61 94 473 0 2/13/19 Friday 111 268 2/14/19 Saturday 0 268 2/15/19 Sunday 268 12/16/19 Monday 90 70 108 750 16.93698 14.43331 16.95851 16.65969 14.67205 14.66315 15.58874 16.37317 14.5741 15.48991 15.55546 16.93647 15.98469 14.45392 16.59574 12/17/19 Tuesday 61 717 2/18/19 Wednesday 2 8 8 46 605 12/19/19 Thursday 65 462 ooo 2/20/19 Friday 112 95 255 12/21/19 Saturday 255 12/22/19 Sunday 255 o Documentation Sales and Order Data Output Ready Accessibility: Investigate + 66%AutoSave OFF HA PYC... Sales and Order - Student Data Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) 11 A A ab General Conditional Formatting Insert v Format as Table v x Delete Paste B I U A % 9 -00 Sort & Find & Analyze Sensitivity i Cell Styles v Format v Filter Select Data AF86 X V fx C D E F G H Q U W Z AA AB AC AD AE AF AG 12/23/19 Monday 97 70 750 14.83755 14.91789 16.69414 14.47499 14.48001 14.60168 14.38289 15.84776 14.34921 16.34282 16.36666 14.51845 15.25279 14.88128 15.41872 12/24/19 Tuesday 65 2/25/19 Wednesday 68 52 577 0 12/26/19 Thursday 81 59 437 o 2/27/19 Friday 114 95 228 750 14.8827 14.92889 16.16552 17.42119 16.54296 14.1787 15.72945 11.49214 16.40743 12.12056 16.04348 11.3266 15.65697 16.3584 17.3231 12/28/19 aturday o 2/29/19 Sunday 0 0 978 2/30/19 Monday 93 71 814 0 12/31/19 Tuesday 80 62 672 1/1/20 Wednesday 37 26 o 1/2/20 Thursday 45 38 1/3/20 Friday 50 o oo ah 1/4/20 aturday 1/5/20 Sunday 1/6/20 Monday 51 36 o 1/7/20 Tuesday 37 14.2562 16.10972 15.77107 16.03668 16.27472 14.511 16.57003 15.48313 15.42299 15.42509 15.40256 15.13054 16.61506 15.36645 16.86708 1/8/20 Wednesday 28 o 1/9/20 Thursday 40 u o o o o o o o o o o o o H o O O O O O O O O o 1/10/20 Friday 50 1/11/20 saturday| 0 1/12/20 Sunday 0 o 1/13/20 Monday 39 1/14/20 Tuesday 38 o 1/15/20 Wednesday 29 1/16/20 Thursday 37 1/17/20 Friday 1/18/20 Saturday 0 1/19/20 Sunday 0 1/20/20 Monday 39 15.34093 15.1279 14.98308 15.78347 16.59649 15.52623 15.26914 14.4449 14.78335 14.89012 16.51893 15.4016 14.8689 15.80482 16.55578 1/21/20 Tuesday 34 1/22/20 Wednesday 28 0 1/23/20 Thursday 38 o 1/24/20 Friday 49 OOC 1/25/20 aturday u o o o o o o o o O 1/26/20 Sunday oo 1/27/20 Monday 37 1/28/20 Tuesday 40 1/29/20 Wednesday 27 1/30/20 Thursday 39 15.00203 15.30996 15.88144 16.36499 14.77962 14.99733 16.31116 16.00987 15.72383 15.10794 16.30727 15.88499 15.67103 15.32067 16.90592 1/31/20 Friday 50 o 2/1/20 aturday 0 2/2/20 Sunday 0 2/3/20 Monday 40 2/4/20 Tuesday 32 2/5/20 Wednesday 33 27 2/6/20 Thursday 47 34 573 2/7/20 Friday 61 39 473 o o o O i O O O O O O O O O O O O 2/8/20 saturday 473 o 2/9/20 Sunday 473 2/10/20 Monday 41 378 2/11/20 Tuesday 32 303 o 2/12/20 Wednesday 27 240 14.11461 14.18017 15.76239 14.83352 16.86173 15.9495 15.53372 14.3096 15.40813 16.64779 14.70365 15.78124 15.87742 16.21455 15.44536 2/13/20 Thursday 33 914 o 2/14/20 Friday 42 810 o 2/15/20 aturday 810 o 2/16/20 Sunday 810 Documentation Sales and Order Data Output + Ready Accessibility: Investigate + 66%AutoSave OFF HAPYC... Sales and Order - Student Data Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) 11 A A ab General Conditional Formatting v Insert v Format as Table v x Delete Paste B I U A % 9 Sort & Find & Analyze Sensitivity i Cell Styles v Format v Filter Select Data AF86 X V fx B D E F G H K M N P Q U V W X Y Z AA AB AC AD AE AF AG 2/17/20 Monday 712 2/18/20 Tuesday 38 42 37 640 2/19/20 Wednesday 28 575 2/20/20 Thursday 44 36 495 /21/20 Friday 58 42 395 oooooo . 2/22/20 Saturday 395 2/23/20 Sunday 2/24/20 Monday 37 2/25/20 Tuesday 36 16.61082 15.97902 15.71581 16.31586 15.60131 15.30828 15.82621 14.3944 14.69581 14.90115 16.53052 16.34723 14.41749 15.24889 14.53153 26/20 Wednesday 28 o 2/27/20 Thursday 32 2/28/20 Friday 42 727 2/29/20 Saturday 3/1/20 Sunday 3/2/20 Monday 39 3/3/20 o o o o O O O O O O O Tuesday 29 3/4/20 Wednesday 27 3/5/20 Thursday 3/6/20 Friday 45 3/7/20 Saturday 3/8/20 Sunday o 3/9/20 Monday 52 41 750 30 16.57021 15.78883 16.88835 15.18257 16.56594 14.70385 15.70835 14.16271 14.66074 16.84795 15.80239 15.42763 14.53119 16.18418 16.48705 3/10/20 Tuesday o 3/11/20 Wednesday 25 poo 12/20 Thursday 31 3/13/20 Friday 44 3/14/20 saturday 0 3/15/20 Sunday 3/16/20 Monday 40 3/17/20 Tuesday 29 3/18/20 Wednesday 29 3/19/20 Thursday 31 ooo 3/20/20 Friday 42 3/21/20 Saturday 0 22/20 Sunday o 3/23/20 Monday 42 16.75596 15.57299 15.61387 14.07143 16.53527 14.90983 15.85813 14.58096 15.23881 14.09359 14.87899 15.57084 14.08232 16.35501 15.42319 3/24/20 Tuesday 31 o 3/25/20 Wednesday 24 3/26/20 Thursday 31 ooo o o o o o o o 3/27/20 Friday 41 3/28/20 Saturday 8/29/20 Sunday 632 3/30/20 Monday 39 3/31/20 Tuesday 28 4/1/20 Wednesday 26 o o O 4/2/20 Thursday 45 32 o 4/3/20 Friday 56 40 237 750 987 16.18525 17.83928 17.82282 16.03193 15.7426 16.4677 14.81668 11.54286 17.63239 14.16657 13.15136 17.11803 15.20939 13.98607 15.17319 4/4/20 Saturday 4/5/20 Sunday 987 0 0 /6/20 Monday 40 897 1/7/20 Tuesday 26 828 4/8/20 Wednesday 26 769 4/9/20 Thursday 31 698 booooo 4/10/20 Friday 39 608 4/11/20 Saturday 608 oo 4/12/20 Sunday 608 1 142120 Documentation Sales and Order Data Output + Ready Accessibility: Investigate + 66%AutoSave OFF HA PYC... Sales and Order - Student Data Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) 11 A A ab General Conditional Formatting Insert v Format as Table x Delete Paste B I U A % 9 Sort & Find & Analyze Sensitivity i Cell Styles v Format v Filter Select Data AF86 X V fx C D E F G H M N o P Q T U V W X Y Z AA AB AC AD AE AF AG 4/13/20 Monday 50 516 4/14/20 Tuesday 43 29 4/15/20 Wednesday 35 28 4/16/20 Thursday 41 29 o 4/17/20 Friday 52 40 16.8585 15.42455 11.14189 17.55564 15.75797 12.9694 17.10717 15.79639 16.27259 11.91865 11.50098 17.21019 12.37547 15.90831 13.99574 4/18/20 aturday 0 o 4/19/20 Sunday 0 4/20/20 Monday 44 40 4/21/20 Tuesday 43 28 4/22/20 Wednesday 37 27 Hi o o o o o o O O o o O O O O O O 4/23/20 Thursday 31 o 4/24/20 Friday 40 4/25/20 aturday 4/26/20 Sunday 4/27/20 Monday 47 38 0 4/28/20 Tuesday 24 4/29/20 Wednesday 28 4/30/20 Thursday 26 o 5/1/20 Friday 41 17.37467 16.52048 14.57715 12.0806 15.33166 12.18404 11.33066 13.49393 16.33797 12.86901 16.30441 13.63225 12.95004 11.85029 11.01466 5/2/20 saturday| 0 5/3/20 Sunday 0 5/4/20 Monday 43 5/5/20 Tuesday 28 5/6/20 Wednesday 28 5/7/20 Thursday 25 5/8/20 Friday 39 5/9/20 Saturday 0 5/10/20 Sunday 0 o 5/11/20 Monday 36 5/12/20 Tuesday 28 oo 5/13/20 Wednesday 28 5/14/20 Thursday 30 5/15/20 Friday 40 o o o o o o o o o o o o O V O O O O O O O O O O O O O 14.55906 16.28811 16.94564 12.05742 12.68317 13.35934 12.91579 14.91664 16.66684 15.94345 15.08567 13.75741 12.26416 12.51667 15.50362 5/16/20 aturday o 5/17/20 Sunday 0 5/18/20 Monday 36 ANA BOO 5/19/20 Tuesday 28 o 5/20/20 Wednesday 28 o 5/21/20 Thursday 29 5/22/20 Friday 39 5/23/20 aturday 0 5/24/20 Sunday a WOOK 0 o 5/25/20 Monday 41 5/26/20 Tuesday 30 5/27/20 Wednesday 39 27 346 ol 5/28/20 Thursday 37 27 282 5/29/20 Friday 50 40 192 15.20689 16.82533 13.06752 13.85978 16.78 13.53683 13.65976 13.40762 13.44888 14.8691 12.87358 15.91446 14.75939 11.49143 17.5656 5/30/20 saturday 0 942 5/31/20 Sunday 0 942 0 6/1/20 Monday 28 876 o o 6/2/20 Tuesday 17 826 6/3/20 Wednesday 21 781 o 6/4/20 Thursday 20 731 o oooOOO of 6/5/20 Friday 22 673 6/6/20 aturday 673 6/7/20 Sunday 673 Documentation Sales and Order Data Output + Ready Accessibility: Investigate + 66%AutoSave OFF HAPYC... Sales and Order - Student Data Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) 11 A A ab General Conditional Formatting v Insert v Format as Table v x Delete Paste B I U A % 9 Sort & Find & Analyze Sensitivity i Cell Styles v Format v Filter Select Data AF86 X V fx B C D E F G H K M N o P Q T U V w X Y 2 AA AB AC AD AE AF AG 6/8/20 Monday 24 615 6/9/20 Tuesday :/10/201 Wednesday 26 565 18 521 6/11/20 Thursday 21 165 6/12/20 Friday 25 6/13/20 aturday o 102 6/14/20 Sunday 0 /15/20 Monday 29 6/16/20 Tuesday 19 o 6/17/20 Wednesday 20 16.09082 15.64527 15.60834 15.64053 16.2371 16.13789 15.42695 15.10234 16.14803 16.38344 15.89825 14.85545 16.6982 14.35836 16.05527 5/18/20 Thursday 20 o 6/19/20 Friday 30 /20/20 Saturday 6/21/20 Sunday o 5/22/20 Monday 24 79: o 6/23/20 Tuesday 5/24/20 Wednesday 19 o /25/20 Thursday 21 6/26/20 Friday 27 6/27/20 saturday 6/28/20 Sunday 5/29/20 Monday 27 /30/20 Tuesday 17 7/1/20 Wednesday 14 7/21 20 Thursday 14 o 7/3/20 Friday 24 7/4/20 Saturday 7/5/20 Sunday 7/6/20 Monday 20 of 7/7/20 Tuesday 18 0 7/8/20 Wednesday 15 16.50887 16.97726 14.50214 15.9251 15.13262 16.09363 15.53101 14.9368 15.14574 14.624 14.81518 14.30446 14.68426 16.49619 14.72137 7/9/20 Thursday 16 o /10/20 Friday 23 o 7/11/20 aturday 0 o 7/12/20 Sunday 0 7/13/20 Monday 21 7/14/20 Tuesday 17 o /15/20 Wednesday 13 7/16/20 Thursday 17 709 7/17/20 Friday 21 o 7/18/20 aturday 7/19/20 Sunday 0 /20/20 Monday 21 7/21/20 uesday 17 7/22/20 Wednesday 11 526 o 7/23/20 Thursday 20 480 7/24/20 Friday 19 435 /25/20 Saturday 435 7/26/20 Sunday 435 7/27/20 Monday 19 389 7/28/20 Tuesday 21 347 7/29/20 Wednesday 13 310 /30/20 Thursday 21 265 0 7/31/20 Friday 18 213 13.98269 11.71978 12.80462 16.106 17.55013 16.48772 11.74037 14.03938 16.73103 11.44328 11.90689 15.48466 14.49197 17.72283 15.35532 8/1/20 Saturday 963 o 8/2/20 Sunday 963 o 9 /2 /20 01 1 Documentation Sales and Order Data Output + Ready Accessibility: Investigate + 66%AutoSave OFF Sales and Order - Student Data Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) 11 A A General Conditional Formatting v Insert v Format as Table x Delete Paste B I U A % 9 Sort & Find & Analyze Sensitivity i Cell Styles v Format v Filter Select Data AE972 X V fx C D E F G H I L M N Q R S T U V W X Y Z AA AB AC AD AE AF AG 8/3/20 Monday 21 911 8/4/20 Tuesday 864 8/5/20 Wednesday 28 8/6/20 Thursday 26 8/7/20 Friday 38 8/8/20 saturday 8/9/20 Sunday 8/10/20 Monday 36 25 8/11/20 Tuesday 19 8/12/20 Wednesday 8/13/20 Thursday 8/14/20 Friday 8/15/20 Saturday 8/16/20 Sunday o 8/17/20 Monday 8/18/20 Tuesday 27 8/19/20 Wednesday 26 8/20/20 Thursday 23 o 3/21/20 Friday 15.28501 17.12899 17.52967 13.61773 15.60794 12.96727 16.49718 14.87005 12.8175 11.49974 13.25016 11.9209 17.07493 14.75711 16.89481 8/22/20 Saturday 8/23/20 Sunday 8/24/20 Monday 8/25/20 Tuesday 3/26/20 Wednesday 8/27/20 Thursday 8/28/20 Friday o 8/29/20 saturday o 8/30/20 Sunday o 3/31/20 Monday o 9/1/20 Tuesday o 9/2/20 ed nesday o 9/3/20 Thursday 9/4/20 Friday 9/5/20 Saturday 9/6/20 Sunday /7/20 Monday 9/8/20 Tuesday 16.04562 15.12741 14.18225 16.41031 16.0101 14.32307 14.66047 16.44244 15.47173 14.79332 15.07643 15.02043 16.65967 15.33797 15.18657 9/9/20 Wednesday oo OOO NoOC 9/10/20 Thursday 9/11/20 Friday 9/12/20 saturday 9/13/20 Sunday 9/14/20 Monday o 9/15/20 Tuesday o 9/16/20 Wednesday 9/17/20 Thursday 9/18/20 Friday 9/19/20 Saturday 347 o 9/20/20 Sunday 347 9/21/20 Monday 269 o 9/22/20 Tuesday 201 750 16.5641 16.09513 15.91871 15.31298 15.12002 15.16006 14.42523 16.92307 16.53508 16.19108 15.32597 14.48397 14.86284 16.90325 16.24507 9/23/20 Wednesday ookwwgeo 887 o oo A WN YWO 9/24/20 Thursday 817 9/25/20 Friday 723 1001 9/26/20 Saturday 0 723 1002 9/27/20 Sunday 0 723 Documentation Sales and Order Data Output + Ready Accessibility: Investigate + 66%AutoSave .0\" Q E) '9 v G - 3. Sales and Order - Student Data Home Inse t Draw Page Layout Formulas Data Review View Q Tell me Calibri (Body) v 11 v A A ESE Conditional Formatting v E Insert v Z v 7 v v p y El v Z B}; Format as Table v E Delete v Sort81 Find 81 Analyze U A 7 B I " V E Cell Styles v @134 Format v 4/ v Filter Select Data 11/11/20 11/14/10 11/15/10 11/15/10 1414115 1550147 15151 1407511 1511014 1551755 155511 1590411 1401115 1457511 1111011 1414515 1471711 1411711 1511411 11/17/10 0 11/11/10 11/19/10 11/10/20 12/1/20 12/2/10 11/1/10 11/4/10 11/5/10 12/6/10 12/7/10 12/1/20 0 11/9/20 1451111 1511075 15.711115 1509717 1511554 1417091 14.171147 1570115 111171 1511114 15.41011 1451177 1515111 14517715 11.171517 Sales and Order Data Ready 7;)? Accessibility: Investigate AutoSave OFF Sales and Order - Student Data Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) 11 A A ab General Conditional Formatting v Insert v Paste Format as Table x Delete B I U A % 9 100 i Cell Styles v Sort & Find & Analyze Format v Sensitivity Filter Select Data AE972 X V fx C D E F G H L M N P Q R S T U V W AA AB AC 1003 X 9/28/20 Y Z AD AE AF AG Monday 9/29/20 46 Tuesday 39 9/30/20 Wednesday 32 10/1/20 Thursday 41 o 10/2/20 Friday 10/3/20 o Saturday 10/4/20 Sunday 10/5/20 Monday 10/6/20 Tuesday 10/7/20 Wednesday 14.88928 16.48334 14.63947 14.04098 14.4205 15.38046 16.01514 16.60995 14.80502 14.65093 15.94905 16.91053 15.32955 14.96346 14.54115 10/8/20 Thursday 10/9/20 Friday o 10/10/20 aturday o 10/11/20 Sunday o 10/12/20 Monday o 10/13/20 Tuesday 10/14/20 Wednesday 0/15/20 Thursday 10/16/20 Friday 10/17/20 aturday 10/18/20 Sunday o 10/19/20 Monday 10/20/20 Tuesday 15.18316 15.39642 15.4944 16.07865 15.60209 14.06373 16.55292 15.22545 15.80982 15.86589 15.78235 14.02599 15.92041 15.9774 15.14291 10/21/20 led nesday 10/22/20 Thursday o 10/23/20 Friday 0/24/20 saturday o o 0/25/20 Sunday o 10/26/20 Monday 10/27/20 Tuesday o 10/28/20 Wednesday 10/29/20 Thursday o o 10/30/20 Friday o 10/31/20 Saturday 11/1/20 Sunday 11/2/20 Monday 11/3/20 Tuesday o 14.21011 15.08303 15.99442 15.33192 15.66887 14.00869 14.70905 14.89 14.36841 15.97606 16.68352 16.45796 14.68985 15.53286 15.24849 11/4/20 Wednesday 11/5/20 Thursday o 11/6/20 Friday 11/7/20 Saturday 11/8/20 Sunday 11/9/20 Monday o 1/10/20 Tuesday o 11/11/20 Wednesday 11/12/20 Thursday o 11/13/20 Friday 1/14/20 aturday 16.65138 17.07643 17.57215 15.77315 17.45528 15.77195 12.92612 15.05148 12.10283 14.49077 14.09988 14.00798 15.94726 14.16982 16.99373 o 11/15/20 Sunday 0 11/16/20 Monday o 11/17/20 Tuesday 11/18/20 Wednesday 11/19/20 Thursday o 11/20/20 Friday 11/21/20 Saturday 1058 11/22/20 Sunday 0 Documentation Sales and Order Data Output Ready Accessibility: Investigate + 66%AutoSave OFF Sales and Order - Student Data Low Battery Home Insert Draw Page Layout Formulas Data Review View Tell me Your Mac will sleep soon unless plugged into a power outlet. X Calibri (Body) A A ab 11 General Conditional Formatting v Insert Format as Table v x Delete v Paste I U A % 9 Sort & Find & Analyze Sensitivity i Cell Styles v Format v Filter Select Data E8 X V fx A B C D E F G H K M N O P Q R S U V W Graphs Create your X-bar and R charts here. Scroll down to Row 38 to type your Recommendations. Complete Cause & Effect diagram at Row 54 D 00 Documentation Sales and Order Data Output + Ready Accessibility: Investigate + 100%