Chapter 9 questions - 327

profilewtfbm69
CH9_P3SpreadsheetTemplate.xlsx
Home>Business & Finance homework help>Accounting homework help>Chapter 9 questions - 327

CH9_P3

FILENAME: CH9_P3.xlsx
CHAPTER 9, PROBLEM 3
OPERATIONS MANAGEMENT by SCHROEDER, et al.
THIS WORKSHEET CALCULATES A CONTROL CHART FOR
ATTRIBUTES (OR PROPORTION DEFECTIVE) FROM THE DATA
GIVEN FOR PROBLEM 3. THE CENTER LINE AND THE UPPER
AND LOWER CONTROL LIMITS ARE CALCULATED. A P CONTROL
CHART IS ALSO PROVIDED.
PRESS THE "PAGE DOWN" AND "PAGE UP" KEYS OR USE THE VERTICAL
SCROLL BAR TO MOVE TO THE DIFFERENT AREAS OF THE WORKSHEET
TO DO THE FOLLOWING:
- ENTER DATA
- VIEW CALCULATED VALUES
- VIEW THE P CONTROL CHART
TO PRINT A COPY OF THE CALCULATIONS AND P CONTROL CHART,
PRESS "CTRL" AND "P" SIMULTANEOUSLY AND CHOOSE "OK".
NAME: ************************* CHAPTER 9, PROBLEM 3
SECTION: ******** 29-Nov-15
Enter sample size for each sample ******
Enter the number of samples taken ******
Enter the proportion of records found in error each day
in cells B33 through B42 and C33 through C42.
_
******* ******* Center Line P 0.0000
******* ******* Upper Control Limit UCL ERROR:#DIV/0!
******* ******* Lower Control Limit LCL ERROR:#DIV/0!
******* *******
******* *******
******* *******
******* ******* TO VIEW THE OTHER AREAS OF THIS WORKSHEET,
******* ******* PRESS THE "PAGE DOWN" AND "PAGE UP" KEYS OR
******* ******* USE THE VERTICAL SCROLL BAR.
******* *******
Error Proportion Center Line UCL LCL
******* 0.0000 ERROR:#DIV/0! ERROR:#DIV/0!
******* 0.0000 ERROR:#DIV/0! ERROR:#DIV/0!
******* 0.0000 ERROR:#DIV/0! ERROR:#DIV/0!
******* 0.0000 ERROR:#DIV/0! ERROR:#DIV/0!
******* 0.0000 ERROR:#DIV/0! ERROR:#DIV/0!
******* 0.0000 ERROR:#DIV/0! ERROR:#DIV/0!
******* 0.0000 ERROR:#DIV/0! ERROR:#DIV/0!
******* 0.0000 ERROR:#DIV/0! ERROR:#DIV/0!
******* 0.0000 ERROR:#DIV/0! ERROR:#DIV/0!
******* 0.0000 ERROR:#DIV/0! ERROR:#DIV/0!
******* 0.0000 ERROR:#DIV/0! ERROR:#DIV/0!
******* 0.0000 ERROR:#DIV/0! ERROR:#DIV/0!
******* 0.0000 ERROR:#DIV/0! ERROR:#DIV/0!
******* 0.0000 ERROR:#DIV/0! ERROR:#DIV/0!
******* 0.0000 ERROR:#DIV/0! ERROR:#DIV/0!
******* 0.0000 ERROR:#DIV/0! ERROR:#DIV/0!
******* 0.0000 ERROR:#DIV/0! ERROR:#DIV/0!
******* 0.0000 ERROR:#DIV/0! ERROR:#DIV/0!
******* 0.0000 ERROR:#DIV/0! ERROR:#DIV/0!
******* 0.0000 ERROR:#DIV/0! ERROR:#DIV/0!

&"Times New Roman,Regular"&9An application of the software accompanying Operations Management by Roger Schroeder.

P Control Chart

Error Proportion 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Center Line 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 UCL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 LCL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0