solution

Vincent Sports manufactures two electric golf carts. The basic model is named Electra golf cart and the luxury model is named Lux golf cart. Each Electra golf cart requires 6 hours of manufacturing time, and each Lux golf cart requires 3 hours of manufacturing time. The manufacturing plant has 2,100 hours of battery manufacturing time in the next production period. The supplier can only provide up to 300 Lux gold cart frames for the next production period. Final assembly and testing require 2 hours for each Electra model and 2.5 hours for each Lux model. A maximum of 1,000 hours of assembly and testing time are available for the next production period. The company’s accounting department projects a profit contribution of $2,400 for each Electra golf cart produced and $1,800 for each Lux golf cart produced. (a) Formulate a linear programming model that can be used to determine the number of units of each model that should be produced in order to maximize the total contribution to profit. (Let E represent the Electra model and let L represent the Lux model.) Max 2,400E + s.t. E + ])s2,100 Battery Manufacturing time Ls 2E + 2.5Ls E, L20 Lux model maximum Assembly and testing time (b) Solve the problem using Excel Solver. What is the optimal solution? (E, L) = (c) Which constraints are binding? (Select all that apply.) Engine manufacturing time Lux model maximum Assembly and testing time