A workshop has 5 jobs to perform today. each job must be done by

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: Job 1 Job 2 Job 3 Job 4 Job 5 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 a. Define the decision variables. (4 Points) b. Develop the objective function. (4 Points) c. Write the constraints. (9 Points) d. Solve the problem in Excel. (18 Points: Decision variables section: 3 point, O.F. Section: 3 points, Constraints section: 8 points, Solver: 4 points )

Connect with a professional writer in 5 simple steps

Please provide as many details about your writing struggle as possible

Academic level of your paper

Type of Paper

When is it due?

How many pages is this assigment?

Looking for a Similar Assignment? Let us take care of your classwork while you enjoy your free time! All papers are written from scratch and are 100% Original. Try us today! Use Code FREE20