1, 2 and 3 please. I will post again for #4 We used the example of the Product M
ID: 2947421 • Letter: 1
Question
1, 2 and 3 please. I will post again for #4 We used the example of the Product Mix model from the textbook. But mind that some numbers are changed here. PC Tech company assembles and then tests eight models of computers, including model 1 to model 8. For the coming month, the company wants to decide how many of each model to assemble and then test. No computers are in inventory from the previous month, and because these models are going to be changed after this month, the company does not want to hold any inventory after this month. All necessary input variables and the objective are shown in the following excel spreadsheet PC Tech wants to know how many of each model it should produce (assemble and test) to maximize its net profit, but it cannot use more labor hours than are available, and it does not want to produce more than it can sell. Therefore, an LP model was employed to know the maximum total net profit while meeting the constraints. Assembling and testing computers Cost per labor hour assembling Cost per labor hour testing, ine 1 Cout per labor hour testing, line 2 $23 Inputs for assembling and testing a computer Model 1 Model 2 Model3 Model 4 Model 5 Model 6 Model 7 Model Labor hours for assembly abor hours for testing. Ine Labor hours for testing, ine 2 Cost of component parts Selling price Unit mangin, tested on line 1 Unit mangin, tested on ine2 5s s 2 25 25 25 335 5150 $225 225 $225$250 so o $300 205.50 $214.00 $134.00 $174.00 $210.00 $185.00 5190.00 517100 198.00 $2070 120 170 0 s 19 $17400 5166.0 Assembling testing plan of computers) Model 1 Model 2 Model3 Model 4 Model 5 Model& Model 7 Models tested on ine 1500 1250 Number tested on ine 2 Total computers produced 1500 1250 50 000 hours per month) Hours used 20000 5000 Labor availability for testing Ine 2 Net profit (S per month Tested on line 1 Model 1 Medel 2 Model 3 Model 4 Model S Model 6 Model 7 Model Totals 308250 $267,500 $21,750 0 0 0 o $597,500 00 S $54 438 5204 500 0 $258.38 856 438 variable Cells
Explanation / Answer
1.
The decision to be taken is how many of each model to be produced. So, the decision variables are
Number tested on line 1 Model 1
Number tested on line 1 Model 2
Number tested on line 1 Model 3
Number tested on line 1 Model 4
Number tested on line 1 Model 5
Number tested on line 1 Model 6
Number tested on line 1 Model 7
Number tested on line 1 Model 8
Number tested on line 2 Model 1
Number tested on line 2 Model 2
Number tested on line 2 Model 3
Number tested on line 2 Model 4
Number tested on line 2 Model 5
Number tested on line 2 Model 6
Number tested on line 2 Model 7
Number tested on line 2 Model 8
2.
We need to maximize net profit of PCTech Company. So, the name of the objective is Net Profit.
3.
The constraints are cannot use more labour hours than available and not to produce more than can sell.
Constraints are -
Total computers produced Model 1
Total computers produced Model 2
Total computers produced Model 3
Total computers produced Model 4
Total computers produced Model 5
Total computers produced Model 6
Total computers produced Model 7
Total computers produced Model 8
Labour availability for assembling
Labour availability for testing, line 1
Labour availability for testing, line 2
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.