Consider the Scenario Given Below

question 26

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.
-If a worker in the finishing department falls ill for a day and is unable to report to work,the overall profit will reduce by ________.

• A)$1,260
• B)$315
• C)$1801
• D)$630

---

Definitions:

Problem Solving Process

A systematic approach to addressing and resolving issues or obstacles, typically involving identifying the problem, analyzing possible solutions, and implementing an effective response.

Problem Solving Process

A systematic approach to addressing and finding solutions for complex or challenging situations or issues.

Commodore

Commodore was a prominent company in the computer industry during the 1980s, best known for its line of personal computers like the Commodore 64.

Business Market

A market where goods and services are sold by one business to another for use in production, resale, or general business operations.