Formulate this same linear programming problem on a spreadsheet and SOLVE using Excel

Solver $($Provide the corresponding $$Excel Spreadsheet$$ and the $$Answer Report$).$ Include

$$managerial statements$$ that communicate the results of the analyses. $($i$.$e$.,$ describe

verbally$/$narratively the results$).$ N$.$B$.$: it is OK to have decimal solutions Power Generation Inc. has just announced the November $1,2023$ expansion of the R$.$H$.$ Saunders

Generating Station in the Ottawa$/$St$.$ Lawrence area. Its personnel department has been directed to

determine how many technicians need to be hired and trained for the November $-$ February period. The

station currently employs $250$ fully trained technicians and projects the following personnel needs:

By Ontario regulations, a technician can actually work no more than $130$ hours per month. Negotiated

policy at Power Generation Inc. also dictates that layoffs are not acceptable in the months when the

station is overstaffed. So$,$ if more trained employees are available than are needed in any month, each

worker is still fully paid, even though the trainee is not required to work the $130$ hours. Training new

employees is an important and costly procedure. It takes one month of one$-$on$-$one classroom instruction

before a new technician is permitted to work alone in the facility. Therefore, Power Generation Inc. must

hire trainees one month before they are actually needed. Each trainee teams up with a skilled technician

and requires $70$ hours of that employee's time, meaning that $70$ hours less of the technician's time are

available that month for actual work. Personnel department records indicate a turnover rate of trained

technicians at $6\%$ per month. In other words, about $6\%$ of the skilled employees at the start of any month

resign by the end of that month. A trained technician earns an average monthly salary of $$5,000$

$($regardless of the number of hours worked, as noted earlier$).$ Trainees are paid $$3,000$ during their one

month of instruction. Power Generation Inc. wants to find the best staffing schedule for the four$-$month

period while minimizing the total labour cost incurred.