Consider the Scenario Given Below

question 8

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.
-In which of the following cases is the Cell Value not equal to the right-hand side of the value of the constraint?

• A)total profit
• B)profit contribution of swivel chairs
• C)fabrication hours used
• D)market mixture excess no-swivel

---

Definitions:

Gross Profit Percentage

A financial metric that represents the gross profit as a percentage of net sales, indicating the efficiency of a company's production process.

Current Ratio

A financial metric that measures a company's ability to pay off its short-term liabilities with its short-term assets.

Current Assets

Assets that are expected to be converted into cash, sold, or consumed within one year or within the business's normal operating cycle if longer than a year.

Short-term Note

A financial instrument typically due for repayment within one year, often used for short-term financing needs.