Please use Excel Solver and show the excel sheet

(c) What is the value of an additional minute of time per week on test device 1? Test device 2? Test device 3? Should Quitmeyer Electronics add one or more test devices to make more time avail- able? If so, on which device(s) should it add? 8-14 (Nuclear plant staffing problem) South Central Utilities has just announced the August 1 opening of its second nuclear generator at its Baton Rouge, Louisiana, nuclear power plant. Its personnel. department has been directed to determine how many nuclear technicians need to be hired and trained over the remainder of the year. The plant currently employs 350 fully trained technicians and projects the following personnel needs: MONTH PERSONNEL HOURS NEEDED August 40,000 September 45,000 October 35,000 November 50,000 December 45,000 By Louisiana law, a reactor employee can ac- tually work no more than 130 hours per month. (Slightly over 1 hour per day is used for check-in and check-out, recordkeeping, and daily radiation health scans.) Policy at South Central Utilities also dictates that layoffs are not acceptable in those months when the nuclear plant is overstaffed. So if more trained employees are available than are needed in any month, each worker is still fully paid, even though he or she is not required to work the 130 hours. PAR Sout Nort Nort West Sout CRO Whea Alfal Barle a PROBLEMS 315 Training new employees is an important and costly procedure. It takes 1 month of one-on-one classroom instruction before a new technician is per- mitted to work alone in the reactor facility. There- fore, South Central must hire trainees 1 month before they are actually needed. Each trainee teams up with a skilled nuclear technician and requires 90 hours of that employee's time, meaning that he or she has 90 fewer hours available that month for actual reactor work. Personnel department records indicate a turn- over rate of trained technicians at 5% per month. In other words, about 5% of the skilled employ- ees at the start of any month resign by the end of that month. A trained technician earns an average monthly salary of $2,000 (regardless of the number of hours worked, as noted earlier). Trainees are paid $900 during their 1 month of instruction. (a) Formulate this staffing problem using LP. (b) Solve the problem. How many trainees must begin each month