linear

Question 1 A manager wants to know how many units of each product to produce on a daily basis in order to achieve the highest possible contribution to profit. Production requirements are below. Available resources for each day are 270kg for Material 1 and 400kg for Material 2 and 350 hours of labour. Constraints Product Material 1 (kg) Material 2 (kg) Labour Profit X 2.5 4 3 $85 Y 1.5 6 2 $90 Z 5 0 1.8 $62 Microsoft Excel 15.0 Answer Report Objective Cell (Max) Cell Name Original Value Final Value $H$4 Total Profit $7,057 $8,748 Variable Cells Cell Name Original Value Final Value Integer $D$4 X 57 100 Contin $E$4 Y 36 0 Contin $F$4 Z 14 4 Contin Constraints Cell Name Cell Value Formula Status Slack $G$7 Material 1 270 $G$7