please use excel and please dont copy and paste from other answers

LNQ Inc. luns a packaging plant located in northern Virginia. Demand for packaging varies from mouth to month, making workforce scheduling a challenging task. Consequently, LNQ wants to start hiring employees from Instant Workers, Inc. which can provide temporary workers tender three different contract options that differ in length of employment and cost Option Length of employment Cost per employee Contract 1 One month $1.000 Contract 2 Two months $1.600 Contract 3 Three months $7.300 The longer contract periods are more expensive as Instant Workers has greater difficulty finding temporary employees who are willing to commit to lenghthier work assignments. Over the first seven months of next year, LNQ has estimated the following needs for worloerse Month January February March April May June July Minimum workers required 14 17 20 13 23 16 Each month. LNQ can hire as many temporary workers as needed under each of the contract options. Because of some merger negotintions underway, LNQ does not want to commit to any contractual obligations for temporary workers that extend beyond July LNQ's quality control program requires mach temporary workout to receive training at the time of hire. The training program is required even if the person worked for the company in the past. LNQ estimates that the cost of training in $850 per worloer hired, independently of the length of the contract 1. Formulate a linear program (algebraic formulation to help LNQ to determine the number of temporary employees to hire each month on each contract type in order to meet the estimated needs at a minimum total cost. 2. Build an Excel specadsheet model of your algebraic formulation with appropriate the af SUMPRODUCT functions and using the "good" preadsheet practices . Provide summary totals for the number of temporary workers to be hired, total contract cost, total training cost, and total cost on your pread lat. Name this sheetodel" 3. Run Excel's built-in Solver to find the optimal solution and grberate answer and stuitivity reports, 4. Fill in answer to the items on the answer sheet. Hint: The optimal objective function value for your linear program should be $309.950 Answer sheet 1. What is the optimal hiring plan for LNQ? Please be specific as to how many employees are hired in which month for which contract 2. The optimal hiring plan will result in costs of for contracts and for training 3. The constraint on temporary employee requirements in May is (bindingonbinding) because It has a shadow price of $ right-hand-side range of 4. If the number of temporary workers required in May increases to 14, then the optimal hiring plan (changes/stays the same), and the total cost increases/decreases/stays the same). LNQ Inc. luns a packaging plant located in northern Virginia. Demand for packaging varies from mouth to month, making workforce scheduling a challenging task. Consequently, LNQ wants to start hiring employees from Instant Workers, Inc. which can provide temporary workers tender three different contract options that differ in length of employment and cost Option Length of employment Cost per employee Contract 1 One month $1.000 Contract 2 Two months $1.600 Contract 3 Three months $7.300 The longer contract periods are more expensive as Instant Workers has greater difficulty finding temporary employees who are willing to commit to lenghthier work assignments. Over the first seven months of next year, LNQ has estimated the following needs for worloerse Month January February March April May June July Minimum workers required 14 17 20 13 23 16 Each month. LNQ can hire as many temporary workers as needed under each of the contract options. Because of some merger negotintions underway, LNQ does not want to commit to any contractual obligations for temporary workers that extend beyond July LNQ's quality control program requires mach temporary workout to receive training at the time of hire. The training program is required even if the person worked for the company in the past. LNQ estimates that the cost of training in $850 per worloer hired, independently of the length of the contract 1. Formulate a linear program (algebraic formulation to help LNQ to determine the number of temporary employees to hire each month on each contract type in order to meet the estimated needs at a minimum total cost. 2. Build an Excel specadsheet model of your algebraic formulation with appropriate the af SUMPRODUCT functions and using the "good" preadsheet practices . Provide summary totals for the number of temporary workers to be hired, total contract cost, total training cost, and total cost on your pread lat. Name this sheetodel" 3. Run Excel's built-in Solver to find the optimal solution and grberate answer and stuitivity reports, 4. Fill in answer to the items on the answer sheet. Hint: The optimal objective function value for your linear program should be $309.950 Answer sheet 1. What is the optimal hiring plan for LNQ? Please be specific as to how many employees are hired in which month for which contract 2. The optimal hiring plan will result in costs of for contracts and for training 3. The constraint on temporary employee requirements in May is (bindingonbinding) because It has a shadow price of $ right-hand-side range of 4. If the number of temporary workers required in May increases to 14, then the optimal hiring plan (changes/stays the same), and the total cost increases/decreases/stays the same)