Unit Profit Metal Needed Plastic Needed Number to Make Total Profit 130 DVD 160 8 10 Total Needed Available 10600 8000 A company manufactures TVs and DVDs. Each TV requires 5 lbs of metal and 8 lbs of plastic. Each DVD requires 8 lbs of metal and 10 lbs of plastic. The company sources 10,600 lbs of metal and 8,000 lbs of plastic per week They also make $130 in profit for each TV and $160 per DVD. 6 Objective Cell (Max) 7 Cell Name Final Value $C$7 Total Profit: Unit Profit: 120375 9 10 Decision Variable Cells 11 Final Reduced Objective Allowable Allowable 12 Cell Name Value Cost Coefficient Increase Decrease 13 SB$4 Televisions Number to Make: 500 0 120 11.25 18+100 14 SBSS Computers Number to Make: 345 0 175 1E+100 15 15 16 Constraints 17 Final Shadow Constraint Allowable Allowable 18 Cell Name Value Price R.H. Side Increase Decrease 19 SB$13 Used Aluminum (1b) 4415 0 8800 1E+100 4385 20 SC$13 Used Plastic (lb) 5760 21.875 5760 5011.428571 2760 21 SD$13 Used Television Demand 500 -11.25 500 460 500