SuperValue Distribution Center has 14 night-shift employees and 13 trucks to be loaded before 3:00 am. The time (number of minutes) required to load each truck by employees is shown in Exam III Question 24 Data.xlsx.

SuperValue wants to minimize the total loading time needed to complete all loading jobs, given that

All trucks must be loaded

All employees must be assigned to at least one loading job

Truck #11 must be loaded by Employee #7

Employee #4 must not be loading Truck #4

Two employees must be loading Truck #13 assume that, for Truck #13, loading times are

already adjusted for a two-employee loading requirement

Truck #3 must be loaded by either Employee #5 or Employee #8

1) Given above information, what is the minimum total loading time needed to complete all loading jobs?

A) 412.33 minutes

B) 824.66 minutes

C) 1,175.89 minutes

D) 1,223.64 minutes

E) 1,260.04 minutes

F) 1,301.25 minutes

G) 1,364.52 minutes

H) Infeasible solution: cannot be solved, one or more of the requirements cannot be

satisfied.