| A planing mill uses 3 different types of planers. What planers should the company use | |||||||
| to minimize cost? The total job has to be finished in | 3 | hours. | |||||
| Characteristics of planers | |||||||
| Speed (ft/min) | Cost ($/hour) | Maximum wood thickness (inches) | |||||
| Planer 1 | 5 | $150 | 6 | ||||
| Planer 2 | 7 | $190 | 4 | ||||
| Planer 3 | 8 | $225 | 2 | ||||
| Wood to be planed (ft) | |||||||
| 1" | 2" | 3" | 5" | Hours | Cost | ||
| Planer 1 | 0 | 0 | 0 | 0 | 0.00 | $0.00 | |
| Planer 2 | 0 | 0 | 0 | 0.00 | $0.00 | ||
| Planer 3 | 0 | 0 | 0.00 | $0.00 | |||
| Total | 0 | 0 | 0 | 0 | $0.00 | ||
| Demand | 500 | 800 | 600 | 300 | |||
| Problem | |||||||
| A planing mill has three different planers. Each planer has a different speed, cost to operate and | |||||||
| maximum thickness of wood it can handle. What planers should the mill use to minimize cost, given | |||||||
| an amount of wood and no more than 3 hours to do the job? | |||||||
| Solution | |||||||
| The solution is structurally very similar to the one found on worksheet Alloc1. | |||||||
| 1) The variables are the amounts of wood that go through the different planers. In worksheet | |||||||
| Process, these are given the names Wood_through_planer1, Wood_through_planer2 and | |||||||
| Wood_through_planer3. | |||||||
| 2) The logical constraints are all defined via the Assume Non-Negative option: | |||||||
| Wood_through_planer1 >= 0 | |||||||
| Wood_through_planer2 >= 0 | |||||||
| Wood_through_planer3 >= 0 | |||||||
| The time and demand constraints give | |||||||
| Total_hours <= Hours_available | |||||||
| Total_planed >= Demand | |||||||
| 3) The objective is to minimize cost and this is defined on the worksheet as Total_cost. | |||||||
| Remarks | |||||||
| This is only a small example of a process selection. An example where process selection is very | |||||||
| important is the oil industry. A process selection model is often used to decide what method to use | |||||||
| to create a product. | |||||||
