A large manufacturing firm is concerned about lost production (i.e., production capability that was not utilized...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A large manufacturing firm is concerned about lost production (i.e., production capability that was not utilized for a variety of reasons). One of the causes of such lost production was identified as employees taking time off work because of illness. Last year, the organization estimated that about 53,000 units of production were lost each week due to this cause, with a standard deviation of 4,800. The Department of Human Resources decided to monitor, on a weekly basis, a small sample of 20 employees on the production line in terms of their attendance at work, and to translate this into a weekly production loss figure for the company. For the first eight weeks the results are as follows: Estimated Lost Production (000 units) Week 1 50.3 Week 2 53.9 Week 3 55.6 Week 4 51.2 Week 5 51.0 Week 6 50.9 Week 7 48.7 Week 8 49.3 Directions 1. Within Excel, construct a control chart that will be of use to the Department of Human Resources. Insert the chart, using proper APA format, into the executive briefing in step 2 below. 2. Prepare a 250- to 350-word executive briefing that (a) reviews the issue under study and the rationale for your analysis (ensure that your briefing includes the quantitative analysis that yielded the mathematical results of warning and action limits); (b) outlines the potential for using control charts in monitoring lost production on a regular basis (highlight which, if any, weeks need management's attention, and support these claims using your numerical analysis); and (c) explains Type l and Type Il errors in this context. Submit both the complete report and your Excel spreadsheet. A large manufacturing firm is concerned about lost production (i.e., production capability that was not utilized for a variety of reasons). One of the causes of such lost production was identified as employees taking time off work because of illness. Last year, the organization estimated that about 53,000 units of production were lost each week due to this cause, with a standard deviation of 4,800. The Department of Human Resources decided to monitor, on a weekly basis, a small sample of 20 employees on the production line in terms of their attendance at work, and to translate this into a weekly production loss figure for the company. For the first eight weeks the results are as follows: Estimated Lost Production (000 units) Week 1 50.3 Week 2 53.9 Week 3 55.6 Week 4 51.2 Week 5 51.0 Week 6 50.9 Week 7 48.7 Week 8 49.3 Directions 1. Within Excel, construct a control chart that will be of use to the Department of Human Resources. Insert the chart, using proper APA format, into the executive briefing in step 2 below. 2. Prepare a 250- to 350-word executive briefing that (a) reviews the issue under study and the rationale for your analysis (ensure that your briefing includes the quantitative analysis that yielded the mathematical results of warning and action limits); (b) outlines the potential for using control charts in monitoring lost production on a regular basis (highlight which, if any, weeks need management's attention, and support these claims using your numerical analysis); and (c) explains Type l and Type Il errors in this context. Submit both the complete report and your Excel spreadsheet.
Expert Answer:
Related Book For
An introduction to management science quantitative approaches to decision making
ISBN: 978-1111532222
13th edition
Authors: David Anderson, Dennis Sweeney, Thomas Williams, Jeffrey Cam
Posted Date:
Students also viewed these accounting questions
-
The president of a small manufacturing firm is concerned about the continual increase in manufacturing costs over the past several years. The following figures provide a time series of the cost per...
-
A gold-mining firm is concerned about short-term volatility in its revenues. Gold currently sells for $650 an ounce, but the price is extremely volatile and could fall as low as $630 or rise as high...
-
The president of a small manufacturing firm is concerned about the continual increase in manufacturing costs over the past several years. The following figures provide a time series of the cost per...
-
Metro builds and operates traditional shopping malls. It holds a $25 million deferred tax asset relating to credit carryforwards at the state, local, and Federal levels. No valuation allowances...
-
A high-resolution solid state camera is to have a 1035 x 1320 pixel matrix. An image processing rate of 30 times per second must be achieved, or 0.0333 sec per frame. To allow for time lost in other...
-
At March 31, 2010, the end of the first year of operations at Jaryd, Inc., the firms accountant neglected to accrue payroll taxes of $4,800 that were applicable to payrolls for the year then ended....
-
In a 1975 contract, Eureka was given the exclusive right to sell spring water and other products under the Ozarka trade name in 60 Oklahoma counties in exchange for \($9,000\) paid to Arrowhead,...
-
Stahl Inc. produces three separate products from a common process costing $100,000. Each of the products can be sold at the split-off point or can be processed further and then sold for a higher...
-
2. 2. A 20 kg child climbs to the top of a slide that is 3 m above the ground level. She starts from rest and slides down the incline. a. Define and model the energy of the system with Energy Bar...
-
The file HotelAway contains the average room price (in US$) paid by various nationalities while traveling abroad (away from their home country) in 2016: 124 101 115 126 114 112 138 85 138 96 130 116...
-
What statement about modern central banks would you most likely agree with? O Central banks easily achieve ultimate objective of low and stable inflation, which they directly control O They may have...
-
Albert House, current workers' compensation carrier has provided Albert House, with a forecasted amount for 2024's workers' compensation claims. The total projected losses for 2024 are almost twice...
-
Based on historical data, the Hospital of St. Jacques wants to have 7 bags of B positive blood to every 2 bags of B Negative, furthermore, they want to have 3 bags of B negative blood for every 1 bag...
-
Balance Sheet Accounts of Athens Corporation Account Accumulated Depreciation Accounts Payable Accounts Receivable Cash Common Stock Inventory Long-Term Debt Plant, Property & Equipment Retained...
-
You want to be able to withdraw $25,000 each year for 15 years. Your account earns 7% interest. How much do you need in your account at the beginning?
-
Starware Software was founded last year to develop software for gaming applications. The founder initially invested $800,000 and received 9 million shares of stock. Starware now needs to raise a...
-
From the SEC.gov website (Securities and Exchange Commission) : " When your broker recommends that you buy or sell a particular security, your broker must have a reasonable basis for believing that...
-
What are conversion costs? What are prime costs?
-
Assume you are given a minimization linear program that has an optimal solution. The problem is then modified by changing a greater-than-or-equal-to constraint in the problem to a...
-
Suppose that Westsides management in Problem likes the operational efficiency of ordering once each month and in quantities of 1000 units. How much more expensive would this policy be than your EOQ...
-
FRED® (Federal Reserve Economic Data), a database of more than 3000 U.S. economic time series, contains historical data on foreign exchange rates. The following data show the foreign exchange...
-
Determine the work required to transport \(10 \mathrm{~kg}\) of material from Earth to the ISS, the International Space Station, in orbit \(420 \mathrm{~km}\) above the Earth's surface.
-
Show that the force field expressed in spherical coordinates \(\mathbf{F}=f(r, \theta) \mathbf{r}\) is conservative if and only if the function \(f\) is independent of \(\theta\).
-
Show that in the case of a binary system in which the orbit is circular of radius \(r\), the kinetic energy corresponds to half the absolute value of the potential energy. In other words, the total...
Study smarter with the SolutionInn App