design of experiment six sigma spring 2024 homework 4 please submit yo
Search for question
Question
Design of Experiment:
Six Sigma Spring 2024 Homework 4
(please submit your homework to the Assignment Submission Folder
"Homework 4" in our course website on BrightSpace)
A sales organization wishes to improve its revenue. To do so they are considering the impact of
four factors; different sales people, sales person incentives, regional differences and
advertising / marketing effectiveness. Their plan is to run a full factorial experiment and vary
factors to determine their impact on monthly sales revenue. They will run a total of 16 runs
twice (32 months). Total revenue is then analyzed to determine the potential impact the changes
have on revenue. The experimental design layout is as follows:
Factor
Low
Level (-1)
High
Level (+1)
Level Description
Sales Person
Percentile
Sales
Person B
Incentive Plan Traditional
Enhanced
Sales
Person A
Region
North
South
Person A comes from a group that is in the top 10
percentile of the historically performing sales
people - Sales Person B comes from the bottom 10
percentile
The traditional incentive plan is the historical plan
deployed. The enhanced plan is a sliding scale
aimed at providing more incentive for high
performers
The region is the geographical distinction in where
the sales occur
Advertising
5%
10%
The advertising represents the percent of revenue
spent on advertising
+
C1
StdOrder RunOrder PtType
C2
C3
C4
Blocks
The uncoded and coded experiment designs are shown below:
C5-T
C6-T
C7-T
C8
Sales Person Incentive Plan Region Advertising Percent
67
34567890
1234567890123456
1
1
1
1B
Standard
North
5
2
2
1
1B
Standard
North
10
3
1
1B
Standard
South
5
4
1
1B
Standard
South
10
5
1
1B
Enhanced
North
5
1
1B
Enhanced
North
10
7
1
1 B
Enhanced
South
5
8
1
1 B
Enhanced
South
10
9
1
1 A
Standard
North
5
10
11
11
12
13
14
15
15
16
0123456
1
1A
Standard
North
10
1
1 A
Standard
South
5
1
1 A
Standard
South
10
1
1 A
Enhanced
North
5
1
1 A
Enhanced
North
10
1
1A
Enhanced
South
5
16
1
1A
Enhanced
South
10 C1
C2
C3
C4
C5-T
C6-T
C7-T
C8
StdOrder | RunOrder
PtType
Blocks
Sales Person Incentive Plan
Region
Advertising Percent
12
1
1
1
1-1
-1
-1
-1
2
2
2
1
1-1
-1
-1
1
3
3
3
1
1-1
-1
1
-1
4
4
4
1
1-1
-1
1
1
5
5
6
7
8
9
0123456
11
11
5678
678901
1
1-1
1
-1
-1
1
1-1
1
-1
1
1
1-1
1
1
-1
1
1-1
1
1
1
9
1
11
-1
-1
-1
10
11
11
1
11
-1
-1
1
1
11
-1
1
-1
12
12
1
11
-1
1
1
14
15
16
3456
13
1
11
1
-1
-1
14
1
11
1
-1
1
15
1
11
1
1
-1
16
1
11
1
1
1
The results of revenues are shown below: StdOrder RunOrder CenterPt Blocks
Sales Pers Incentive Region
Advertisin Results
1
1
1
1A
Standard North
5
$86,117.00
2
2
1
1B
Standard North
5 $65,109.00
3
3
1
1A
Enchanced North
5 $97,120.00
4
4
1
1B
Enchanced North
5 $68,930.00
5
5
1
1A
Standard South
5 $89,121.00
6
6
1
1B
Standard South
5 $83,460.00
7
7
1
1A
Enchanced South
5 $131,670.00|
8
8
1
1B
Enchance South
5 $119,001.00
9
9
1
1 A
Standard North
10 $121,091.00
10
10
1
1B
Standard North
10 $99,407.00
11
11
1
1A
Enchanced North
12
12
1
1B
Enchanced North
10 $123,378.00|
10 $119,872.00
13
13
1
1A
Standard South
10 $89,584.00|
14
14
1
1B
Standard South
10 $69,018.00
15
15
1
1A
Enchance South
10
$98,710.00
16
16
1
1B
Enchance South
10 $75,822.00
17
17
1
1 A
Standard North
5 $73,002.00
18
18
1
1B
Standard North
5 $62,010.00
19
19
1
1A
Enchanced North
5 $68,201.00|
20
20
1
1B
Enchanced North
5 $52,967.00
21
21
1
1A
Standard South
5 $100,921.00
22
22
1
1B
Standard South
5 $90,019.00
23
23
1
1A
Enchance South
5 $135,978.00
24
24
1
1B
Enchance South
5 $128,000.00|
25
25
1
1A
Standard North
10 $117,000.00
26
26
1
1B
Standard North
10 $109,213.00
27
27
1
1A
Enchance North
10 $149,021.00
28
28
1
1B
Enchance North
10 $138,650.00|
29
29
1
1A
Standard South
10 $78,904.00|
30
30
1
1B
Standard South
10 $69,690.00
31
31
1
1A
Enchance South
10 $86,540.00
32
32
1
1B
Enchance South
10 $79,059.00
(1) Use Minitab to generate the full factorial design of experiment
(2) Run analysis to identify the significant factors
(3) Create main effect and two way interaction plots