Problem: Andy is the production manager for the tyreco Corp, which produces three types of spare parts for vehicles. The manufacture of each part requires processing on each of two machines, with the following processing time (in hours):
Part 1:
Machine A B C
1 0.02 0.03 0.05
2 0.05 0.02 0.04
Each machine is available 40 hours per month. Each part manufactured will yield a unit profit as follows:
Part 2:
A B C
Profit $50 $40 $30
a) Identify both the activities and the resources for this problem.
b) Formulate a linear programming model for this problem on a spreadsheet.
c) Use Solver to find an optimal solution.
d) Express the model in algebraic form.