Question: Solve the question below in Excel. Make your Excel sheet like a template that you can use for solving similar questions. The grade is based

Solve the question below in Excel. Make your Excel sheet like a template that you can use for solving similar questions. The grade is based on the functionality of the file, the accuracy of the solution, and the easy-to-use Excel sheet.
Problem:
An injector machine goes down roughly 20% of the time (the injector gums up and needs to be cleaned, a quick process). One operator is assigned to service three identical such machines. Each machine can produce 100 parts/hr if running properly (i.e., not down). The operator is paid $10.00/hr and each machine costs $20.00/hr to operate.
How many hours are idle due to machine downtime?
What is the unit cost for this operation?
Is it worth hiring another operator at the same rate to assist the first operator, in case more than one machine goes down simultaneously?

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!