Multiple Choice
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.
-Calculate the number of swivel chairs produced in a day.
A) 10.5 units
B) 5.25 units
C) 15 units
D) 30 units
Correct Answer:

Verified
Correct Answer:
Verified
Q83: Use the case below to answer the
Q84: Briefly explain the difficulties experienced while using
Q85: What is a feasible solution?
Q86: What are shadow prices? How are shadow
Q87: In linear optimization,the phrase "cannot exceed" specifies
Q89: In the constraints section obtained in solver
Q90: Decision variables are the unknown values that
Q91: How does Solver create names in reports?
Q92: Use the case below to answer the
Q93: Slack variables are always nonnegative.