Using Excel solver Solve the problem

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..

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

C.

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

D.

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

Please show how to solve in Excel solver