Assignment
1. Analyze the cost data in the Excel workbook Ch03Data.xlsx for the Costbusters Company. What percent of sales are represented by each category of cost for each product? What are the dollar costs for each cost of quality category, by product? How might this information be used to help define a Six Sigma project?
2. Prepare a pie chart showing the different quality cost categories and percentages for the Great Press Printing Company. See the data in the Excel workbook C03Data.xlsx. How might this information be used to help define a Six Sigma project?
3. Puragua Corporation makes water meters that are sold to contractors and municipal water departments. Analyze their quality costs, group them into the four standard quality cost categories, and prepare a Pareto chart showing the company's quality costs that were incurred over the past year (use data in the worksheet Prob03-04 in the Excel workbook Ch03Data.xlsx on the Student Companion website). How might this information be used to help define a Six Sigma project?
4. Cost of quality data are often expressed as indexes by dividing by some reference value, such as cost/sales dollar or cost/labor dollar. Compute a sales dollar base index for International Fabrica, Inc., to analyze the quality cost data in worksheet Prob.03-08 in the Excel workbook Ch03Data.xlsx on the Student Companion website and prepare a memo to management.
5. Cost of quality data are often expressed as indexes by dividing by some reference value, such as cost/sales dollar or cost/labor dollar. Compute a labor cost base index for Loire Valley Wine Co. from data in the worksheet Prob03-09 in the Excel workbook Ch03Data.xlsx on the Student Companion website, and prepare a memo to management.
Problem 1 has two graphs "Percent of Quality by Product" and "Quality Costs by Cost Category"
Problem 2 has one graph (pie chart) "Great Press Printing Company % Quality Costs"
Problem 3 has two graphs " Detail Pareto Chart" and "COQ - Pareto"
Problem 4 has one graph "Cost of Quality Index Graph"
Problem 5 has one graph "Cost of Quality"
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also include a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also Include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.
Attachment:- Ch03Data.rar