Here is example 2

Here is example 2 solution

Here is what I actually need solved:

Solve for the net profit for the week. Be sure to identify your constraint and show the best product mix.

Prod 100 Prod 200 Prod 300 $125 / unit 90 units / week $130 / unit 100 units / week $100 / unit 120 units / week D 9 min D 7 min D 8 min RM #7 $5/unit 10 min B 11 min C 12 min 9 min A 5 min B 10 min A 10 min B 7 min B 6 min A 12 min RM #1 RM #2 RM #3 RM #4 RM #5 RM #6 $20/unit $10/unit $20/unit $10/unit $20/unit $10/unit A & B: 2 units of each resource C&D: 1 unit of each resource Available time: 2,400 minutes / week Operating Expenses (not including RM): $11,000 / week Setup time: 20 minutes per machine per task A) Identify the constraint: : Product Units/ Week 1001 200 300 Setup time Time Reg. Capacity 1% above capacity Worker A Worker B Worker C Worl Time/Unit Total Time/Unit Total Time/Unit Total Time/Unit 90 151 1350 21 1890 10 9001 9 100 10 1000 18 1800 12 1200 7 120 12 1440 6 720 91 1080 8 60 80 60 3850 4490 3240 48000 4800 2400 0.8021 0.9354 1.3500 ker D Total 8101 700 960 60 2530 2400 1.0542 B) Throughput per unit: Selling Price / Unit Material Cost/Unit Throughput / Unit Prod 100 $ 125 $ 50 $ 75 Prod 200 $ 130 $ 30 $ 100 Prod 300 $ 100 $ 35 $ 65 C) Throughput per constraint minute and product priorities: Prod 100 Throughput / Unit $ 75 Constraint time / unit (minutes) 10 Throughput / Constraint time $ 7.50 Product Priority #2 Prod 200 $ 100 12 $ 8.33 #1 Prod 300 $ 65 9 $ 7.22 #3 D) Best Product Mix Units/ Week Worker C Time/Unit 100 12 90 10 26 9 Product 200 Product 100 Product 300 Setup time Total Time Capacity Total 1200 900) 2100 234 26.6666667 60 2394 2400 E) Maximum Expected Profit per Week: Units/Week T/ Unit Total T Product 200 100 $ 100 $ 10,000 Product 100 901 $ 75$ 6,750 Product 300 26 $ 65 $ 1,690 Total Throughput $ 18,440 Total Throughput Operating Expenses Net Profit per Week $ 18,440 $ 11,000 $ 7,440 Prod 100 Prod 200 Prod 300 $140 / unit 100 units / week $145 / unit 120 units / week $130 / unit 120 units / week D 14 min D 12 min D 11 min RM #7 $5/unit C 10 min B 5 min C 9 min 7 min A 7 min B 10 min 10 min B 8 min B 7 min 12 min RM #1 RM #2 RM #3 RM #4 RM #5 RM #6 $20/unit $10/unit $20/unit $10/unit $20/unit $10/unit A & B: 2 units of each resource C&D: 1 unit of each resource Available time: 2,400 minutes / week Operating Expenses (not including RM): $12,000 / week Setup time: 25 minutes per machine per task