Ken Wilson had done it all at Wilson Manufacturing, a company founded by his grandfather 63 years ago. Among his many duties, Ken oversaw all the plant’s operations, a task that had grown in responsibility given the company’s rapid growth over the past three decades. When Ken’s grandfather founded the company, there were only two manufacturing sites. Expansion and acquisition of competitors over the years had caused that number to grow to over 50 manufacturing plants in 18 states.
Wilson Manufacturing had a simple process the produced only two products, but the demand for these products was strong and Ken had spent millions of dollars upgrading his facilities over the past decade. Consequently, most of the company’s equipment was less than 10 years old on average. Wilson’s two products were produced for local markets, as prohibitive shipping costs prevented shipping the product long distances. Product demand was sufficiently strong to support two manufacturing shifts (day and night) at every plant, and every plant had the capability to produce both products sold by Wilson. Recently, the management team at Wilson noticed that there were differences in output levels across the various plants. They were uncertain what, if anything, might explain these differences. Clearly, if some plants were more productive than other, there might be some meaningful insights that could be standardized across plants to boost overall productivity.
Ken Wilson asks your team, an industrial engineering group at the company’s headquarters, to conduct a study of the plant’s productivity. You randomly sampled 159 weeks of output from various plants together with the number of plant employees working that week, the plants’ average age in years, the product mix produced that week (either product A or B), and whether the output was from the day or night shift. The sampled data are contained in the file Case Study 1 Wilson Manufacturing. The Wilson management team is expecting a written report and a presentation by you when it meets again next week.
| Output | Number of Employees | Avg Age of Plant (Years) | Product Mix (A or B) | Shift (Day or Night ) |
| 2876 | 248 | 2 | B | Night |
| 2928 | 233 | 5 | A | Day |
| 2451 | 104 | 3 | B | Night |
| 2458 | 179 | 11 | A | Day |
| 2266 | 153 | 10 | A | Day |
| 2674 | 132 | 10 | B | Night |
| 2119 | 228 | 12 | A | Day |
| 2789 | 144 | 2 | A | Day |
| 2842 | 246 | 3 | A | Day |
| 2693 | 216 | 1 | A | Day |
| 2167 | 124 | 11 | A | Day |
| 2120 | 214 | 12 | B | Night |
| 2814 | 216 | 10 | A | Day |
| 2572 | 191 | 7 | A | Day |
| 2883 | 122 | 6 | A | Day |
| 2054 | 201 | 12 | B | Night |
| 2631 | 196 | 6 | B | Night |
| 2493 | 104 | 8 | A | Day |
| 2935 | 184 | 2 | A | Day |
| 3026 | 249 | 5 | B | Night |
| 2236 | 137 | 3 | A | Day |
| 2503 | 211 | 8 | B | Night |
| 2121 | 156 | 10 | A | Day |
| 2375 | 233 | 13 | B | Day |
| 2725 | 226 | 10 | A | Day |
| 2190 | 229 | 9 | A | Day |
| 2890 | 107 | 4 | A | Day |
| 2829 | 150 | 7 | A | Day |
| 2685 | 245 | 9 | A | Day |
| 2526 | 172 | 7 | A | Day |
| 2567 | 196 | 3 | A | Day |
| 2169 | 153 | 12 | A | Day |
| 2147 | 183 | 3 | A | Day |
| 2757 | 232 | 2 | A | Day |
| 2853 | 132 | 9 | B | Night |
| 2599 | 222 | 3 | B | Night |
| 2473 | 123 | 9 | A | Night |
| 2329 | 220 | 4 | B | Night |
| 2243 | 102 | 6 | B | Night |
| 2076 | 144 | 2 | B | Night |
| 2326 | 217 | 7 | B | Night |
| 2953 | 145 | 9 | A | Day |
| 2783 | 204 | 12 | A | Day |
| 2135 | 101 | 7 | A | Day |
| 2811 | 164 | 8 | A | Day |
| 2523 | 237 | 3 | B | Night |
| 2322 | 203 | 6 | A | Day |
| 1936 | 117 | 7 | A | Night |
| 2330 | 181 | 2 | B | Night |
| 2967 | 198 | 6 | A | Day |
| 2610 | 223 | 7 | B | Night |
| 2340 | 134 | 2 | A | Day |
| 2886 | 127 | 12 | A | Day |
| 2540 | 163 | 5 | A | Day |
| 2942 | 204 | 1 | A | Day |
| 2560 | 103 | 13 | A | Day |
| 1871 | 137 | 13 | A | Night |
| 2491 | 181 | 7 | B | Night |
| 2446 | 174 | 4 | A | Day |
| 2070 | 232 | 11 | A | Day |
| 2210 | 135 | 11 | B | Night |
| 2960 | 123 | 8 | A | Day |
| 2121 | 170 | 10 | A | Day |
| 2865 | 113 | 3 | B | Night |
| 2631 | 114 | 2 | B | Night |
| 2552 | 113 | 5 | A | Day |
| 2728 | 227 | 7 | A | Day |
| 2145 | 114 | 12 | A | Day |
| 2067 | 210 | 6 | A | Day |
| 2328 | 192 | 11 | A | Day |
| 2681 | 119 | 7 | A | Day |
| 2282 | 122 | 9 | B | Day |
| 2655 | 168 | 1 | B | Night |
| 2061 | 116 | 7 | A | Day |
| 2256 | 244 | 11 | A | Night |
| 2036 | 136 | 12 | A | Day |
| 2530 | 198 | 9 | A | Day |
| 2049 | 120 | 4 | B | Night |
| 2080 | 105 | 2 | A | Night |
| 1941 | 212 | 12 | A | Night |
| 2878 | 106 | 7 | A | Day |
| 2340 | 193 | 2 | A | Day |
| 2520 | 134 | 11 | B | Night |
| 2022 | 225 | 3 | A | Day |
| 2406 | 143 | 11 | B | Night |
| 2839 | 113 | 12 | A | Day |
| 2916 | 217 | 12 | B | Night |
| 2227 | 209 | 3 | A | Day |
| 2671 | 141 | 8 | B | Night |
| 2081 | 155 | 9 | A | Day |
| 2513 | 185 | 5 | A | Day |
| 2664 | 231 | 13 | A | Day |
| 2525 | 213 | 8 | A | Day |
| 2532 | 155 | 11 | B | Night |
| 2524 | 177 | 8 | B | Night |
| 2385 | 184 | 5 | A | Day |
| 2033 | 142 | 12 | B | Night |
| 2253 | 201 | 10 | B | Night |
| 2187 | 221 | 10 | B | Night |
| 2268 | 239 | 6 | B | Night |
| 2691 | 135 | 2 | B | Night |
| 2341 | 110 | 5 | A | Day |
| 2218 | 124 | 1 | A | Night |
| 2155 | 162 | 1 | A | Day |
| 2407 | 136 | 1 | B | Night |
| 2179 | 181 | 12 | A | Day |
| 2321 | 149 | 6 | B | Night |
| 2605 | 243 | 11 | B | Night |
| 2548 | 232 | 5 | B | Night |
| 2410 | 144 | 7 | A | Day |
| 2182 | 161 | 10 | A | Day |
| 2197 | 112 | 11 | A | Night |
| 2591 | 214 | 9 | A | Day |
| 2674 | 167 | 11 | B | Night |
| 2210 | 162 | 1 | A | Day |
| 2104 | 230 | 3 | B | Night |
| 2273 | 250 | 11 | A | Day |
| 1913 | 243 | 4 | A | Night |
| 2936 | 102 | 1 | B | Night |
| 2244 | 125 | 5 | A | Day |
| 2497 | 116 | 13 | A | Day |
| 2268 | 136 | 10 | B | Night |
| 2726 | 217 | 4 | A | Day |
| 2314 | 136 | 4 | A | Day |
| 2493 | 161 | 12 | A | Day |
| 2488 | 107 | 7 | A | Day |
| 2737 | 162 | 6 | B | Night |
| 2057 | 137 | 12 | A | Night |
| 2825 | 160 | 12 | B | Night |
| 2370 | 113 | 6 | A | Day |
| 2698 | 109 | 2 | A | Day |
| 2632 | 108 | 4 | B | Night |
| 2423 | 246 | 10 | A | Day |
| 2578 | 225 | 3 | A | Day |
| 2095 | 235 | 13 | A | Day |
| 2046 | 128 | 4 | B | Night |
| 2787 | 130 | 9 | A | Day |
| 2475 | 200 | 13 | A | Day |
| 2809 | 214 | 5 | B | Night |
| 2062 | 224 | 2 | A | Day |
| 2727 | 152 | 9 | A | Day |
| 2833 | 130 | 8 | A | Day |
| 2694 | 250 | 13 | A | Day |
| 2804 | 239 | 1 | B | Night |
| 2297 | 242 | 5 | A | Day |
| 2449 | 226 | 5 | B | Night |
| 2809 | 198 | 2 | A | Day |
| 2123 | 199 | 4 | A | Day |
| 2361 | 187 | 6 | A | Day |
| 2899 | 223 | 9 | B | Night |
| 2039 | 146 | 2 | A | Day |
| 2394 | 194 | 5 | A | Day |
| 2687 | 203 | 7 | B | Night |
| 2344 | 223 | 12 | A | Day |
| 2879 | 141 | 3 | A | Day |
| 2983 | 213 | 2 | B | Night |
| 3126 | 200 | 4 | B | Day |
| 2385 | 115 | 5 | A | Day |
| 2620 | 145 | 3 | A | Day |
1. Identify the primary issue of the case
2. Analyze the data
3. Draw your conclusions




