You are a business analyst working in the mortgage banking industry. Your manager asked you to analyze
staffing needs for the Foreclosure Department. The manager requested a detailed report because she is not
familiar with statistics and computations needed to make conclusions. Hence, your report must be written in a
descriptive manner that defines and explains key concepts, categories, and processes rather than just
presenting math calculation. You should explain each concept, discuss advantages and disadvantages, and
justify your recommendations. The expectation is that the report is an MS Word document that is 5 pages long.
The following is what the manager gave you:
At the beginning of this year, the portfolio included 100,000 loans in various stages of the foreclosure process.
In the last 4 months, there has been a significant increase in the portfolio, as presented in the following table:
Month January February March April
% increase 5% 10% 15% 20%
Total# of loans 105000 115500 132825 159390
The department currently employs 50 employees and has a huge backlog. The department quickly needs to
hire more people, but the management does not know how many. This report should help resolve this problem
quickly.
Please include the following information in your report:
Compare and contrast various sampling approaches (e.g., large sample, small sample, convenience sample,
and so forth). Apprise each of them, and select the one that you intend to use. Justify your recommendation.
Explain how you are going to overcome challenges associated with sampling biases. In addition, what
assurances are taken to address ethics problems in the experimental design that may arise if you need to lay
off employees in your department to replace them with offshore, less expensive employees, assuming that you
do not want to see your friends losing their jobs?
Propose performance expectations (goals) for all employees by composing productivity data and providing
mean, median, and mode values. Some information has been gathered from 9 employees, but feel free to
replace these numbers with numbers that will be discovered in your research. The number of documents
processed per hour per employee is 14, 17, 14, 14, 13, 16, 15, 21, and 12. Do not forget to create charts to
visually enhance this section.
Determine the probability that current trends in foreclosed loans will continue. Discuss factors that, in addition
to percent increase presented in the table above, can affect the accuracy of your forecast. You should know
whether or not unemployment rate, consumer spending, currency exchange rates, house prices, or seasonal
factors can affect the number of foreclosed loans
Sample Solution
owers of enchantment, but when their olâ man loses his job, will the magic from the rock be enough to help their family? They believed the rock was the solution to everything and after their olâ man got fired and was going to have to sell his car they all went out to the magic rock and waited for good things to happen. The car never did sell but he was offered a position on the radio and didnât have to sell the car! The Secret Sheriff Of Sixth Grade Chapter Book/Upper Elementary Fiction Sonnenblick, J. (2017). The Secret Sheriff Of Sixth Grade. Scholastic Press. Sixth grade is not a good time for everybody; bad things can happen to good kids. Teachers will accuse you of doing things wrong, bullies will find your weaknesses and use them against you and the students who are the loudest and most disruptive can drown out the quiet, nice kids. But this year is Maverick Falconerâs year. Heâs going to make a difference by helping those smaller than him (and those shorter if he can find anyone!) and heâs going to stand up to bullies. Maverickâs father died a hero on active military duty in Afghanistan when he was 3 and one of the last things his father left him was a toy sheriffsâ badge when he was little but being a hero is not as simple as carrying his badge. Now he likes to carry it to remind him of his dad and to remind him to make school a better place for everyone even if itâs hard to do. At school, itâs his arch nemesis Bowen Stack to deal with. At home itâs his Momâs drinking and abusive boyfriends to worry about. A powerful story showing a young boy who just wants to make school and home a better place to be. Yoko Picture Book/Animal Fiction Wells, R. (2009). Yoko. New York: Disney/Hyperion Books. Yoko the kitten is off to her first day of school and so her mother sends her off with a healthy comfort food, a lunchbox full of her favorite sushi. Yoko is excited for the day ahead and to show her classmates her red bean ice cream. Timothy had a peanut butter and honey sandwich, Tulip had Swiss cheese on rye and the Franks brothers both bought Franks. Yoko is super excited for her lunch, but her classmates decided to tease and bully her at lunch time when she goes to eat because it was a lunch they had not seen before. During the class Snack Time Song, the two Frank bulldog brothers tell her her food is for weirdos âYuckorama!â. Everyone laughs, and Yoko finishes her day sad and down. But Mrs. Jenkins has a plan and decides to host an International Food Day. She asks all the students t>
owers of enchantment, but when their olâ man loses his job, will the magic from the rock be enough to help their family? They believed the rock was the solution to everything and after their olâ man got fired and was going to have to sell his car they all went out to the magic rock and waited for good things to happen. The car never did sell but he was offered a position on the radio and didnât have to sell the car! The Secret Sheriff Of Sixth Grade Chapter Book/Upper Elementary Fiction Sonnenblick, J. (2017). The Secret Sheriff Of Sixth Grade. Scholastic Press. Sixth grade is not a good time for everybody; bad things can happen to good kids. Teachers will accuse you of doing things wrong, bullies will find your weaknesses and use them against you and the students who are the loudest and most disruptive can drown out the quiet, nice kids. But this year is Maverick Falconerâs year. Heâs going to make a difference by helping those smaller than him (and those shorter if he can find anyone!) and heâs going to stand up to bullies. Maverickâs father died a hero on active military duty in Afghanistan when he was 3 and one of the last things his father left him was a toy sheriffsâ badge when he was little but being a hero is not as simple as carrying his badge. Now he likes to carry it to remind him of his dad and to remind him to make school a better place for everyone even if itâs hard to do. At school, itâs his arch nemesis Bowen Stack to deal with. At home itâs his Momâs drinking and abusive boyfriends to worry about. A powerful story showing a young boy who just wants to make school and home a better place to be. Yoko Picture Book/Animal Fiction Wells, R. (2009). Yoko. New York: Disney/Hyperion Books. Yoko the kitten is off to her first day of school and so her mother sends her off with a healthy comfort food, a lunchbox full of her favorite sushi. Yoko is excited for the day ahead and to show her classmates her red bean ice cream. Timothy had a peanut butter and honey sandwich, Tulip had Swiss cheese on rye and the Franks brothers both bought Franks. Yoko is super excited for her lunch, but her classmates decided to tease and bully her at lunch time when she goes to eat because it was a lunch they had not seen before. During the class Snack Time Song, the two Frank bulldog brothers tell her her food is for weirdos âYuckorama!â. Everyone laughs, and Yoko finishes her day sad and down. But Mrs. Jenkins has a plan and decides to host an International Food Day. She asks all the students t>
