Homework SourseHelp using Excel please During the course of the current pro
Help using Excel please:
During the course of the current production cycle, the owner of the woodworking company discussed in the preceding problem discovers that his assumption regarding customers being interested in buying tables and chairs individually rather than in sets is incorrect.The vast majority of his customers are indicating that they are only interested in purchasing table and chair in sets, with each set consisting of one table and four chairs.Without revising the previously stated general guidelines or previously LP model for problem 2, answer the following questions based upon only being able to sell the tables and chairs produced in complete sets:
How many complete table and chair sets can the company assemble from the optimal number of tables and chairs produced during the current production cycle?
How many excess tables will the company have left in inventory at the end of the current production cycle?
How many excess chairs will the company have left in inventory at the end of the current production cycle?
What is the total amount of profit that the company would potentially earn, assuming that excess tables or chairs do not contribute to profit earned during the current production cycle?
| USING SOLVER WE HAVE | |||||
| Table | Chair | Total | Constraint | Available | |
| Decision Variable | 179.6875 | 31.25 | |||
| Contribution | 250 | 65 | 46953.13 | ||
| Wood | 4.0 | 1.0 | 750 | <= | 750.0 |
| Fabrication labor | 20.0 | 45.0 | 5000 | <= | 5000.0 |
| Assembly labor | 2.0 | 4.0 | 484.375 | <= | 1225.0 |
| Finishing labor | 12.0 | 8.0 | 2406.25 | <= | 3250.0 |
| Packaging labor | 1.0 | 1.0 | 210.9375 | <= | 500.0 |
Solution
How many complete table and chair sets can the company assemble from the optimal number of tables and chairs produced during the current production cycle?
7 TABLES AND 28 (7*4)CHAIRS
How many excess tables will the company have left in inventory at the end of the current production cycle?
179-7 = 172 TABLES
How many excess chairs will the company have left in inventory at the end of the current production cycle?
31 - 28 = 3 CHAIRS
What is the total amount of profit that the company would potentially earn, assuming that excess tables or chairs do not contribute to profit earned during the current production cycle?
7*250 + 28*65 = 3570
$3570
