Solve using Solver in excel spreadsheet and show all steps

06. {25 points] Antlponish Restaurant is open from 0:00 am to 10:00 pm daily. Besides the hours the restaurant is open for customers. workers are needed an hour before opening and an hour after closing for set up and cleanup activities. The restaurant operates with both full-time and part-time workers on the following shifts: \" $32 ?:00 am 11:00 am 1'00 am 3:00 pm $00 11:00 am 3:00 pm $32 m The following numbers of workers are needed during each of the Indicated time blocks. Hours Workers Needed 100 am 11:00 am 11:00 am 1:00 pm 1:00 pm 3:00 pm 3:00 pm 5:00 pm 5:00 pm "3:00 pm 1:00 pm - 9:00 pm 9:00 pm -11:00 pm At least one fulltime worker must be available during the hour before opening and after closing. Addition-altar, at least 3015 of the employees should be fulltime {0 hour] workers during the restaurant's periods from 11 :am - 1:00 pm and from 5:00 pm - 100 pm. a. Formulate and LP for this problem with the objective of minimizing total daily labor costs. 0. Implement your model In an Excel spreadsheet and use Solver to solve it. What is the optimal solution? QT. (15 points] A company produces three products which must be painted: assembled, and inspected. The machinery must be cleaned and adjusted before each batch is produced. They want to maximize their profits for the amount of operating time they have. The unit prot and setup cost per batch are: Product Profit per unit Setup cost per batch 1 9 500 2 10 600 3 12 650 The operation time per unit and total operating hours available are: Operating Time per Unit Operating Operation Product 1 Prod uot 2 Product 3 Hours Available Palm 1 2 2 400 Assemble 2 3 2 600 Inspection 2 4 3 540 Formulate and solve a LP model for this problem with Solver