Reference no: EM131099646

A furniture supplier, Acme Chairs, Inc., manufactures a Basic office chair and a Deluxe office chair.  Each Basic chair costs $25.00 to manufacture, and each deluxe office chair costs $40.00 to manufacture.  Acme Chairs wishes to determine the optimal production quantities per day for each chair model in order to minimize overall total cost.

The production of each chair requires three types of materials: Wood, Primer, and Paint.  The amount of material available per day to manufacture the chairs is as follows:

• 30 units of wood.
• 600 oz. of primer.
• 750 oz. of paint.

Each chair requires the materials as shown below:

Wood (units)	1.25	2.50
Primer (oz.)	3.00	7.50
Paint (oz.)	6.00	10.00

• State the Objective function mathematically.
• State the constraints mathematically.
• Do not solve the problem graphically.
• Instead, create an Excel Model for this Example.
• State the Objective function mathematically.
• State the constraints mathematically.
• Do not solve the problem graphically.
• Instead, create an Excel Model for this Example.
• Use Solver to determine the optimized solution.