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 2 P78 89 81 32 33 3 P82 4 39 43 40 92 90 4 P79 63 58 The company wants to know how many units of each product to produce on each machine to maximize profit. Solve the model by using the computer.
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 2 P78 89 81 32 33 3 P82 4 39 43 40 92 90 4 P79 63 58 The company wants to know how many units of each product to produce on each machine to maximize profit. Solve the model by using the computer.
Chapter10: Short-term Decision Making
Section: Chapter Questions
Problem 12EB: Power Corp. makes 2 products: blades for table saws and blades for handsaws. Each product passes...
Related questions
Question
100%
PLEASE USE EXCEL ON ANSWERING THE QUESTIONS. MAKE SURE TO TAKE A SCREENSHOT STEP BY STEP OF HOW YOU DID THE SOLUTIONS IN EXCEL. ANSWER THIS COMPLETELY TO GET AN UPVOTE. I POSTED A LOT OF THIS, IF YOU SEE THIS AGAIN, YOU CAN SEND THE SAME SOLUTIONS, I WILL STILL UPVOTE DO NOT WORRY, JUST GIVE ME THE CORRECT SOLUTIONS AND ANSWERS.
I REPEAT, ONLY EXCEL
![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
Product
1
2
3
40
38
1
P78
Machine
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
maximize profit. Solve the model by using the computer.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F6234a0cd-12fa-4df1-97b9-0316f6aad75b%2Fb02b78ba-2aee-4c15-9bad-27f2ebca2fd3%2F4j374fg_processed.png&w=3840&q=75)
Transcribed Image Text: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
Product
1
2
3
40
38
1
P78
Machine
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
maximize profit. Solve the model by using the computer.
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
![Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781337912020/9781337912020_smallCoverImage.jpg)
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
![Financial And Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781337902663/9781337902663_smallCoverImage.jpg)
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
![Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781337912020/9781337912020_smallCoverImage.jpg)
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
![Financial And Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781337902663/9781337902663_smallCoverImage.jpg)
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
![Managerial Accounting: The Cornerstone of Busines…](https://www.bartleby.com/isbn_cover_images/9781337115773/9781337115773_smallCoverImage.gif)
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
![Intermediate Accounting: Reporting And Analysis](https://www.bartleby.com/isbn_cover_images/9781337788281/9781337788281_smallCoverImage.jpg)
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
![Cornerstones of Cost Management (Cornerstones Ser…](https://www.bartleby.com/isbn_cover_images/9781305970663/9781305970663_smallCoverImage.gif)
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning