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.