Ken Wilson had done it all at Wilson Manufacturing, a company founded by his grandfather 63...
Ken Wilson had done it all at Wilson Manufacturing, a company founded by his grandfather 63 years ago. Among his many duties, Ken oversaw all the plant’s operations, a task that had grown in responsibility given the company’s rapid growth over the past three decades. When Ken’s grandfather founded the company, there were only two manufacturing sites. Expansion and acquisition of competitors over the years had caused that number to grow to over 50 manufacturing plants in 18 states. Wilson...
The manager of a travel agency has been using a seasonally adjusted forecast to predict demand for packaged tours. the actual and predicted values are as follows: Period Demand Predicted 1 124 113 2 184 200 3 144 150 4 79 102 5 74 80 6 119 135 7 114 128 8 141 124 9 106 109 10 161 150 11 116 94 12 101 80 13 136 140 14 146 128 a) Compute MAD for the fifth period, then...
A manufacturing company makes drawers for commercial tool cabinets. To assess the quality of the manufacturing process, the company collected one sample of 200 consecutively manufactured drawers each day for 10 days and counted the number of defective items. The resulting sample data are: Sample: Sample Size: 200 200 200 200 200 200 200 200 200 200 Defectives: 8 6 11 15 12 11 9 6 5 4 1 2 3 4 5 6 7 8 9 10 The proportion...
A manufacturing company makes drawers for commercial tool cabinets. To assess the quality of the manufacturing process, the company collected one sample of 200 consecutively manufactured drawers each day for 10 days and counted the number of defective items. The resulting sample data are Sample Sample Size: 200 200 200 200 200 200 200 200 200 200 Defectives: 8 6 11 15 12 11 9 6 5 4 1 2 3 4 5 6 7 8 9 10 The value...
1. Ford Manufacturing Company incurs the following manufacturing costs and expenses during the month of May. (12 pts) 1. Assembly line wages 2. Raw materials used directly in product 3. Depreciation on office equipment 4. Property taxes on factory building 5. Rent on factory building 6. Sales commissions 7. Depreciation on factory equipment 8. Factory utilities 9. Wages for factory maintenance workers 10. Advertising 11. Indirect materials used in production 12. ...
QUESTION 24 A manufacturing company makes drawers for commercial tool cabinets. To assess the quality of the manufacturing process, the company collected one sample of 200 consecutively manufactured drawers each day for 10 days and counted the number of defective items. The resulting sample data are: Sample Sample Size: 200 200 200 200 200 200 200 200 200 200 Defectives: 8 6 11 15 12 11 9 6 5 4 The Upper Control Limit, UCL, for a p control chart...
What is the height of the node that contains 10 in the tree below? A. 8, 13, 4, 2, 5, 14, 9, 1, 10, 15, 6, 3, 11, 7, 12 B. 1, 2, 4, 8, 13, 5, 9, 14, 3, 6, 10, 15, 7, 11, 12 C. 13, 8, 4, 14, 9, 5, 2, 15, 10, 6, 11, 12, 7, 3, 1 D. 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15
Ken is 63 years old and unmarried. He retired at age 55 when he sold his business, Understock.com. Though Ken is retired, he is still very active. Ken reported the following financial information this year. Assume Ken files as a single taxpayer. 1. Ken won $1,200 in an illegal game of poker (the game was played in Utah, where gambling is illegal). 2. Ken sold 1,000 shares of stock for $32 a share. He inherited the stock two years ago....
The manager of a travel agency has been using a seasonally adjusted forecast to predict demand for packaged tours. The actual and predicted values are as follows: Period Demand Predicted 1 123 113 2 183 200 3 143 150 4 78 102 5 73 80 6 118 135 7 113 128 8 142 124 9 107 109 10 162 150 11 117 94 12 102 80 13 137 140 14 147 128 a. Compute MAD for the fifth period, then...