You are the Operations Manager for a trailer
manufacturing company
On the Plant Information tab you have the production results from 2
manufacturing plants that belong to your company
The two plants make the same trailers and have very similar people
and processes, but the number of trailers they produce each day is
not the same
The company President has told you that she is worried about
production. She gives you no other details about what "worried"
means
You decide that you need to prove to the President that you are
adding value to the company by addressing her "worries"
Your task:
Develop a Word document report that specifically addresses the
following question: Which plant she should focus improvement
efforts on, and why?
To develop your recommendation you need to perform at least the
following analysis: Calculate the following and use results to make
recommendations Mean Median Mode Standard Deviation
The Final report should have the following sections: Title
page
Problem statement - This should be one sentence, but make it a good
one
Methodology - this will be at least a couple of paragraphs to say
what you have done to analyze the problem
Assumptions - this is one paragraph and includes any assumptions
that you made Analysis - present your results (graphs, tables, and
sentences to explain them) analysis Recommendation - this should be
a one paragraph conclusion/recommendation based on your
date. Gran hico
23-Feb 186 77 Calculate Granbury Plant
25-Jan 187 77 Mean
15-Feb 180 83 Median
8-Mar 195 85 Mode
7-Mar 179 92 Standard Deviation
5-Feb 196 93
22-Mar 182 97
24-Jan 169 98
2-Feb 191 98
13-Jan 186 99
8-Feb 167 100
19-Jan 183 104
5-Mar 183 106
9-Jan 196 106
14-Jan 195 108
28-Feb 164 110
11-Feb 187 112
4-Feb 160 117
17-Mar 193 119
24-Feb 196 120
18-Feb 191 124
12-Feb 181 127
16-Feb 188 128
16-Jan 194 129
22-Feb 168 132
21-Jan 181 135
11-Jan 193 139
15-Mar 175 142
20-Feb 185 142
28-Jan 184 145
24-Mar 165 149
12-Mar 162 151
1-Feb 189 152
20-Jan 181 154
11-Mar 175 155
17-Jan 196 156
29-Jan 193 159
19-Mar 187 160
3-Jan 183 164
3-Feb 166 167
25-Mar 193 167
26-Feb 168 168
15-Jan 174 175
10-Feb 173 176
8-Jan 199 176
6-Feb 168 180
29-Mar 192 182
2-Mar 188 187
6-Mar 181 188
31-Mar 170 190
3-Mar 170 192
18-Mar 185 192
17-Feb 172 193
31-Jan 160 194
30-Mar 168 194
16-Mar 192 204
13-Mar 171 210
26-Mar 164 212
6-Jan 177 219
23-Mar 163 221
7-Jan 186 224
4-Mar 186 224
28-Mar 197 226
2-Jan 196 227
13-Feb 169 231
4-Jan 168 223
9-Mar 192 233
10-Jan 164 238
1-Mar 170 239
27-Feb 180 239
20-Mar 185 224
9-Feb 196 245
26-Jan 161 248
14-Feb 183 249
23-Jan 164 255
12-Jan 188 255
3-Jan 166 256
10-Mar 197 257
5-Jan 167 258
25-Feb 169 260
14-Mar 186 260
22-Jan 175 261
21-Mar 168 262
27-Mar 160 267
19-Feb 188 268
7-Feb 166 271
27-Jan 175 273
21-Feb 172 275
18-Jan 171 276
Eliyahu Goldratt in his article “The Goal: a process of continuous improvement” does effectively facilitate to elucidate that organizations do have three different options for system improvement such as increasing throughput (T), reducing inventory (I) or reducing operating expense (OE). However the practical limits of reducing inventory and operating expenses are indeed relatively low as system cannot produce outputs without them.
Hypothetically there's no upper limit on how much an organization can increase its throughput as market sizes are limited. However the prospective of efficiently enhancing T tend to be much higher than the potentiality of reducing I and OE. Furthermore it effectively necessitates for a basic model facilitating system improvements thus focusing on increasing T and enduring the reduction of I and OE as secondary priority.
Rather than spending time, energy and resources across the entire system business administrator indeed needs to effectively focus on that part of the system which eventually has the potentiality to produce immediate system improvement. Furthermore Goldratt outlines several principles which ultimately helps to efficiently create an environment conductive to the rigid part of his theory. However prescriptive theory part of constraints indeed help organizations effectually respond towards management concerns regarding systems and their constraints.
A constraint is indeed regarded as something which eventually averts a system from attaining high level of performance related to its business goal and objective. Furthermore a system is regarded as any collection of interconnected parts sharing a common goal. Constraints may be for instance an individual or department which in due course fails to keep up with market demand. However if this department could produce more it would eventually facilitate organization with enhance sales and revenue.
Goldratt suggested focused steps eventually facilitating to effectively manage resources and market constraints. It comprised of effectively deciding on system goal, determining performance measures, identifying constraints and elucidating on how to take advantage of constraints thus ultimately helping to form a basis aimed towards continuous improvement.
You are the Operations Manager for a trailer manufacturing company On the Plant Information tab y...
It is well documented that cholesterol over 200 is a risk factor in developing heart disease for both men and women (www.livestronge.com, January 11, 2011). Younger men are known to have higher cholesterol levels than younger women; however, beyond the age of 55, women are more likely to have higher cholesterol levels. a recent college graduate working at a local blood lab has access to the cholesterol data of 50 men and 50 women in the 20 - 40 age...
Maintaining a healthy weight is important for women’s health. Some physicians recommend being back to your pre-pregnancy weight six months after giving birth. Public health officials are interested in whether this is a realistic goal. Do the women in North Carolina weigh more than their pre-pregnancy weight six months postpartum? In other words, is the six months post-pregnancy weight greater than their pre-pregnancy weight? Use a paired samples t-test to compare pst6wght (variable 1) and prewght (variable 2). This uses...
Consider the compressive strength data 6-2. What propotion of thespecimens exhibit compressive strength of at least 1379 KN/m^2? ■ TABLE 62 Compressive Strength (in psi) of 80 Aluminum-Lithium Alloy Specimens 105 97 245 163 207 134 218 199 160 196 221 154 228 131 180 178 157 151 175 201 183 153 174 154 190 76 101 142 149 200 186 174 199 115 193 167 121 120 181 160 194 184 165 145 160 150 181 168 158 208...
A manufacturer of home products is designing a new wall mount for large flat-panel televisions. Since some flat-panel televisions weigh up to 100 pounds, the manufacturer wants to make sure that the mean weight of failure for the wall mounts is greater than 180 pounds. Dayton is a researcher for the manufacturer who is conducting the test. He randomly selects 35 wall mounts and tests them by using a machine that pulls down on the mounts until each one fails....
Please let me know how to solve this questions, I would like to know know how to do this using excel. Using the data in tab, test whether the average weight of patients attending your new weight loss clinic has changed as a result of attending the clinic. That is, is the average weight of patients after attending the clinic different from the average weight before attending? Report the average weight of these patients before and after attending the clinic...
You will start by considering the data set in the proj2-2.txt file on BlackBoard. The data set contains SEX (1=female; 2=male), PEFR in l/min and height in cm. 1. Make a scatter plot of PEFR versus height. 2. Fit the simple linear regression of PEFR on height. 3. What is the estimated slope (with CI) and the interpretation of this estimate. 4. What is the standard deviation around the line (with CI) and the interpretation of this estimate. 5. Estimate...
Electric Bill 99 174 205 181 150 105 156 200 130 85 160 188 93 119 175 114 151 216 133 168 144 152 209 178 126 131 147 171 112 170 98 166 153 157 133 146 190 169 142 152 111 122 186 154 117 138 194 140 132 161 In our text, "Applied Business Statistics for Business Managers using Excel," please read Chapters 2 and 3. In Chapter 2, you will be learning how to construct some...
Serum Systolic Serum Systolic Serum Systolic Serum Systolic Serum Systolic 04 137 183115 218 145 209 170 195 115 Question 1a: Data a. Use the proportion from question 1a. Test the claim that the Sample 153 127 193 146 173 194 163 201...-174--157 proportion of Asianssi-s than 25%, use 219 ; 1191 163 160 174,160 140 Proportion 0.2 Critical Value 1.645 Margin of Error 0.0658 144 140 145 177 152166175 200 131 Hypotheses: You may write HO and Hl Test...
181. Reactivation of the varicella virus when older 182. Excision of the uterus Nail-biting 183. 184. The process of totally removing a structure, such as the eye 185. The study of diseases and disorders of the rectum 186. Referring to physical complaints that are caused by mental conflict 187. The spread of a cancer to one place beyond its original site 188. Swelling, commonly in the lower extremities Excision of the stapes 189. 190. "Humpback" Low hemoglobin 191. Supply the...
Crop Fertilizer Corn Wheat Rice Soy Blend A 128 123 151 166 150 156 125 178 174 112 117 187 116 100 155 153 109 168 158 195 Blend B 175 135 167 140 132 130 183 145 120 176 142 159 187 120 167 131 184 155 168 126 Blend C 185 156 175 185 138 180 173 206 178 147 154 188 176 146 191 165 190 193 169 188 A company has developed a new fertilizer to...