Altec Manufacturing Inc. is planing to produce and sell two new products: AS 106 and BS...

  

Transcribed Image Text:

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: AS 106 BS 107 Per-unit resource requirements Available Plastic 15,000 kg Production 4 55,000 hours Assembly 8 9 84,000 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 Number to make Total Contribution Margin Unit Contribution Mar 165 195 Resources Used Available Per-unit resource requirements 1. 15,000 55.000 Plastic 2 kg Production 4 hours Assembly 8 84,000 hours 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: AS 106 BS 107 Per-unit resource requirements Available Plastic 15,000 kg Production 4 55,000 hours Assembly 8 9 84,000 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 Number to make Total Contribution Margin Unit Contribution Mar 165 195 Resources Used Available Per-unit resource requirements 1. 15,000 55.000 Plastic 2 kg Production 4 hours Assembly 8 84,000 hours

Answer rating: 100% (QA)

The first step is to set up the linear programming prob... View the full answer