PROBLEM 4 The Pee Tool Shop has four heavy presses it uses to stamp out prefabricated metal covers and housings for electronic consumer products. All four presses operate differently and are of different sizes. Currently the firm has a contract to produce three products. The contract calls for 400 units of product 1; 570 units of product 2; and 320 units of product 3. The time (in minutes) required for each product to be produced on each machine is as follows: Product 1 2 3 1 35 40 38 Product 1 2 3 Machine 1 P78 67 84 2 41 36 37 Machine 1 is available for 150 hours, machine 2 for 240 hours, machine 3 for 200 hours, and machine 4 for 250 hours. The products also result in different profits, according to the machine they are produced on, because of time, waste, and operating cost. The profit per unit per machine for each product is summarized as follows: Machine 3 34 32 33 2 P78 89 81 4 39 43 40 3 P82 92 90 4 P79 63 58 The company wants to know how many units of each product to produce on each machine to |||
PROBLEM 4 The Pee Tool Shop has four heavy presses it uses to stamp out prefabricated metal covers and housings for electronic consumer products. All four presses operate differently and are of different sizes. Currently the firm has a contract to produce three products. The contract calls for 400 units of product 1; 570 units of product 2; and 320 units of product 3. The time (in minutes) required for each product to be produced on each machine is as follows: Product 1 2 3 1 35 40 38 Product 1 2 3 Machine 1 P78 67 84 2 41 36 37 Machine 1 is available for 150 hours, machine 2 for 240 hours, machine 3 for 200 hours, and machine 4 for 250 hours. The products also result in different profits, according to the machine they are produced on, because of time, waste, and operating cost. The profit per unit per machine for each product is summarized as follows: Machine 3 34 32 33 2 P78 89 81 4 39 43 40 3 P82 92 90 4 P79 63 58 The company wants to know how many units of each product to produce on each machine to |||
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
100%
The Pee Tool Shop has four heavy presses it uses to stamp out prefabricated metal covers and housings
for electronic consumer products. All four presses operate differently and are of different sizes.
Currently the firm has a contract to produce three products. The contract calls for 400 units of product
1; 570 units of product 2; and 320 units of product 3. The time (in minutes) required for each product
to be produced on each machine is as follows: SOLVE THE MODEL BY USING MS EXCEL
Transcribed Image Text:2:53 Sat, Jul 9 ..
PROBLEM 4
The Pee Tool Shop has four heavy presses it uses to stamp out prefabricated metal covers and housings
for electronic consumer products. All four presses operate differently and are of different sizes.
Currently the firm has a contract to produce three products. The contract calls for 400 units of product
1; 570 units of product 2; and 320 units of product 3. The time (in minutes) required for each product
to be produced on each machine is as follows:
Product
1
2
3
1
35
40
38
Product
1
2
3
2
1
P78
67
84
Machine
41 36 37
Machine 1 is available for 150 hours, machine 2 for 240 hours, machine 3 for 200 hours, and machine
4 for 250 hours. The products also result in different profits, according to the machine they are
produced on, because of time, waste, and operating cost. The profit per unit per machine for each
product is summarized as follows:
Machine
3
34
32
33
2
P78
89
81
4
39
43
40
3
P82
92
90
4
P79
63
58
The company wants to know how many units of each product to produce on each machine to
|||
O
11%
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 2 steps with 3 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education