1. A manufacturing facility is trying to finalize its work 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 must be scheduled, 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 i) if job C is worked on, then job D must also be worked on and (ii) that we cannot work on both job A and job C. Finally, we must ensure that, if we decide to work on a particular job, then we spend at least one hour on that job. Determine the cost minimizing set of jobs to work on and the amount of time that they should be worked on.JobAvailable HoursStart-Up CostHourly CostA12103B8122C20181D465. Please include a screenshot and a step-by-step guide for Excel Solver.