I would like to see the excel sheet for part b , also would like to see the function ( formula ) inputted in the cell to get the result .
QUESTION 1 Labor planning problems address staffing needs over specific planning horizon. 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 available on its roster of part-time employees. A pa rt-time employee must put in exactly 4 hours per day but can start anytime between 9am and 1pm. Part-timers are fairly inexpensive labor pool because no retirement or lunch benefits are provided for them. Full-timers on the other hand, work from 9am to 5pm but are allowed 1hour 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 50% of the day's total requirement. Part-timers earn $7 per hour (or $28 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 NUMBER REQUIRED teaImam REQUIRED: a. Formulate a linear programming model for this problem. b. Solve this model by using the computer. :2. State the optimal solution to the problem d. Interpret the non-zero shadow prices in your output constraint table