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.

The price is based on these factors:

Academic level

Number of pages

Urgency

Basic features

- Free title page and bibliography
- Unlimited revisions
- Plagiarism-free guarantee
- Money-back guarantee
- 24/7 support

On-demand options

- Writer’s samples
- Part-by-part delivery
- Overnight delivery
- Copies of used sources
- Expert Proofreading

Paper format

- 275 words per page
- 12 pt Arial/Times New Roman
- Double line spacing
- Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Delivering a high-quality product at a reasonable price is not enough anymore.

That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more