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:

Positive Romberg Sign

A sign of neurological dysfunction where a person sways or falls when standing with feet together and eyes closed, indicating proprioceptive or vestibular impairment.

Sternomastoid

A major muscle in the neck that runs from the sternum and clavicle to the mastoid process of the temporal bone, involved in head movement and rotation.

Anterior and Posterior Triangles

Regions of the neck divided by the sternocleidomastoid muscle into front (anterior) and back (posterior) areas.

Hydrocephalus

A condition characterized by an abnormal buildup of cerebrospinal fluid in the ventricles of the brain.