A Furniture Manufacturer Produces Three Products,desks,tables,and Chairs

question 19

Essay

A furniture manufacturer produces three products,desks,tables,and chairs.These products can be produced during either the morning shift or the evening shift.The morning shift has a labor cost of $20 per hour with a maximum availability of 20,000 hours.The evening shift has a labor cost of $25 per hour and is limited to 15,000 hours.The labor,lumber,and demand requirements are given as follows:

Assume that there are 20,000 pounds of lumber and 20,000 pounds of nails available for both shifts.
Use Excel to formulate and solve this problem to minimize total labor cost.

---

Definitions:

All-Or-None

The All-Or-None principle is a rule stating that the strength of a response of a nerve or muscle fiber is not dependent on the strength of the stimulus; if the stimulus exceeds the threshold, a complete response is generated.

Non-Decremental Fashion

Describes a process that does not decrease or diminish in size, importance, or intensity over time or distance.

Strength of Stimulus

A parameter that influences the magnitude of a physiological response, where greater stimuli typically induce stronger responses.

Glial Cells

In the central and peripheral nervous system, these are the non-neuronal cells that provide support and protection for nerve cells.