A large department store in Ottawa operates 7 days per week. This department store needs the following number of full-time employees working each day of the week: Day Number of employees 47 23 28 Sunday Monday Tuesday Wednesday Thursday Friday Saturday 35 34 43 54 Each employee must work 5 consecutive days each week and then have 2 days off. For example, any employee who works Sunday through Thursday has Friday and Saturday off. This department store currently has a total of 60 employees available to work. The manager of the store has developed the following set of goals for employee scheduling: 1. The store wants to avoid hiring any additional employees. Weight=40 2. The most important days for the department to be fully staffed are Saturday and Sunday. Weight=30 3. The next most important day to be fully staffed is Friday. Weight=25 4. The department would like to be fully staffed the remaining 4 days in the week. Weight=20 Formulate a goal programming model to determine the number of employees who should begin their 5-day workweek each day of the week to achieve the department's objectives. How would this problem change if the weights were not given and the order of goals can be assumed as the order of importance? Do NOT solve the problem in Excel. A large department store in Ottawa operates 7 days per week. This department store needs the following number of full-time employees working each day of the week: Day Number of employees 47 23 28 Sunday Monday Tuesday Wednesday Thursday Friday Saturday 35 34 43 54 Each employee must work 5 consecutive days each week and then have 2 days off. For example, any employee who works Sunday through Thursday has Friday and Saturday off. This department store currently has a total of 60 employees available to work. The manager of the store has developed the following set of goals for employee scheduling: 1. The store wants to avoid hiring any additional employees. Weight=40 2. The most important days for the department to be fully staffed are Saturday and Sunday. Weight=30 3. The next most important day to be fully staffed is Friday. Weight=25 4. The department would like to be fully staffed the remaining 4 days in the week. Weight=20 Formulate a goal programming model to determine the number of employees who should begin their 5-day workweek each day of the week to achieve the department's objectives. How would this problem change if the weights were not given and the order of goals can be assumed as the order of importance? Do NOT solve the problem in Excel