Question: An operator is assigned four machines that experience an expected downtime of 4 9 % . When running, each machine produces 8 0 units per

An operator is assigned four machines that experience an expected downtime of 49%. When running, each machine produces 80 units per hour. The operator's hourly wage is $13.00, and the cost to operate a machine is $70.00 per hour. Is it worth it to hire an additional operator to reduce downtime and keep the machines operating efficiently? Compare and contrast the probability, machine hours lost per 8hr day, and the TEC for 1,2,3, and 4 operators. Show complete work in Excel
ENTER ONLY NUMERICAL VALUES ROUNDED TO TWO DECIMAL PLACES IN THE TEXT BOXES BELOW. DO NOT INCLUDE UNITS. HOWEVER, MAKE SURE TO INCLUDE UNITS IN EXCEL.
What is the proportion (in %) of machine time (in minutes) lost for 1 operator? Blank 1
What is the proportion (in %) of machine time (in minutes) lost for 2 operators? Blank 2
What is the proportion (in %) of machine time (in minutes) lost for 3 operators? Blank 3
What is the proportion (in %) of machine time (in minutes) lost for 4 operators? Blank 4
What is the average time in minutes to produce one unit per machine in the case of 1 operator? Blank 5
What is the average time in minutes to produce one unit per machine in the case of 2 operators?Blank 6
What is the average time in minutes to produce one unit per machine in the case of 3 operators? Blank 7
What is the average time in minutes to produce one unit per machine in the case of 4 operators? Blank 8
What is the number of units per minute produced by n machines in the case of 1 operator? Blank 9
What is the number of units per minute produced by n machines in the case of 2 operators? Blank 10
What is the number of units per minute produced by n machines in the case of 3 operators? Blank 11
What is the number of units per minute produced by n machines in the case of 4 operators? Blank 12
What is the total expected cost per unit in the case of 1 operator? Blank 13
What is the total expected cost per unit in the case of 2 operators? Blank 14
What is the total expected cost per unit in the case of 2 operators? Blank 15
What is the total expected cost per unit in the case of 4 operators? Blank 16
What is the preferred number of operators?Explain your decision in your Excel file. Blank 17

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!