Q4. Altec Manufacturing Inc. is planing to produce and sell two new products: AS 106 and BS 107. The resources(in kg and hours) for producing each type of productc are as follows: Plastic Production Assembly AS 106 BS 107 Per-unit resource requirements 1 2 4 5 8 9 Available 15,000 55,000 84,000 kg hours hours Required: Compute the optimal numbem of products of each type that Altec Manufacturing Inc. should make and sell to maximize operating income using Excel Solver Functions. Solutions: Altec Manufacturing Inc. AS106 BS107 Total Contribution Margin Number to make Unit Contribution Mar 165 195 Used Resources Plastic Production Assembly Per-unit resource requirements 1 2 4 5 8 9 Available 15,000 55,000 84,000 kg hours hours