Develop a forecasting models that michael could use

Reference no: EM133477656

Case: The Charring Cross branch of NatWest is having trouble getting the correct staffing levels to match customer arrival paterns. On some days, the number of tellers was too high reltive to customer traffic, so that tellers were otien idle. On other days, the opposite occurred. Long customer waiting lines formed because the relatively fewer tellers could not keep up with the number of customers. The manager, Michael Kaluuya, knew that there was a problem, but he had litle of the quantitative training he believed would be necessary to find a beter staffing solution. Michael figured that first, he needed a reliable forecast of each day's number of customer arrivals. Data for this problem is in the dataset file under the tab "Problem_5_Data". The data lists the number of customers entering this bank each day of the past year. It also lists other information: the day of the week, whether the day was a staff or faculty holiday.

Question 1: Use this data set to develop a forecasting models that Michael could use to help solve this problem. [Hint] You will need to create Dummy Variables

Question 2: Develop an improved model using only significant variables. Comment on your results and potential issues.

Question 3: Based on your model(s), write a report and make any recommendations about staffing that appear reasonable.

Reference no: EM133477656

Questions Cloud

Discuss the security issues that this company must consider : Discuss the security issues (in addition to simple customs requirements) that this company must consider when transporting customers

Discuss the unique properties of water : Discuss the unique properties of water that result from the charges on a water molecule.

Explain how inflation affects various sectors of the economy : Explain how inflation affects various sectors of the economy, for example: businesses, workers, retirees, lenders and borrowers. What do the experts say

Describe the stressor include contributing factors and rate : Describe the stressor include contributing factors and rate of incidence - Describe potential impact of the stressor on the family

Develop a forecasting models that michael could use : develop a forecasting models that Michael could use to help solve this problem. [Hint] You will need to create Dummy Variables

Research the seven primary human resource management : Research the seven (7) primary human resource management (HRM) functions most commonly associated with today's organizations. In a PowerPoint Presentation

Evaluate the terms of the loan : Evaluate the terms of the loan: How much money is the borrower seeking? What will the monthly payments be? How large is this monthly payment relative

What are the effects of the sympathetic : What are the effects of the sympathetic and parasympathetic division of the nervous system on the hearing?

Discuss how each has influenced the inclusion of individuals : Discuss how each has influenced the inclusion of individuals with disabilities in the educational setting. - Create a timeline of the history of special

User Account

All Pages