Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

 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 weelk 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 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 50.3 53.9 55.6 51.2 51.0 50.9 48.7 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 described in step 2 below. 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 managements attention, and support these claims using your numerical analysis); and (c) explains Type I and Type Il errors in this context. Submit both the complete report and your Excel spreadsheet. 2.

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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

An Introduction To Management Science Quantitative Approaches To Decision Making

Authors: David Anderson, Dennis Sweeney, Thomas Williams, Jeffrey Cam

13th Edition

9781111532246, 1111532222, 1111532249, 978-1111532222

More Books

Students also viewed these Accounting questions

Question

What are conversion costs? What are prime costs?

Answered: 1 week ago