A workshop has 5 jobs to perform today. Each job must be done by exactly one machine, but a machine can do more than one job. For each machine, there is a setup cost for the regular workday. Once this cost is paid, you can use the machine for up to 8 hours; if you do not pay the setup cost, you cannot use the machine today. If you set up a machine for the regular workday, you may also elect to set up the machine for overtime, in which case there is an additional cost and you may use the machine for up to 2 more hours. On the other hand, if you do not set up a machine for the regular workday, it cannot be used for overtime. The costs are as follows:

Thus, if you pay $600, you can use machine 1 for up to 8 hours, and if you pay $600 + $190 = $790, you may use machine 1 for up to 8 + 2 = 10 hours. The number of hours each job takes on each machine is as follows:

1. Define the decision variables.
2. Develop the objective function.
3. Write the constraints.
4. Solve the problem in Excel.

Transcribed Image Text:

Setup Cost $600 $700 Machine1 Machine 2 Machine3 Machine 4 Machine5 Overtime Setup Cost $190 $ 200 $275 $150 $195 550 $ 675 $585 b17895 J32212 59896 J22322 3 b54561 J56555 2 b09830 J44456 b08691 J33323 12345