Exhibit 3.1 The Following Questions Are Based on This Problem and Accompanying

question 69

Multiple Choice

Exhibit 3.1
The following questions are based on this problem and accompanying Excel windows.
Jones Furniture Company produces beds and desks for college students. The production process requires carpentry and varnishing. Each bed requires 6 hours of carpentry and 4 hour of varnishing. Each desk requires 4 hours of carpentry and 8 hours of varnishing. There are 36 hours of carpentry time and 40 hours of varnishing time available. Beds generate $30 of profit and desks generate $40 of profit. Demand for desks is limited, so at most 8 will be produced. The LP model for the problem is
-Refer to Exhibit 3.1. What formula should be entered in cell D8 in the accompanying Excel spreadsheet to compute the amount of carpentry used?

• A) =B4*B5+C4*C5
• B) =SUMPRODUCT(B8:C8,$B$4:$C$4)
• C) =SUM(B5:C5)
• D) =SUM(E8:E10)

---

Definitions:

Tall Structures

An organizational structure characterized by many levels of hierarchy, with a large number of management levels between the top executives and the lower-level employees.

Authority-And-Responsibility Principle

The principle that authority should equal responsibility when work is delegated.

Supervisor

An individual in a position of authority who oversees and directs the work of others to ensure tasks and objectives are completed effectively.

Subordinate

An employee who reports to a supervisor or manager, typically responsible for following directives and completing tasks assigned by their superior.