Question

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 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

0 0
Add a comment Improve this question Transcribed image text
Answer #1

he plansaverage age in year, e in fear and weathe lala4hat coe need to huuld mode is the deher denl- Jarfa bes eoithựdeperdechecK -he sela onship blo tohich rmooot effedt plant moded 2386 and echen Dyodud- he role moduLe Hơn then 3o ateraugerodudionOutput 3200 3100 3000 2900 2800 2700 2600 2500 2400 2300 2200 2100 2000 1900 Output y 12.90x101.5 R2 0.709 147 157 167177 187can be achelted (r) bet Inereasirg numbej plant- age and poducirg modu achteued L*pyeas, decnaplant age and dala set

Add a comment
Know the answer?
Add Answer to:
Ken Wilson had done it all at Wilson Manufacturing, a company founded by his grandfather 63...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 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...

    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...

    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...

    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....

    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...

    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,...

    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...

    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...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT