关键词 > Excel代写

Improve Phase for the MSD Purchasing Case Study

发布时间：2023-07-03

Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

Improve Phase for the MSD Purchasing Case Study

After the Analyze phase of the MSD quality project, the team determined to focus on the effect of X₁ (vendor), X₂ (size), and X₃ (ridges), and their interactions, on the durability, while X₇ and the functionality would be the focus of a separate project. As such, they conducted an experimental design with the experiment results shown in Table 1 below.

Table 1. Experimental Design Data

Run Order	Vendor	Size	Ridges	Durability
1	Ibix	Small	Without	1
2	Ibix	Large	Without	9
3	Office Optimum	Large	Without	1
4	Ibix	Large	With	11
5	Office Optimum	Small	With	10
6	Ibix	Small	With	4
7	Office Optimum	Large	With	4
8	Office Optimum	Small	Without	10
9	Ibix	Large	With	9
10	Ibix	Small	Without	3
11	Ibix	Large	Without	9
12	Ibix	Small	With	3
13	Office Optimum	Small	With	9
14	Office Optimum	Large	Without	2
15	Office Optimum	Small	Without	8
16	Office Optimum	Large	With	2

The team further conducted a pilot test using the revised purchasing process, focusing on the durability CTQ with the data shown in Table 2 below. The two data points in the same hour of the same shift were collected independently (without grouping).

Table 2. Pilot Test Data

Hour	Vendor	Size	Ridges	Durability
Shift 1, Hour 1	Office Optimum	Small	With	10
Shift 1, Hour 1	Ibix	Large	With	11
Shift 1, Hour 2	Office Optimum	Small	With	7
Shift 1, Hour 2	Ibix	Large	With	11
Shift 1, Hour 3	Office Optimum	Small	With	10
Shift 1, Hour 3	Ibix	Large	With	11
Shift 1, Hour 4	Office Optimum	Small	With	8
Shift 1, Hour 4	Ibix	Large	With	11
Shift 1, Hour 5	Office Optimum	Small	With	9
Shift 1, Hour 5	Ibix	Large	With	10
Shift 1, Hour 6	Office Optimum	Small	With	9
Shift 1, Hour 6	Ibix	Large	With	9
Shift 1, Hour 7	Office Optimum	Small	With	8
Shift 1, Hour 7	Ibix	Large	With	11
Shift 1, Hour 8	Office Optimum	Small	With	9
Shift 1, Hour 8	Ibix	Large	With	10
Shift 2, Hour 1	Office Optimum	Small	With	9
Shift 2, Hour 1	Ibix	Large	With	11
Shift 2, Hour 2	Office Optimum	Small	With	8
Shift 2, Hour 2	Ibix	Large	With	10
Shift 2, Hour 3	Office Optimum	Small	With	10
Shift 2, Hour 3	Ibix	Large	With	9
Shift 2, Hour 4	Office Optimum	Small	With	7
Shift 2, Hour 4	Ibix	Large	With	9
Shift 2, Hour 5	Office Optimum	Small	With	7
Shift 2, Hour 5