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