Assignments

Send  to your instructor a single Excel file (including written answers) as e-mail an attachment through WebMail addressed to BA501@mail.cba.nau.edu and put BA501 (last name) Assignment name and number somewhere in the e-mail "subject" line. If you have any questions on this home work, please e-mail me with questions.    Here is the Excel file for this assignment.  There is an additional template to use and include with your assignment found below. Use "save as" to save it to your computer or to a floppy.

1. Use Pareto analysis to investigate the following data collected on a printed-circuit-board assembly line.

1. Prepare a graph of the data.
2. What conclusions do you recall?

2. Develop a Pareto analysis of the following causes of customer delay in a restaurant.

Reason for delay	Frequency
Host/Hostess not available	22
Table not ready	15
Server order error	40
Lack of kitchen personnel available	3
Cashier error	10
Entrée return	11

3. What are the three major components of TQM and briefly explain each.

4. Using Power Point, draw a fishbone chart detailing reasons why a typist you paid to prepare a term paper produced a document with numerous errors.

5. How does inspection contribute to the overall quality of a product/service?

6. Assume you own a micro-brewery, using QFD, create a relationship matrix for a light beer. Use this template for your answer and include it in the Excel file (above).