LNQ Inc. has a packaging plant located in northern Virginia. Demand for packaging varies from month to month, making workforce 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 1 Contract 2 ontract3 One mont Two months Three months 1.900 $4,600 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 workers: January Feb ont Minimum Num. Workers Required April May June July 10 25 17 14 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 each 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 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 Ercel spreadsheet model of your algebraic formulation with appropriate use of SUMPRODUCT functions and using the "good" spreadsheet practices. Follow the Excel implementations provided in the slides as guide Provide summary totals for the number of temporary workers to be hired, total contract cost, total training cost, and total cost on your spreadsheet. Name this sheet "Model 3. Run Excel's built-in Solver to find the optimal solution and generate Answer and Sensitivity reports.