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...
icon
Related questions
Question

Please do not give solution in image format thanku 

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
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
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
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.