New Exercise Bank Content Qu$.06-07$

Carlos 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 available $40$ hours per month. Each part manufactured will yield a unit profit as follows:

Click here for the Excel Data File

Formulate a linear programming model for this problem on a spreadsheet. Use Solver to find an optimal solution.

a$.$ Carlos wants to determine the mix of spare parts.

Note: Enter $"0"$ if a particular part is not produced. Round your answers to $3$ decimal places.

b$.$ Determine the maximum total profit.

Note: Round your answer to $2$ decimal places.

Total profit