GRAPH USING EXCEL AND LINGO I WILL DOWNVOTE INCOMPLETE ANSWERS

The hotel's policy is that all employees are to work five consecutive days per week with two consecutive days off (Saturday and Sunday are consecutive). Such a schedule might mean that some employees show up for work (for which they are paid) but they are not required (for example, the schedule might assign 337 employees on Friday). Employees are paid $120 per shift, with a $10 per shift bonus on Sunday. (Ignore the fact that the number of employees must be integer.) (a) Formulate the model of this problem. (b) Solve the model using Excel. (c) Solve the model using LINGO. (d) Clearly state the recommendation based on the obtained solution. The hotel's policy is that all employees are to work five consecutive days per week with two consecutive days off (Saturday and Sunday are consecutive). Such a schedule might mean that some employees show up for work (for which they are paid) but they are not required (for example, the schedule might assign 337 employees on Friday). Employees are paid $120 per shift, with a $10 per shift bonus on Sunday. (Ignore the fact that the number of employees must be integer.) (a) Formulate the model of this problem. (b) Solve the model using Excel. (c) Solve the model using LINGO. (d) Clearly state the recommendation based on the obtained solution