ESTES FURNITURE COMPANY

The Estes Furniture Company produces and markets three types of credenzas (Classic, Modern and Continental) using three machine centers. The sales prices and times required per unit on the machine centers are displayed in Table 1.

Table 1. Sales prices and hours per unit
	Classic	Modern	Continental
Sales Prices	$350	$450	$525
Machine Center
Router	1.5	2.0	2.5
Sander	3.0	4.5	5.0
Polisher	2.0	2.5	3.0

The available machine center times in the upcoming week are 1250 hours (Router), 2400 hours (Sander) and 1750 hours (Polisher).

Marketing issues require that each of the three products must constitute at least 25% of the total number produced.

Create a Solver-based spreadsheet model to determine the number of each of the three credenza models to produce in the upcoming week in order to maximize revenue and solve the model.

Comments and Hints:

Be sure to use sumproduct, formulas that can be copied and range constraints.

ESTES FURNITURE COMPANY The Estes Furniture Company produces and markets three types of credenzas (Classic, Modern and Continental) using three machine centers. The sales prices and times required per unit on the machine centers are displayed in Table 1. Table 1. Sales prices and hours per unit Classic Sales Prices $350 Machine Center Router Sander Polisher 1.5 3.0 2.0 Modern $450 Continental $525 2.0 4.5 2.5 2.5 5.0 3.0 The available machine center times in the upcoming week are 1250 hours (Router), 2400 hours (Sander) and 1750 hours (Polisher). Marketing issues require that each of the three products must constitute at least 25% of the total number produced. Create a Solver-based spreadsheet model to determine the number of each of the three credenza models to produce in the upcoming week in order to maximize revenue and solve the model. Comments and Hints: 1 Be sure to use sumproduct, formulas that can be copied and range constraints