business analytics

following problem. You do NOT need to formulate the objective and the constraints. A BestBuy store in Norfolk VA has a mix of part-time and full-time employees. Full-time employees have yearly contracts but part-time employees can be hired on 1- to 6-month contracts. They currently have 5 full-time employees who will work through December 31st 2020. The store manager is now planning employee coverage for the second half of 2020. He estimates that the minimum number of employees the store needs during this period is as shown in the table below: Minimum number of employees needed Month July August September October November December Part time 5 10 8 15 20 20 Full time 5 6 6 8 The salary for full-time employees is $4000 per month but the salary for part-time employees depends on the length of their contract as show in the table below: Monthly salary of part-time employees Duration 1 month 2 month 3 month 4 month 5 month 6 month 1200 Salary 1400 1600 1800 2000 2200 The hiring cost of employees is $850 for each full-time employee and $400 for each part-time employee. The manager would like to come up with a staffing plan that would satisfy their needs with minimal cost for July to December 2020. 7 00