A major airport has high needs in maintenance personal. Shifts are six hours long and start every three hours throughout the day for all 24h. The airport needs technicians for mechanical and electrical issues. Required minimum numbers of technicians in each area are given below. Mechanical technician hours cost $35, electrical technician hours cost $45. How should the technicians be scheduled to minimize costs while having at least the minimum number of technicians per shift? Build and solve the respective LP model in Excel.

Shift	Mechanics	Electricians
12am to 4am	30	15
4am to 8am	120	95
8am to 12 pm	240	185
12 pm to 4pm	180	155
4pm to 8pm	220	200
8pm to 12am	60	40