Consider the scenario given below.Use Excel solver to answer the following question(s).
Peca Inc.is a small manufacturer of two types of office chairs,the swivel and no-swivel models.The manufacturing process consists of two principal departments: fabrication and finishing.The fabrication department has 24 skilled workers,each of whom works 7 hours per day.The finishing department has 6 workers,who also work a 7-hour shift.A swivel type requires 7 labor hours in the fabricating department and 2 labor hours in finishing.The no-swivel model requires 8 labor hours in fabricating and 3 labor hours in finishing.Peca Inc.makes a net profit of $100 on the swivel model,and $130 on the no-swivel model.The company anticipates selling at least twice as many no-swivel models as swivel models.The company wants to determine how many of each model should be produced on a daily basis to maximize net profit.
-Using the data,calculate the number of no-swivel chairs produced in a day.
A)10.5 units
B)5.25 units
C)15 units
D)30 units

Question

Quizplus · Accepted Answer

The correct answer is A. 10.5 units.The problem can be formulated as a linear programming problem with the following decision variables:x = number of swivel chairs produced per dayy = number of no-swivel chairs produced per dayThe objective function is to maximize net profit, which is given by:Z = 100x + 130yThe constraints are as follows:* Fabrication department: 7x + 8y <= 24 * 7* Finishing department: 2x + 3y <= 6 * 7* No-swivel chairs produced must be at least twice the number of swivel chairs produced: y >= 2x* Non-negativity constraints: x >= 0, y >= 0Using Excel Solver, we can solve this problem to find the optimal values of x and y. The optimal solution is x = 10.5 and y = 21. Therefore, the number of no-swivel chairs produced in a day is 21.

Consider the Scenario Given Below