Question

Based on a careful work study in the Hofstetter Corp., the results shown in the following table have been observed Observation (minutes per cycle) Performance Rating 5 40 4 Element 115% 35 40 34 Prepare daily reports Photocopy results Label and package reports Distribute reports 12 110% 95% 9 36 15 2 85% 17 20 18 46A Photocopying machine broken; included as delay in the allowance factor A Power outage; included as delay in the allowance factor The allowance factor for this type of work is given to be 12%. (Round all intermediate calculations to two decimal places before proceeding with further calculations.)

A: Find the Normal Time for the "Prepare Daily Reports" operation:

B: Normal Time for "Photocopy Results" Operation:

C: Normal TIme for the "Label and Package Reports Operation:

D: Normal Time for "Distribution Reports" Operation:

E: Normal Time for the ENTIRE OPERATION PROCESS

F: The Standard Time for this Process:

G: The number of Operations that are required for a 90, 95, and 99% confidence level with 5% accuracy?

Answer 1

Below is the screenshot of the formula applied to get the result -

Observation number Excel Tell me what you want to do General Abhishek Rai File Home Page Layout Formulas Data Review View Help Insert s Cut AutoSum - A Fill ▼ Clear Filter Select Calibri Copy Format Painter Paste Merge & Center-s-% , 騽| Conditional Format as. Cel-Insert Delete Format 1 u . ▼ク-A. - Sort & Find & Formatting Table Styles Styles Ciipboard Font Alignment Number Cells Editing A1 B C D E F GH M N 0 Observation Perf Allowa Average observed Time Normal Timedard Time Deviation (s) (99 h Number of obervation ance Factor 1 2 34 5 05 3 Prepare Daily 4 5 6 1.15 0 12 Photocopy Result 1.1 0.12 Label and Package R 0.95 0 12 Distribute Rp ort 0.85 0 12 35 40 34 41 40 11 9 15 12 2 2 5 5 5 16 17 20 18 ROUND(AVERAGE(D3 H3) 2) ROUND AVERAGE D4H4) 2 ROUND(AVERAGEID5 HS 2) ROUND(AVERAGEID6 6) 2) -ROUND( 3 B3 2) -ROUND 4"34,2 -ROUND 5 B5,2) =ROUND 6 86,2) SUMUS16) ROUNDU3/(1-C3) 2-11D3-13}"2 E3-13)-2刊F3-13)42 +(G3-13)42 +{ 3-13)"21 (COUNTID3 H3} 1))40 5 ROUNDU4/ 1 C4 2 D4-14 л2刊E4 4 42 F4 4 42 + G4 4 42 + 4 14 2 /(COUNT D4H4) 1 0.5 ROUNDUS/ 1 C5 2) ((D5-15) 2 HE5-15)^2 + F5 5)^2 + G5-15 42 +(H5-15)^2)/ COUNT D5 5 -1)) 0.5 ROUNDI 6/(1-C6) 2) ((D6-16) 2刊E6-16)^2+ F6-1642 (G6-16)424( 6-16) 2 COUNT D6 6) 1)) 0.5 SUM(K3:K6 2 0 5-| M3 L3)/(N343))"2 2.58005-M4"L4)/ N4 14 2 2.580 05-1M5"L5) (N5 15)) 2 2.58 005 ((M6 L6) ( 6 6)) 2

Below will be the desired result and number of observation at 99% confidence level -

Observation number Excel File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Wrap Text 園 Calibri General . s-% , .00 → : Conditio Formattir Paste 를 Merge & Center 00 3.0 Format Painter Clipboard Font Alignment Number H4 M N Observation Perfor Allow mance ance 12 3 4 Rating Factor 115% | 12% | 35 | 40 | 34 | 41 11096| 1296 | 11| 9 Average Observed Normal Standard |Number of Obervation Element h Time Time Deviation (s)|(99%| Time 3 Prepare Daily Reports 4 Photocopy Result 19 1008 498 912 40 49.66 3.240370349 | 2.58| 0.05 11.75 | 12.93 | 14.69 7.2298570761 2.58 0.05 1.6431676732.58 0.05 17.75 | 15.09 | 17.15 10.38929738 2.58 0.05 38 43.7 15 12 Label and Package Reports | 9596 | 1296 | 2 | 2 | 5 6 Distribute Rpeorts 3.8 3.61 85% | 12% | 16 | 17 | 20| 18 Total Process 75.33 85.6

Number of observation at 99% confidence level = 1008

Similarly we will change the z value in excel for different confidence level. Below will be the result -

Number of observation at 95% confidence level = 582

Number of observation at 90% confidence level = 410