how would i solve this in excel?

LNQ Inc. has a padlaging plant located in northern Virginia Demand for packaging varies from month to month, making worldorce scheduling a challenging task. Consequently, LNQ wants to start hiring employees from Instant Workers, Inc., which can provide temporary workers under three different contract options that differ in length of employment and cost: Option Length of employment Cost per employee Contract One mooth $15 Contract 2 Two months $4.600 Contract 3 Three maths The longer contract periods are more expensive as Instant Workers has greater dialty 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 workers Month January February March April May June July Minimum workers required 10 Each month, LNQ can hire as many temporary workers as needed under each of the contract options. Because of some merger negotiations underway. LNQ does not want to commit to any contractual obligations for temporary workers that extend beyond July LNQ's quality control program requires cach temporary worker 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 is $850 per worker hired, independently of the Ingth 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. Buikdan Excel spreadsheet model of your algebraic formulation with appeopeiate we of SUMPRODUCT functions and using the "good" spreadsheet practices Provide summary totals for the number of temporary workers to be hired, total contract cost, total training cost, and total cost on your prendet Name this sheet "Model" 3. Run Excel's built-in Solver to find the optimal solution and generate answer and sensitivity reports. 4. Fill in answers to the items on the answer sheet. Hint: The optimal objective function value for your linear program should be $318,150 Answer sheet for 1. The optimal plan is to hire a total of temporary works for the month of January through July, respectively, for a total cost of $ 2. The optimal hiring plan will result in costs of for contracts and training 3. The constraint on temporary employee requirements in June is hindingonbinding) because It has a shadow price of right-hand-side range of 4. If the number of temporary workers required in June increases to then the optimal hiring plan (changes/stays the same), and the total cost (increme/decrease stays the same). LNQ Inc. has a padlaging plant located in northern Virginia Demand for packaging varies from month to month, making worldorce scheduling a challenging task. Consequently, LNQ wants to start hiring employees from Instant Workers, Inc., which can provide temporary workers under three different contract options that differ in length of employment and cost: Option Length of employment Cost per employee Contract One mooth $15 Contract 2 Two months $4.600 Contract 3 Three maths The longer contract periods are more expensive as Instant Workers has greater dialty 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 workers Month January February March April May June July Minimum workers required 10 Each month, LNQ can hire as many temporary workers as needed under each of the contract options. Because of some merger negotiations underway. LNQ does not want to commit to any contractual obligations for temporary workers that extend beyond July LNQ's quality control program requires cach temporary worker 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 is $850 per worker hired, independently of the Ingth 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. Buikdan Excel spreadsheet model of your algebraic formulation with appeopeiate we of SUMPRODUCT functions and using the "good" spreadsheet practices Provide summary totals for the number of temporary workers to be hired, total contract cost, total training cost, and total cost on your prendet Name this sheet "Model" 3. Run Excel's built-in Solver to find the optimal solution and generate answer and sensitivity reports. 4. Fill in answers to the items on the answer sheet. Hint: The optimal objective function value for your linear program should be $318,150 Answer sheet for 1. The optimal plan is to hire a total of temporary works for the month of January through July, respectively, for a total cost of $ 2. The optimal hiring plan will result in costs of for contracts and training 3. The constraint on temporary employee requirements in June is hindingonbinding) because It has a shadow price of right-hand-side range of 4. If the number of temporary workers required in June increases to then the optimal hiring plan (changes/stays the same), and the total cost (increme/decrease stays the same)