Question: Please answer 6.4 & 6.5 with excel and show work 6.4. An order for 50 of a product is processed on work centers A and

Please answer 6.4 & 6.5 with excel and show work

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 4 minutes per piece. The setup time on B is 30 minutes, and the run time is 5 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 7 hours, and the move time into stores is 2 hours. Queue at work center A is 40 hours and at B is 30 hours. Calculate the total manufacturing lead time for the order. 6.5. In problem 6.4, what percentage of time is the order actually running

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!

A month has elapsed since Precision Computer Centre's year-end. Tony Freedman will use four specialized journals for recording business transactions in the month of September. To assist you in...

Basic Data Analysis: Analysis of Supplier Evaluation and Selection The attached MS EXCEL spreadsheet contains data about a company named ABC LLC and its suppliers. The highlights of the data include...

Please answer Q8 in an excel format! Thank you for the help! Operation Work Center Setup Time Run Time Notebook assembly 100 2 hours 10 minutes Pad production 200 3 hours 5 minutes Cover production...

please, put the "exhibits" into excel and show the work put into excel thats needed to answers questions 1 - 6. INTRODUCTION Allegheny County Port Authority is the main organization that oversees...

S&P Enterprises has provided data from the first three months of the year. The Controller has asked you to prepare the Cash Budget and the related Schedules for Expected cash collections and Payments...

please give solution to this whole question 14 chapter 6. coarse instruction 161 Why 1. Usip 14 TMC ABC Coily for the VEI. MES fondu Ye Master Production Schedule 1 2 3 We Number 4 5 6 Product 10 25...

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) Instructor: to your instructor. The tabs (bottom of each...

1 Possible contracting to provide Call Centre services You are Data Analysts working for a Call Centre Outsourcing firm. There is a potential client, who has been running their own call center for...

Cutting Edge This case was adapted from Hiller, Frederick S. & Mark S. Hillier (2014). Introduction to Management Science: A Modeling and Case Studies Approach with Spreadsheets, 5th ed.,...

You need the weekly rated capacity & "effective number of hours per day per machine" for the Cap-load profiles. Make capacity-load charts for Work Centers A, B, C, D, E and F based on the work center...

Consider the situation faced in the 1990s by Carolina Distributors, a Fortune 500 distributor of medical and surgical supplies. Sales had more than tripled in five years (325%) to nearly $3 billion....

A truck owned by Johnson Construction Company needed repairs. John Robert Johnson, Jr., the companys president, took the truck with its attached fifteen- ton trailer to Bubba Shaffer, doing business...

An increasing number of Americans are moving to a warmer climate when they retire. To take advantage of this trend, Sunny Skies Unlimited is undertaking a major real estate development project. The...

You download a new app to your phone. You consent to the developer's privar statement, which states that your personal information will not be shared. Th developer then sells your personal...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...