Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
Use Excel/Solver add in for accurate answers. Problem 3-19 (Algorithmic) Better Products, Inc., manufactures three products on two machines. In a typical week, 40 hours
Use Excel/Solver add in for accurate answers. Problem 3-19 (Algorithmic) Better Products, Inc., manufactures three products on two machines. In a typical week, 40 hours are available on each machine. The profit contribution and production time in hours per unit are as follows: Category Product 1 Product 2 Product 3 Profit/unit $39 $51 $18 Machine 1 time/unit 1.5 Machine 2 time/unit Two operators are required for machine 1; thus, 2 hours of labor must be scheduled for each hour of machine 1 time. Only one operator is required for machine 2. A maximum of 90 labor hours is available for assignment to the machines during the coming week. Other production requirements are that product 1 cannot account for more than 50% of the units produced and that product 3 must account for at least 10% of the units produced required, round your answers to the nearest a. How many units of each product should be produced to maximize the total profit contribution whole number. If your answer is zero, enter "0" Product of units What is the projected weekly profit associated with your solution? Profit - $ b. How many hours of production time will be scheduled on each machine? Machine Hours Schedule: Machine 1 Hours Machine 2 Hours c. What is the value of an additional hour of labor? If required, round your answer to two decimal places. ) d. Assume that labor capacity can be increased to 100 hours. Develop the optimal product mix, assuming that the extra hours are made available. If required, round non-monetary answers to the nearest whole number. If required, round monetary answer to the nearest dollar. If your answer is zero, enter "0" Product # of units 1 Profit - $ In/takeAssignment/takeAssignmentMain.doinvokerStake AssignmentSessionLocator &inprogress-false Machine Hours Schedule: Machine 1 Hours Machine 2 Hours c. What is the value of an additional hour of labor? If required, round your answer to two decimal places. d. Assume that labor capacity can be increased to 100 hours. Develop the optimal product mix, assuming that the extra hours are made available. If required, round non-monetary answers to the nearest whole number. If required, round monetary answer to the nearest dollar. If your answer is zero, enter "0". Product # of units Profit - $ Would you be interested in using the additional 10 hours available for this resource
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669bfeae88b30_304669bfea8db156.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669bfeb0835bf_311669bfeafc9d66.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669bfeb16bdb4_312669bfeb0c70be.jpg)
Use Excel/Solver add in for accurate answers.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started