GRAND CANYON MGT455 WEEK 6 ASSIGNMENT HOMEWORK AND Chapter 10 and E Problem Set

Complete problems 9.11, 9.13, and 9.15 in the textbook.

Submit one Excel file. Put each problem result on a separate sheet in your file.

You are not required to submit this assignment to Turnitin, unless otherwise directed by your instructor. If so directed, refer to the Student Success Center for directions. Only Word documents can be submitted to Turnitin.

Details:

Complete Problems 10.25, 10.29, E.3, E.5, and E.6 in the textbook.

Submit one Excel file. Put each problem result on a separate sheet in your file.

You are not required to submit this assignment to Turnitin, unless otherwise directed by your instructor. If so directed, refer to the Student Success Center for directions. Only Word documents can be submitted to Turnitin.

9.11 Stanford Rosenberg Computing wants to establish an
assembly line for producing a new product, the Personal Digital
Assistant (PDA). The tasks, task times, and immediate predecessors
for the tasks are as follows:
TASK TIME (sec)
IMMEDIATE
PREDECESSORS
A 12 —
B 15 A
C 8 A
D 5 B, C
E 20 D
Rosenberg’s goal is to produce 180 PDAs per hour.
a) What is the cycle time?
b) What is the theoretical minimum for the number of workstations
that Rosenberg can achieve in this assembly line?
c) Can the theoretical minimum actually be reached when workstations
are assigned?

9.13 Sue Helms Appliances wants to establish an assembly
line to manufacture its new product, the Micro Popcorn
Popper. The goal is to produce five poppers per hour. The tasks,
task times, and immediate predecessors for producing one Micro
Popcorn Popper are as follows:
TASK
TIME
(min)
IMMEDIATE
PREDECESSORS
A 10 —
B 12 A
C 8 A, B
D 6 B, C
E 6 C
F 6 D, E
a) What is the theoretical minimum for the smallest number of
workstations that Helms can achieve in this assembly line?
b) Graph the assembly line and assign workers to workstations.
Can you assign them with the theoretical minimum?
c) What is the efficiency of your assignment?

9.15 The following table details the tasks required for
Indiana-based Frank Pianki Industries to manufacture a fully
portable industrial vacuum cleaner. The times in the table are in
minutes. Demand forecasts indicate a need to operate with a cycle
time of 10 minutes.

ACTIVITY ACTIVITY DESCRIPTION
IMMEDIATE
PREDECESSORS TIME
A Attach wheels to tub — 5
B Attach motor to lid — 1.5
C Attach battery pack B 3
D Attach safety cutoff C 4
E Attach filters B 3
F Attach lid to tub A, E 2
G Assemble attachments — 3
H Function test D, F, G 3.5
I Final inspection H 2
J Packing I 2
a) Draw the appropriate precedence diagram for this production
line.
b) Assign tasks to workstations and determine how much idle
time is present each cycle.
c) Discuss how this balance could be improved to 100%.
d) What is the theoretical minimum number of workstations

10.25 Peter Rourke, a loan processor at Wentworth Bank,
has been timed performing four work elements, with the results
shown in the following table. The allowances for tasks such as this
are personal, 7%; fatigue, 10%; and delay, 3%.
TASK
ELEMENT
PERFORMANCE
RATING (%)
OBSERVATIONS (MINUTES)
1 2 3 4 5
1 110 .5 .4 .6 .4 .4
2 95 .6 .8 .7 .6 .7
3 90 .6 .4 .7 .5 .5
4 85 1.5 1.8 2.0 1.7 1.5
a) What is the normal time?
b) What is the standard time?

10.29. The Dubuque Cement Company packs 80-pound
bags of concrete mix. Time-study data for the filling activity are
shown in the following table. Because of the high physical demands
of the job, the company’s policy is a 23% allowance for workers.
a) Compute the standard time for the bag-packing task.
b) How many observations are necessary for 99% confidence,
within {5% accuracy?
ELEMENT
OBSERVATIONS (SECONDS) PERFORMANCE
1 2 3 4 5 RATING (%)
Grasp and place bag 8 9 8 11 7 110
Fill bag 36 41 39 35 112a 85
Seal bag 15 17 13 20 18 105
Place bag on conveyor 8 6 9 30b 35b 90

aBag breaks open; included as delay in the allowance factor.
bConveyor jams; included as delay in the allowance factor