Bank Teller Staffing Plan As the teller supervisor at Montana Federal Credit Union you are responsible...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Bank Teller Staffing Plan As the teller supervisor at Montana Federal Credit Union you are responsible for developing a staffing plan for tellers that meets customer needs, satisfies the union contract that specifies hours per week for each teller, and optimizes labor costs. This plan will be used throughout the next six months, so it would be nice to get it right. You currently have 9 tellers on staff (4 full- time and 5 part-time). You may need to hire and train some new part-time tellers. Hiring and training new tellers is always a demanding process. The staffing requirements and constraints are summarized below: + 1. Part-time workers work four-hour shifts only, including at most two consecutive shifts if necessary. Full-time workers must work eight-hour shifts Monday-Friday and four-hour shifts on Saturdays. 2. Shifts can begin at any even hour of the day, 8:00 am, 10:00 am, etc. + 3. Weekly schedules must include at least the contract hours for each teller (40 hours for full- timers and 32 hours for part-timers) but cannot exceed more than the contract hours plus 4 hours for both part-time and full-time workers. 4. The bank is open from 8:00 am -6:00 pm Monday - Friday and from 8:00 am 2:00 pm on Saturdays. + 5. At least one full-time employee must be on duty at all times. < 6. With all benefits and hourly wages included full-time labor costs are $16.00 per hour while part-time labor costs are $8.00 per hour. + +Based on customer flow, the following numbers of tellers are needed: +¹ Mon Tue Wed Thu 84 54 8:00 am 10:00 am Noon 2:00 pm 4:00 pm ܢ6 54 64 64 54 64 44 64 64 545 64 54 64 64 ܒ5 ته 6 543 64 Fri ت.6 54 74 540 8+ Sat 74 84 94 04 04 Suggest two staffing plans: + a. A staffing plan that uses a rational approach (and includes # of tellers per shift, by day of the week). What is the weekly labor cost of your suggested plan? How many additional full- and part-time staff will you be hiring? (Note: you will be presented with a data analysis tool in class to help you with the rational approach) + b. A staffing plan that uses a creative approach (and includes # of tellers per shift, by day of the week) What is the weekly labor cost of your suggested plan? How many additional full- and part-time staff will you be hiring? +¹ IMPORTANT: For both plans, ALL constraints must be met. Include charts and/or graphs to help support your plans. Labor $ Number 8:00 AM Noon 2:00 PM 4:00 PM Workers Starting at This time on Monday Full-Time Part-Time 8:00 AM ####### 8:00 AM ###### Noon ###### Total $128.00 $128.00 $32.00 $32.00 $32.00 $32.00 On-Duty Matrix 1 1 1 1 0 0 1 1 1 1 1 1 0 0 0 0 1 1 0 0 0 0 1 1 0 0 0 0 1 1 Input Area: Enter the number of workers starting shift. Output 1: Labor cost of tellers for the day. Output 2: Number of tellers available during time span. $0.00 Actual Require 0 0 0 0 0 8 85656 5 6 Bank Teller Staffing Plan As the teller supervisor at Montana Federal Credit Union you are responsible for developing a staffing plan for tellers that meets customer needs, satisfies the union contract that specifies hours per week for each teller, and optimizes labor costs. This plan will be used throughout the next six months, so it would be nice to get it right. You currently have 9 tellers on staff (4 full- time and 5 part-time). You may need to hire and train some new part-time tellers. Hiring and training new tellers is always a demanding process. The staffing requirements and constraints are summarized below: + 1. Part-time workers work four-hour shifts only, including at most two consecutive shifts if necessary. Full-time workers must work eight-hour shifts Monday-Friday and four-hour shifts on Saturdays. 2. Shifts can begin at any even hour of the day, 8:00 am, 10:00 am, etc. + 3. Weekly schedules must include at least the contract hours for each teller (40 hours for full- timers and 32 hours for part-timers) but cannot exceed more than the contract hours plus 4 hours for both part-time and full-time workers. 4. The bank is open from 8:00 am -6:00 pm Monday - Friday and from 8:00 am 2:00 pm on Saturdays. + 5. At least one full-time employee must be on duty at all times. < 6. With all benefits and hourly wages included full-time labor costs are $16.00 per hour while part-time labor costs are $8.00 per hour. + +Based on customer flow, the following numbers of tellers are needed: +¹ Mon Tue Wed Thu 84 54 8:00 am 10:00 am Noon 2:00 pm 4:00 pm ܢ6 54 64 64 54 64 44 64 64 545 64 54 64 64 ܒ5 ته 6 543 64 Fri ت.6 54 74 540 8+ Sat 74 84 94 04 04 Suggest two staffing plans: + a. A staffing plan that uses a rational approach (and includes # of tellers per shift, by day of the week). What is the weekly labor cost of your suggested plan? How many additional full- and part-time staff will you be hiring? (Note: you will be presented with a data analysis tool in class to help you with the rational approach) + b. A staffing plan that uses a creative approach (and includes # of tellers per shift, by day of the week) What is the weekly labor cost of your suggested plan? How many additional full- and part-time staff will you be hiring? +¹ IMPORTANT: For both plans, ALL constraints must be met. Include charts and/or graphs to help support your plans. Labor $ Number 8:00 AM Noon 2:00 PM 4:00 PM Workers Starting at This time on Monday Full-Time Part-Time 8:00 AM ####### 8:00 AM ###### Noon ###### Total $128.00 $128.00 $32.00 $32.00 $32.00 $32.00 On-Duty Matrix 1 1 1 1 0 0 1 1 1 1 1 1 0 0 0 0 1 1 0 0 0 0 1 1 0 0 0 0 1 1 Input Area: Enter the number of workers starting shift. Output 1: Labor cost of tellers for the day. Output 2: Number of tellers available during time span. $0.00 Actual Require 0 0 0 0 0 8 85656 5 6
Expert Answer:
Answer rating: 100% (QA)
Answer Ratinal Approach Full Timer Teller are fixed with 2 every H... View the full answer
Related Book For
Auditing and Assurance Services An Applied Approach
ISBN: 978-0073404004
1st edition
Authors: Iris Stuart
Posted Date:
Students also viewed these accounting questions
-
You work for Gregory Plumbing Supply. You are responsible for training a new accounting clerk. She has the following questions for you to answer about this invoice. 1. Who is the buyer? 2. Who is...
-
You are responsible for labor relations in your company. During heated labor negotiations, the General Secretary of your largest union exclaims, "Look, this company has $15 billion in assets, $7.5...
-
You are responsible for developing a security evaluation process that can be used to assess various operating systems both during and after development. List the five most desirable qualities your...
-
Jay Bhattacharya and Kate Bundorf of Stanford University have found evidence that people who are obese and who work for firms that provide health insurance receive lower wages than workers at those...
-
Suppose that a lean work center is being operated with a lot size of 50 units. Assume that 200 parts are demanded per hour and it takes three hours to circulate a container, including all setup, run,...
-
A company is considering which of two mutually exclusive projects it should undertake. The finance director thinks that the project with the higher NPV should be chosen, whereas the managing director...
-
Accountants for Datsun, Inc., have assembled the following data for the year ended December 31, 2007: Requirement Prepare Datsun's statement of cash flows using the indirect method to report...
-
Jerilyn Ross, a New York City psychologist, specializes in treating patients who are phobic and afraid to leave their homes. The following table indicates how many patients Dr. Ross has seen each...
-
Olay Manufacturing Company provided you the following information to help him determine the balances of some accounts. Balances as of Oct 1: Cash Raw Materials, 5,000 units Work in process Accounts...
-
The bottle of champagne (SG 0.96) in Fig P2.87 is under pressure as shown by the mercury manometer reading. Compute the net force on the 2-in-radius hemispherical end cap at the bottom of the...
-
What tax is both withheld from an employee's pay and matched by the employer?
-
Starling Corp. has a target capital structure of 40% debt and 60% common equity with no preferred stock. The company's outstanding bonds earn 9% of return, and its tax rate is 40%. Starling's CFO...
-
A rapidly growing tech startup with a strong remote work culture is facing challenges with employee engagement and knowledge sharing. While individual performance remains high, collaboration and...
-
A broker is charged with discrimination. The Federal fair housing investigator notices that the Fair Housing Poster is not displayed in the broker's office. The investigator may: remind the broker...
-
A $100 par convertible debenture has a conversion price for common stock of $40 per share. With the common stock selling at $49, what is the conversion value of the bond? (Do not round intermediate...
-
Blossom Company has accounts receivable of $92,000 at March 31, 2025. Credit terms are 2/10, n/30. At March 31, 2025, there is a $2,200 credit balance in Allowance for Doubtful Accounts prior to...
-
Jolene, a sales representative, was worried about her work-related productivity so she made a series of entries in her records to show that she had more sales than she actually did. This is known as...
-
Suppose that a business sells 6-month subscriptions to its monthly magazine. On January 1, the company receives a total of $600 for 10 subscriptions. To record this transaction, the company debits...
-
Describe the rules of the applicable financial accounting framework for recognizing revenue. Are these rules easy for the client to apply
-
How does the auditor control sampling risk and nonsampling risk?
-
Describe management's assertions for the cash and investment processes. Which are the most important for these processes? Explain why this is so.
-
Why is it important to find the natural frequency of a vibrating system?
-
Is the frequency of a damped free vibration smaller or greater than the natural frequency of the system?
-
What is the use of the logarithmic decrement?
Study smarter with the SolutionInn App