All necessary information is given. Determine the cost minimizing set of jobs to work on and the amount of time that they should be worked on. must solve problem with solver on excel.

A manufacturing facility is trying to finalize its production schedule for the next day. There are four different jobs available (A,B,C,D), and we must determine which of the jobs to work on and how much time to devote to them. There are 24 hours of labor that we need to use, and there is a limit for each job on the amount of time that we can spend on them in a day. There is also a fixed startup-cost associated with any job that we decide to work on and an hourly cost of working on any job. The limits and costs for each job are in the below table. Some additional requirements are that at least two different jobs must be worked on, if job D is worked on then job C must also be worked on, and that we cannot work on both job A and job C. Determine the cost minimizing set of jobs to work on and the amount of time that they should be worked on. Start-Up Cost Job A B Available Hours 12 8 20 10 12 18 Hourly Cost 3 2 1 5 D 4 6