Arlington Bank of Commerce and Industry is a busy bank that has requirements for between 10...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Arlington Bank of Commerce and Industry is a busy bank that has requirements for between 10 and 18 tellers depending on the time of day. Lunchtime, from noon to 2 P.M., is usually heaviest. The table below indicates the workers needed at various hours that the bank is open. Time Period Number of Tellers Time Period Number of Tellers Required Required 9 am - 10 am 10 am - 11 am 11 am - Noon Noon -1 pm 1 pm - 2 pm 2 pm - 3 pm 3 pm - 4 pm 4 pm - 5 pm 10 18 12 17 14 15 16 10 The bank now employs 12 full-time tellers, but many people are on its roster of available part-time employees. A part-time employee must put in exactly 4 hours per day but can start anytime between 9 A.M. and 1 P.M. Part-timers are a fairly inexpensive labor pool because no retirement or lunch benefits are provided them. Full-timers, on the other hand, work from 9 A.M. to 5 P.M. but are allowed 1 hour for lunch. (Half the full-timers eat at 11 A.M., the other half at noon.) Fulltimers thus provide 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 $6 per hour (or $24 per day) on average, whereas full-timers earn $75 per day in salary and benefits on average. The bank would like to set a schedule that would minimize its total manpower costs. It will release 1 or more of its full-time tellers if it is profitable to do so. a) Formulate this problem as an LP model. þ) Solve the problem by Excel. What is the best schedule? What is the total cost for the best schedule? Arlington Bank of Commerce and Industry is a busy bank that has requirements for between 10 and 18 tellers depending on the time of day. Lunchtime, from noon to 2 P.M., is usually heaviest. The table below indicates the workers needed at various hours that the bank is open. Time Period Number of Tellers Time Period Number of Tellers Required Required 9 am - 10 am 10 am - 11 am 11 am - Noon Noon -1 pm 1 pm - 2 pm 2 pm - 3 pm 3 pm - 4 pm 4 pm - 5 pm 10 18 12 17 14 15 16 10 The bank now employs 12 full-time tellers, but many people are on its roster of available part-time employees. A part-time employee must put in exactly 4 hours per day but can start anytime between 9 A.M. and 1 P.M. Part-timers are a fairly inexpensive labor pool because no retirement or lunch benefits are provided them. Full-timers, on the other hand, work from 9 A.M. to 5 P.M. but are allowed 1 hour for lunch. (Half the full-timers eat at 11 A.M., the other half at noon.) Fulltimers thus provide 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 $6 per hour (or $24 per day) on average, whereas full-timers earn $75 per day in salary and benefits on average. The bank would like to set a schedule that would minimize its total manpower costs. It will release 1 or more of its full-time tellers if it is profitable to do so. a) Formulate this problem as an LP model. þ) Solve the problem by Excel. What is the best schedule? What is the total cost for the best schedule?
Expert Answer:
Answer rating: 100% (QA)
a LP model Let F Total full timers employed after recruiti... View the full answer
Related Book For
Posted Date:
Students also viewed these general management questions
-
a. Make an exponential smoothing forecast for periods 2 through 5 with 2 values of alpha, 0.05 and 0.60, and an assumed forecast for period 1 of 30. b. Compute the MAD for each of the above...
-
To ascertain the number of tellers needed during peak hours of operation, data were collected by an urban bank. Four tellers were studied during three "busy" times,(1) Weekdays between 10:00 and...
-
The Prescott National Bank has six tellers available to serve customers. The data in the following table provide the number of busy tellers observed during 25 spot checks. a. Use single-value...
-
According to the 2020 Global Study on Occupational Fraud and Abuse, a tip is the most common way to report fraud. What should be the ethical considerations for employees before deciding whether to...
-
Maxwell Corporation has income per books before tax of $400,000. Included in the income per books is $8,000 interest income from tax-exempt municipal bonds. In computing income per books, Maxwell...
-
Nell agrees to buy a unique collection of Olympics memorabilia for $7,000 from Piper and sends $1,500 as a down payment. When Nell sends Piper the rest of the price, she refuses to ship the...
-
If the yield to maturity on a one-year bond is 8 per cent and the expected spot rate on a one-year bond, beginning in one years time, is 7 per cent, what will be the yield to maturity on a two-year...
-
Reread the Management Focus box on Procter & Gamble and then answer the following questions: a. What strategy was Procter & Gamble pursuing when it first entered foreign markets in the period up...
-
Noah and Joan Arc live with their family in Dayton, OH. Noahs Social Security number is 434-11-3311. Noah was born on February 22, 1987, and Joan was born on July 1, 1988. Both enjoy good health and...
-
The dependency diagram in Figure indicates that authors are paid royalties for each book that they write for a publisher. The amount of the royalty can vary by author, by book, and by edition of the...
-
Discuss the research methodologies used in the field, that is, correlation studies, experimental design, and field versus laboratory settings and explain the correlation between these methodologies...
-
Explain the important concepts of Relevant Cost, Opportunity Cost, and Sunk Cost used in incremental analysis.
-
WATER SUPPLY PLANNING AND DEVELOPMENT QUESTION: EXPLAIN AND EXPOUND THE TOPICS MENTIONED BELOW. PROVIDE EXAMPLES. TOPICS: >Importance of safe drinking water on public health. >Development of water...
-
Scottsdale Company has actual sales for July and August and forecast sales for September, October, November, and December as follows: Actual: July August Forecast: September October November December...
-
Oil flows over both sides of a flat plate. The plate dimensions are W = 250 mm and L = 740 mm. The free stream velocity is U = 4.2 m/s. Calculate the drag force on the plate. U W.
-
I am trying to add a new member by calling the membership constructor and adding it to the arraylist. However, it doesn't add to the list. The initial members in public memberships() are added, but...
-
Find the interest rate implied by the following combinations of present and future values: (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places. Leave...
-
A Alkynes can be made by dehydrohalogenation of vinylic halides in a reaction that is essentially an E2 process. In studying the stereochemistry of this elimination, it was found that...
-
Let X be the value of a randomly selected decimal digit, that is, a whole number between 0 and 9, inclusive. a. Use simulation to estimate the mean of X. Explain your reasoning. b. Obtain the exact...
-
The report Controlling Road Rage: A Literature Review and Pilot Study was prepared for the AAA Foundation for Traffic Safety by D. Rathbone and J. Huckabee. The authors discussed the results of a...
-
Refer to Problems 11 and 12. a. Find a point estimate for the mean graduation rate of all universities that have a student-to-faculty ratio of 17. b. Determine a 95% confidence interval for the mean...
-
Lucky Jim plc has the opportunity to manufacture a particular type of self-tapping screw, for a client company, that would become indispensable in a particular niche market in the engineering field....
-
You are required to compute the MVA for 2009, 2010, and 2011 from the estimated information for a supermarket group. 2011 2010 2009 Number of shares 6.823m 6.823m 6.776m Share price 261p 169p 177p...
-
Figure 1.7a (top) shows the elevation of a location in both feet and meters. Is the conversion correct? ELEVATION 1000 ft 305 m (a)
Study smarter with the SolutionInn App