Question
A furniture company manufactures desk and chairs. Each desk uses four units of wood and each chair uses three units of wood. A desk contributes
A furniture company manufactures desk and chairs. Each desk uses four units of wood and each chair uses three units of wood. A desk contributes $250 to profit, and a chair contributes $145. Marketing restriction require that the number of chairs produced be at lease four times the number of desks produced. There are 2,000 units of wood available. Use solver to maximize the profit.
A. What is the optimized company's profit?
For this answer I got $103,750 (this number was correct)
B. Select a graph
C. Use solvertable to see what happens to the decision variables and total profit when the availability of wood varies from 1,000 to 3,000 in 100-unit increments. Based on your findings, how much would the company be willing to pay for each extra unit of wood over its current 2,000 units? How much profit would the company lose if it lost any of it's current 2000 units. Round to nearest whole dollar amount.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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