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

please use excel please use excel 3. Exercise Three: Tribeca Studio produces two types of

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!