Question: I need to solve this problem on excel and I am so lost, can you help? A manager must decide on the mix of products
I need to solve this problem on excel and I am so lost, can you help?
A manager must decide on the mix of products to produce for the coming week. Product A requires three minutes per unit for molding, two minutes per unit for painting, and one minute for packing. Product B requires two minutes per unit for molding, four minutes for painting, and three minutes per unit for packing. There will be 600 minutes available for molding, 600 minutes for painting, and 420 minutes for packing. Both products have contributions of $1.50 per unit. Algebraically state the objective and constraints of this problem. What combination of A & B will yield the optimum for this problem?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
