OTM 300 Individual Assignment #1
Buckingham Chocolates
Due on Sunday, March 16th, by 11:59 PM
Learning Objectives: The objectives of this assignment are for students to be able to:
· Describe variability statistically
· Implement and interpret statistical process control charts
· Recognize and interpret common quality-related terms used in practice
· Be more confident and experienced with analyzing data using Microsoft Excel
The Setting: Buckingham Chocolates is a mid-sized regional producer of chocolate candy bars. They produce a variety of sizes and flavors, and each order is filled to customer specifications. For this assignment, you will be given an excel file containing the required data and assignment questions.
The Assignment: There are six pages in the excel assignment file. The first page gives an overview of the chocolate production process, including a link to a short video. On page two you will assess yield rates for each stage of the production process, as well as for the process overall, and will construct a p chart for statistical process control. On the third and fourth pages you are given additional data and will assess the impact of two input factors on the output of the process. Page five returns to the data on yield rates, and you will be required to construct a histogram for the overall process yield rate data. Finally, on page six, you will use data on the weights of chocolate bars to measure process capability. It may be helpful to reference the following materials for any questions you may have:
· Lecture videos and slides
· Practice problems
· Chapters 5 and 9 from our text
· Internet search engines
· If you still have questions, please contact the instructor or one of the TAs
All answers should be provided in the yellow spaces indicated on the spreadsheet. As indicated there, some answer boxes should contain numbers and others require a short explanation. For those cells requiring numbers, use a formula or function to obtain the answer. If you are copying a number from another cell where the value was calculated, then reference the source cell in the new cell. You should never just type a number in a cell when completing this assignment. By clicking on the cell, we will then be able to see how the number was calculated.
Showing your work: Remember this is an individual assignment, and we encourage you to use this assignment to improve your proficiency using Excel. As you complete your assignment, please:
1. Do not calculate numbers by hand, you should be using Excel functions and formulas.
2. Make your Excel document such that everything will update automatically if one were to change a data-point. (This should be the case if you are using Excel functions and formulas correctly). This is good practice, as in business you want to be able to change/update data without having to redo all your analyses.
3. Do not add columns or rows to your spreadsheet, and be sure to put answers in the cells indicated. This assignment will be, in part, graded using a computer program and if you have the correct answer in the wrong cell it will be marked wrong.
Getting Your Assignment File: In Canvas, click on the Modules tab and then click on "Analytics #1 Buckingham Chocolates." Download the file version indicated based on your campus identification number.
Submitting Your Assignment
In Canvas, click on the Modules tab and then click on "Analytics #1 Buckingham Chocolates." You can upload your file here through the submission link provided. The file you submit must be an Excel file (.xls or .xlsx).