Use excel linear programming to answer the question

Problem T2: Assigning Technicians to Shifts You are planning the staffing of maintenance technicians at a printing plant which operates on three shifts. You can use up to 8 possible technicians, each of whom can be assigned to at most one shift. The costs of assigning the technicians and their certified categories of competency are as follows: Shift 1 Shift 2 Shift 3 Certified in Category Technician Cost Cost Cost 1 2 3 4 $ 280 $ 290 $ 300 X X 300 $ 330 $ 200 X -- X 270 $ 280 $ 290 X 180 $ 190 $ 150 X OO JOVIAWN 375 $ 360 $ 385 $ 225 $ 205 $ 175 $ 315 $ 295 $ 230 280 $ 200 $ 250 For example, it would cost $280 to assign technician 1 to shift 1, $290 to shift 2, and $300 to shift 3, and technician 1 is certified in categories 1, 2, and 4. More than one technician may be assigned to each shift. In each category, you need at least one certified technician assigned to each shift. Determine (1) the least expensive way to meet your maintenance technician staffing needs and (2) the least number of technicians (and whom) you need to hire meet your maintenance technician staffing needs