Consider that there are multiple text files, each named with a unique department code in the format "DEPARTMENT$\_$CODE.txt$".$ DEPARTMENT$\_$CODE is a unique identifier for each department, for example, HR$001,$ FIN$002,$ etc.

Each file contains data structured as follows:

Quarter $1$ Revenue $(25\%)$ Quarter $2$ Revenue $(25\%)$ Quarter $3$ Revenue $(25\%)$ Quarter $4$ Revenue $(25\%)$ Employee ID

$20000\mathrm{.}0022000\mathrm{.}0021000\mathrm{.}0023000\mathrm{.}00$ e$12345$

$18000\mathrm{.}0025000\mathrm{.}0020000\mathrm{.}0024000\mathrm{.}00$ e$23456$

$21000\mathrm{.}0023000\mathrm{.}0022000\mathrm{.}0021000\mathrm{.}00$ e$34567$

Each line represents revenue contributions from Quarter $1$ out of $25,$ Quarter $2$ out of $25,$ Quarter $3$ out of $25,$ and Quarter $4$ out of $25$ for a specific employee ID$.$ Each file contains the revenue contributions for a specific department.

Write a program to:

$1.$ Load all the files and process them to calculate the average revenue contributions for Quarter $1,$ Quarter $2,$ Quarter $3,$ and Quarter $4$ for each department. Save the result in a file named "DEPARTMENT$\_$CODE$\_$avg.txt$".$

$2.$ Determine the number of employees who did not meet the annual revenue target $($assuming a total annual revenue threshold of $$80,000,$ combining all four quarters$).$ Save the result in a file named "DEPARTMENT$\_$CODE$\_$failed.txt$".$