PLEASE SOLVE USING EXCEL (B,C,D ) show formulas and steps

3,5-3. Ed Butler is the production manager for the Bilco Corporation. which produces three types of spare parts for automobiles. The manufacture of each part requires processing on each of two machines, with the following processing times (in hours): Each machine is avaifable 40 hours per month, Each part manufactured will yieid a unit profit as follows: Ed wants to determine the mix of spare parts to produce in order to maximize total profit. (a) Formuluie u lineur programming nodel for this protilem. (b) Dreplay the model on an Exeel spread theet. (c) Make three guesses of your owil chocaning for the optimal soIution. Une the ypreadsheet to check each one for fersibility and, if feasible, to find the value of the abjective function. Which feasible guess has the best objective function value? C (d) Use Solver to wolve the medel by the simplex method