Nt1310 Unit 2 Regression Analysis Paper

972 Words4 Pages
Question 1 In summary: Product Line 1 (time in minutes) Line 2 (time in minutes) Profit ( $ ) X1 SUPER 3 4 42 X2 EXCELLENT 6 2 87 Let X1 = Number of SUPER model produced during 8 hour shift. X2 = Number of EXCELLENT model produced during 8 hour shift. Max 42X1 + 87X2 ST X1 + X2 ≤ 480 3X1 + 6X2 ≤ 480 4X1 + 2X2 ≤ 480 X1, X2 ≥ 0 It is recommended to produce 80 units of EXCELLENT and none SUPER in order to get the maximum profit (See attached print-out, table № 1). If the company wants to produce SUPER, the maximum profit will reduce by $1.5 per each unit, with $6960 - $1.5 = $6958.5 (See attached print-out, table № 2). As the company has extra 320 minutes…show more content…
John A. Lawrence and Jr. Barry A. Pasternack (2002, pp. 49) indicate that the Linear programming gives the solution according to the parameters input that are assumed to be constant but in real life situations they could not be constant and it is not really known. 2. The spreadsheet indicates the fixed profit margin but selling price can not be constant as it is indicated by the market. (John A. Lawrence and Jr. Barry A. Pasternack, 2002) 3. The company can not stop producing Super according to the market demand as it might be available to everybody. Also it wants to use the 8-hour shift per day while the spreadsheet indicates that there will be about 5 hours and a half of unused time because linear programming does not take into consideration the time. (John A. Lawrence and Jr. Barry A. Pasternack, 2002) Question 3 Let X1 = Number of SUPER model produced during 8 hour shift. X2 = Number of EXCELLENT model produced during 8 hour shift. Max 42X1 + 87X2 ST X1 + X2 ≤ 480 3X1 + 6X2 ≤ 480 4X1 + 2X2 ≤ 480 X1 ≥ X2 X1, X2 ≥…show more content…
X2 = Number of EXCELLENT model produced during 8 hour shift. Max 42X1 + 87X2 ST X1 + X2 ≤ 480 3X1 + 6X2 ≤ 480 4X1 + 2X2 ≤ 480 X1 ≥ X2 3X1 + 6X2 ≤ 4X1 + 2X2 + 30 3X1 + 6X2 ≤ 4X1 + 2X2 – 30 X1, X2 ≥ 0 If the management limits the difference between Line 1 and Line 2 up to 30 minutes, it is recommended to produce about 96.667 (or 97) units of SUPER and 31.667 (or 32) units of EXCELLENT in order to maximize the total profit. Even it gives $65 reduction on initial profit, there will be more efficient balance on workload where time for Line 1 is fully utilized and on Line 2 there is only 30 minutes of unused time. (See attached print-out, table № 6) Question 6 Let X1 = Number of SUPER model produced during 8 hour shift. X2 = Number of EXCELLENT model produced during 8 hour shift. Max X1 + X2 ST X1 + X2 ≤ 480 3X1 + 6X2 ≤ 480 4X1 + 2X2 ≤ 480 X1, X2 ≥

More about Nt1310 Unit 2 Regression Analysis Paper

Open Document