Problem II - Use the information of the line composed of the tasks shown in the following table (time is in minutes) to answer the following questions.Time (Minutes)221422TaskABC23DEFGThere are 238 labor days per year, each day are worked 2 shifts of 7.5 hours each one. Annual production is 42,840 units.0 0 0 0Assuming the same assignment of tasks per stations shown in the previous question, calculate the efficiency of station II.80%93.3 %100%O O O O90%1844.5Predecessor80%AA.B.C.DEFAssuming the same assignment of tasks per stations shown previously, calculate the efficiency of the line.88.75%85.45%93.3%

Here, I have been given the table data, this table data includes Task Id, time in minutes for each…

Answered: Assuming the same assignment of tasks…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Use excel to show formulas 1. A company is designing a product layout for a new product. They plan to use this production line 16 hours a day in order to meet forecasted demand of 1200 units per day. For output to equal forecasted demand, what should be the actual cycle time for this production?
The effective capacity and efficiency for the next quarter at MMU Mfg. in Waco, Texas, for each of three departments are shown: Compute the expected production for next quarter for each department.
The design capacity for car workshop in a company is 110 cars per week. The effective capacity is 95 cars per week and the actual output for this week was 88 cars. If the utilization for next week is expected to be 70%, then the expected output is (...................) cars per week. Answer:
(Please apply indifference point formula for this exercise) 1. The school cafeteria can make pizza for approximately $0.30 per slice. The cost of the kitchen use and cafeteria staff runs about $200 per day. The Pizza Den nearby will deliver whole pizzas for $9.00 each. The cafeteria staff cuts the pizza into eight (8) pieces and serves them in the usual cafeteria line. With no cooking duties, the staff can be reduced by half, for a ﬁxed cost of $75 per day. Should the school cafeteria make or buy pizza? Calculations are needed to justify the answer. (Please apply the indifference point formula for this exercise). Excel spreadsheet would be great!.
A small firm intends to increase the capacity of a bottleneck operation for producing a product by adding a new machine. Two alternatives, A and B, have been identified and the associated costs and revenues have been estimated. Annual fixed costs would be $30000 for A and $25,000 for B; variable costs per unit would be $10 for A and $12 for B; and the revenue per unit would be $25. i. Find the total cost functions for alternatives A and B, and the revenue function ii. Draw both the total cost functions and the revenue function in the same figure. iii. Find the break-even point for the alternatives A and B and show it in the figure iv. Is there any volume of output at which both the alternatives yield the same profit? If so, show it in the figure. If not, identify the volume of output at which the alternatives are indifferent
Jack has gathered the following information for Work Center 2, the work center that directly feeds Work Center 3. Complete the input/output analysis of Work Center 2. Input Information(in hours) 4 5 6 7 8 Planned input 60 70 70 80 80 Actual input 15 25 25 30 30 Output Information(in hours) 4 5 6 7 8 Planned output 40 70 70 80 80 Actual output 45 45 45 55 80 Backlog165 hours Jack has asked you to calculate the following for Work Center 2. Calculate the percentage of available output that was actually accomplished (actual output/planned output) at Work Center 2.(Round your answers to 1 decimal place, e.g. 17.5.) 4 5 6 7 8 Actual outputPlanned output · 100% enter percentages % enter percentages % enter percentages % enter percentages % enter percentages %
Jack has gathered the following information for Work Center 2, the work center that directly feeds Work Center 3. Complete the input/output analysis of Work Center 2. Input Information(in hours) 4 5 6 7 8 Planned input 60 70 70 80 80 Actual input 15 25 25 30 30 Output Information(in hours) 4 5 6 7 8 Planned output 40 70 70 80 80 Actual output 45 45 45 55 80 Backlog165 hours Jack has asked you to calculate the following for Work Center 2. (a) Calculate the percentage of planned output needed to complete the planned inputs [(planned input + backlog)/ planned output] at Work Center 2.(Round your answers to 1 decimal place, e.g. 17.5.) 4 5 6 7 8 Percentage of planned output · 100% enter percentages % enter percentages Percentages shoul be # 4 through 8
Jack has gathered the following information for Work Center 2, the work center that directly feeds Work Center 3. Complete the input/output analysis of Work Center 2. Input Information(in hours) 4 5 6 7 8 Planned input 60 70 70 80 80 Actual input 15 25 25 30 30 Output Information(in hours) 4 5 6 7 8 Planned output 40 70 70 80 80 Actual output 45 45 45 55 80 Backlog165 hours Jack has asked you to calculate the following for Work Center 2. alculate the percentage of planned input that actually happened [(actual input + backlog)/(planned input + backlog)] at Work Center 2.(Round your answers to 1 decimal place, e.g. 17.5.) 4 5 6 7 8 Actual input + Backlog Planned input + Backlog · 100% enter percentages % enter percentages % enter percentages % enter percentages % enter percentages %
(a) What is the cycle time necessary to achieve the desired rate of production?(b) Using the longest element rule, create workstations to balance the line,attempting to get as close as possible to the theoretical minimum numberof workstations.(c) What is the efficiency and idle time of the line balance?(d) The company considers that if the lamps are successful with the publicit may need to increase production to 30,000 units. The company thinksthe simplest solution is to obtain two more production lines, thus havingtriple capacity. Another option is to re-balance the line. Considering thata single worker is assigned to a work station, determine which option(more production lines or re-balancing) yields the smallest labour size.
Smart Kids Wonderland has decided to manufacture a new train toy set. The production process consist of which is broken into seven steps and the demand for the train is 1280 units. If the company have an eight hours operating time per day with a desired output of 1280 units per day as display in Table 4. Determine the following: (Hint: Provides the answers in two decimal points) Task Time (seconds) Predecessors A 16 - B 17 A C 10 A D 12 B E 8 C F 15 D,E G 20 F (a) Draw the diagram and calculate for the appropriate cycle time.(b) The minimum number of stations needed to achieve the appropriate cycle time.(c) The assembly line efficiency rate. Comment on the answer.
The Sun River beverage company is a regional producer of teas, exotic juices, and energy drinks. With an interest in healthier lifestyles, there has been an increase in demand for its sugar-free formulation. The final packing operation requires 13 tasks. Sun River bottles its sugar-free product 5 hours a day, 5 days a week. Each week, there is a demand for 3,000 bottles of this product. TASK TIME (MINUTES) PRECEDING TASK 1 0.1 — 2 0.1 1 3 0.1 2 4 0.2 2 5 0.1 2 6 0.2 3, 4, 5 7 0.1 1 8 0.1 7 9 0.2 8 10 0.1 9 11 0.2 6 12 0.2 10, 11 13 0.1 12 Using the following data, solve the assembly-line balancing problem and calculate the efficiency of your solution. Use the longest task time for your decision criteria. Note: Round your answer to the nearest whole percent.
The XYZ company produces all type of office furniture. The “Executive Secretary” is a chair that has been designed using ergonomics to provide comfort during long office hours. The chair sells for $130. There are 480 minutes available during the day, and the average daily demand has been 50 chairs. There are eight tasks; Task Time (min) Immediate predecessor A 4 - B 7 - C 6 A, B D 5 C E 6 D F 7 E G 8 E I 6 F, G a) Draw a precedence diagram of this operation b) What is the cycle time for this operation? c) What is the theoretical minimum number of workstations? d) Assign tasks to the workstations e) What is the idle time per cycle? f) What is the efficiency of the assembly line?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

Assuming the same assignment of tasks per stations shown in the previous question, calculate the efficiency of station II. 80% 93.3% 100% 90% Assuming the same assignment of tasks per stations shown previously, calculate the efficiency of the line. 80% 88.75% 85.45% 93.3%