Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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)
please use excel
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started