Get Instant Help From 5000+ Experts For
question

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing:Proofread your work by experts and improve grade at Lowest cost

And Improve Your Grades
myassignmenthelp.com
loader
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Attach file

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!
Free Quote
wave
Linear Programming Model for maximizing net profit with input constraints
Answered

Input values for the model

  1. If we still use the product mix model with some revisions here. Now, there are six available models, not just two. Each computer must be assembled and then tested, but there are now three lines for testing.

The inputs for the model are same here as before: (1) the hourly labor costs for assembling and testing, (2) the required labor hours for assembling and testing any computer model, (3) the cost of component parts for each model, (4) the selling prices for each model, (5) the maximum sales for each model, and (6) labor availabilities. These input values are listed in the file HW_09. xlsx. Similarly, the company needs to determine the product mix that maximizes its total net profit.

Pleaseuse LP to find the mix of computer models that maximizes total net profit and stays within the labor hour availability and maximum sales constraints.conduct the sensitivity analysis test for the model and choose two values from the Variable Cells and Constraints respectively to interpret.

Cost per labor hour assembling    $11                    
Cost per labor hour testing, line 1    $19                    
Cost per labor hour testing, line 2    $17                    
Cost per labor hour testing, line 3    $14                    
                        
Inputs for assembling and testing a computer                        
    Model 1    Model 2    Model 3    Model 4    Model 5    Model 6
Labor hours for assembly    4    5    5    5.5    5.5    5.5
Labor hours for testing, line 1    1.5    2    2    2.5    2.5    2.5
Labor hours for testing, line 2    2    2.5    2.5    3    3    3.5
Labor hours for testing, line 3    1    1    1.5    2    2.5    1
Cost of component parts    $150    $225    $225    $250    $250    $250
Selling price    $350    $460    $470    $500    $525    $530
Unit margin, tested on line 1                        
Unit margin, tested on line 2                        
Unit margin, tested on line 3                        
                        
Assembling, testing plan (# of computers)                        
    Model 1    Model 2    Model 3    Model 4    Model 5    Model 6
Number tested on line 1                        
Number tested on line 2                        
Number tested on line 3                        
Total computers produced                        
                        
Maximum sales    1500    1250    1250    1000    1000    1000
                        
Constraints (hours per month)    Hours used    Hours available                
Labor availability for assembling        20000                
Labor availability for testing, line 1        5000                
Labor availability for testing, line 2        6000                
Labor availability for testing, line 3        7000                

support
close