solve this LP using Excel

A gear manufacturer is planning nest week's production run for four types of gears. If necessary, it is pos. sible to outsource any gpe of gear from anotber gear company located nearby. The following table and the table at the bottom of this page show next week's 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 processes. 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? A gear manufacturer is planning next week's production run for four types of gears. If necessary, it is pos. sible to outsource any gpe of gear from another gear company located nearby. The following table and the table at the bottom of this page show next week's 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 processes. The nearty 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? \begin{tabular}{|c|c|c|c|c|c|c|} \hline Poraing & 0.30 & 0.36GEAR & GEARC & GEARD & \( \begin{array}{c}\text { HOURS } \\ \text { AVAIL_ABL. }\end{array} \) & COSTPEHOUR \\ \hline & 0.20 & 030 & 0.380.24 & 0.450.330.25 & 500300 & $9.0058.00 \\ \hline \end{tabular} A gear manufacturer is planning nest week's production run for four types of gears. If necessary, it is pos. sible to outsource any gpe of gear from anotber gear company located nearby. The following table and the table at the bottom of this page show next week's 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 processes. 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? A gear manufacturer is planning next week's production run for four types of gears. If necessary, it is pos. sible to outsource any gpe of gear from another gear company located nearby. The following table and the table at the bottom of this page show next week's 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 processes. The nearty 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? \begin{tabular}{|c|c|c|c|c|c|c|} \hline Poraing & 0.30 & 0.36GEAR & GEARC & GEARD & \( \begin{array}{c}\text { HOURS } \\ \text { AVAIL_ABL. }\end{array} \) & COSTPEHOUR \\ \hline & 0.20 & 030 & 0.380.24 & 0.450.330.25 & 500300 & $9.0058.00 \\ \hline \end{tabular}