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

Ed wants to determine the mix of spare parts to produce to maximize total profit.
a. Identify both the activities and the resources for this resource-allocation problem.
b. Formulate a linear programming model for this problem on a spreadsheet.
c. Make three guesses of your own choosing for the optimal solution. Use the spreadsheet to check each one for feasibility and, if feasible, for the value of the objective function. Which feasible guess has the best objective function value?
d. Use Solver to find an optimal solution.
e. Express the model in algebraic form?

Transcribed Image Text:

Part B Machine A 0.05 0.04 0.02 0.05 0.03 0.02 Part B A Profit $50 $40 $30