answer the following and include step by step excel calculations

1) A car dealership can offer a $36,000 car under a special promotion with four years financing at 0%, or can offer a discount off the price of the vehicle if the buyer finances the sale at 0.5% monthly over the four years. What discount off the purchase price results in the buyer making the identical monthly payment under either purchase option? 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: 4,000 hours/month Cold Roll: 500 hours/month Strand anneal: 1,000 hours/month Production rates in tons per hour are: Box anneal Cold roll pass 1 Strand anneal Cold roll pass 2 Boral 4 72 11 36 Chromal 2 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: $35. What combination of boral and chromal maximizes total monthly contribution?