Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The PENTEL Corporation manufactures three different types of computer chips. Each type of chip requires different amounts of processing time in three different departments
The PENTEL Corporation manufactures three different types of computer chips. Each type of chip requires different amounts of processing time in three different departments as summarized in the following table. Processing Hours Required per 100 Chips Chip A Chip B Hours Available Chip C Dept 1 3. 2 4 10,000 Dept 2 2 4 3 9,000 Dept 3 3 4 2 11,000 The total profit (in dollars) for each type of chip may be described as follows: Chip A profit = -0.36A + 8.29A + 540 Chip B profit = -0.6182 + 9.468 + 1,108 Chip C profit = -0.48C + 11.00C + 850 where A, B, and C represent the number of chips produced in 100s. (a) Formulate an NLP model for this problem to maximize profit (in dollars). MAX: Subject to: department 1 department 2 department 3 A, B, C, 0 (b) Implement your model in a spreadsheet and solve it. What is the optimal solution? (Round your numerical values to two decimal places.) (A, B, C) =
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started