please solve the question in excel

WORKFORCE PLANNING-BUS SCHEDULING MODEL Example 2.4.5 on page 68 of Taha's book Progress City is studying the feasibility of introducing a mass transit hus system to reduce the in-city driving, The study seeks the minimum number of busses that can handle the transportation needs. After gathering necessary information, it is realized that the 4-hour intervals for determining the bus numbers in a day is a good choice. Number of busses needed to meet the demand in 4-hour intervals are given in the figure below. 400 AM 2 . . A bus has a working schedule for 8 hours. Develop a model to find the minimum number of busses that meet the demand 32 WORKFORCE PLANNING-BUS SCHEDULING MODEL Example 2.4.5 on page 68 of Taha's book Number of busses as a function of the time of the day: Nowheroes AM December Number of being 12 Number of heating Number of starting Number of busses as a function of the time of the day: 19 Number of buses 12 AM Decision Variables: * Number of buses starting at 12:01am Number of buses starting alam x: Number of buses starting alam *Number of buses starting at 12.01pm * Number of starting at 40 Number of buses starting at Olpen Number of busses as a function of the time of the day: Nurder of 200 12:00 12:00 AM Decision Variables: * Number of being a 120 am *Number of bees starting alam * Number of buses starting Bolam Xe Number of buses starting at 12.01pm Number of buses starting at 40 pm Number of starting op Constraints: Meeting the demand X: + x 24 X: + x2 28 Xg+xz 210 X3 + X7 X+12 Xs+ X6 24 Non-negativity x 20 Time period 12:01am- 4:00am Time period 4:01am-8:00am Time period 8:01am-12:00 noon Time period 12:01 pm 4:00pm Time period 4:01pm-8:00pm Time period 8:01pm 12:00am j = 1,2,3,4,5,6 480 BH AM Midnight 36/76 Decision Variables: * Number of starting at 12:01am Number of buses starting 40lm * Number of buses starting alam *Number of buses starting a 12.01pm is Number of buses starting 43 * Number of buses starting 28.01 Constraints: Meeting the demand X + X 24 %+xz 28 X2 + x3 2 10 x3 + x 27 X+X5 2 12 X5 X 24 Non-negativity 20. Time period 12:01am-4:00am Time period 4:01am - 8:00 am Time period 8:01am-12:00 noon Time period 12:01 pm 4:00pm Time period 4:01pm-8:00pm Time period 8:01pm- 12:00am j = 1,2,3,4,5,6 35 WORKFORCE PLANNING-BUS SCHEDULING MODEL Example 2.4.5 on page 68 of Taha's book Mathematical Model to minimize total number of busses Minimize z= xy + x2 + x3 + x4 + X5 + X6 Subject to X1 + X 24 X1 + X2 28 X2 + x, 10 X3 + x 27 X + X5 2 12 X5 + X6 24 Time period 12:01am- 4:00am Time period 4:01am-8:00am Time period 8:01am-12:00 noon Time period 12:01 pm- 4:00pm Time period 4:01 pm-8:00pm Time period 8:01pm- 12:00am x 20, j = 1,2,3,4,5,6