InI tTe Excel template, Havigate to the Requirement Lab. Assumfit at Conroy is considering raising the price of B100 to $1,400. The company believes that the price increase would drop maximum customer demand from 2,800 units to 2,600 units. a. If Conroy implements the price increase, which product would have the highest contribution margin per unit of its constraining resource? b. If the company decided to initiate production by maximizing the output of the product chosen in requirement 7a, then how many units of this product would it be able to produce before encountering that product's constraint? c. If the company implemented the production plan in requirement 7b, then how many units of its remaining product could it produce with the capacity that is still available? d. What total contribution margin would the company earn if it followed the production plan described in requirements 7b and 7c? In the Excel template navigate to the "Ro aquirement ?" tah Solver