Consider the Scenario Given Below

question 10

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.
-Determine the objective function.

• A)Minimize profit = 5.375X₁ + 10.75X₂
• B)Minimize profit = 130X₁ + 100X₂
• C)Maximize profit = 100X₁ + 130 X₂
• D)Maximize profit = 24X₁ + 14X₂

---

Definitions:

Eating Disorder

Mental disorders characterized by abnormal or disturbed eating habits, such as anorexia nervosa or bulimia nervosa.

Predictive Validity

The extent to which a score on a scale or test predicts future performance on a related outcome.

Independent Variable

In an experimental setup, the variable that is manipulated or changed to observe its effect on a dependent variable.

Dependent Variable

In an experimental setting, the variable that is being tested and measured, which is expected to change as a result of manipulations to the independent variable.