Reference no: EM13968690

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: setup cost overtime setup cost Machine 1 600 190 machine 2 700 200 machine 3 550 275 machine 4 675 150 machine 5 585 195 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: J1 J2 J3 J4 J5 Machine 1 3.0 4.0 5.5 2.5 3.1 Machine 2 3.8 4.9 6.4 2.9 2.7 Machine 3 3.6 4.8 5.5 3.8 2.8 Machine 4 2.9 5.3 5.6 2.9 1.9 Machine 5 3.1 6.0 5.1 2.6 2.5 1. Define the decision variables 2. Develop the objective function 3. write the constraints 4. Solve the problem in excel