Chapter 9 questions - 327

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

CH9_P11

FILENAME: CH9_P11.xlsx For the charts
CHAPTER 9, PROBLEM 11
OPERATIONS MANAGEMENT by ROGER SCHROEDER, et al. Average Range
no. obs cl ucl lcl obs cl ucl lcl
THIS WORKSHEET CALCULATES CONTROL CHARTS FOR AVERAGE 1.0 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
AND RANGE. ENTER THE DATA FROM THE PROBLEM AND THE CONTROL 2.0 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
LIMIT COEFFICIENTS. THE PROGRAM WILL CALCULATE THE CONTROL 3.0 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
LIMITS AND PLOT THE DATA ON THE AVERAGE AND RANGE CONTROL 4.0 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
CHARTS. 5.0 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
6.0 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
PRESS THE "PAGE DOWN" AND "PAGE UP" KEYS OR USE THE VERTICAL 7.0 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
SCROLL BAR TO MOVE TO THE DIFFERENT AREAS OF THE WORKSHEET TO 8.0 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
DO THE FOLLOWING: 9.0 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
- ENTER DATA 10.0 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
- VIEW CALCULATED VALUES 11.0 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
- VIEW THE AVERAGE AND RANGE CONTROL CHARTS 12.0 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
15.0 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
TO PRINT A COPY OF THE CALCULATIONS AND CHARTS, PRESS "CTRL" 16.0 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
AND "P" SIMULTANEOUSLY AND CHOOSE "OK". 17.0 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
NAME: ***************** CHAPTER 9, PROBLEM 11
SECTION: ******** 41256.0
Observation Sample Sample
Sample 1 2 3 Average Range
= = = = = =
1.0 ***** ***** ***** 0.00 0.00
2.0 ***** ***** ***** 0.00 0.00
3.0 ***** ***** ***** 0.00 0.00
4.0 ***** ***** ***** 0.00 0.00
5.0 ***** ***** ***** 0.00 0.00
6.0 ***** ***** ***** 0.00 0.00
7.0 ***** ***** ***** 0.00 0.00
8.0 ***** ***** ***** 0.00 0.00
9.0 ***** ***** ***** 0.00 0.00
10.0 ***** ***** ***** 0.00 0.00
11.0 ***** ***** ***** 0.00 0.00
12.0 ***** ***** ***** 0.00 0.00
13.0 ***** ***** ***** 0.00 0.00
14.0 ***** ***** ***** 0.00 0.00
15.0 ***** ***** ***** 0.00 0.00
16.0 ***** ***** ***** 0.00 0.00
17.0 ***** ***** ***** 0.00 0.00
18.0 ***** ***** ***** 0.00 0.00
19.0 ***** ***** ***** 0.00 0.00
20.0 ***** ***** ***** 0.00 0.00
=
Grand Averages 0.00 0.00
Enter Values of
A2 *****
D3 *****
D4 *****
RESULTS: Average Range
= =
Center Line 0.00 0.00
Upper Control Limit (UCL) 0.00 0.00
Lower Control Limit (LCL) 0.00 0.00
Average Chart Range Chart
Center Line UCL LCL Center Line UCL LCL
0.0 0.0 0.0 0.0 0.0 0.0
0.0 0.0 0.0 0.0 0.0 0.0
0.0 0.0 0.0 0.0 0.0 0.0
0.0 0.0 0.0 0.0 0.0 0.0
0.0 0.0 0.0 0.0 0.0 0.0
0.0 0.0 0.0 0.0 0.0 0.0
0.0 0.0 0.0 0.0 0.0 0.0
0.0 0.0 0.0 0.0 0.0 0.0
0.0 0.0 0.0 0.0 0.0 0.0
0.0 0.0 0.0 0.0 0.0 0.0
0.0 0.0 0.0 0.0 0.0 0.0
0.0 0.0 0.0 0.0 0.0 0.0
0.0 0.0 0.0 0.0 0.0 0.0
0.0 0.0 0.0 0.0 0.0 0.0
0.0 0.0 0.0 0.0 0.0 0.0
0.0 0.0 0.0 0.0 0.0 0.0
0.0 0.0 0.0 0.0 0.0 0.0
0.0 0.0 0.0 0.0 0.0 0.0
0.0 0.0 0.0 0.0 0.0 0.0
0.0 0.0 0.0 0.0 0.0 0.0

&9An application of the software accompanying Operations Management by Roger Schroeder.

RANGE CHART for Chapter 9 Problem 11

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

AVERAGE CHART for Chapter 9 Problem 11

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