operations

ch11hmwkdata.xlsx

Formulas

Problem 2				Mouse over red triangles for tips
	2.58
z=		(look up value in table on pg. 405)			pg381
e=	0.05
Work Element	Standard Deviation	Mean Observed Time (min)	Theory Sample Size WLK Forward, Inc: Formula Tip: Use formula #1 from the first sheet to complete this column
1	0.20	1.10
2	0.10	0.80
3	0.15	0.90
4	0.10	1.00

Problem 4				Mouse over red triangles for tips
z=		(look up value in table on pg. 405)
e=	0.05
Work Element	Standard Deviation	Mean Observed Time (min)	Therotical Sample Size WLK Forward, Inc: Formula Tip: Use formula #1 from the first sheet to complete this column
1	0.60	2.40
2	0.20	1.50
3	1.10	3.85
4	0.85	2.55
5	0.40	1.60
6	0.50	2.50
Sample size from Problem 3
Percentage increase due to higher confidence level

Problem 12								Mouse over red triangles for tips
	Elements
Observations	1	2	3	4	5	6	Total for Nav III
Cycle 1	1.10	3.00	0.92	1.23	1.46	1.80
Cycle 2	1.08		0.88	1.30	1.64	1.78
Cycle 3	1.15	3.20	0.85	1.26	1.55	1.76
Cycle 4	1.16		0.88	1.33	1.52	1.80
Cycle 5	1.07	3.10	0.90	1.28	1.62	1.82
Cycle 6	1.10		0.94	1.30	1.60	1.82
Mean Observed Time WLK Forward, Inc: Formula Tip: Find the average for each element.
Rating factor	0.95	0.9	1.05	1.00	0.85	1.10
Frequency	1.00	0.50	1.00	1.00	1.00	1.00
Normal Time WLK Forward, Inc: Formula Tip: Mean observed time X Perf Rating X Freq
Standard Time WLK Forward, Inc: Formula Tip: Normal Time X (1+Allowance Factor)
							WLK Forward, Inc: Formula tip: Add standard times for each element.	WLK Forward, Inc: Formula Tip: Find the average for each element.	WLK Forward, Inc: Formula Tip: Mean observed time X Perf Rating X Freq	WLK Forward, Inc: Formula Tip: Normal Time X (1+Allowance Factor)	Production at 100% WLK Forward, Inc: Formula tip: 60min X 1unit 1hour std time
Production at 90% WLK Forward, Inc: Formula Tip: Production at 100% X .90
Monthly production	20,000
Old element 6 time
New element 6 time
Time saved
Total time saved for monthly production

Problem 14						Mouse over red triangles for tips
z=	1.96	(look up value in table on pg. 405)			381
e=	0.05
Activity Observed	# of times observed	% of total
Doing paperwork	9.00
		WLK Forward, Inc: Formula tip: find the percentage of the total for each task.	On the phone	3.00
Eating doughnuts	3.00
Cleaning weapon	4.00
Idle	2.00
Not in sight	4.00
Initial observations WLK Forward, Inc: Formula Tip: Find the sum of the observations.
Total observations needed for pprwork WLK Forward, Inc: Formula tip: Use formula #6 on the formula sheet tab.
Total observations needed for phone
Total observations needed for idle time

Problem 16								Mouse over red triangles for tips
z=	2.17	(look up value in table on pg. 405)
e=	0.05
Activity Observed	# of times observed	% of total	Total Observations needed
Grading	4.00
Admin paperwork	6.00					=ROUNDUP(($B$3/$B$4)^2(C8)(1-C8),0)
Preparing for class	5.00
Teaching class	5.00
Meeting with students	8.00
On the phone	2.00
Working on research	6.00
Unavailable	4.00
Total WLK Forward, Inc: Formula Tip: Find the sum of the observations.	40.00
			WLK Forward, Inc: Formula tip: Use the MAX formula to take the largest number.	Activity Observed	# of times observed	% of total	Hours per week
Grading	30.00	WLK Forward, Inc: Formula tip: find the percentage of the total for each task.	WLK Forward, Inc: Formula tip: find the percentage of the total for each task.	WLK Forward, Inc: Formula tip: Use formula #6 on the formula sheet tab. Also, you will want to use the ROUNDUP function to make your answers come out as whole numbers	WLK Forward, Inc: Formula Tip: Find the sum of the observations.			0.00
Admin paperwork	50.00		0.00
Preparing for class	30.00		0.00
Teaching class	30.00		0.00
Meeting with students	66.00		0.00
On the phone	17.00		0.00
Working on research	45.00		0.00
Unavailable	34.00		0.00
Total	302.00		54