PLEASE INCLUDE EXCEL WORKSHEET!!

2. A steel mill produces two types of steel alloy: boral and chromal. Production of each alloy requires three processes: Box anneal, Cold Roll, and Strand anneal. Production capacities are Box anneal Cold Roll Strand anneal: Production rates in tons per hour are 4,000 hours month 500 hours/monthh 1,000 hours month Box anneal Cold roll pass 1 Strand anneal Cold roll pass Boral 72 36 Chromal Not required 20 24 The maximum demand for boral is 10,500 tons/month and for chromal 6,000 tons/month. The contributions/ton are boral: $25, and chromal: S35. What combination of boral and chromal maximizes total monthly contribution? 2. A steel mill produces two types of steel alloy: boral and chromal. Production of each alloy requires three processes: Box anneal, Cold Roll, and Strand anneal. Production capacities are Box anneal Cold Roll Strand anneal: Production rates in tons per hour are 4,000 hours month 500 hours/monthh 1,000 hours month Box anneal Cold roll pass 1 Strand anneal Cold roll pass Boral 72 36 Chromal Not required 20 24 The maximum demand for boral is 10,500 tons/month and for chromal 6,000 tons/month. The contributions/ton are boral: $25, and chromal: S35. What combination of boral and chromal maximizes total monthly contribution