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

Transcribed Image Text:eBook
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
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.