MGT-240 Problem Solving Activity

Show all work Only excel Needed

5.2. The work center in problem 5.1 is utilized 75% of the time. What are the hours per week actually
worked?
5.5. A work center consists of 4 machines working 8 hours a day for a 5-day week. If the utilization is 80%
and the efficiency is 90%, what is the rated capacity of the work center?
5.9. A work center consisting of 3 machines operates 40 hours a week. In a 4-week period, it actually
worked 355 hours and produced 475 standard hours of work. Calculate the utilization and efficiency of
the work center. What is the demonstrated weekly capacity of the work center?
5.10. A firm wishes to determine the efficiency and utilization of a work center composed of 5 machines
each working 16 hours per day for 5 days a week. A study undertaken by the materials management
department found that over the past 50 weeks the work center was actually working for 16,000 hours,
and work performed was 15,200 standard hours. Calculate the utilization, efficiency, and demonstrated
weekly capacity.
5.14. A work center has the following open and planned orders for week 4. Calculate the total standard
time required (load).
5.16. Complete the following load report and suggest possible courses of action.
5.18. Back schedule the following shop order. All times are given in days. Move time between operations
is 1 day, and wait time is 1 day. Due date is day 200. Assume orders start at the beginning of a day and
finish at the end of a day.
6.4. An order for 50 of a product is processed on work centers A and B. The setup time on A is 45
minutes, and run time is 5 minutes per piece. The setup time on B is 30 minutes, and the run time is 4
minutes per piece. Wait time between the two operations is 8 hours. The move time between A and B is
60 minutes. Wait time after operation B is 8 hours, and the move time into stores is 2 hours. Queue at
work center A is 40 hours and at B is 35 hours. Calculate the total manufacturing lead time for the order.
6.7. International Door Slammers has an order to deliver 500 door slammers on day 130. Draw up a
backward schedule under the following conditions:
A. Only one machine is assigned to each operation.
B. Schedule one 8-hour shift per day for 5 days per week.
C. All parts are to move in one lot of 500 pieces.
D. Allow 8 hours between operations for queue and move times.
A slammer consists of three parts. Purchased components C and D form subassembly A. Subassembly A
and component B form the final assembly. Part B is machined in three operations. No special tooling is
required except for part B, operation 20. It takes 24 hours to make the tooling. Material is available for all
parts.
Standard times for the lot of 500 are as follows:
6.9. An order for 250 bell ringers is processed on work centers 10 and 20. The setup and run times are as
follows. It is decided to overlap the lot on the two work centers and to split the lot into two lots of 100
and 150. Move time between operations is 30 minutes. Work center 20 cannot be set up until the first
lot arrives. Calculate the saving in manufacturing lead time.
6.15. Complete the following input/output report. What is the actual backlog at the end of period 5?
6.16. Complete the following table to determine the run sequence for each of the sequencing rules.
6.18. Calculate the critical ratios for the following orders and establish in what order they should be run.
Today’s date is 75.