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 an 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.50oz. They have also established an average range of 2.50oz with upper and lower control limits of 4.00oz and 1.00oz 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). 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 across all trucks "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. These only occur when an order is placed. "Output" Sheet - 1. Post both your X-bar and R-charts in the "Graphs" box posed from Row 1 - Row 36. There must be 2 graphs. 2. 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. a. Manpower: P52:P53 b. Material: P56:P57 c. Machinery: P60:P61 d. Methods: P64:P65 3. Give your Observation and Recommendation in the merged cells A39:X44, You must have information in all the Output sheet places listed above AND the Documentation sheet must be filled out. If you do not, no credit will be given. 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 an 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.50oz. They have also established an average range of 2.50oz with upper and lower control limits of 4.00oz and 1.00oz 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). 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 across all trucks "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. These only occur when an order is placed. "Output" Sheet - 1. Post both your X-bar and R-charts in the "Graphs" box posed from Row 1 - Row 36. There must be 2 graphs. 2. 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. a. Manpower: P52:P53 b. Material: P56:P57 c. Machinery: P60:P61 d. Methods: P64:P65 3. Give your Observation and Recommendation in the merged cells A39:X44, You must have information in all the Output sheet places listed above AND the Documentation sheet must be filled out. If you do not, no credit will be given