Question: Please include excel formulas so that I understand how to work the problem A worker-machine operation was found to involve 3.70 minutes of machine time

Please include excel formulas so that IPlease include excel formulas so that I understand how to work the problem

A worker-machine operation was found to involve 3.70 minutes of machine time per cycle in the course of 50 cycles of stopwatch study. The worker's time averaged 2.55 minutes per cycle, and the worker was given a rating of 110 percent (machine rating is 100 percent). Midway through the study, the worker took a 10-minute rest break. Assuming an allowance factor of 10 percent of work time (machine allowance is 0 percent), determine the following: a. Determine standard time of the machine. b. Determine standard time of the worker. . c. Determine standard time of the job. * Round your final answers to two decimal places

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!