Question: please use excel 3. Exercise Three: Tribeca Studio produces two types of chairs, one is an economic, office model (model X), whereas the other is
3. Exercise Three: Tribeca Studio produces two types of chairs, one is an economic, office model (model X), whereas the other is a more sophisticated, recliner (model Y). Based on daily historical data, management expects a demand of at least 110 units for model X, and at least 95 for model Y. In addition, due to limited capacity on the assembly line, production of model X cannot exceed 185 units, and 226 units for model Y respectively. What's more, due to a contractual obligation to a dealer, at least 200 total units must be send every day. If the sale of each model X unit yields a profit of $70.25, and each modely unit yields a $40.99 profit, how many units of each type should be made daily to maximize profits? (Hint: Use the simplex algorithm as shown in class). (3 Points)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
