What is the minimum-cost schedule for the bank

Assignment Help Business Management
Reference no: EM135951

Can you provide me specific setup in excel for the Chase Manhattan Bank case study? I have the breakdown of information however am having difficulty with the Excel (Qm or Solver) set up. I would like a stage by stage explanation if possible.

Case Study

Chase Manhattan Bank

The workload in numerous areas of bank operations has the characteristics of a no uniform distribution with respect to time of day. For example, at Chase Manhattan Bank in New York the number of domestic money transfer requests received from customers, if plotted against time of day, would appear to have the shape of an inverted U curve with the peak around 1 P.M. For efficient use of resources, the personnel available should, thus vary correspondingly.

Figure 8.2 shows a typical workload curve and corresponding personnel supplies at different hours of the day. A variable capacity can be accomplished effectively by employing part-time personnel. Because part-timers are not entitled to all the fringe benefits, they are often more economical than fulltime employees. Other considerations however may limit the extent to which part-time people can be hired in a given department. The problem is to find an optimal workforce schedule that would encounter personnel requirements at any given time and also be economical. Some of the factors distressing personnel assignment are listed here-

1. By corporate policy, part-time personnel hours are limited to a maximum of 40% of the day's total requirement.

2. Full-time employees work for 8 hours (1 hour for lunch included) per day. Thus, a full-timer's productive time is 35 hours per week.

3. Part-timers work for at least 4 hours per day but less than 8 hours and are not allowed a lunch break.

4. Fifty percent of the full-timers go to lunch between 11 A.M. and noon, and the remaining 50% go between noon and 1 P.M.

5. The shift starts at 9 A.M. and ends at 7 P.M. (that is overtime is limited to 2 hours). Any work left over at 7 P.M. is considered holdover for the next day.

6. A full-time employee is not allowed to work more than five hours overtime per week. He or she is paid at the normal rate for overtime hours not at one-and-a-half times the normal rate applicable to hours in excess of 40 per week. Fringe benefits aren't applied to overtime hours. In addition, the following costs are pertinent-

1. The average cost per full-time personnel hour (fringe benefits included) is $10.11.

2. The average cost per overtime personnel hour for full-timers (straight rate excluding fringe benefits) is $8.08.

3. The average cost per part-time personnel hour is $7.82. The personnel hours required, The bank's goal is to attain the minimum possible personnel cost subject to meeting or exceeding the hourly workforce requirements as well as the constraints on the workers listed earlier.

Discussion Questions

1. What is the minimum-cost schedule for the bank?

2. What are the limitations of the model used to answer question 1?

3. Costs might be reduced by relaxing the constraint that no more than 40% of the day's requirement be met by parttimers. Would changing the 40% to a higher value significantly reduce costs?

 

Reference no: EM135951

Questions Cloud

Evaluate the cost of the finished goods inventory : Evaluate the cost of the finished goods inventory. Under variable costing, evaluate the cost of the finished goods.
Which child is most expected to be the tallest : Also glucose technically doesn't have a carbonyl functional group then because it is broken when the ring structure is formed? Is it a random chance that either alpha or beta glucose is formed.
Arrange journal entries for the transactions : Arrange journal entries for the transactions listed above and adjusting entries. Arrange an adjusted trial balance at 31 st December, 2011.
One is a siamese while the other is calico : Explain how black and white pattern on the male siamese cat arises. If the oceans warm a few degrees, what impacts can you see on the landmasses, biologic community, and human populations? Are these positive or negative changes? Why with reason.
What is the minimum-cost schedule for the bank : What is the minimum-cost schedule for the bank. What are the limitations of the model used to answer question 1. Costs might be reduced by relaxing the constraint that no more than 40% of the day's requirement be met by parttimers. Would changing th..
Producers of hamburger : Which of these same curve would shift as a result of the per-burger tax. Curves average fixed cost,marginal cost would shift as a result.
Include a simple organizational chart : Madagascar, Indonesia and the Amazon basin have some of the greatest numbers of different species concentrated in a single area. What kinds of environments do you think encourage greater biodiversity.
Sweezy oligopoly and cournot oligopoly : Their banks are holding back credit so it is harder for businesses to invest and for consumers to spend
Evaluate berclairs basic and diluted earnings per share : Evaluate Berclairs basic and diluted earnings per share for the year ended December, 2013.

Reviews

Write a Review

 

Business Management Questions & Answers

  Liquidates the entire inventory

Assuming that Attic's awareness stays the same next year (77%), out of the promotion budgets below, what is the minimum Chester's Elite product manager must spend in promotion to earn more awareness than Andrews' Attic product?

  Describe a management performance plan that links action

Describe a management performance plan that links action plans to the following issues- o Motivation o Empowerment o Training

  What is the appropriate test to compare the evaluations

They give a random sample of of 100 customers the curly fries and compare the mean evaluation with the historical average for the traditional shoestring fries. What is the appropriate test to compare the evaluations?

  How can team building be made into work and interaction

Class, team building exercises can be precisely effective however also take time and money that may not be available. How can team building be made into daily work and interaction

  Prepare a research proposal

Prepare a research proposal using the standard Research Proposal

  Describe the general environment

Organizations have both an internal as well as an external environment. Describe the general environment and give at least one specific example of each dimension other than the examples given in the text and in the lectures

  What are the essential characteristics of groups

What are the essential characteristics of groups. What are the reasons that prompt people to join groups.

  Describe in what ways that women in business

Describe in what ways that Women in Business

  Recognise the evaluations of monetary losses in revenue

Recognise the evaluations as well as key decisions that need to be made in each of the next six weeks. Because of a down-turn in the economy, your company has been experiencing monetary losses in revenue.

  Write a paper on leadership and transformation

Write a paper on Leadership and Transformation and aslo Impact of Transformational Experience.

  International business environment

Prepare a report choosing a business describing the strategic options

  Analying activity in inventory accounts

Analying Activity in Inventory Accounts. Select data concerning operations of Cascade Manufacturing Company for the past fiscal year follow- Raw materials used $300,000

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd