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 in order to maximize total profit.
(a) Formulate a linear programming model for this problem.
(b) Display the model on an Excel spreadsheet.

  • CreatedSeptember 22, 2015
  • Files Included
Post your question