Review the following two questions and help determine the use of analytics and data in today’s business environment. Please also attach your Excel Worksheet to illustrate how you constructed your simulation model.
Exercises1 .A car dealership can offer a $36,000 car under a special promotion with four years financing at !’" , or can offer a discount off the price of the vehicle if the buyer finances thesale at 0. S’ 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 : baral and chromal . Production of each alloy requires three processes : Box anncal , Cold Roll , and Strand anncal . Productioncapacities are !Box anneal ."4. 0010 hours / monthCold Roll :500 hours monthStrand anneal ."1 . 000 hours ‘ monthProduction rates in tons per hour are*Box annealCold roll pass 1Strand annealColdrollPass2Borall4721 130ChromalNot required2024The maximum demand for baral is 10. 500 tons ‘month and for chromal 6, 000 tons ‘ month . The contributions , ton are baral : $25 , and chromal : $35.What combination of baral and chromal maximizes total monthly contribution ?"