Abbott Manufacturing produces plastic cases for solar photovoltaic panels and has decided to combine orders from customers to increase work order size, and thereby make one large production run per model type. Plastic injection molding machines are used to make these parts, and it is time consuming to clean the machines and set them up again between production runs. Each molding machine and operator works one 8-hour shift with a one-hour lunch break and one-half hour for operator breaks. Consolidated Work Orders Model XVT-5 Case Model UYT-3 Case Model KLY-6 Case Work Order Quantity 9,700 panels To do this work in 1 day they need To do this work in 2 days they need To do this work in 3 days they need 7,100 11,200 Setup (Changeover) Time per Work Order (Minutes) 88 78 160 Processing Time per Panel machine(s). machine(s). machine(s). (Seconds) 2.00 2.84 What is the total workload (demand) in hours for this work order mix? Round your answer to one decimal place. The total workload is hours. How many machines are needed to do this work in 1, 2, or 3 days? Round your answers up to the nearest whole number. 3.91
Abbott Manufacturing produces plastic cases for solar photovoltaic panels and has decided to combine orders from customers to increase work order size, and thereby make one large production run per model type. Plastic injection molding machines are used to make these parts, and it is time consuming to clean the machines and set them up again between production runs. Each molding machine and operator works one 8-hour shift with a one-hour lunch break and one-half hour for operator breaks. Consolidated Work Orders Model XVT-5 Case Model UYT-3 Case Model KLY-6 Case Work Order Quantity 9,700 panels To do this work in 1 day they need To do this work in 2 days they need To do this work in 3 days they need 7,100 11,200 Setup (Changeover) Time per Work Order (Minutes) 88 78 160 Processing Time per Panel machine(s). machine(s). machine(s). (Seconds) 2.00 2.84 What is the total workload (demand) in hours for this work order mix? Round your answer to one decimal place. The total workload is hours. How many machines are needed to do this work in 1, 2, or 3 days? Round your answers up to the nearest whole number. 3.91
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...
Related questions
Question
Please do not give solution in image format thanku
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
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
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
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.