AutoSave Off October 2021 Project Two Part Four (2) Search (Alt+Q) Lewis, Josh G File Home Insert Draw Page Layout Formulas Data Review View Help P Comment X General Insert M Calibri 2TO DX Delete Paste I B $ ~ % 9 obo Sensitive E Conditional Formatting Format as Table Cell Styles Styles Sort & Find & Filter - Select Analyze Data Format Undo Clipboard Font Alignment Number N Cells Editing Analysis Sensitivity A48 v: Xfx Throughput/unit B. D E F G H K LE M N 6 120 1 2 Pennhurst, Inc. manufactures a high-quality office desk, which is offered in both oak and walnut. The demand for the desks is 1000 units for the oak desk and 1500 for the walnut desk. 3 The desks are priced at $560 and $990 for the oak and walnut desks, respectively. The materials cost is $270 for the oak desk and $450 for the walnut desk. In addition, the company 4 has the following information for the four manufacturing processes (receiving, preparation, assembly and finishing) showing the amount of time (in minutes) required for each desk for each process, 5 and the total minutes of time available for each process. Time Required/unit Time Required/unit Time 7 Name Oak Walnut Available 8 Receiving 25 50 120,000 9 Preparation 80 120 320,000 10 Assembly 200 400,000 11 Finishing 60 40 150,000 12 13 Required: 14 1. Which process(es), if any, are constraints for the current level of demand? 15 2. Given any constraints identified in part (1) above, determine the best production and sales plan for the two types of tables, 16 This will be accomplished by performing all three steps based upon the structure below: (1) Identify the constraint (2) Identify the Most Profitable Product 17 and (3) Identify the Most Profitable Product Mix 18 4. Complete step four by addressing the two questions related the theory of constraints. 19 20 Answer to Part One: 21 22 Paste B09A I U B M 00 0 Forr 00 Cell Styles Styles Undo Clipboard Font IS Alignment Number IV Cell 2 A48 SIX v fx Throughput/unit . B D E F G H K 22 23 Answer to Part Two: 24 Step One: Identify the Constraint - Total Time Required for Each Activity for Given Demand 25 Time Slack 26 Oak Walnut Total Time Available Time 27 Receiving 28 Preparation 29 Assembly 30 Finishing 31 32 33 Step Two: Identify the Most Profitable Product 34 35 Oak Walnut 36 Price 37 Materials Cost 38 Throughput Margin 39 Constraint Time 40 Throughput/Time 42 Step Three: Identify the Most Profitable Product Mix 43 Oak Project 3 Part Four Ready Type here to search A LE Paste $ - % F Format as Table 9 Delete 3 B I So 4. 00 1000 Cell Styles Format Undo Clipboard Font Alignment Number Styles Cells Edi A48 v fx Throughput/unit c D G H 1 41 E * } } 42 Step Three: Identify the Most Profitable Product Mix 43 Oak 44 Walnut 45 Oak Walnut Total 47 Units 48 Throughput/unit 49 Total Throughput 50 51 Step Four. Use five to six sentences to address the following: 52 1. Explain the usefulness of the theory of constraints in the determination of the most profitable product mix for this furniture manufacturer. 53 2. Describe some ideas for improving the production process based upon the constraint, so the company can improve the total number of units produced for both products. 54 55 56 57 58 61 62