B20 × ✓ fx A 1 Decision Variables 2 Products 12345678 5 Objective Function 6 Profit 9 10 Constraints 11 12 Demand Constraints 13 XA 14 XB 15 XC 16 xD 17 XE 18 xF C D E F G H J K L M N P Q =607*B3+3*C3+12*D3+6*E3+18*F3+17*G3 B A B C D E 1 1 1 1 1 LHS 19 Testing Equipment Time Constraints 20 T1 21 T2 22 T3 23 24 25 26 Decision Variables are Integer 27 Non-Negativity 28 VI VI VI VI VI VI VI VI RHS |=607*B3+3*C3+12*D3+6*E3+18*F3+17*G3 644 622≤ 100 80 F 1 X_A0X_BOX_C0X_D>=0X_E=0X_F>=0 File Home Insert Draw Design Layout References Mailings Review View Help Х Aptos Display (Head | 11 ▾ Aˆ A Paste BIU ab X x² A Aa A A ▾ ་ Normal No Spacing Heading Heading 2 Title H v Clipboard ✓ Font ✓ Paragraph √☑ Styles QUESTION 1 - LINEAR PROGRAMMING An auto part manufacturer sells six different parts to automobile companies: spot lights (A), break lights (B), headlights (C), thermostat (D), fan ditch (E), and battery (F). Demand is expected to be within 2,000, 1,500, 1,800, 1,200, 1,000 and 1,000 units of each of the auto parts, respectively. The table that follows summarizes the revenues and material costs for each product: Auto Parts Produced Price per Unit Material Cost per Unit A B C D E F 200 120 180 200 430 260 35 25 40 45 170 60 Each of these auto parts needs to be tested before being sold. Specifically, there are three different tests the protocol requires each part passes, before completing the quality check. Appropriate testing equipment is required for each test: T1, T2 and T3. Equipment T1 and T2 are available 100 hours per week each, while T3 is available only 80 hours per week. The time (in minutes) required per device for each of the three tests is reported in the following table: Electronic Devices Produced A B C D E F Test on T1 7 3 12 6 18 17 Test on T2 2 5 3 2 15 17 Test on T3 5 1 3 2 9 2 Specialized personnel is required to operate each of the test equipment. The variable labour costs are £16 per hour for equipment T1, £12 per hour for T2, and £20 per hour for T3. A) Considering the manufacturer intends to maximize profit, write a linear program for this problem and find a solution with Excel Solver. Reflect on whether to impose a constraint on the nature of the decision variables. K>> Comments Find ▾ Editing Share Ө Replace Select Editor Dictate Add-ins Editing Voice Editor Add-ins
B20 × ✓ fx A 1 Decision Variables 2 Products 12345678 5 Objective Function 6 Profit 9 10 Constraints 11 12 Demand Constraints 13 XA 14 XB 15 XC 16 xD 17 XE 18 xF C D E F G H J K L M N P Q =607*B3+3*C3+12*D3+6*E3+18*F3+17*G3 B A B C D E 1 1 1 1 1 LHS 19 Testing Equipment Time Constraints 20 T1 21 T2 22 T3 23 24 25 26 Decision Variables are Integer 27 Non-Negativity 28 VI VI VI VI VI VI VI VI RHS |=607*B3+3*C3+12*D3+6*E3+18*F3+17*G3 644 622≤ 100 80 F 1 X_A0X_BOX_C0X_D>=0X_E=0X_F>=0 File Home Insert Draw Design Layout References Mailings Review View Help Х Aptos Display (Head | 11 ▾ Aˆ A Paste BIU ab X x² A Aa A A ▾ ་ Normal No Spacing Heading Heading 2 Title H v Clipboard ✓ Font ✓ Paragraph √☑ Styles QUESTION 1 - LINEAR PROGRAMMING An auto part manufacturer sells six different parts to automobile companies: spot lights (A), break lights (B), headlights (C), thermostat (D), fan ditch (E), and battery (F). Demand is expected to be within 2,000, 1,500, 1,800, 1,200, 1,000 and 1,000 units of each of the auto parts, respectively. The table that follows summarizes the revenues and material costs for each product: Auto Parts Produced Price per Unit Material Cost per Unit A B C D E F 200 120 180 200 430 260 35 25 40 45 170 60 Each of these auto parts needs to be tested before being sold. Specifically, there are three different tests the protocol requires each part passes, before completing the quality check. Appropriate testing equipment is required for each test: T1, T2 and T3. Equipment T1 and T2 are available 100 hours per week each, while T3 is available only 80 hours per week. The time (in minutes) required per device for each of the three tests is reported in the following table: Electronic Devices Produced A B C D E F Test on T1 7 3 12 6 18 17 Test on T2 2 5 3 2 15 17 Test on T3 5 1 3 2 9 2 Specialized personnel is required to operate each of the test equipment. The variable labour costs are £16 per hour for equipment T1, £12 per hour for T2, and £20 per hour for T3. A) Considering the manufacturer intends to maximize profit, write a linear program for this problem and find a solution with Excel Solver. Reflect on whether to impose a constraint on the nature of the decision variables. K>> Comments Find ▾ Editing Share Ө Replace Select Editor Dictate Add-ins Editing Voice Editor Add-ins
Economics Today and Tomorrow, Student Edition
1st Edition
ISBN:9780078747663
Author:McGraw-Hill
Publisher:McGraw-Hill
Chapter5: Buying The Necessities
Section: Chapter Questions
Problem 20AA
Related questions
Question
hello so i got a question and i need to use linear programming and i answered it only half can you show me how and the answer using excel for the question please.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Economics Today and Tomorrow, Student Edition
Economics
ISBN:
9780078747663
Author:
McGraw-Hill
Publisher:
Glencoe/McGraw-Hill School Pub Co
Economics Today and Tomorrow, Student Edition
Economics
ISBN:
9780078747663
Author:
McGraw-Hill
Publisher:
Glencoe/McGraw-Hill School Pub Co