Each day, Eastinghouse produces capacitors during three shifts: 8 A.M. to 4 P.M., 4 P.M. to 12 A.M., and 12 A.M. to 8 A.M. The hourly salary paid to the employees on each shift, the price charged for...

Each day, Eastinghouse produces capacitors during three shifts: 8 A.M. to 4 P.M., 4 P.M. to 12 A.M., and 12 A.M. to 8 A.M. The hourly salary paid to the employees on each shift, the price charged for each capacitor made during each shift, and the number of defects in each capacitor produced during a given shift are listed in the file P04_102.xlsx. The company can employ up to 25 workers, and each worker can be assigned to one of the three shifts. A worker produces 10 capacitors during a shift, but due to machinery limitations, no more than 10 workers can be assigned to any shift. Each capacitor produced can be sold, but the average number of defects per capacitor for the day’s production cannot exceed 3. Determine how Eastinghouse can maximize its daily profit.