SOLVE USING EXCEL SOLVER PLEASE

A fleet manager of Jaxon Trucking Company is responsible for both the drivers and the loaders schedules. The loaders are critical for the trucking company because trucks are loaded for on time departure. It is important ensure that the loaders are fully staffed 24 hours a day. The number of loaders needed in each four-hour period is listed below

Schedule	Period	Minimum Loaders Needed
A	10pm to 2am	8
B	2am to 6am	4
C	6am to 10am	7
D	10am to 2pm	12
E	2pm to 6pm	10
F	6pm to 10pm	15

Loaders must work for eight consecutive hours.

To ensure full coverage you must consider how many loaders start at consecutive shifts.

Loaders Start Time	Minimum Required
10 pm + 2am	4
2am + 6am	7
6am + 10am	12
10am + 2pm	10
2pm + 6pm	15
6pm + 10pm	8

Each Loaders make $120 per eight-hour shift. Your objective is to find the minimum payroll cost.

1A. What is the minimum cost? No Decimal Places. Round to the Whole Number.

1B. How many total loaders need to be scheduled?

1C. What is the combined amount of loaders starting their shift at 10pm and at 2am?

1D. What is the combined amount of loaders starting their shift at 2pm and at 6pm?

Please do not post this

For one day at Jaxon Trucking Company, the minimum payroll cost is computed as follows,

Number of employees/eight-hour shifts = 4 + 7 + 12 + 10 + 15 + 8 = 56 eigh-hour shifts.

Minimum payroll cost = Number of eight-hour shifts x Rate per eight-hour shift = 56 x $120 = $6,720.

Note: Since no information regarding pension, tax deductions are given, the same is not considered

Please post the excel spread sheet and how to solve.