Share
Explore BrainMass

Excel Solver Problem

Please give some feedback on setting up solver

Picnic Table Bench(separate) Armchair Chaise Lounge Available
Price $225 $225 $275 $300
Redwood (board Ft.) 22 6 7 8 4,500
Cedar (board ft) 12 4 4 0 3,600
12 inch fittings 18 4 0 2 2,250
8 inch fittings 12 4 6 6 2,075
Bolts 48 12 12 20 5,925
Labor(Hours) 20 5 8 12 4,800

Redwood costs $8 per board foot cedar costs $6 per board foot, 12 inch fittings cost $2.50 8 inch fittings cost $1.50 bolts cost $.50 the hourly wage rate and fringe benefits of the workers average $9.00 per hour.

Because of prior orders at least 50 benches and at least 40 chaise lounges must be produced. Use the excel Solver.

$2.19