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.

Question

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.

Quizplus · Accepted Answer

The Answer of 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.

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