Solve the Theory of Constraints problem.  Identify the constraint.  Be sure to show your best product mix and the net profit.

 

Home Insert Draw 1 K19 23 4 LO 5 69 AutoSave OFF 7 Paste 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 A A 7 min RM #1 $20/unit Ready Arial B I U v B Prod 100 $140/unit 100 units / week D 14 min Prob C 10 min fx D Page Layout 12 min C + B 10 min RM #2 $10/unit V Accessibility: Investigate v D 14 Formulas Data E V B 5 min A^ A A 10 min RM #3 $20/unit 25 26 A & B: 2 units of each resource 27 C & D: 1 unit of each resource 28 Available time: 2,400 minutes / week 29 Setup time: 25 minutes per machine per task 30 31 32 33 V Prod 200 $145/unit 120 units / week F E D 12 min Review G C 9 min B 8 min RM #4 $10/unit H View Automate I C 7 min ab Wrap Text B 7 min Prod 300 $130/unit 120 units/week RM #5 $20/unit Merge & Center v J Tell me D 11 min X PQhw2_F23 K Operating Expenses (not including RM): $12,000 / week General $ % 9 A 12 min RM #6 $10/unit V L RM #7 $5/unit .00 0 .00 .0 M V Conditional Format Formatting as Table N Cell Styles P Q Insert v Delete v Format v R WE v V S Sort & Filter O. Find & Select T a Comments Sensitivity U V Analyze Data Share W + 114%