Integer Programming

The Harry Electric Company, located in Conway South Carolina produces two products popular with home renovators: old-fashioned chandeliers and ceiling fans. Both the chandeliers and fans require a two-step production process involving wiring and assembly. It takes about 2 hours to wire each chandelier and 3 hours to wire a ceiling fan. Final assembly of the chandeliers and fans requires 6 and 5 hours, respectively. The production capability is such that only 36 hours of wiring time and 90 hours of assembly time are available. Each chandelier produced nets the firm $7 and each ceiling fan $6. o Create a spreadsheet model to help Harry solve this integer programming model. First, formulate an integer programming model, and type your IP model in a textbox in your worksheet

Use solver to solve this problem