| Corporate Sales & Operations Dept. Data 2017 |
| Order | Dept | Area | Month | # of Employees | Labor Costs | # of Process Transactions | # Process Errors | Error Repair Cost | Utility Costs | Facility Costs | Supply Costs | Raw Material Costs | Shipping Costs | T & E | Revenue |
| 1 | 999 | Sales | 1 | 50 | 500,000.00 | 100 | 10 | 15,000.00 | 500.00 | 50,000.00 | 200.00 | 0.00 | 0.00 | 6,000.00 | 1,300,000.00 |
| 2 | 999 | Sales | 2 | 50 | 500,000.00 | 100 | 1 | 20,000.00 | 500.00 | 50,000.00 | 220.00 | 0.00 | 0.00 | 7,500.00 | 1,300,000.00 |
| 3 | 999 | Sales | 3 | 50 | 500,000.00 | 100 | 1 | 2,050.00 | 500.00 | 50,000.00 | 200.00 | 0.00 | 0.00 | 7,500.00 | 1,300,000.00 |
| 4 | 999 | Sales | 4 | 50 | 500,000.00 | 190 | 1 | 1,000.00 | 400.00 | 50,000.00 | 240.00 | 0.00 | 0.00 | 8,000.00 | 300,000.00 |
| 5 | 999 | Sales | 5 | 50 | 500,000.00 | 200 | 25 | 1,000,000.00 | 400.00 | 50,000.00 | 600.00 | 0.00 | 0.00 | 20,000.00 | 26.000.000.00 |
| 6 | 999 | Sales | 6 | 50 | 500,000.00 | 700 | 10 | 300.00 | 800.00 | 50,000.00 | 250.00 | 0.00 | 0.00 | 7,000.00 | 1,300,000.00 |
| 7 | 999 | Sales | 7 | 50 | 500,000.00 | 705 | 10 | 45,000.00 | 800.00 | 50,000.00 | 120.00 | 0.00 | 0.00 | 7,000.00 | 12,300,000.00 |
| 8 | 999 | Sales | 8 | 50 | 500,000.00 | 200 | 5 | 1,500.00 | 800.00 | 50,000.00 | 160.00 | 0.00 | 0.00 | 12,000.00 | 1,300,000.00 |
| 9 | 999 | Sales | 9 | 50 | 500,000.00 | 200 | 40 | 1,200.00 | 400.00 | 50,000.00 | 200.00 | 0.00 | 0.00 | 10,000.00 | 1,300,000.00 |
| 10 | 999 | Sales | 10 | 50 | 500,000.00 | 250 | 1 | 1,400.00 | 500.00 | 50,000.00 | 200.00 | 0.00 | 0.00 | 4,000.00 | 1,300,000.00 |
| 11 | 999 | Sales | 11 | 50 | 500,000.00 | 400 | 40 | 1,200,000.00 | 500.00 | 50,000.00 | 200.00 | 0.00 | 0.00 | 8,000.00 | 28,000,000.00 |
| 12 | 999 | Sales | 12 | 50 | 500,000.00 | 50 | 1 | 2,800.00 | 500.00 | 50,000.00 | 1,200.00 | 0.00 | 0.00 | 13,000.00 | 1,300,000.00 |
| 13 | 999 | Marketing | 1 | 60 | 240,000.00 | 1500 | 5 | 5,000.00 | 500.00 | 35,000.00 | 100.00 | 0.00 | 0.00 | 4,000.00 | 1,200,000.00 |
| 14 | 999 | Marketing | 2 | 60 | 240,000.00 | 1500 | 5 | 5,000.00 | 500.00 | 35,000.00 | 100.00 | 0.00 | 0.00 | 6,000.00 | 1,200,000.00 |
| 15 | 999 | Marketing | 3 | 60 | 240,000.00 | 1500 | 5 | 5,000.00 | 500.00 | 35,000.00 | 100.00 | 0.00 | 0.00 | 6,500.00 | 1,200,000.00 |
| 16 | 999 | Marketing | 4 | 60 | 240,000.00 | 1500 | 5 | 5,000.00 | 400.00 | 35,000.00 | 100.00 | 0.00 | 0.00 | 8,000.00 | 1,200,000.00 |
| 17 | 999 | Marketing | 5 | 60 | 240,000.00 | 1500 | 5 | 5,000.00 | 400.00 | 35,000.00 | 100.00 | 0.00 | 0.00 | 22,000.00 | 1,200,000.00 |
| 18 | 999 | Marketing | 6 | 60 | 240,000.00 | 1500 | 5 | 5,000.00 | 800.00 | 35,000.00 | 100.00 | 0.00 | 0.00 | 6,500.00 | 1,200,000.00 |
| 19 | 999 | Marketing | 7 | 60 | 240,000.00 | 1500 | 5 | 5,000.00 | 800.00 | 35,000.00 | 100.00 | 0.00 | 0.00 | 6,525.00 | 1,200,000.00 |
| 20 | 999 | Marketing | 8 | 60 | 240,000.00 | 1500 | 5 | 5,000.00 | 800.00 | 35,000.00 | 100.00 | 0.00 | 0.00 | 11,000.00 | 1,200,000.00 |
| 21 | 999 | Marketing | 9 | 60 | 240,000.00 | 1500 | 5 | 5,000.00 | 400.00 | 35,000.00 | 100.00 | 0.00 | 0.00 | 10,000.00 | 1,200,000.00 |
| 22 | 999 | Marketing | 10 | 60 | 240,000.00 | 1500 | 5 | 5,000.00 | 500.00 | 35,000.00 | 100.00 | 0.00 | 0.00 | 11,000.00 | 1,200,000.00 |
| 23 | 999 | Marketing | 11 | 60 | 240,000.00 | 1500 | 5 | 5,000.00 | 500.00 | 35,000.00 | 100.00 | 0.00 | 0.00 | 20,000.00 | 1,200,000.00 |
| 24 | 999 | Marketing | 12 | 60 | 240,000.00 | 1500 | 5 | 5,000.00 | 500.00 | 35,000.00 | 100.00 | 0.00 | 0.00 | 12,000.00 | 1,200,000.00 |
| 25 | 999 | Product Mgmt | 1 | 55 | 275,000.00 | 2000 | 0 | 0.00 | 500.00 | 40,000.00 | 100.00 | 0.00 | 0.00 | 1,500.00 | 1,500,000.00 |
| 26 | 999 | Product Mgmt | 2 | 55 | 275,000.00 | 2500 | 0 | 0.00 | 500.00 | 40,000.00 | 100.00 | 0.00 | 0.00 | 1,200.00 | 1,500,000.00 |
| 27 | 999 | Product Mgmt | 3 | 55 | 275,000.00 | 2000 | 0 | 0.00 | 500.00 | 40,000.00 | 100.00 | 0.00 | 0.00 | 1,000.00 | 1,500,000.00 |
| 28 | 999 | Product Mgmt | 4 | 55 | 275,000.00 | 3000 | 0 | 0.00 | 400.00 | 40,000.00 | 100.00 | 0.00 | 0.00 | 17,000.00 | 1,500,000.00 |
| 29 | 999 | Product Mgmt | 5 | 55 | 275,000.00 | 4000 | 0 | 0.00 | 400.00 | 40,000.00 | 100.00 | 0.00 | 0.00 | 2,000.00 | 1,500,000.00 |
| 30 | 999 | Product Mgmt | 6 | 55 | 275,000.00 | 3000 | 8 | 40.00 | 800.00 | 40,000.00 | 100.00 | 0.00 | 0.00 | 4,000.00 | 1,500,000.00 |
| 31 | 999 | Product Mgmt | 7 | 55 | 275,000.00 | 2800 | 7 | 35.00 | 800.00 | 40,000.00 | 100.00 | 0.00 | 0.00 | 3,000.00 | 1,500,000.00 |
| 32 | 999 | Product Mgmt | 8 | 55 | 275,000.00 | 2900 | 10 | 50.00 | 800.00 | 40,000.00 | 100.00 | 0.00 | 0.00 | 1,000.00 | 1,500,000.00 |
| 33 | 999 | Product Mgmt | 9 | 55 | 275,000.00 | 3000 | 0 | 0.00 | 400.00 | 40,000.00 | 100.00 | 0.00 | 0.00 | 1,000.00 | 1,500,000.00 |
| 34 | 999 | Product Mgmt | 10 | 55 | 275,000.00 | 3100 | 0 | 0.00 | 500.00 | 40,000.00 | 100.00 | 0.00 | 0.00 | 1,000.00 | 1,500,000.00 |
| 35 | 999 | Product Mgmt | 11 | 55 | 275,000.00 | 2000 | 10 | 50.00 | 500.00 | 40,000.00 | 100.00 | 0.00 | 0.00 | 1,000.00 | 1,500,000.00 |
| 36 | 999 | Product Mgmt | 12 | 55 | 275,000.00 | 1000 | 10 | 50.00 | 500.00 | 40,000.00 | 100.00 | 0.00 | 0.00 | 1,900.00 | 1,500,000.00 |
| 37 | 999 | Order Process | 1 | 40 | 180,000.00 | 150,000 | 5 | 10.00 | 500.00 | 20,000.00 | 100.00 | 20,000.00 | 120.00 | 500.00 | 0.00 |
| 38 | 999 | Order Process | 2 | 40 | 180,000.00 | 165,000 | 4 | 8.00 | 500.00 | 20,000.00 | 100.00 | 21,000.00 | 120.00 | 500.00 | 0.00 |
| 39 | 999 | Order Process | 3 | 40 | 180,000.00 | 180,000 | 0 | 0.00 | 500.00 | 20,000.00 | 100.00 | 21,000.00 | 120.00 | 500.00 | 0.00 |
| 40 | 999 | Order Process | 4 | 40 | 180,000.00 | 185,000 | 0 | 0.00 | 400.00 | 20,000.00 | 100.00 | 22,000.00 | 120.00 | 500.00 | 0.00 |
| 41 | 999 | Order Process | 5 | 40 | 180,000.00 | 190,000 | 0 | 0.00 | 400.00 | 20,000.00 | 100.00 | 22,000.00 | 120.00 | 500.00 | 0.00 |
| 42 | 999 | Order Process | 6 | 40 | 180,000.00 | 200,000 | 0 | 0.00 | 800.00 | 20,000.00 | 100.00 | 15,000.00 | 120.00 | 500.00 | 0.00 |
| 43 | 999 | Order Process | 7 | 40 | 180,000.00 | 210,000 | 0 | 0.00 | 800.00 | 20,000.00 | 100.00 | 15,000.00 | 120.00 | 500.00 | 0.00 |
| 44 | 999 | Order Process | 8 | 40 | 180,000.00 | 180,000 | 0 | 0.00 | 800.00 | 20,000.00 | 100.00 | 21,000.00 | 120.00 | 500.00 | 0.00 |
| 45 | 999 | Order Process | 9 | 40 | 180,000.00 | 190,000 | 0 | 0.00 | 400.00 | 20,000.00 | 100.00 | 22,000.00 | 120.00 | 500.00 | 0.00 |
| 46 | 999 | Order Process | 10 | 40 | 180,000.00 | 200,000 | 7 | 14.00 | 500.00 | 20,000.00 | 100.00 | 15,000.00 | 120.00 | 500.00 | 0.00 |
| 47 | 999 | Order Process | 11 | 40 | 180,000.00 | 210,000 | 6 | 12.00 | 500.00 | 20,000.00 | 100.00 | 15,000.00 | 120.00 | 500.00 | 0.00 |
| 48 | 999 | Order Process | 12 | 40 | 180,000.00 | 220,000 | 5 | 10.00 | 500.00 | 20,000.00 | 100.00 | 15,000.00 | 120.00 | 500.00 | 0.00 |
| 49 | 999 | Trans. Process | 1 | 30 | 120,000.00 | 300,000 | 0 | 0.00 | 500.00 | 20,000.00 | 70.00 | 15,000.00 | 120.00 | 500.00 | 0.00 |
| 50 | 999 | Trans. Process | 2 | 30 | 120,000.00 | 300,000 | 0 | 0.00 | 500.00 | 20,000.00 | 70.00 | 15,000.00 | 120.00 | 500.00 | 0.00 |
| 51 | 999 | Trans. Process | 3 | 30 | 120,000.00 | 320,000 | 0 | 0.00 | 500.00 | 20,000.00 | 70.00 | 15,000.00 | 120.00 | 500.00 | 0.00 |
| 52 | 999 | Trans. Process | 4 | 30 | 120,000.00 | 310,000 | 0 | 0.00 | 400.00 | 20,000.00 | 70.00 | 15,000.00 | 120.00 | 500.00 | 0.00 |
| 53 | 999 | Trans. Process | 5 | 30 | 120,000.00 | 280,000 | 0 | 0.00 | 400.00 | 20,000.00 | 70.00 | 15,000.00 | 120.00 | 500.00 | 0.00 |
| 54 | 999 | Trans. Process | 6 | 30 | 120,000.00 | 500,000 | 0 | 0.00 | 800.00 | 20,000.00 | 70.00 | 15,000.00 | 120.00 | 500.00 | 0.00 |
| 55 | 999 | Trans. Process | 7 | 30 | 120,000.00 | 480,000 | 0 | 0.00 | 800.00 | 20,000.00 | 70.00 | 15,000.00 | 120.00 | 500.00 | 0.00 |
| 56 | 999 | Trans. Process | 8 | 30 | 120,000.00 | 400,000 | 0 | 0.00 | 800.00 | 20,000.00 | 70.00 | 15,000.00 | 120.00 | 500.00 | 0.00 |
| 57 | 999 | Trans. Process | 9 | 30 | 120,000.00 | 300,000 | 0 | 0.00 | 400.00 | 20,000.00 | 70.00 | 15,000.00 | 120.00 | 500.00 | 0.00 |
| 58 | 999 | Trans. Process | 10 | 30 | 120,000.00 | 350,000 | 0 | 0.00 | 500.00 | 20,000.00 | 70.00 | 15,000.00 | 120.00 | 500.00 | 0.00 |
| 59 | 999 | Trans. Process | 11 | 30 | 120,000.00 | 500,000 | 0 | 0.00 | 500.00 | 20,000.00 | 70.00 | 15,000.00 | 120.00 | 500.00 | 0.00 |
| 60 | 999 | Trans. Process | 12 | 30 | 120,000.00 | 200,000 | 0 | 0.00 | 500.00 | 20,000.00 | 70.00 | 15,000.00 | 120.00 | 500.00 | 0.00 |
| Assumptions About the Data and Work Functions | | | | | | | | | Areas |
| | | | | | | | | | Sales |
| 1. Sales, Marketing and Product Areas - Employees primarily have offices on higher floors in the building | | | | | | | | | Marketing |
| 2. Processing Areas work on the open floors - lower in the building where there is lower rent | | | | | | | | | Product Management |
| 3. Thinking like a true Six Sigma person, identify the % of errors and what could be possible causes of the errors | | | | | | | | | Order Processing |
| 4. Your Management would like to see pictures, graphs, trends and explanations for your choices | | | | | | | | | Transaction Processing |
| 5. Think about the types of errors that might occur in certain areas and why are some more costly |
| 6. What is your Hypothesis - Just by eyeballing the data? |
| 7. Accept or Reject Hypothesis based on data |
| 8. All areas above are in the same department but the areas have distinct functions. Some have Profit Centers and others have just Cost Centers. What does that mean? |
| 9. Consider the monthly salary per employee |
jugxyaev
CopyofCTU_BADA_Dataset.xlsx
