Solve question in excell and show excell formulas step by step. The answer I had seem before is wrong . Could another expert answer , please?!

And pay attention to the requirements!

Chase Manhattan Bank The workiosd in many areas of bank operations has the charac- nate for overtime hours - not at one-and-a-half times the norteristics of a nonuniform distribution with respect to time of day. mal rate applicable to hours in excess of 40 per week. Fringe For example, at Chase Manhattan Bank in New York, the number__benefits are not applied to overtime hoars: of domestic money transfer requests received from customers, if In Indition, the following costs are pertinent: inverted U curve with the peak around 1 PM. For efficient use of resources, the personnel available should, therefore, vary corre- included) is $10.11. 1. The average cost per full-time personnel hour (fringe benefits spoading personnel requirements at different hours of the day. 2. The average cost per overtime personnel hour for full-timers (straight rate excluding fringe benefits) is $8.08. A variable capacity can be achieved effectively by employ. 3. The average cost per part-time personnel hour is $7.82. ing part-time personnel. Because part-timers are not entitled to The personnel hours required, by hour of day, are given in all the fringe benefits, they are often more economical than full- Table 8.9. time employees. Other considerations, however, may limit the So The bank's goal is to achieve the minimum possible perextent to which part-time people can be hired in a given depart- sonnel cost subject to meeting or exceeding the hourly workment. The problem is to find an optimum workforce schedule forse requirements as well as the constraints on the workers that would meet personnel requirements at any given time and listed earlier. also be economical. Some of the factors affecting personnel assignment are Discussion Questlons listed here: 1. What is the minimum-cost schedule for the bank? 1. By corporate policy, part-time personnel hours are limited to 2. What are the limitations of the model used to answer 2. Full-time employees work for 8 hours ( 1 hour for lunch incloded) per day. Thus, a full-timer's productive time is 35 houn per week: 3. Part-timers work for at least 4 hours per day bot less than 8 hours and are not allowed a lunch break. 4. Fifty percent of the full-timers go to lunch between 11x.M. and noon, and the remaining 50% go between noon and 1ru. Soorwer Adipted from Shyam L. Mooodra. "Aa L. P. Model for Work Forse 5. The shift starts at 9NM. and ends at 7kM. (i.e., overtime is limited to 2 hours). Any work left over at 7pM. is considered holdover for the next day. TABLE 8.9 Workforce Requirements 6. A full-time employee is not allowed to work more than 5 hours overtime per week. He or she is paid at the normal FIGURE 8.2