1. Find the optimal solution using Excel
3. A gear manufacturer is planning next weeks produc- tion run for four types of gears. If necessary, it is pos- sible to outsource any type of gear from another gear company located nearby. The following table and the table at the bottom of this page show next weeks demand, revenue per unit, outsource cost per unit, time (in hours) required per unit in each production process, and the availability and costs of these pro- cesses. The nearby company can supply a maximum of 300 units of each type of gear next week. What should be the production and/or outsource plan for the next week to maximize profit?
4. 

GEAR TYPE GEAR A GEAR B GEAR C GEAR D Demand 400 500 450 600 Revenue $12.50 $15.60 $17.40 $19.30 Outsource $7.10 $8.10 $8.40 $9.00 GEAR TYPE GEAR A GEAR B GEAR C GEAR D Demand 400 500 450 600 Revenue $12.50 $15.60 $17.40 $19.30 Outsource $7.10 $8.10 $8.40 $9.00