X AutoSave @ Off H Lewis_Josh_Project Two Part Four (2) - Search (Alt+Q) A Lewis, Josh G U X File Home Insert Draw Page Layout Formulas Data Review View Help Comments Share ab General 11 ~ A" A" Conditional Formatting Insert Calibri =1 AY O $ ~ % " Format as Table Delete GI Paste B EE Sort & Find & Analyze Sensitivity Cell Styles * Format Filter * Select v Dat Undo Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity A19 : XV fx Step Four: Use five to six sentences to address the following: A B D E F G H J K L M N O P Q 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. W 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, and the total minutes of time available for each process. Time Required/unit Time Required/unit Time Name Oak Walnut Available 8 Receiving 25 50 120,000 9 Preparation 80 120 320,000 10 Assembly 120 200 400,000 11 Finishing 60 40 150,000 12 13 Required: 14 15 16 17 18 Complete step four by addressing the two questions related the theory of constraints. 19 Step Four: Use five to six sentences to address the following: 20 1. Explain the usefulness of the theory of constraints in the determination of the most profitable product mix for this furniture manufacturer. 21 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. 22 Project 3 Part Four + Ready Count: 3 + 100% 6:57 PM Type here to search O E M 9 0 2 W ? 30 F 11/26/2021