i also would like to see the solution when solved using the computer. as such i would like to see the excel file as well as the other for the other questions. Thank you

QUESTION 1 Labor planning problems address staffing needs over specific planning horison. They are especially useful when staffing needs are different during different time periods in the planning horizon and managers have some flexibility in assigning workers to jobs that require overlapping or interchangeable talents The Country Side Commercial Bank is a busy bank that has requirements for between 10 and 18 tellers, depending on the time of day. The afternoon time from noon to 3pm, is usually heaviest Table 1 indicates the workers needed at various hours that the bank is open. The bank now employs 12 full-time tellers but also has several people wallable on its roster of part-time employees. A part-time employee must put in exactly 4 hours per day but can start anytime between 9am and 1pm. Part-timers are fairly inexpensive tabor pool because no retirement or lunch benefits are provided for them. Full-timers on the other hand, work from 9am to Spm but are allowed thour for lunch. (Half of the full-timers eat at 11am, the other half at noon). Each full-timer thus provides 35 hours per week of productive labor time. By corporate policy, the bank limits part-time hours to a maximum of sex of the day's total requirement Part-timers earn $7 per hour for S28 per day) on average, and full-timers earn $90 per day in salary and benefits, on average. The bank would like to set a schedule that would minimize its total personnel costs. It is willing to release one or more of its full-time tellers if it is cost-effective to do so Table 1 TIME PERIOD = (9-10)am 110-11) am 11am-noon Noon-1pm (1-2pm 12 - 31pm (3 - 4 pm NUMBER REQUIRED 10 12 14 16 18 17 15 REQUIRED: a formulate a linear programming model for this problem b. Solve this model by using the computer. c. State the optimal solution to the problem d. Interpret the non-zero shadow prices in your output constraint table e What would be the result if the number of full-time tellers is decreased by 3. 4. What would result if the (11am-noon) needs and the 3-4pm needs were to simultaneously decrease by 1 and 2 units respectively